My Oracle Support Banner

E1: 31: Work Order Processing (R31410) Doubles Inventory Commitments Against Kit Component Items (Doc ID 2850167.1)

Last updated on JULY 19, 2022

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When Work Order Processing (R31410) is run over a Kit Work Order that is attached to a W line type Sales Order, and the line type is changed from S (Stock) to T (Text), the Inventory Commitments are doubled on the kit component items.

Oracle Support duplicated the issue following the steps below. All references to items are demo data not real customer items.

  1. Create three new items (P4101 and P41026) as follows:
    1. Item P5225 Kit Parent - Stocking Type K,  Line Type W
    2. Item C15225 Kit Component 1 - Stocking Type S,  Line Type S
    3. Item C25225 Kit Component 2 - Stocking Type S,  Line Type S
  2. Setup a Kit Bill of Material (P3002) in Branch 30 as follows:
    1. Item P5225 Kit Parent
    2. Item C15225 Kit Component 1 – 1 EA per kit
    3. Item C25225 Kit Component 2 – 1 EA per kit
  3. Setup Item Costs (P4105) for the components as 07 Standard Cost
  4. Create an Inventory Adjustment (P4114) for Kit Components
    1. Item C15225 Kit Component 1 – 1 EA
    2. Item C25225 Kit Component 2 – 1 EA
  5. Create a sales order for a quantity of 1 the Kit parent with a “W” line type to create a work order.
  6. Click green checkmark on Kit Selection Window:
  7. After saving order, Customer Service Inquiry shows lines for Kit Parent and two components with related Work Order number on the kit parent line.
  8. Find the Work Order in Work Order Processing (P48013)
  9. Item Availability (P41202) shows both component lines have quantity 1 on-hand and quantity 1 soft committed
  10. Work Order Processing (R31410) version has the following setup.
    1. Process Tab Option #1 (Generate Parts List and Routing Instructions) = 3 (Parts list and routing instructions)
    2. Sales/Config Tab Option #1 (Line Type) = T which is a Text line type.
    3. Sales/Config Tab Option #3 (Standard Cost Calculation) = 2 (Calculate standard cost only if it has not been calculated)
  11. Run the Work Order Processing (R31410) version with data selection on the Work Order Number.
  12. Check Sales Detail with Databrowser. Line Type was changed from S (stock) to T (text) on kit component lines.
  13. Check Item Availability (P41202). Commitments were doubled by Work Order Processing (R31410)
    1. Total commitments = 2, Quantity Available is -1. Quantity Available should be zero.
    2. SO Soft Commitments = 1  - this should be zero because the line is now a Text (non-inventory) line. 
    3. Work Order Processing (R31410) should have reduced the Sales order Soft Commitment to Zero.
    4. WO Hard Commitments = 1 (correct)
    5. Total Quantity Committed should be 1 not 2

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.