'Calculate Cumulative Yield For Network Routing' Updates BOM_OPERATION_SEQUENCES Even When There Are No Changes

(Doc ID 2213978.1)

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

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