Changes to the Data Model

The following tables are modified:

• SVC_PARTICIPANT_BASE
  • Added column CURRENT_SCHEDULE
• H_SVC_PARTICIPANT_BASE
  • Added column CURRENT_SCHEDULE
• FSM_TRANSITION
  • Changed the data type length of the FSM_ACTION column to 500
  • Changed the data type length of the OVERRIDE_SELECTION column to 1000
• OUT_REQ_CORREL
  • Altered the ID column CACHE attribute from the default value of 24 to 1000
• PRODUCT_INSTANCE
  • Altered the type of PRODINST_ID column from configurable(BIGINT|INTEGER) to INTEGER..
  • Altered the type of USAGE_INSTANCE_TYPE column from configurable(BIGINT|INTEGER) to INTEGER..
• SVC_PARTICIPANT_BASE
  • added CURRENT_SCHEDULE_ENTRY column.
• H_SVC_PARTICIPANT_BASE
  • added CURRENT_SCHEDULE_ENTRY column.

The following views have been modified:

• TRANSMISSION_V: removed use of the COALESE function to improve performance
• TRANSMISSION_BASE_V: removed use of the COALESE function to improve performance
• SERVICE_PARTICIPANT_V : added CURRENT_SCHEDULE_ENTRY column.
• SVC_PARTICIPANT_V : added CURRENT_SCHEDULE_ENTRY column.
• H_SVC_PARTICIPANT_V : added CURRENT_SCHEDULE_ENTRY column.

The following indexes are new:

• New index on the NAME column of the APPLICATION table
• New index on the APPLICATION_ID, VERSION columns of the APP_VERSION table

The following constraints have been altered:

• The foreign key constraint (CC_OP_FK) on the OBJ_PARTY_REL table has been changed from ENFORCED to NOT ENFORCED

The following constraints have been dropped:

• The foreign key constraint (CC_OE_FK) has been dropped from the OBJ_BASE table

The following triggers are new:

• New trigger (T_ERR_INS) on the ERROR table to modify the CREATED column

The following stored procedures have been modified:

• SET_DELETE_FLAG modified to change logic sequence
• UPSERT_OBJ_VALUE modified to add new parameter (SVP_TYPE) to support scheduler tasks

The following sequences have been modified:

• ID_INT_SEQ: cache has been disabled