'Calculate Cumulative Yield For Network Routing' Updates BOM_OPERATION_SEQUENCES Even When There Are No Changes
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Bills of Material - Version 12.2.4 and later
Information in this document applies to any platform.
Concurrent Request 'Calculate Cumulative Yield For Network Routing' updates table BOM_OPERATION_SEQUENCES.
Even when there is no change to Cumulative yield values, the concurrent request still updates the table but request_id and last_update_date columns are not changed.
Every time the table BOM_OPERATION_SEQUENCES is updated by any Oracle concurrent programs, REQUEST_ID, LAST_UPDATE_DATE columns should be updated.
The issue can be reproduced at will with the following steps:
1. Submit concurrent request 'Calculate Cumulative Yield For Network Routing' with Update Events as Y
Performed internal test case and saw this update statement in the trace file:
Due to this issue, users cannot audit the data in BOM_OPERATION_SEQUENCES using REQUEST_ID, LAST_UPDATE_DATE
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