Components Of BOM Not Reflecting While Changing Status From Unreleased To Released (Doc ID 2204426.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



ACTUAL BEHAVIOR

When trying to change existing jobs from Unreleased to Released status via the Interface table (WIP Mass Load) including BOM Revision date as Sysdate, BOM components are not being reflected.


The functionality works using Forms (CORE). The functionality does not work using the WIP Mass Load.


EXPECTED BEHAVIOR

Changing via the Interface table with BOM Revision date as Sysdate should work correctly. This is to pull any latest changes in BOM.


STEPS

The issue can be reproduced at will with the following steps:
1. Inserted data into Staging table (wip_job_schedule_interface).
2. Change existing jobs from Unreleased to Released status through Interface table with BOM Revision date as Sysdate to pull any latest changes in BOM.
3. Still BOM Revision date did not reflect and did not fetch new component from modified BOM.




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