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 JULY 19, 2016

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms