INCIAR Fails With 'Cannot Retrieve Payment Term From Bill-to Site Information' (Doc ID 1485376.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Symptoms

On : 12.1.3 version, Intercompany Invoicing

ACTUAL BEHAVIOR
---------------
In a new implementation of release 12.1.3, there are two Legal Entities and each legal entity has its own operations i.e, separate operating units, Operating Unit (ABC) procuring the items for Operating Unit (XYZ). Each operating unit has different inventory organization.

ABC operating unit raises the "Internal Requisition" to XYZ operating unit. Internal Sales order been created in XYZ Operating Unit and the items were shipped from XYZ inventory org to ABC Inventory Org. ABC inventory organization received the items."

However, INCIAR ends with:

  4 shipment transaction(s) selected.
  0 shipment transaction(s) processed.
  4 shipment transaction(s) rejected

Log file reports, for each of the 4 transactions:
Inside inarcii Caching the AR Invoice Information

trxFlowHeaderId is 1
 
Getting customer/site defaults, price list and payment Term

Warning: Cannot retrieve payment term from bill-to site information
Returned warning from extra function

 Return Warning from inilco.
The global status is INVALID.

Warning: Cannot create invoice line

End Processing Transaction ID: 321.000000
Transaction ID: 321.000000 Status = FAILURE

 ******** New Session:2143463****16-AUG-12:03.48.49 **********
[16-AUG-12 15:48:49] 9: After getting transaction flow header id from MMT
[16-AUG-12 15:48:49] 9: Transaction date, Transaction Source Id and Transaction Action Id are: 13-AUG-12, 8 and 21
[16-AUG-12 15:48:49] 9: TrxFlowHeaderId = 0 in MMT/RAE, getting it from mtl_transaction_flows_v or mtl_transaction_flow_headers
[16-AUG-12 15:48:49] 9: No data found from MTFV with inv org id
[16-AUG-12 15:48:49] 9: l_trxFlowHeaderId = 1
[16-AUG-12 15:48:49] 9: l_logicalTrxTypeCode = 0
[16-AUG-12 15:48:49] 9: l_new_accounting_flag = 0
[16-AUG-12 15:48:49] 9: l_inv_cur = 1
[16-AUG-12 15:48:49] 9: Assigning the local variables to the C local variables
[16-AUG-12 15:48:49] 9: Getting the transaction flow header Id and trxDate from MMT
[16-AUG-12 15:48:49] 9: After getting transaction flow header id from MMT
[16-AUG-12 15:48:49] 9: Transaction date, Transaction Source Id and Transaction Action Id are: 15-AUG-12, 8 and 21
[16-AUG-12 15:48:49] 9: TrxFlowHeaderId = 0 in MMT/RAE, getting it from mtl_transaction_flows_v or mtl_transaction_flow_headers
[16-AUG-12 15:48:49] 9: No data found from MTFV with inv org id
[16-AUG-12 15:48:49] 9: l_trxFlowHeaderId = 1
[16-AUG-12 15:48:49] 9: l_logicalTrxTypeCode = 0
[16-AUG-12 15:48:49] 9: l_new_accounting_flag = 0
[16-AUG-12 15:48:49] 9: l_inv_cur = 1
[16-AUG-12 15:48:49] 9: Assigning the local variables to the C local variables
[16-AUG-12 15:48:49] 9: Getting the transaction flow header Id and trxDate from MMT

There is a single shipping transaction flow set up between the selling and shipping orgs identified in the log file.

EXPECTED BEHAVIOR
-----------------------
Intercompany AR invoice to be created with this setup and without error.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Internal requisition.
2. Create internal Sale order
3. Ship and receive
4. Run create intercompany AR invoice

Cause

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