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
-