1. Patch Set Release Notes
  2. Schema and Index Changes

11 Schema and Index Changes

The Oracle Communications Billing and Revenue Management (BRM) 12.0 Patch Sets include new and changed schemas and indexes.

Patch Set 8 Schema and Index Changes

BRM 12.0 Patch Set 8 includes the following schema and index changes.

Note:

No views were added in BRM 12.0 Patch Set 8.

The following tables have been added:

  • THREAD_INFO_FAILED_ACCT_T

The following indexes have been added:

  • I_EVT_CONTRACT_CANCEL__ID

Table 11-1 lists the columns that have been added.

Table 11-1 Columns Added

Table Column Added

AU_CONFIG_BUSINESS_EVENTS_T

NOTIFY_SEARCH_LEVEL

NOTIFY_OPCODE

AU_PROC_AUD_BILL_ERR_ACCT_T

SCOPE_OBJ_DB

SCOPE_OBJ_ID0

SCOPE_OBJ_TYPE

SCOPE_OBJ_REV

AU_PRODUCT_T

OFFER_VALIDITY_ROUNDING

SCALE_ROUNDING

AU_SERVICE_T

SVC_EXP_LAST_NOTI_T

SVC_EXP_LAST_NOTI_OFFSET

CONFIG_BUSINESS_EVENTS_T

NOTIFY_SEARCH_LEVEL

NOTIFY_OPCODE

CONFIG_DISTRIBUTION_T

SCHEMA_NAME

CONFIG_NOTIFICATION_SPEC_T

NOTIFY_OPT_TYPE

AGGREGATE_MODE

PROC_AUD_BILL_ERR_ACCT_T

SCOPE_OBJ_DB

SCOPE_OBJ_ID0

SCOPE_OBJ_TYPE

SCOPE_OBJ_REV

PRODUCT_T

OFFER_VALIDITY_ROUNDING

SCALE_ROUNDING

SERVICE_T

SVC_EXP_LAST_NOTI_T

SVC_EXP_LAST_NOTI_OFFSET

Patch Set 7 Schema and Index Changes

BRM 12.0 Patch Set 7 includes the following schema and index changes.

Note:

No views were added in BRM 12.0 Patch Set 7.

The following tables have been added:

  • CONFIG_STORED_PROCEDURE_T

  • CONFIG_PROMISE_TO_PAY_SPEC_T

  • GROUP_SHARING_PRODUCTS_T

  • AU_GROUP_SHARING_PRODUCTS_T

  • EVENT_GROUP_SHARE_PRODUCTS_T

The following indexes have been added:

  • I_PAYINFO_UNIQUE__ID

  • I_GROUP_SHARING_PRODUCTS__ID

  • I_EVENT_GRP_SHARE_PROD__ID

Table 11-2 lists the columns that have been added.

Table 11-2 Columns Added

Table Column Added

AU_BAL_GRP_BALS_T

ROLLED_UP_CREDIT_LIMIT

AU_BAL_INFO_LIMIT_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

AU_CFG_CREDIT_PROFILE_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

AU_DEAL_PRODUCTS_T

BASE_PRODUCT_OBJ_ID0

BASE_PRODUCT_OBJ_TYPE

BASE_PRODUCT_OBJ_REV

BASE_PRODUCT_OBJ_DB

FLAGS

AU_DISCOUNT_T

APPLY_MODE

AU_PLAN_LIMIT_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

AU_PRODUCT_T

APPLY_MODE

AU_PURCHASED_DEPOSIT_T

END_DETAILS

PARENT_DB

PARENT_ID0

PARENT_TYPE

PARENT_REV

AU_PURCHASED_PRODUCT_T

BASE_PRODUCT_OBJ_ID0

BASE_PRODUCT_OBJ_TYPE

BASE_PRODUCT_OBJ_REV

BASE_PRODUCT_OBJ_DB

BAL_GRP_BALS_T

ROLLED_UP_CREDIT_LIMIT

BAL_INFO_LIMIT_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

CFG_CREDIT_PROFILE_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

COLL_SCEN_PROMISETOPAY_T

CONFIG_OBJ_DB

CONFIG_OBJ_ID0

CONFIG_OBJ_TYPE

CONFIG_OBJ_REV

STATUS

CONFIG_PROMISE_TO_PAY_SPEC_T

MIN_PERC_THRESHOLD

DEAL_PRODUCTS_T

BASE_PRODUCT_OBJ_ID0

BASE_PRODUCT_OBJ_TYPE

BASE_PRODUCT_OBJ_REV

BASE_PRODUCT_OBJ_DB

FLAGS

DISCOUNT_T

APPLY_MODE

EVENT_ACT_COLL_P2P_UNEQUAL_T

MILESTONE_AMOUNT

MILESTONE_PERCENTAGE

MILESTONE_INTERVAL

EVENT_BILLING_LIMIT_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

EVENT_BILLING_PRODUCT_ACTION_T

BASE_PRODUCT_OBJ_ID0

BASE_PRODUCT_OBJ_TYPE

BASE_PRODUCT_OBJ_REV

BASE_PRODUCT_OBJ_DB

PLAN_LIMIT_T

DYNAMIC_CREDIT_FLOOR

OVERRIDE_CREDIT_LIMIT

PRODUCT_T

APPLY_MODE

PURCHASED_DEPOSIT_T

END_DETAILS

PARENT_DB

PARENT_ID0

PARENT_TYPE

PARENT_REV

PURCHASED_PRODUCT_T

BASE_PRODUCT_OBJ_ID0

BASE_PRODUCT_OBJ_TYPE

BASE_PRODUCT_OBJ_REV

BASE_PRODUCT_OBJ_DB

Patch Set 6 Schema and Index Changes

BRM 12.0 Patch Set 6 includes the following schema and index changes.

Note:

No views were added in BRM 12.0 Patch Set 6.

The following tables have been added:

  • CONFIG_DELIVERY_METHODS_T

  • CFG_NOTIF_SPEC_ADV_NOTIF_T

  • CFG_NOTIF_SPEC_CRITERIA_T

  • CFG_NOTIF_SPEC_DELIV_METHODS_T

  • CFG_NOTIF_SPEC_DELIVERY_SPEC_T

  • CONFIG_NOTIFICATION_SPEC_T

  • CONFIG_DEPOSIT_SPEC_PROFILE_T

  • DEPOSIT_SPECIFICATION_T

  • DEPOSIT_REFUND_REQUEST_T

  • EVENT_DEPOSIT_DETAILS_T

  • EVENT_DEPOSIT_RECEIVE_T

  • EVENT_DEPOSIT_REFUND_T

  • EVENT_DEPOSIT_RELEASE_T

  • EVENT_DEPOSIT_TRANSFER_T

  • EVENT_DEPOSIT_UPDATE_DETAILS_T

  • PURCHASED_DEPOSIT_EVENT_T

  • PURCHASED_DEPOSIT_T

  • REQUEST_T

  • REQUEST_FAILED_T

  • REQUEST_FAILED_OPCODE_T

  • REQUEST_FAILED_ERROR_INFO_T

  • REQUEST_FAILED_REST_T

  • REQUEST_FAILED_HEADER_INFO_T

  • EVENT_BILLING_LOAN_LATE_FEE_T

  • EVENT_BILLING_LOAN_PULLBACK_T

  • EVENT_BILLING_LOAN_RECOVERY_T

  • EVENT_BILLING_LOAN_REC_REV_T

  • EVENT_BILLING_LIMIT_T

  • CONFIG_INSTL_SCH_CRITERIA_T

  • CONFIG_INSTL_SCH_SPEC_T

  • CONFIG_INSTL_NEXT_STATE_T

  • CONFIG_INSTL_STATE_T

  • EVT_BILLING_INSTL_T

  • EVENT_INSTL_CANCEL_T

  • EVENT_INSTL_CREATE_T

  • INSTALLMENT_SOURCE_T

  • INSTALLMENT_SCH_INSTALLMENT_T

  • INSTALLMENT_SCHEDULE_T

The following indexes have been added:

  • I_REQUEST__ID

  • I_REQUEST_ACC__ID

  • I_REQUEST_STATUS__ID

  • I_REQUEST_PROGRAM_NAME__ID

Table 11-3 lists the columns that have been added.

Table 11-3 Columns Added

Table Column Added

PROFILE_LOAN_T

PULLBACK

REPAYMENT_DAYS

MAX_ACTIVE_LOANS

OPT_LOAN

PROFILE_LOAN_LIMIT_T

CREDIT_LIMIT

VALID_TO

VALID_FROM

EVENT_BILLING_LOAN_FEE_T

AMOUNT

PURCHASED_PRODUCT_T

NEXT_RETRY_T

RATE_BAL_IMPACTS_T

MINIMUM_SCALED_AMOUNT

RATE_T

PRORATE_QUANTITY

TYPE

PRODUCT_T

RETRY_UNIT

RETRY_OFFSET

MAX_RETRY_COUNT

EVENT_BILLING_PRODUCT_ACTION_T

NEXT_RETRY_T

ITEM_T

TAX_DATA

EVENT_BILLING_TAXES_T

ITEM_OBJ_DB

ITEM_OBJ_ID0

ITEM_OBJ_TYPE

ITEM_OBJ_REV

CONFIG_DELIVERY_METHODS_T

DELIVERY_IDENTIFIER_TAG

BAL_GRP_SUB_BALS_T

SUBTYPE

EVENT_BILLING_LOAN_DEBIT_T

CHANNEL

TYPE

CFG_CREDIT_PROFILE_T

LOAN_THRESHOLDS_FIXED

LOAN_THRESHOLDS

PLAN_LIMIT_T

LOAN_THRESHOLDS_FIXED

LOAN_THRESHOLDS

BAL_INFO_LIMIT_T

LOAN_THRESHOLDS_FIXED

LOAN_THRESHOLDS

PROFILE_LOAN_T

NO_OF_ACTIVE_LOANS

UNIT

FREQUENCY

COLLECTIONS_ACTION_T

LAST_NOTIFICATION_OFFSET

LAST_NOTIFICATION_T

INSTALLMENT_SCH_INSTALLMENT_T

LAST_NOTIFICATION_OFFSET

INSTALLMENT_SCHEDULE_T

LAST_NOTIFICATION_OFFSET

EVENT_BILLING_FEE_TRANS_INFO_T

ZONEMAP_NAME

ZONEMAP_TARGET

LOCALE

Patch Set 5 Schema and Index Changes

BRM 12.0 Patch Set 5 includes the following schema and index changes.

The following tables have been added:

  • BATCH_REL_RETRY_T
  • BATCH_REL_ZIP_FILE_BUF_T
  • BATCH_REL_ZIP_FILE_T
  • BILL_STRUCTURE_T
  • CFG_NOTIF_SPEC_ADV_NOTIF_T
  • CFG_NOTIF_SPEC_CRITERIA_T
  • CFG_NOTIF_SPEC_DELIV_METHODS_T
  • CFG_NOTIF_SPEC_DELIVERY_SPEC_T
  • CONFIG_DEPOSIT_SPEC_PROFILE_T
  • CONFIG_EVENT_PROMO_MAP_T
  • CONFIG_EVENT_PROMO_TAG_MAP_T
  • CONFIG_INSTL_SCH_CRITERIA_T
  • CONFIG_INSTL_SCH_SPEC_T
  • CONFIG_INSTL_STATE_T
  • CONFIG_LOAN_LOC_T
  • CONFIG_NOTI_DELIVERY_METHODS_T
  • CONFIG_NOTIFICATION_SPEC_T
  • CONFIG_TAXCODES_MAP_T
  • CONFIG_TAXEXEMPTION_CODE_MAP_T
  • DEPOSIT_SPECIFICATION_T
  • EVENT_AUDIT_TRANS_OUT_T
  • TAX_SELECTOR_T
  • EVENT_BILLING_FEE_TRANS_INFO_T
  • EVENT_BILLING_LOAN_GRANT_T
  • EVENT_INSTL_CANCEL_T
  • EVENT_INSTL_CREATE_T
  • EVT_BILLING_INSTL_T
  • INSTALLMENT_SCHEDULE_T
  • INSTALLMENT_SOURCE_T
  • INSTALLMENT_SCH_INSTALLMENT_T
  • NO DB IMPACTS
  • OFFERING_OVERRIDE_T
  • PROFILE_LOAN_T
  • PROFILE_SPECIALDATES_T
  • TAX_EXEMPTION_SELECTOR_T

The following indexes have been added:

  • I_BATCH_REL_RETRY__ID
  • I_BATCH_REL_RETRY__ID
  • I_BATCH_REL_RETRY_READY
  • I_BATCH_REL_ZIP__OBJ_ID0
  • I_BATCH_REL_ZIP__OBJ_ID0
  • I_BATCH_REL_ZIP_BUF__OBJ_ID0
  • I_BATCH_REL_ZIP_BUF__OBJ_ID0
  • I_BATCH_REL_ZIP_INCOMPLETE
  • I_BILL_BILLINFO__ID
  • I_CONFIG_INSTL_SCH_CRIT__VALUE
  • I_CONFIG_INSTL_SCH_SPEC__NAME
  • I_TOPUP_AUTH__ID

The following views have been added:

  • BALANCE_BUCKET_ACCOUNT_V
  • BALANCE_BUCKET_V
  • BALANCE_BUCKET_SERVICE_ALIAS_V
  • BALANCE_BUCKET_SERVICE_V

Table 11-4 lists the columns that have been added.

Table 11-4 Columns Added

Table Column Added

BAL_GRP_T

UNIQUE_ID

BAL_GRP_BALS_T

DELTA_CREDIT_LIMIT

OUTSTANDING_AMOUNT

BAL_GRP_SUB_BALS_T

GRANTED_BAL

LAST_NOTIFICATION_OFFSET

UNIQUE_ID

BATCH_REL_ZIP_FILE_T

FILENAME

NUM_RECORDS

STATUS

BILL_T

LAST_NOTIFICATION_OFFSET

STATE

BILLINFO_T

UNIQUE_ID

CFG_CREDIT_PROFILE_T

GRANT_FIXED_THRESHOLD

GRANT_PERC_THRESHOLD

CONFIG_BEID_BALANCES_T

ENABLE_EXPIRY_NOTIFICATION

CONFIG_BUSINESS_PARAMS_T

PARAM_VALUE

DEAL_PRODUCTS_T

GRACE_PERIOD

RENEWAL_MODE

EVENT_BAL_IMPACTS_T

OUTSTANDING_AMOUNT

TAX_EXEMPTION_CODE

EVENT_BILLING_CHARGE_CC_T

CARD_TYPE

EVENT_BILLING_DISC_ACTION_T

OFFERING_OVERRIDE_VALUES_OBJ_DB

OFFERING_OVERRIDE_VALUES_OBJ_ID0

OFFERING_OVERRIDE_VALUES_OBJ_REV

OFFERING_OVERRIDE_VALUES_OBJ_TYPE
EVENT_BILLING_LIMIT_T

GRANT_FIXED_THRESHOLD

GRANT_PERC_THRESHOLD

EVENT_BILLING_PAYMENT_CC_T

TRACE_NUM

AUTH_MOP

EVENT_BILLING_PRODUCT_ACTION_T

GRACE_PERIOD

LAST_NOTIFICATION_T

LAST_NOTIFICATION_OFFSET

OFFERING_OVERRIDE_VALUES_OBJ_DB

OFFERING_OVERRIDE_VALUES_OBJ_ID0

OFFERING_OVERRIDE_VALUES_OBJ_TYPE

OFFERING_OVERRIDE_VALUES_OBJ_REV

RENEWAL_MODE

RETRY_COUNT

EVENT_BILLING_TAXES_T

TAX_EXEMPTION_CODE

EVENT_BILLING_TOPUP_T

AUTH_ID

BAL_GRP_OBJ_DB

BAL_GRP_OBJ_ID0

BAL_GRP_OBJ_TYPE

BAL_GRP_OBJ_REV

SUB_BAL_ID

TOPUP_TYPE

HISTORY_BILLS_T

LAST_NOTIFICATION_OFFSET

JOURNAL_T

TAX_EXEMPTION_CODE

PAYINFO_T

UNIQUE_ID

PAYINFO_CC_T

CARD_TYPE

TYPE_STR

PRODUCT_T

ENABLE_NOTIFICATION

PURCHASED_DISCOUNT_T

OFFERING_OVERRIDE_VALUES_OBJ_DB

OFFERING_OVERRIDE_VALUES_OBJ_ID0

OFFERING_OVERRIDE_VALUES_OBJ_REV

OFFERING_OVERRIDE_VALUES_OBJ_TYPE

PURCHASED_PRODUCT_T

GRACE_PERIOD

LAST_NOTIFICATION_OFFSET

OFFERING_OVERRIDE_VALUES_OJB_DB

OFFERING_OVERRIDE_VALUES_OBJ_ID0

OFFERING_OVERRIDE_VALUES_OBJ_REV

OFFERING_OVERRIDE_VALUES_OBJ_TYPE

RENEWAL_MODE

RETRY_COUNT

RATE_T

PRORATION_FLAG

RATE_BAL_IMPACTS_T

FIXED_PRICE_TAG

SCALED_PRICE_TAG

SPLIT_DETAILS

RATE_PLAN_T

SELECTOR_OBJ_ID0

SELECTOR_OBJ_DB

SELECTOR_OBJ_REV

SELECTOR_OBJ_TYPE

TMP_JOURNALS_TO_PROCESS_T

TAX_EXEMPTION_CODE

TOPUP_T

TOPUP_TYPE

TRANSITION_T

PRORATION_FLAG

Patch Set 4 Schema and Index Changes

BRM 12.0 Patch Set 4 includes the following schema and index changes:

  • The following tables are added:

    • EVENT_ACTIVITY_JOB_REQ_T

    • PERFORMANCE_SNAPSHOT_T

    • PERFORMANCE_RESULTS_T

    • PERFORMANCE_SQL_DATA_T

    • OFFER_ATTRIBUTE_GROUP_T

    • OFFER_ATTRIBUTE_T

    • JOB_TEMPLATE_SCHEMAS_T

    • AU_JOB_TEMPLATE_SCHEMAS_T

    • EVENT_BILLING_TOPUP_T

    • EVENT_AUDIT_TRANS_INFO_T

    • BRM_PS_T

  • The following column is added in the EVENT_BILLING_CHARGE_CC_T table:

    • TYPE_STR

  • The following column is added in the EVENT_BILLING_VALID_CC_T table:

    • TYPE_STR

  • The following column is added in the EVENT_BILLING_DISC_ACTION_T table:

    • PURCHASE_MODE

  • The following columns are added in the EVENT_BILLING_PRODUCT_ACTION_T table:

    • PURCHASE_MODE

    • CALENDAR_DOM

  • The following columns are added in the PRODUCT_T table:

    • CALENDAR_DOM

    • DATE_RANGE_TYPE

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the DISCOUNT_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the PLAN_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the DEAL_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the PURCHASED_PRODUCT_T table:

    • CALENDAR_DOM

    • PURCHASE_MODE

  • The following column is added in the DEAL_PRODUCTS_T table:

    • PURCHASE_MODE

  • The following column is added in the DEAL_DISCOUNTS_T table:

    • PURCHASE_MODE

  • The following column is added in the PURCHASED_DISCOUNT_T table:

    • PURCHASE_MODE

  • The following columns are added in the AU_PLAN_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the AU_DISCOUNT_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the AU_PRODUCT_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

    • DATE_RANGE_TYPE

    • CALENDAR_DOM

  • The following columns are added in the AU_DEAL_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following column is added in the AU_PURCHASED_DISCOUNT_T table:

    • PURCHASE_MODE

  • The following column is added in the AU_DEAL_DISCOUNTS_T table:

    • PURCHASE_MODE

  • The following column is added in the AU_DEAL_PRODUCTS_T table:

    • PURCHASE_MODE

  • The following columns are added in the AU_PURCHASED_PRODUCT_T table:

    • PURCHASE_MODE

    • CALENDAR_DOM

  • The following columns are added in the AU_SPONSORSHIP_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following columns are added in the TOPUP_T table:

    • BAL_GRP_OBJ_REV

    • BAL_GRP_OBJ_TYPE

    • BAL_GRP_OBJ_ID0

    • BAL_GRP_OBJ_DB

    • STATUS

    • TOPUPS_DONE

    • NUM_TOPUPS

    • NEXT_TOPUP_T

    • TOPUP_INTERVAL

    • RESOURCE_ID

  • The following columns are added in the SPONSORSHIP_T table:

    • ATTRIBUTE_OBJ_REV

    • ATTRIBUTE_OBJ_TYPE

    • ATTRIBUTE_OBJ_ID0

    • ATTRIBUTE_OBJ_DB

  • The following column is added in the THREAD_INFO_T table:

    • THREAD_ID_DB

    • THREAD_ID_ID0

    • THREAD_ID_TYPE

    • THREAD_ID_REV

  • The following indexes are added:

    • i_PERF_SNAPSHOT__ID

    • i_PERF_SNAPSHOT__HOST_NAME

    • i_PERF_RESULTS_ADD

    • i_PERF_RESULTS__ID

    • i_PERF_SQL_DATA__ID

    • i_PERF_SQL_DATA_BUF__ID

Patch Set 3 Schema and Index Changes

BRM 12.0 Patch Set 3 includes the following schema and index changes:

  • The following tables are added:

    • JOB_TEMPLATE_CUSTOM_INFO_T

    • JOB_DEFINITION_T

    • EVENT_JOB_TEMPLATE_INFO_T

    • BOC_VERSION_T

Patch Set 2 Schema and Index Changes

BRM 12.0 Patch Set 2 includes the following schema and index changes:

  • The following tables are added:

    • CMT_BALANCES_T

    • EVT_BILLING_CHARGE_CC_TRANS_T

    • EVT_BILL_VLDT_CC_TRANS_T

    • JOB_TEMPLATE_TBILL_BILLINFO_T

    • JOB_TEMPLATE_TBILL_INFO_T

    • JOB_TEMPLATE_TBILL_PAY_TYPES_T

    • JOB_TEMPLATE_TBILL_STATUSES_T

    • JOB_TEMPLATE_TBILLP_BILLINFO_T

    • JOB_TEMPLATE_TBILLP_INFO_T

    • JOB_TEMPLATE_TBILLP_STATUSES_T

    • JOB_TEMPLATE_WF_CATEGORIES_T

    • NAMEINFO_T

    • PAYINFO_CC_TRANS_T

  • The following columns are added in the EVENT_CUSTOMER_NAMEINFO_T table:

    • POID_DB

    • POID_ID0

    • POID_TYPE

    • POID_REV

  • The following columns are added in the JOB_BOC_T table:

    • WORKFLOW_OBJ_ID

    • WORKFLOW_OBJ_TYPE

    • WORKFLOW_OBJ_REV

  • The following column is added in the JOB_TEMPLATE_T table:

    • WORKFLOW_FLAG

  • The following columns are added in the HISTORY_SUBSCRIBER_CONTRACT_T table:

    • GROUP_CONTRACT_OBJ_ID0

    • GROUP_CONTRACT_OBJ_TYPE

    • GROUP_CONTRACT_OBJ_REV

    • PLAN_CONTRACT_OBJ_DB

    • PLAN_CONTRACT_OBJ_ID0

    • PLAN_CONTRACT_OBJ_TYPE

    • PLAN_CONTRACT_OBJ_REV

  • The following column is added in the RATE_BAL_IMPACTS_T table:

    • TAXABLE_AMOUNT

  • The following columns are added in the SERVICE_T table:

    • NAMEINFO_OBJ_ID0

    • NAMEINFO_OBJ_TYPE

    • NAMEINFO_OBJ_REV

  • The following columns are added in the SUBSCRIBER_CONTRACT_T table:

    • GROUP_CONTRACT_OBJ_DB

    • GROUP_CONTRACT_OBJ_IDO

    • GROUP_CONTRACT_OBJ_TYPE

    • GROUP_CONTRACT_OBJ_REV

    • PLAN_CONTRACT_OBJ_DB

    • PLAN_CONTRACT_OBJ_ID0

    • PLAN_CONTRACT_OBJ_TYPE

    • PLAN_CONTRACT_OBJ_REV

  • The following indexes are added:

    • I_PROC_AUD_POCESS_END__ID

    • I_NAMEINFO__ID

    • I_NAMEINFO_ACCOUNT_OBJ__ID

    • I_NAMEINFO_PHONES__ID

    • I_PROFILE_SUBS_PREF__ID

    • I_ALLOWANCE__ID

    • I_ASS_BUS_PROFILE_TEMPLATES__ID

    • I_CFG_PROV_TAX_CODE_EFFECT__ID

    • I_CFG_PROV_TAXES_REC__ID

    • I_CFG_PROV_TAX_INFO__ID

    • I_CFG_PROV_TAX_JUR_REC__ID

    • I_DELIVERABLE_PRODUCT__ID

    • I_EVT_ACT_SSP_MS__ID

    • I_EVT_CONTRACT__ID

    • I_EVT_CONTRACT_MODIFY__ID

    • I_EVT_CONTRACT_RENEW__ID

    • I_EVT_CONTRACT_START__ID

    • I_EVT_PRODUCT_FEE_PENALTY__ID

    • I_FEATURE__ID

    • I_HIS_SUB_CNTR_ACCT_PKG__ID

    • I_NOTE_DATA__ID

    • I_RATE_RBI_INFO__ID

    • I_RECURRING_ALLOWANCE__ID

    • I_REV_DISTRIB_SC__ID

    • I_REVENUE_DETAILS__ID

    • I_REVENUE_PRODUCT_ACCT__ID

    • I_REVENUE_PRODUCT_SC__ID

    • I_REVENUES_PROD_T__ID

    • I_REV_EVENT_BAL_IMPT__ID

    • I_REV_EVENT_DEL__ID

    • I_REV_EVENT__ID

    • I_REV_PRODUCT_DEL__ID

    • I_SERVICE_ENTITLEMENTS__ID

    • I_SUB_CNTR_ACCT_PKG__ID

    • I_ASSOCIATED_BUS_PROFILE__ID

    • I_DELIVERABLE__ID

    • I_ENTITLEMENT__ID

    • I_HIS_SUBSCRIBER_CONTRACT__ID

    • I_REV_DISTRIB__ID

    • I_REVENUE_BASIS_ITEM__ID

    • I_REVENUE_PRODUCT__ID

    • I_SUBSCRIBER_CONTRACT__ID

    • I_SUBSCRIPTION_TERMS__ID

Patch Set 1 Schema and Index Changes

BRM 12.0 Patch Set 1 includes the following schema and index changes:

  • The following tables are added:

    • EVENT_ACT_ROLLUP_ITEMS_T

    • TMP_AR_ITEM_TO_ROLL_UP_T

  • The following columns are added in the ITEM_T table:

    • ITEM_CLASS

    • AR_ITEM_OBJ

  • The following column is added in the TMP_JOURNALS_TO_PROCESS_T table:

    • AR_BILLINFO_OBJ

  • The following indexes are added:

    • I_TMP_AR_ITM_ROLLUP__ID

    • I_TMP_AR_ITM_ROLLUP__STATUS

    • I_ITEM_AR_ITEM_OBJ__ID

    • I_TMP_JOURNALS_TO_PROCESS__AR