My Oracle Support Banner

While Updating The Service Login - UNIQUENESS_T Table's MOD_T Field Value Changes To Entry Modify Time (Doc ID 2523862.1)

Last updated on APRIL 03, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.20.0 and later
Information in this document applies to any platform.

Goal

After creating a new account while changing the service login, both CREATED_T and MOD_T value changes to entry modify time.

Steps:

1. Create a customer account with some /service/ip

2. Select * from uniqueness_t.

One gets a new entry in uniqueness for it, with CREATED_T and MOD_T set at sysdate, note the timestamp.

Expected Behavior:

Only MOD_T has to change , CREATED_T should not change.

Solution

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
Goal
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.