My Oracle Support Banner

What Does the CHANGE_TERM Column on the Tables in the SMF Database Represent? (Doc ID 2421879.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Oracle Communications Convergent Charging Controller - Version 6.0.0 and later
Information in this document applies to any platform.

Goal

On all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C or 3C), all the tables in the SMF database on the Service Management Server have a CHANGE_TERM column.

For example:

SQL> desc smf_user
 Name                                                                      Null?    Type
 ------------------------------------------------------------------------- -------- -----------------------------------
 CHANGE_USER                                                               NOT NULL VARCHAR2(30 CHAR)
 CHANGE_DATE                                                               NOT NULL DATE
 CHANGE_TERM                                                               NOT NULL VARCHAR2(45 CHAR)
 USER_NAME                                                                 NOT NULL VARCHAR2(30 CHAR)
 FULL_NAME                                                                 NOT NULL VARCHAR2(50 CHAR)
 DESCRIPTION                                                                        VARCHAR2(50 CHAR)
 LOGIN_ATTEMPTS                                                            NOT NULL NUMBER(1)
 LOCK_REASON                                                                        VARCHAR2(100 CHAR)
 PWD_LIFETIME                                                                       NUMBER(3)
 PWD_EXPIRY                                                                         DATE
 JAVA_CONFIG                                                                        VARCHAR2(200 CHAR)
 TEMP_LOCK_TIME                                                                     NUMBER(4)
 TEMP_LOCK_EXPIRY                                                                   DATE
 ACCT_EXPIRY                                                                        DATE
 QOS                                                                       NOT NULL VARCHAR2(20 CHAR)
 SCREENS_USER                                                                       CHAR(1 CHAR)

What does this CHANGE_TERM column represent?

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!

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