Changes to the Data Model for Oracle

Tables

  • CHANNEL: Column PARAM length changed from 200 to 800.
  • H_CHANNEL: Column PARAM length changed from 200 to 800.
  • OUT_REQ_CORREL: The following new columns have been added :
    • REQ_TIME(TIMESTAMP)
    • SRVC_PTC_ID(INTEGER)
    • MASTER_PT_ID(INTEGER)
    • TIMEOUT(TIMESTAMP)
    • RESEND_TIME(TIMESTAMP)
    • FINAL_ACK_RESP_TIME(TIMESTAMP)
    • INTERIM_ACK_RESP_TIME(TIMESTAMP)
    • FINAL_ACK_TIME(TIMESTAMP)
    • INTERIM_ACK_TIME(TIMESTAMP)

Indexes

The following new index has been added :
  • TIMEOUT_IDX on the OUT_REQ_CORREL table.

Triggers

The following existing trigger has been updated :
  • FRAGMENT_V_INSERT
  • TRANSMISSION_V_INS
  • TRANSACTION_V_INS
  • TXN_PAYMENT_V_INS
  • TXN_SEC_V_INS
  • BATCH_V_INSERT

Stored Procedures

The following new Stored Procedures have been created :
  • UPSERT_COUNTER
The following existing Stored Procedures have been updated :
  • UPSERT_CAL_OBJ_REL
  • SET_PENDING
  • SET_DELETE_FLAG
  • UPSERT_OBJ_VALUE

Functions

The following new functions have been created :
  • FTM_UTC_TIMESTAMP
The following existing functions have been updated :
  • CONVERT_UTC_TO_DB_TZ