INCIAR Fails With 'Cannot Retrieve Payment Term From Bill-to Site Information'
(Doc ID 1485376.1)
Last updated on FEBRUARY 08, 2024
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
NOTE: |
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
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
Symptoms |
Cause |
Solution |
References |