My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2023

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.


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:



To view full details, sign in with your My Oracle Support account.

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

In this Document

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