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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Intercompany Invoicing

ACTUAL BEHAVIOR
---------------
In a new implementation of release 12.1.3, "We have two Legal Entities and each legal entity has its own operations i.e, separate operating units, Operating Unit (ILT) procuring the items for Operating Unit (NTA). Each operating unit has different inventory organizations.

ILT operating unit raises the "Internal Requisition" to NTA operating unit. Internal Sales order been created in NTA Operating Unit and the items were shipped from NTA inventory org to ILT Inventory Org. ILT 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: 3021.000000
Transaction ID: 3021.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

Customer has 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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate intercompany invoices.

Cause

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