E1: 32: Configured Item Revision - P3210 Shows Incorrect Order Cost When Configured Sub-assembly Creates Transfer Order Using Different Currencies (Doc ID 3011496.1)

Last updated on MAY 01, 2024

Applies to:

Symptoms

When a Transfer Order (Transfer Type = 2) is done with a Sub Assembly in a foreign Branch, the routing currency conversions are not happening, which means the cost is incorrect for the Order.
This means that the Configured Sales Order and Parent Order Costs are incorrect, where the Parent Configured work order has a configured lower-level sub-assembly that creates a transfer order with different currencies. The currency conversions are not happening at the parent level so this means that the Parent Work Order cost/Total Cost of the Order are incorrect thus the sales order cost is incorrect because the foreign currency exchange rate conversion was never done.
The bottom line is that the Routing costs (Labor) incurred in a transferred configured component in a foreign branch do not have the routing costs converted to the Sales Order header currency, therefore the cost of the parent-configured item is wrong on the parent work order when the parent-configured work order has a configured Sub-assembly brought in thru “Transfer Order” with different Currencies.

Steps

1. Set up Parent Configured Item is In B/P M30 where the Currency is USD
2. Setup Routing Rules for the Parent Item with only Run Labor
3. Enter actual P3003 Routing using a Work Center
4. Make Sure the Direct Labor Work Center Costs are frozen at 200.00
5. For the Parent Configured Item, have a P Rule to call the Sub-Assembly that creates a Transfer Order from B/P 7, which uses Euro Currency
6. Setup a simple Segment for the configured Sub-Assembly
7. For the Configured Sub-Assembly, create a P Rule to call a Single Component from B/P 7
8. Configured Component from B/7 has Frozen cost of 100.00 Euro
9. For the Configured Sub-Assembly, Enter a R Rule in B/P 7
10. The actual routing P3003 has only 1 hour Direct Labor in B/P 7
11. The Work Center being used in above will be from B/7 and have Frozen Direct Labor of 150.00 Euro
12. Setup a Conversion for USD to EUR Inverse Method Divisor Rate 2.00000 Multiplier Rate of .5000000 (P0015A)
13. Create a Sales Order (make sure the P3210 Processing Option has a Version ZJDE0007 Set for Transfer Order
14. Go to the Edit/Item Price/Cost Screen
15. Notice that the Labor for the Sub-Assembly Foreign Cost is Blank, and the Extended Cost is Wrong (it's should be in the Foreign Extend Cost) and the "Extend Cost should be the value 150 x2=300.0

Cause

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