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 20, 2022
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
To assist with troubleshooting Advanced Pricing issues involving the transfer price using intercompany processing.
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
|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)?|
|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|