Intercompany Import Program Not Importing AGIS Transaction.
Last updated on FEBRUARY 15, 2018
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:
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