Comments

  • Shyam Singh Patel

    Hi Mohamed,

    Go to Fulfilment Lines>select Line>Actions>View Fulfilment Details>Billing>Invoice Number
    You can not view Invoice Print details from OM like EBS 

    Regards

    Shyam

  • Shyam Singh Patel

    Hi Amol,

    I think this will be the EFF Query you are looking for:

    SELECT

        fdsb.descriptive_flexfield_code,

        fdcv.context_code,

        fdcv.context_identifier context_api,

        fdsb.segment_code ,

        fdsb.segment_identifier Segment_api,

       -- fds.enabled_flag,

        fdsb.column_name,

        fvvs.value_set_code,

        fvvs.value_data_type,

        fvvs.maximum_length max_value_set_length,

        (

            SELECT

                value_column_size

            FROM

                fnd_flex_validation_tables ffvt

            WHERE

                ffvt.flex_value_set_id = fdsb.value_set_id

        ) table_type_valueset_size

    FROM

        fnd_vs_value_sets fvvs,

        fnd_df_contexts_b fdcv,

        fnd_df_segments_b fdsb

    WHERE

              fdsb.descriptive_flexfield_code LIKE 'DOO_%'

        AND   fdsb.value_set_id               = fvvs.value_set_id (+)

        AND   fdsb.DESCRIPTIVE_FLEXFIELD_CODE = fdcv.DESCRIPTIVE_FLEXFIELD_CODE

        AND   fdsb.CONTEXT_CODE = fdcv.CONTEXT_CODE

        AND   fdsb.application_id = fdcv.application_id

        AND   fdsb.enabled_flag = 'Y'

       AND    fdcv.enabled_flag = 'Y'

    ORDER BY

        fdsb.descriptive_flexfield_code,

        fdsb.context_code,

        fdsb.column_name

  • Shyam Singh Patel
  • Shyam Singh Patel

    SQL to Obtain ALL copied/Returned orders where original order is known

    SELECT  orig_dha.source_order_number "Original Order",
            Copied_dha.source_order_number "Copied Order" ,
            dcr.HEADER_ID                                 ,
            dcr.LINE_ID                                   ,
            dcr.FULFILL_LINE_ID                           ,
            dcr.DOC_REF_TYPE                              ,
            dcr.DOC_ID                                    ,
            dcr.DOC_CONTEXT_ID                            ,
            dcr.DOC_USER_KEY                              ,
            dcr.DOC_SUBLINE_ID
    FROM    FUSION.DOO_DOCUMENT_REFERENCES dcr,
            fusion.doo_headers_All orig_dha   ,
            fusion.doo_headers_All copied_dha
    WHERE   dcr.DOC_REF_TYPE = 'ORIGINAL_SALES_ORDER'
            AND
            (
                    TO_CHAR(dcr.doc_id)    = TO_CHAR(orig_dha.source_order_number)
                    OR TO_CHAR(dcr.doc_id) = TO_CHAR(orig_dha.header_id)
            )
            AND orig_dha.source_order_number in('&ENTER_ORIGINAL_ORDER')
            AND copied_dha.header_id    = DCR.header_id
    AND copied_dha.submitted_flag = 'Y'
            AND orig_dha.submitted_flag = 'Y'
    order by Copied_dha.source_order_number

     

    SQL to show receiving transactions for the Return Order
    SELECT  ra_document_code       ,
            SHIPMENT_HEADER_ID     ,
            CUSTOMER_ID            ,
            RECEIPT_ADVICE_NUMBER  ,
            RA_DOCUMENT_CODE       ,
            RA_DOCUMENT_NUMBER     ,
            RA_DOO_SOURCE_SYSTEM_ID,
            HEADER_INTERFACE_ID    ,
            RA_ORIG_SYSTEM_REF
    FROM    fusion.rcv_shipment_headers
    WHERE   ra_document_code        = 'RMA'
            AND ra_document_number in( '&ENTER_RETURN_ORDER')  

     

    SQL to show Shipping transactions for the Return Order

    SELECT  SHIPMENT_LINE_ID         ,
            QUANTITY_RECEIVED        ,
            QUANTITY_DELIVERED       ,
            ITEM_ID                  ,
            SHIPMENT_LINE_STATUS_CODE,
            SOURCE_DOCUMENT_CODE     ,
            RA_DOO_HEADER_NUMBER     ,
            RA_ORIG_DOO_HEADER_NUMBER
    FROM    fusion.rcv_shipment_lines
    WHERE   shipment_header_id IN
            (
                    SELECT  SHIPMENT_HEADER_ID
                    FROM    fusion.rcv_shipment_headers
                    WHERE   ra_document_code        = 'RMA'
                            AND ra_document_number IN( '&ENTER_RETURN_ORDER')
            )

     

    RMA- One or more Order Lines have already been returned, A Return Order for one or more lines on the order already exists for sales order and can be validated in one of the ways below


    SELECT

       dha.order_number "Original Sales Order"

     , dla.line_number "Original Order Line"

     , dhr.order_number "RMA Order"

    FROM

      doo_headers_all dha

     , doo_lines_all dla

     , doo_document_references ddr

     , doo_headers_all dhr

    WHERE

           ddr.doc_id = dha.header_id

    AND dha.order_number = '289966'  ---- Enter your Sales Order Here

    AND dhr.header_id = ddr.header_id

    AND doc_ref_type = 'ORIGINAL_SALES_ORDER'

    AND dla.header_id = ddr.doc_id

    AND dla.line_id = ddr.doc_line_id

     

  • Shyam Singh Patel

    Hi,

    This is available only in Pre-transformation rule. Tax Classification Code you can do in Post-transformation rule.

    Please use VIB task from Setup and Maintenance> " Manage Pretransformation Rules for Sales Orders"

    How To: Default Accounting Rule, Invoicing Rule And Tax Classification Code On Sales Order (Doc ID 2544401.1)
    How To Create A Post Transformation Rule to update BillingTrxTypeId (Doc ID 2404668.1)

    Regards
    Shyam

  • Shyam Singh Patel

    Hi Mohanish,

    Please use the following URL for Apply Hold and Release Hold

    https://URL:PORT/soa-infra/services/default/DooDecompReceiveOrderExternalComposite/ReceiveOrderRequestService?WSDL

    Regards
    Shyam

     

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dood="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/DooDecompOrderDetailSvcComposite">
       <soapenv:Header/>
       <soapenv:Body>
          <dood:ReleaseHoldProcessRequest>
             <!--1 or more repetitions:-->
             <dood:ReleaseHoldRequestParams>
       <soapenv:Header/>
       <soapenv:Body>
          <dood:ReleaseHoldProcessRequest>
             <dood:ReleaseHoldRequestParams>
                <dood:SourceOrderSystem>OPS</dood:SourceOrderSystem>
                <dood:SourceOrderId>300000020427297</dood:SourceOrderId>
                <dood:SourceLineId>300000020427313</dood:SourceLineId>
                <dood:SourceHoldCode>CREDIT_MEMO_HOLD</dood:SourceHoldCode>
                <dood:HoldReleaseReasonCode>RMA_CREDITMEMO_REJECTED</dood:HoldReleaseReasonCode>
                <dood:HoldReleaseComments>RMA_CREDITMEMO_REJECTED</dood:HoldReleaseComments>
             </dood:ReleaseHoldRequestParams>
          </dood:ReleaseHoldProcessRequest>
       </soapenv:Body>
    </soapenv:Envelope>
             </dood:ReleaseHoldRequestParams>
          </dood:ReleaseHoldProcessRequest>
       </soapenv:Body>
    </soapenv:Envelope>

  • Shyam Singh Patel

    after 19A upgrade I figured out this issue option and Now I'm able to re-access it 
    Tools>Reports and Analytics>Administration>Manage Privileges> Search " Edit Direct Database Analysis " update the role/User Grant and Search " Execute Direct Database Analysis " and update the Role/User Grant   log out and log in back you can see that menu again

     
     

    In Fusion Applications Update 19A, the Direct Database Query capability for writing reports using BI Answers will be disabled by default.  Oracle recommends users only write reports against the OTBI subject areas, and will remove the unsupported Direct Database Query capability in 12 months.  Therefore, Oracle strongly suggests migrating the report writing process to the OTBI subject areas.

    If your organization currently uses Direct Database Query, you may re-enable this option for a 12-month grace period. 

  • Shyam Singh Patel

    Hi Deepankar,

    Please see following Note ID for your answer
     

    No Supply Orders are created for Back to Back (B2B) Orders (Doc ID 2164846.1)
     
    Order to Cash - Back to Back (B2B) - Transfer Flow - Setup Requirements (Doc ID 2275549.1)
    Section :  Assignment Sets
     
    Regards
    Shyam
  • Shyam Singh Patel

    Hi Dev,

    Assign Business Unit Data Access to Following Roles

    Accounts Receivable Specialist
    Accounts Receivable Manager

    Regards
    Shyam

  • Shyam Singh Patel

    Interfacing Order Management EFF to Invoicing - Receivables (AR) (Doc ID 2251724.1)

  • Shyam Singh Patel

     

    White Papers for Order Management Cloud (Doc ID 2051639.1)

    Oracle Order Management Cloud R13 (updates 18A - 18C)
    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/nfs/r13-2018-scm-order-mgmt-nfs.htm#F1712

    Oracle Order Management Cloud R13 (update 18A)​
    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/r13-2018-scm-order-mgmt-wn.htm

    Oracle Order Management Cloud R13 (updates 17B - 17D)
    www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/r13-scm-order-mgmt-wn.htm#T729

    Release Readiness Document for R13-OM

    https://cloud.oracle.com/saas/readiness?offering=order-management

    Oracle Fusion Distributed Order Orchestration (DOO) White Papers (Doc ID 1536633.1)

    Oracle Applications Cloud Known Issues and Maintenance Packs (Doc ID 1603154.1)

     

  • Shyam Singh Patel

    Hi Shlomo,

    Please check the checkbox of "Allow manual adjustment" in Price List of the item. I see your order in draft status. please click on edit draft and submit it. the pencil option for edit price is visible only when line status is in awaiting shipping and you do a SO revision. also, check in service level if the manual price adjustment checkbox is checked
     
    Regards
    Shyam

     

  • Shyam Singh Patel

    Hi Kranthi,

    You need to raise an SR

    Note these points:

    • Order Management uses the predefined sequence when it creates a sales order, a return order, or an order for an internal material transfer.
    • If you're updating from 19A to 19B, then you can use an upgrade script that Oracle provides. You apply the script during the update process. It resets the initial value of the ORA_FOM_DOC_SEQUENCE_AUTO predefined document sequence.
    • If you don’t want to use the predefined sequence, then you can enable the Retain Sales Order Number for Orchestration Order Number option. This option instructs Order Management to continue to use order numbers that some other system creates, and not to use the predefined sequence
  • Shyam Singh Patel

    Hi Ekansh,

    please see the attached document for Printer Configuration. you need the network login and password to configure network printer in Cloud BI for Document Print.

    Regards
    Shyam

  • Shyam Singh Patel

    Hi  Harshal,
    You can use PO webservice.  Purchase Order Version V2 Web Service can be used for creating a change order on Open purchase orders. PO Schedule status update is not supported with change order creation service.

     

    Tools>Developer Connect> Service Name :  Purchase Order Service Version 2
    WSDL File https://TEST-TEST2.fa.us6.oraclecloud.com:443/fscmService/PurchaseOrderServiceV2?WSDL
    changePurchaseOrder Active An operation to change a purchase order.
     
    Regards
    Shyam