"LAST_UPD" Column Are Not Getting Update In An Inter Table "S_CONTACT_BU" When Parent Or Child Record Are Updated On "S_CONTACT" Table (Doc ID 2835653.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Symptoms

When updating an Parent or Child record, for some reason the Intersection table are not getting updated as show in the screenshot below when updating the Contact Name from "Test5" to Test6":

1. SELECT * FROM S_CONTACT WHERE row_id = '1-DRN8';

2. SELECT * FROM S_CONTACT_BU WHERE row_id = '1-DRNA';

Steps to Reproduce the issue:

1. When updated the Contact Name from "Test5" to "Test6".
2. When checking the LAST_UPD column from these tables below:

a. S_CONTACT
b. S_CONTACT_BU

3. For some reason the LAST_UPD column for the Inter table "S_CONTACT_BU" was not update and still showing "05-JAN-22" as show in the second screen above.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.