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 MARCH 12, 2018

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


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).

Note: One can check the source code for the price list by clicking on the "Other" tab on the price list header record.


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