12.1.3 B16774558 Error CST_XFER_PRICE_ERROR In MTI Table For ISO From OPM To Discrete Organization (Doc ID 1552267.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Process Manufacturing Financials - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Goal

In an internal sales order for a direct interorg transfer between an OPM inventory organization and an EAM inventory organization, the transaction gets stuck in mtl_transactions_interface with error: CST_XFER_PRICE_ERROR.
A corresponding List price has been set and the shipping network is updated.
Inventory log shows:
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: MTL_QP_PRICE.get_transfer_price error
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: Error =
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: EXCEP G_EXC_ERROR
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_transfer_price: After Advanced Pricing. status: E
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: Error =
[22-APR-13 12:14:20] : EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price:
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: After getting transfer price. Status: E
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: Error in validate_line :
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: Error:User-Defined Exception
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Returned from inv_txn_manager_grp.validate_lines
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Error in Line Validatin
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Error in Line Validatin
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Failed Interface ID : 675137 Item: 4001Org : 251
...
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing control record...
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Assigning value of org_id to l_control_rec...121
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: After assigning the value of org_id to l_control_rec...121
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QP:Price Request routine ...
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[22-APR-13 12:14:20] 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 L.
[22-APR-13 12:14:20] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: MTL_QP_PRICE.get_transfer_price error
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: Error =
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: EXCEP G_EXC_ERROR
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_transfer_price: After Advanced Pricing. status: E
[22-APR-13 12:14:20] : GMF_get_transfer_price_PUB.get_xfer_price_qp: Error =
[22-APR-13 12:14:20] : EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price:
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: After getting transfer price. Status: E
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: Error in validate_line :
[22-APR-13 12:14:20] INV_TXN_MANAGER_GRP: Error:User-Defined Exception
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Returned from inv_txn_manager_grp.validate_lines
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Error in Line Validatin
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Error in Line Validatin
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: Failed Interface ID : 692304 Item: 4001Org : 251
[22-APR-13 12:14:20] INV_TXN_MANAGER_PUB: All records failed after line validation

Solution

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