INCIAR Create Intercompany AR Invoices Not Working Due To Incorrect Picking Of Accounts DIST_CODE_COMBINATION_ID OR ACCOUNTING_EVENT_ID (Doc ID 2108987.1)

Last updated on JANUARY 07, 2020

Applies to:

Symptoms

CASE 1 :

Find the concurrent program "Create Intercompany AP Invoices" (INCIAP) is populating incorrect value for column DIST_CODE_COMBINATION_ID in AP_INVOICE_LINES_INTERFACE, however, no error occurs in the request log file.

EXPECTED BEHAVIOR
-----------------------
Expect INCIAP populates correct value for column DIST_CODE_COMBINATION_ID in AP_INVOICE_LINES_INTERFACE.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Create Intercompany AP Invoices program.
2. Once it completes, run Payables Open Interface Import program.

CASE 2 :

ACTUAL BEHAVIOR
---------------
Create Intercompany AR Invoices program picking up the transaction from rcv_accounting_events for processing but not creating AR invoice.

EXPECTED BEHAVIOR
-----------------------
Expect Create Intercompany AR Invoices program to pick correct record and process accordingly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Run Create Intercompany AR Invoices program

2) Note (User Observation) : Issue happening in case where there is a matching record (rcv_accounting_events.ACCOUNTING_EVENT_ID=mtl_material_transactions.transaction_id) present in mtl_material_transactions table for shipping type relationship.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.