Intercompany Import Program Not Importing AGIS Transaction. (Doc ID 1493991.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle General Ledger - Version 12.0.1 and later
Oracle Receivables - Version 12.0.1 and later
Oracle Financials Common Modules - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

Intercompany Import fails to import data from interface tables for a specific Supplier and Transaction Type.
The same Transaction Type works ok when created with a different Supplier (Initiator) for the same customer (Recipient).

Customer/Supplier associations are correctly created both ways between the two organizations at Organization level.
Supplier setups for sites are correct.

1) Error message received when Importing AGIS transactions /entering an Outbound transaction.

"The intercompany transaction requires an invoice and the recipient organization &Recipient_Org does not have a customer association with the initiator organization &Initiator_Org. Legal entity, customer, and site association for recipient organization &Recipient_Org does not exist."


2) Message displayed by FND debug logfile:

"Error in module FUN.PLSQL.funtraderelb.FUN_TRADING_RELATION_PKG.GET_CUSTOMER:  Customer mapping is not present for the relation id <&relation ID number >"

 

3) Running the query below will show that Bill-To site for the customer has inactive status:

 &nbsp;

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