Price Was Not Found on This Price List for This Item and UOM (Unit of Measure)
(Doc ID 471722.1)
Last updated on JULY 06, 2020
Applies to:Oracle Order Management - Version 12.0 and later
Information in this document applies to any platform.
EXECUTABLE: WSHINTERFACE - Interface Trip Stop
ConcurrentProgram: WSHINTERFACES - Interface Trip Stop - SRS
EXECUTABLE: INCIAR - Create Intercompany AR Invoices
-- Problem Statement:
On 22.214.171.124.0 in Production:
When attempting to Create Internal Requisition in OU 1 with source as OU 2, run Create Internal Sales Order process in US 1. Import Sales Order in OU 2. Pick Release and Ship Confirm from OU 2 and it fails the following errors.
CST: Transfer Pricing Option : Yes, Price As Incoming Cost
GMF: Include Invoices in Actual Cost : Yes
GMF: Include Receipts in Actual Cost : Yes
Transfer type -InTransit
Inventory application has profile values:
QP: Source System Code = Oracle Inventory
QP: Pricing Transaction Entity = Intercompany Transaction.
INV: Advanced Pricing for Inter-Org Transfers =2 (No)
Static Price list is being used which is attached to internal Customer bill-to.
Intercompny Price List has this item ABC and UOM defined.
From the Interface Trip Stop Log File:
GET_TRANSFER_PRICE: Error from get_transfer_price_for_item
Get_Transfer_price: In Exc_Unexpected_Error 4
GMF_get_transfer_price_PUB.get_transfer_price: return status from
Discrete Xfer. IC Relations do exists between from OU and To OU. Error is
being raised and txn will not be shipconfirmed.
INV_TRANSACTION_FLOW_PUB.get_transfer_price: Error =
EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price:
INV_TXN_MANAGER_GRP: After getting transfer price. Status: E
INV_TXN_MANAGER_GRP: Error in validate_line : Price was not found on price
list Intercompny Price List for this item ABC and uom EA.
INVTXNB: Error from INV worker : error_code : CST_XFER_PRICE_ERROR, err_expl :Price was not found on price list Intercompny Price List for this item ABC and uom EA.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Create Internal Requisition in OU 1 with source as OU 2,run Create Internal Sales Order
process IN OU 1. Import Sales Order in OU 2
Pick Release and Ship Confirm from OU 2
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