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.
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
BRM 7.5 Patch Set 22 included the following schema and index changes:
The following table was added:
CMT_BALANCES_T
BRM 7.5 Patch Set 21 included the following schema and index changes:
The following table was added:
RECURRING_BUNDLE_HISTORY_T
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).
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).
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).
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
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
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