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 15, 2021

Applies to:

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


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


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.


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

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