5 Schema and Index Changes

This chapter provides an overview of the schema and index changes introduced in Oracle Communications Billing and Revenue Management (BRM) 7.5 Patch Set 14 through BRM 7.5 Patch Set 23.

Schema and Index Changes (Patch Set 23)

BRM 7.5 Patch Set 23 included the following schema and index changes:

  • The following tables were added:

    • EVT_BILLING_CHARGE_CC_TRANS_T

    • EVT_BILL_VLDT_CC_TRANS_T

    • PAYINFO_CC_TRANS_T

  • The following table was modified:

    OPTIONAL_PARTITION

  • The following column was added in EVT_BILLING_CHARGE_CC_TRANS_T and EVT_BILL_VLDT_CC_TRANS_T tables:

    • PIN_FLD_AMOUNT_ORIG

  • The following indexes were added:

    • I_AU_GROUP_ACC__ID

    • I_AU_GROUP_SHARING_MEM__ID

Schema and Index Changes (Patch Set 22)

BRM 7.5 Patch Set 22 included the following schema and index changes:

  • The following table was added:

    • CMT_BALANCES_T

Schema and Index Changes (Patch Set 21)

BRM 7.5 Patch Set 21 included the following schema and index changes:

  • The following table was added:

    • RECURRING_BUNDLE_HISTORY_T

Schema and Index Changes (Patch Set 20)

BRM 7.5 Patch Set 20 included the following schema and index changes:

  • The following table was added:

    • PRODUCT_DELIVERABLE_T

  • The following columns were added in the JOURNAL_T table:

    • TYPE

    • CONTRACT_OBJ_DB

    • CONTRACT_OBJ_ID0

    • CONTRACT_OBJ_TYPE

    • CONTRACT_OBJ_REV

    • CONTRACT_START_T

    • CONTRACT_END_T

  • The following columns were added in the PLAN_T and DEAL_T tables:

    • SUBSCRIPTION_TERMS_OBJ_ID0

    • SUBSCRIPTION_TERMS_OBJ_TYPE

    • SUBSCRIPTION_TERMS_OBJ_REV

    • SUBSCRIPTION_TERMS_OBJ_DB

  • The following column in the EVENT_T table was deleted:

    • COMPACT_SUB_EVENT

  • The size of the AU_SERVICE_T and EVENT_CUSTOMER_PASSWORD_T columns were changed to VARCHAR2 (1024).

Schema and Index Changes (Patch Set 18)

BRM 7.5 Patch Set 18 included the following schema and index changes:

  • The size of the API_USER_ID, CORRELATION_ID, and EXTERNAL_USER_ID columns in the USER_ACTIVITY_T table were changed from VARCHAR2 (255) to VARCHAR2 (128).

Schema and Index Changes (Patch Set 17)

BRM 7.5 Patch Set 17 included the following schema and index changes:

  • The following column was added in the PROFILE_CUSTOMER_CARE_T table:

    • GROUP_TYPE

  • The size of the IMPACT_CATEGORY column in the IFW_DSCBALIMPACT table was changed from VARCHAR2 (10) to VARCHAR2 (255).

Schema and Index Changes (Patch Set 16)

BRM 7.5 Patch Set 16 included the following schema and index changes:

  • The following tables were added:

    • CONFIG_BUSINESS_EVENTS_T

    • CONFIG_PROV_TAX_INFO_T

    • CONFIG_PROV_TAX_JUR_T

    • CONFIG_PROV_TAXES_T

    • JOB_TEMPLATE_COLL_AC_INFO_T

    • JOB_TEMPLATE_PRICE_SYNC_INFO_T

    • JOB_TEMPLATE_PYMT_CLEAN_T

    • JOB_TEMPLATE_RCVR_ACTION_T

    • JOB_TEMPLATE_RCVR_PAY_TYPES_T

    • JOB_TEMPLATE_REF_STATUSES_T

    • JOB_TEMPLATE_REF_PAY_TYPES_T

    • PROC_AUD_BATCH_PAYMENT_T

    • PROC_AUD_PRICE_SYNC_T

  • The following columns were added in the EVENT_BILLING_REVERSAL_CC_T and EVENT_BILLING_REVERSAL_DD_T tables:

    • AUTH_CODE

    • AUTH_DATE

    • RESULT

    • VENDOR_RESULTS

  • The following column was added in the CONFIG_TAXES_T table:

    • INPUT_ID

  • The following columns were added in the PROC_AUD_BILL_T table:

    • AMOUNT

    • AMOUNT_ORIG

  • The following columns were added in the JOB_TEMPLATE_T table:

    • CREATED_BY

    • EMAIL_ADDR

    • JOB_OBJ_DB

    • JOB_OBJ_ID0

    • JOB_OBJ_REV

    • JOB_OBJ_TYPE

    • JOB_TYPE

    • MODIFIED_BY

    • NOTIFY_FLAG

    • PARENT_TEMPLATE_OBJ_DB

    • PARENT_TEMPLATE_OBJ_ID0

    • PARENT_TEMPLATE_OBJ_REV

    • PARENT_TEMPLATE_OBJ_TYPE

    • USER_TAG

  • The following column was added in the JOB_TEMPLATE_GL_INFO_T table:

    • START_UNIT

  • The following indexes were added:

    • I_BATCH_PAYMENT_FAILED_ID

    • I_BATCH_PAYMENT_FILENAME_ID

    • I_PROC_AUD_BATCH_PAYMENT_ID

    • I_PROC_AUD_POCESS_END_ID

  • The following views were added:

    • JOB_HISTORY_VW

    • REV_ASSURANCE_VW

Schema and Index Changes (Patch Set 15)

BRM 7.5 Patch Set 15 included the following schema and index changes:

  • The following tables were added:

    • AU_JOB_TEMPLATE_BILL_DOMS_T

    • AU_JOB_TEMPLATE_BILL_PAY_TYP_T

    • AU_JOB_TEMPLATE_BILL_SEGMENT_T

    • AU_JOB_TEMPLATE_BILL_STATUSE_T

    • AU_JOB_TEMPLATE_BILLINFO_T

    • AU_JOB_TEMPLATE_COLL_PAY_TYP_T

    • AU_JOB_TEMPLATE_COLL_STATUSE_T

    • AU_JOB_TEMPLATE_GL_INFO_T

    • AU_JOB_TEMPLATE_GL_TYPES_T

    • AU_JOB_TEMPLATE_INV_BILLS_T

    • AU_JOB_TEMPLATE_INV_INFO_T

    • AU_JOB_TEMPLATE_INV_PAY_TYPE_T

    • AU_JOB_TEMPLATE_T

    • CONFIG_BOC_ANALYTICS_T

    • JOB_BOC_T

    • JOB_TEMPLATE_BILL_DOMS_T

    • JOB_TEMPLATE_BILL_PAY_TYPES_T

    • JOB_TEMPLATE_BILL_SEGMENTS_T

    • JOB_TEMPLATE_BILL_STATUSES_T

    • JOB_TEMPLATE_BILLINFO_T

    • JOB_TEMPLATE_COLL_PAY_TYPES_T

    • JOB_TEMPLATE_COLL_STATUSES_T

    • JOB_TEMPLATE_GL_INFO_T

    • JOB_TEMPLATE_GL_TYPES_T

    • JOB_TEMPLATE_INV_BILLS_T

    • JOB_TEMPLATE_INV_INFO_T

    • JOB_TEMPLATE_INV_PAY_TYPES_T

    • JOB_TEMPLATE_T

    • PROC_AUD_GL_REPORT_T

    • PROCAUD_ACC_BY_STATUS_T

    • PROCAUD_ACC_BY_SUBS_T

    • PROCAUD_ACCS_RECEIVABLE_T

    • PROCAUD_BILLED_REVENUE_T

    • PROCAUD_PYMTS_COLLECTED_T

  • The following column was added in the EVENT_CUSTOMER_NOTE_DATA_T table:

    • EXTERNAL_USER_NAME

  • The following column was added in the JOB_T table:

    • tracking_id

  • The following column was added in the NOTE_DATA_T table:

    • EXTERNAL_USER_NAME

  • The following columns were added in the PROC_AUD_T table:

    • JOB_OBJ_DB

    • JOB_OBJ_ID0

    • JOB_OBJ_REV

    • JOB_OBJ_TYPE

  • The following column was added in the PROC_AUD_BILL_SEGMENTS_T table:

    • NUMBER_OF_BILLS

  • The following column was added in the PROC_AUD_BILL_T table:

    • NUMBER_OF_BILLS

  • The following indexes were added:

    • I_JOB_TEMPLATE__ID

    • I_JOB_TRACKING_ID

Schema and Index Changes (Patch Set 14)

BRM 7.5 Patch Set 14 included the following schema and index changes:

  • There were no schema changes in this release.

  • The following indexes were added:

    • i_au_c_action_parent_obj__id

    • i_au_coll_inv_reminder__id

    • i_au_collections_action__id

    • i_au_collections_dunning__id

    • i_event_audit_object__id