Price Was Not Found on This Price List for This Item and UOM (Unit of Measure) (Doc ID 471722.1)

Last updated on JULY 08, 2024

Applies to:

Symptoms

-- Problem Statement:
On 12.0.0.0.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.

INVVICAS.pls 120.1.12000000.1
INVVICAB.pls 120.5.12000000.1

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
FOB point-SHIPMENT

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.

ERROR
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
INV_TRANSACTION_FLOW_PUB.get_transfer_price: U
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

Changes

Cause

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