E1: 32: Line Type W P Rule Component (P3293) Set as Purchased in Item Master (P4101) but Manufactured in Item Branch (P41026) Causes Sales Update (R42800) to Overstate Journal Entries (Doc ID 2867628.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

When processing Sales Update (R42800) over a Configured Sales Order that has Manufactured P Assembly Inclusion Rule items with line type W, if the sub-assembly items have Cost Types (e.g. D1, X1, B2) that are not included in the Production Cost Inquiry Cost Types (F3102) of the parent, the system will under report Cost of Goods Sold and Inventory Journal Entries. This occurs when Product Cost Detail is active in the Branch Constants (P41001).

The issue can be reproduced at will with the following steps:

1. Create a Configured Parent and a Manufactured child (P4101, P41026).
2. Create Configured Item Segments (P3291).
3. Link the Manufactured item to the Configured parent in the P Assembly Inclusion Rules (P3293). Make sure the line type is W.
4. Create Frozen Standard Costs (R30812 and R30835) for the Manufactured item: A1, B2, B3, X1 (not all of these cost types will be at the parent level).
5. Create a Sales Order for the Configured parent; this will create a Work Order for the Configured item and the Manufactured child. Note the unit and extended Sales Order cost for the Configured parent.
6. Run Work Order Processing (R31410) over all of the Work Orders in descending order.
7. Complete the Work Order (P31114) for the Manufactured item.
8. Complete the Configured parent (P31114).
9. Ship Confirm (P4205) the Configured parent.
10. Run Sales Update (R42800) and review the report. Notice that Cost of Goods Sold and Inventory accounts have values lower than the Sales Order Detail Cost.
    
    

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.