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.
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.
Changing via the Interface table with BOM Revision date as Sysdate should work correctly. This is to pull any latest changes in BOM.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms