Who Columns (Creation_Date, Last_Update_Date, Etc.) Are Missing in the Table, OE_BLANKET_LINES_EXT. (Doc ID 2104592.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Currently, there are no Who Columns (CREATION_DATE, LAST_UPDATE_DATE, etc.) in the table, OE_BLANKET_LINES_EXT.

oe_blanket_lines_all table is not getting updated when quantities are getting updated on oe_blanket_lines_ext table.
Even the time stamp in the view, OE_BLANKET_LINES_HIST_V, does not change when the quantities are getting updated on the Sales Agreement line (oe_blanket_lines_ext).

EXPECTED BEHAVIOR
Need to have the last_update_date time stamp available when there are quantity adjustments in, oe_blanket_lines_ext, because of order releases.

STEPS
 1. Create release from a BSA line.
 2. Enter a line for item specified in the BSA line and save.

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