'Calculate Cumulative Yield For Network Routing' Updates BOM_OPERATION_SEQUENCES Even When There Are No Changes (Doc ID 2213978.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Bills of Material - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

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.

EXPECTED BEHAVIOR

Every time the table BOM_OPERATION_SEQUENCES is updated by any Oracle concurrent programs, REQUEST_ID, LAST_UPDATE_DATE columns should be updated.

STEPS

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

Changes

 

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