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

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms