Intercompany Import Program Not Importing AGIS Transactions: The intercompany transaction requires an invoice and the recipient organization / FUN_TRADING_RELATION_PKG.GET_CUSTOMER: Customer mapping is not present for the relation id <number> (Doc ID 1493991.1)

Last updated on DECEMBER 29, 2023

Applies to:

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:

  

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.