Comments

  • Shyam Singh Patel

    Hi Afaq,
    If you have not done Promote All feature in Pricing Algorithm and No Custom Pricing Code. Simply Create the New Version of the following Algorithm from Version 0 and Publish it.

    Get Base List Price for Goods and Services
    Apply Pricing Terms
    Get Sales Pricing Strategy
    Price Sales Transactions   -------- Make Enable Cache as false
    Set Initial Values
     

    Regards

    Shyam


    Please see following Metalink Note ID for all in One solutions

    https://community.oracle.com/docs/DOC-890633
    If you are happy with the Document, please mark as Helpful by doing so this will provide assistance for other people looking for answers to their queries

  • Shyam Singh Patel

    No Onhand Stock Considered in B2B where PR got created.

  • Shyam Singh Patel

    Standard Price List
     

  • Shyam Singh Patel

    Hi Afaq,
    we faced this issue earlier here is the solution.
    The Price Type, Charge Type, Charge Subtype set up in the discount list is not matching the charge definition of the sale price List.
    as per your Screenshot, this is set as ALL,ALL,ALL  please open your Standard Price List and check what is the selection over there based on Price list change your Price Type, Charge Type, Charge Subtype in the discount list then it will work

    Regards

    Shyam

     

    Please see following Metalink Note ID for all in One solutions

    https://community.oracle.com/docs/DOC-890633

    If you are happy with the Document, please mark as Helpful by doing so this will provide assistance for other people looking for answers to their queries

  • Shyam Singh Patel

    Hi Dev,

    as per your screenshot Role "Accounts Receivable Specialist" and "Accounts Receivable Manager"  you have assigned the Reference data set which is good but you need to assign Business unit too. which is missing there.

    Regards
    Shyam 
  • Shyam Singh Patel

    Hi Sunil,

    please see the following Note ID.
    Setup and Maintenance>Manage Pretransformation Rules for Sales Orders
     

    2290957.1 Order Creation Fails With:- The Value Provided For The Attribute BILLING_TRX_TYPE_ID Is Invalid
    2280325.1 How to: Assign a Value to Receivables (AR) Transaction Type based on Order Type
    1347608.1 Setting Up Transaction Types In Oracle Fusion Receivables
    1610024.1 How to Setup Custom Transaction Types Required For External Transaction In Fusion Cash Management
    1347760.1 Setting Up AutoAccounting Rules In Oracle Fusion Receivables
    2175626.1 How to Configure Invoice Revenue Based on Order Type from Order Management 
    1358419.1 Setting Up Receivables Descriptive Flexfields In Oracle Fusion Receivables
    2329318.1 Receivables Transaction Types Not Available In Intercompany Receivables Assignment Form
  • Shyam Singh Patel

    Sales Order is Status is Awaiting Shipping After Line is Shipped (Doc ID 2195109.1)

  • Shyam Singh Patel

    Hi Pavan,

    Please Run ESS " Send Shipment Advice"  " Manage Shipment Interface"

    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

    Hi Mohamed,

    we also had the same requirement and we raised following SR and it ends up in ER/BUG

    SR 3-17542117551 : not able to create RMA If Sales Order Line in Awaiting Billing Status   raised on 22nd May 2018
    Bug 28071252 : REQUIREMENT TO CREATE RETURN ORDER EVEN WHEN THE ORDER IS IN AWAITING BILLING

    Regards
    Shyam

  • Shyam Singh Patel

    Hi Rajesh,

    Go to Manage Transaction Sources>Select the Transaction Type> Edit> Check the Checkbox Derive Date. this will default accounting date from ship date.
    Please try this and share the results.

    Regards

    Shyam

     

     

  • 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

     

    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 Srini,

    Thanks for the point. we rectified the EFF and Now we are able to Override the Line Price through EFF value in 18.02.
    now we also able to get the price based on Price matrix condition with the seeded attribute even though this is a bug in 18.02. 

    Regards
    Shyam