My Oracle Support Banner

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 MAY 04, 2019

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
inter-company
Checked for relevance 7-MAY-2015
MTL_MATERIAL_TRANSACTION.TRANSFER_PRICE

Symptoms

ACTUAL BEHAVIOR
The Transfer price column in MTL_MATERIAL_TRANSACTION table is populated with 0 when the Interface Trip Stop is run.

EXPECTED BEHAVIOR
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.

STEPS TO REPRODUCE
A. Setup Item Cost
   Set items frozen unit cost (in this case used material cost)

    Non working Item: XX with UOM: FT -- Cost: 1.12
    Working Item: YY 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 = <Item Validation Organization Name>
  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
5. Results:

Non working Item: XX - Transfer Price: 0
Working Item: YY - Transfer Price = 100



Cause

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
Symptoms
Cause
Solution
References


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