Transfer Price Column In MTL_MATERIAL_TRANSACTION Table Is Populated With Zero Instead of The Customer Expected Item Cost Value
(Doc ID 1963275.1)
Last updated on MARCH 28, 2018
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Interface Trip Stop = ITS
Intercompany Processing with Advanced Pricing
Checked for relevance 7-MAY-2015
On : 12.1.3 version, Price List
The Transfer price column in MTL_MATERIAL_TRANSACTION table is populated with 0
when the Interface Trip Stop is run.
The frozen item cost for this item in the receiving organization is expected to be populated
in this column (MTL_MATERIAL_TRANSACTION.transfer_price)
when an Inter org transaction occurs.
The issue can be reproduced at will with the following steps:
A. Setup Item Cost
Set items frozen unit cost (in this case used material cost)
Non working Item: 0033 with UOM: FT -- Cost: 1.12
Working Item: 10055 with UOM: CM -- Cost: 100
B. Setup Profiles
INV:Advanced Pricing for Intercompany Invoice = YES
INV:Intercompany Invoice for Internal Orders = YES
QP: Item Validation Organization = Greatbatch, LTD
QP: Pricing Transaction Entity = Order Fullfilment
QP: Source System Code = Oracle Pricing
INV: Use Model & Options for Configuration Pricing = No
CST: Transfer Pricing Option = Yes, price as incoming
INV: Intercompany Currency Conversion = Budge
C. Process As Follows
1. Create Internal Requisition
2. Approve Requisition
3. Create Internal Sales Order via Order Import
4. Schedule and Ship Confirm the order
Non working Item: 0033 - Transfer Price: 0
Working Item: 10055 - Transfer Price = 100
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