WIP mass upload updates required quantity for component which is not specified in WIP_JOB_DTLS_INTERFACE (Doc ID 1671736.1)

Last updated on JULY 10, 2023

Applies to:

Symptoms

WIP mass upload updates required quantity for component which is not specified in WIP_JOB_DTLS_INTERFACE even though EXPLOSION_FLAG is set to "N".

STEPS

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

1.Define a BOM as below

TEST_ASSEMBLY
+-- COMPONENT_001 qty:1
+-- COMPONENT_002 qty:1

2.Create a wip job for TEST_ASSEMBLY.

JOB Name:12345
Assembly Item:TEST_ASSEMBLY
qty:1

Component Requirement is extracted as below;

COMPONENT_001 Qty=1
COMPONENT_002 Qty=1

3. Change COMPONENT_001 qty:1 ->qty:2 through WIP mass upload

5.Navigate to Material Requirement form and check required quantity for COMPONENT_001 and COMPONENT_002.

JOB Name:12345

Component Requirement is updated as below;

COMPONENT_001 Qty=1
COMPONENT_002 Qty=2

Quantity for COMPONENT_002 is updated to 2 as we expect, but Quantity for COMPONENT_001 gets back to 1 even though ALLOW_EXPLOSION is set to "N".

Cause

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