My Oracle Support Banner

"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:

Siebel CRM - Version 20.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 Steps to Reproduce the issue:
Changes
Cause
Solution
References


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