Intercompany Invoicing Could Not Find A Price List In Ordered UOM Or Primary UOM When Price List Setup With Source Code = "QP" (Doc ID 550304.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
EXECUTABLE: INCIAR - Create Intercompany AR Invoices
QPXAMPTE




Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to Create Intercompany AR Invoices, the following error occurs.
This problem occurs when the price list has been setup with
Source Code = QP (Advanced Pricing) and profile INV:Advanced Pricing for Intercompany Invoice = Yes (appscheck for Inventory shows profile = 1).

ERROR
Could not find a price list in Ordered UOM or Primary UOM

 

 

 

INCIAR module: Create Intercompany AR Invoices
Log File Might Show Errors:

[07-JAN-13 03:49:57] INV_INTERCOMPANY_INVOICING:
MTL_QP_PRICE.get_transfer_price: Calling QP:Price Request routine ...
[07-JAN-13 03:49:57] INV_INTERCOMPANY_INVOICING:
MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[07-JAN-13 03:49:57] INV_INTERCOMPANY_INVOICING:
MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=Price was not found on price list  for this item  and uom EA.
[07-JAN-13 03:49:57] INV_INTERCOMPANY_INVOICING:
MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[07-JAN-13 03:49:57] get_transfer_price_for_item: l_transfer_price is

[07-JAN-13 03:49:57] INV_TXN_MANAGER_PUB: All records failed after line validation
[07-JAN-13 03:49:57] INVTXNB: Error from INV worker : error_code : CST_XFER_PRICE_ERROR, err_expl :
MTL_ONLINE_TRANSACTION_PUB.process_online returns false
Error Code:CST_XFER_PRICE_ERROR
Error Explanation: Retrieving messages from the stack

 



-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Price list is setup with item and UOM used on the order.
Primary UOM is selected.
2. Run Create Intercompany AR Invoices
3. Review log file. Error is shown.

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