Order Management

Get Involved. Join the Conversation.

Topic

    Shyam Singh Patel
    ICO Dropship Procurement AR Invoice "Intercompany...Answered
    Topic posted August 14, 2019 by Shyam Singh PatelGold Trophy: 10,000+ Points, tagged Order Management, Supply Chain Financial Orchestration, Supply Chain Orchestration 
    74 Views, 8 Comments
    Title:
    ICO Dropship Procurement AR Invoice "Intercompany Receivables Invoice" Stuck in SFO Execution
    Summary:
    ICO Dropship Procurement AR Invoice "Intercompany Receivables Invoice" Stuck in SFO Execution
    Content:

    Hi All,

    This is regarding "Intercompany Procurement Flow" Intercompany AR Invoice Generation is stuck
    we can see this Monitor Financial Orchestration Execution 

    Error: An error occurred while processing the AR task. Contact your help desk. (FOS-3465306) 

    SR 3-20726287461: ICO Dropship Procurement AR Invoice "Intercompany Receivables Invoice" Stuck in SFO Execution

     

    Version:
    19C
    Image:

    Best Comment

    Shyam Singh Patel

    Our internal team has reviewed the log files 

    Here is the summary of advice 

    FOS does not support flexfields enabled at the BU level or FOS related batch source level, hence we are seeing the following errors as FOS does not populate these values during the population of invoice details into the AR interface table. So, please request the disable the flexfield at the BU level or FOS related batch source level and reprocess the failed event again from the Monitor Financial Orchestration Execution UI by selecting the failed event and clicking on Submit Selected.

    following DFF were mandatory at AR Header level, we made these two DFFs are non-mandatory and were able to import AR Invoice for PO#P102100019 

    oracle.jbo.AttrSetValException: JBO-FND:::FND_VS_VAL_REQUIRED:  AR Saleschannel is a required field. ------ Sending through AR Mapper 
    oracle.jbo.AttrSetValException: JBO-FND:::FND_VS_VAL_REQUIRED: P&L is a required field. 

    Accrual Account we will set up and will resolve the AP Error. 

    Comment

     

    • Shyam Singh Patel
    • Deepak Padhy

      Hi Shyam - Is it for one test case or you are not able to generate interco AR for all?

      If the issue is generic, maybe you can check Item validation org set up in Receivable option (task - Manage Receivables System Options)  and make sure the item is assigned there. Some days ago I was also getting this error during one of my testing and AR interco invoice was not getting generated from SCFO. Once we assign the item validation org in Receivable option, AR interco invoice got generated. Pls check this once.

       

      Thanks

      Deepak.

      • Shyam Singh Patel

        Hi Deepak,

        Thanks for the update. I have checked both BU Setup in "Manage Receivables System Options>Search BU>>Edit>Search Transactions Manu at >Item Validation Organization = Item Master Org -01" and our Item Master Org is setup in Both BU as Item Validation Organization.
        In our all setup Item Master Org we have set up as Item Validation Organization 

        I've also checked Manage Planning Source Systems> OPS>Manage Organization List>Refresh Org List>Enable for Collection
        here to all org's are enabled for collection and both org where intercompany is happening also enabled.

        Supply Chain Planning work areas>Maintain Supply Network Model Click the Tasks panel tab and then select the Maintain Supply Network Model link.

        This would be where drop ship validation org is set up. So we do have a separate validation org for drop ship apart from the common item validation org which comes from OM parameters hence we have not enabled any item validation org here as it is governing from Manage Order Management Parameters>Item Validation Organization> ALL BU:  Item Master Org -01

        still, we are facing this error in Monitor Financial Orchestration Execution as mentioned in Screenshot.

        Regards
        Shyam

         

    • Deepak Padhy

      Hi Shyam - Hmm, Not having any hints as of now other than this, As SCFO is not showing the Error message in detail as well so it is little difficult to drill down.

      I saw you have already raised an SR and it is being worked upon by support team. Our support team will check and revert accordingly.

       

      Thanks.

    • Shyam Singh Patel

      Our internal team has reviewed the log files 

      Here is the summary of advice 

      FOS does not support flexfields enabled at the BU level or FOS related batch source level, hence we are seeing the following errors as FOS does not populate these values during the population of invoice details into the AR interface table. So, please request the disable the flexfield at the BU level or FOS related batch source level and reprocess the failed event again from the Monitor Financial Orchestration Execution UI by selecting the failed event and clicking on Submit Selected.

      following DFF were mandatory at AR Header level, we made these two DFFs are non-mandatory and were able to import AR Invoice for PO#P102100019 

      oracle.jbo.AttrSetValException: JBO-FND:::FND_VS_VAL_REQUIRED:  AR Saleschannel is a required field. ------ Sending through AR Mapper 
      oracle.jbo.AttrSetValException: JBO-FND:::FND_VS_VAL_REQUIRED: P&L is a required field. 

      Accrual Account we will set up and will resolve the AP Error. 

    • Ravi Kanth Vuddagiri

      Please perform following and retest the issue

      1) Use the task : Manage Mapping sets for the scope 'Cost Management'.
      2) Name of the mapping set : 'Accrual Account - Organization'. (CST_ACCRUAL_ACCT_ORG_MS)
      3) Select the 'chart of Accounts' that is assigned to the ledger you are using.
      4) In the mapping section : For the inventory org, give the Account Code combination, User want to use.