My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

NOTE:
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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


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