My Oracle Support Banner

Technical Brief for Diagnosing Intercompany Processing GET_TRANSFER_PRICE Error CST_XFER_PRICE_ERROR When Using Advanced Pricing (Doc ID 1372245.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Advanced Pricing - Version 12.1.1 and later
Oracle Order Management - Version 12.1.1 and later
Oracle Inventory Management - Version 12.1.1 and later
Oracle Shipping Execution - Version 12.1.1 and later
Information in this document applies to any platform.
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
inter-company
inter company
INCIAR

Purpose

To assist with troubleshooting Advanced Pricing issues involving the transfer price using intercompany processing.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. What value does one have set for the following profile options?
 2. How to collect a detailed log file and QP Trace File when INV:Advanced Pricing for Intercompany Invoice = yes.
 3. Does the QP Trace file show error DUPLICATE_PRICE_LIST ?
 4. Does the QP Trace file show error "Could not find a price list in Ordered UOM or Primary UOM"?
 5. Has one coded external API MTL_INTERCOMPANY_INVOICES.get_transfer_price (package MTL_INTERCOMPANY_INVOICES within file $INV_TOP/patch/115/sql/INVICIVB.pls)?
 References
 6. Are QP and INV enabled for the pricing transaction entity?
 7. What versions does one have for the following files?
 8. Is one using a custom pricing attribute on the expected price list?
 9. Does one wish to use all_items setup on a price list that is setup with pricing transaction entity = INTCOM?
 10. Are there any OPM (Oracle Process Manufacturing) restrictions?
 11. Is Pricing Security On?  If so, is Global Checked for the expected price list?
 12. Engine fails when doing multi currency conversion for conversion type Corporate - Error from INV worker : error_code : CST_XFER_PRICE_ERROR
 13. Can One Use All Items On A "Static Price List" During Intercompany Processing Running the Interface Trip Stop?
 14. Known issues
 a) R12 Patch May be Needed Using a Dynamic Formula
 b) R12 Patch May be Needed Using Multi-Currency Conversion
 c) R12 Patch May be Needed When the utl_file_dir Parameter Exceeds 2000 Characters.
 d) R12 Patch May be Needed When for error:  INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP NO_DATA_FOUND
References

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