8 Storable Class Changes
The Oracle Communications Billing and Revenue Management (BRM) 12.0 Patch Sets include new and modified storable classes.
Topics in this document:
New Storable Classes
Table 8-1 lists the storable classes that have been introduced in the BRM 12.0 patch set releases.
Table 8-1 New Storable Classes
New Storable Class | Description |
---|---|
/config/collections/promise_to_pay_spec |
(Patch Set 7) Store details about a promise-to-pay specification for bills that are in collections. It lists the minimum installment amount, the number of days between installment payments, and so on. |
/config/stored_procedure |
(Patch Set 7) Stores information about all stored procedures that can be run by client applications connected to the CM. The object contains information about stored procedures included with BRM, but you can add custom stored procedures. |
/event/group/sharing/products |
(Patch Set 7) Stores information about product sharing groups. |
/event/group/sharing/products/create |
(Patch Set 7) This event is generated when a /group/sharing/products object is created for an account or service. |
/event/group/sharing/products/delete |
(Patch Set 7) This event is generated when a /group/sharing/products object is deleted for an account or service. |
/event/group/sharing/products/modify |
(Patch Set 7) This event is generated when a /group/sharing/products object is modified for an account or service. |
/group/sharing/products |
(Patch Set 7) Stores a list of products for the owner of a product sharing group. |
/config/calendar/silent_days |
(Patch Set 6) Stores all calendar days that are considered silent days. Messages cannot be sent to customers on these days. |
/config/deposit |
(Patch Set 6) Stores configuration data for deposits. |
/config/deposit_spec_profile |
(Patch Set 6) Stores the common business rules for the deposits in your organization. |
/deposit_refund_request |
(Patch Set 6) Stores information about an account's deposit refund status. |
/deposit_specification |
(Patch Set 6) Stores the configuration for a deposit specification. |
/event/billing/deposit |
(Patch Set 6) Stores details about a deposit event. |
/event/billing/deposit/reversal |
(Patch Set 6) Stores details about a deposit reversal event. |
/event/billing/deposit/interest |
(Patch Set 6) Event created when interest is applied to a deposit. |
/event/billing/deposit/interest/credit |
(Patch Set 6) Event created when interest is applied to a credit card deposit. |
/event/billing/deposit/interest/debit |
(Patch Set 6) Event created when interest is applied to a debit deposit. |
/event/billing/loan_grant |
(Patch Set 6) Stores details about a loan grant event. |
/event/billing/loan_late_fee |
(Patch Set 6) Event created when a late payment fee is applied for a late loan repayment. |
/event/billing/loan_pullback |
(Patch Set 6) Event created when the amount due for a loan is pulled from the customer's main balance. |
/event/billing/loan_recovery |
(Patch Set 6) Event created when a loan grant is recovered from a customer. |
/event/billing/loan_recovery_reversal |
(Patch Set 6) Event created when a customer reverts a loan payment. |
/event/billing/product/fee/purchase/deposit |
(Patch Set 6) Event created when a deposit fee associated with a product is applied. |
/event/billing/product/fee/purchase/deposit/refund |
(Patch Set 6) Event created when a deposit refund fee associated with a product is applied. |
/event/deposit |
(Patch Set 6) Stores a deposit event. |
/event/deposit/collected |
(Patch Set 6) Event created when a deposit is collected. |
/event/deposit/create |
(Patch Set 6) Event created when a deposit is created. |
/event/deposit/receive |
(Patch Set 6) Event created when a deposit is received. |
/event/deposit/refund |
(Patch Set 6) Event created when a deposit is refunded. |
/event/deposit/refund/approved |
(Patch Set 6) Event created when the request for a deposit refund is approved. |
/event/deposit/refund/rejected |
(Patch Set 6) Event created when the request for a deposit refund is rejected. |
/event/deposit/refund/request |
(Patch Set 6) Event created when a deposit refund is requested. |
/event/deposit/release |
(Patch Set 6) Event created when a deposit is released. |
/event/deposit/reversal |
(Patch Set 6) Event created when a deposit is reversed. |
/event/deposit/transfer |
(Patch Set 6) Event created when a deposit is transferred. |
/event/deposit/update |
(Patch Set 6) Event created when a deposit is updated. |
/item/deposit |
(Patch Set 6) Stores details about a deposit. |
/item/deposit/charge |
(Patch Set 6) Stores details about a deposit charge. |
/item/deposit/interest |
(Patch Set 6) Stores details about interest on a deposit. |
/item/deposit/interest/credit |
(Patch Set 6) Stores details about deposit interest applied to a credit card. |
/item/deposit/interest/debit |
(Patch Set 6) Stores details about deposit interest applied to debits. |
/item/deposit/refund |
(Patch Set 6) Stores details about a refunded deposit. |
/item/deposit/refund/fee |
(Patch Set 6) Stores details about a refund deposit fee. |
/item/deposit/reversal |
(Patch Set 6) Stores details about a deposit reversal. |
/item/loan_late_fee |
(Patch Set 6) Stores details about late fees applied to a loan. |
/purchased/deposit |
(Patch Set 6) Stores details about a purchased deposit. |
/request |
(Patch Set 6) A base class for recording a request or transaction for review. |
/request/failed |
(Patch Set 6) Stores the error summary for a failed request. |
/request/failed/opcode |
(Patch Set 6) Stores information about the opcode called as part of the failed request. |
/request/failed/rest |
(Patch Set 6) Stores information about the failed request from the REST API. |
/config/delivery_methods |
(Patch Set 5) Stores the supported delivery methods, such as email or IVR, for notifications. |
/config/event_promo_map |
(Patch Set 5) Stores the mapping between events and promotional events for applying event-based promotions. |
/config/event_promo_tag_map |
(Patch Set 5) Stores the mapping between promotional tags and promotional events. |
/config/loan | (Patch Set 5) A configuration object that stores loan parameters. |
/config/notification_spec |
(Patch Set 5) Stores notification specifications. |
/config/taxcodes_map |
(Patch Set 5) Stores your tax codes. |
/config/taxexemption_code_map |
(Patch Set 5) Stores details about each tax exemption code. |
/event/audit/transfer_balance |
(Patch Set 5) Stores an audit event for tracking individual balance transfers between balance groups. |
/event/billing/fee/balance_transfer |
(Patch Set 5) Stores the balance transfer fee for the target or source account. |
/event/billing/loan_credit | (Patch Set 5) Stores details about a loan event. |
/event/billing/loan_debit | (Patch Set 5) Stores details about a loan event. |
/event/billing/loan_fee | (Patch Set 5) Stores details about a loan fee event. |
/event/billing/loan_grant | (Patch Set 5) Stores details about a loan that also grants non-currency resources. You configure charge offers in PDC to grant the resources for this event. |
/event/billing/topup |
(Patch Set 5) Stores details about a top-up applied to an account. |
/installment_schedule |
(Patch Set 5) Stores details about an installment payment plan. |
/item/installment |
(Patch Set 5) Stores details about an installment. |
/item/loan_credit | (Patch Set 5) Stores details about a loaned amount. |
/item/loan_debit | (Patch Set 5) Stores details about the asset representing a loan. |
/item/loan_fee | (Patch Set 5) Stores details about a loan fee. |
/offering_override_values | (Patch Set 5) Stores details for overriding a rate for a period of time. |
/profile/loan | (Patch Set 5) A profile object that stores loan parameters specific to a customer or service. |
/profile/specialdates |
(Patch Set 5) Stores extended account attributes such as special dates. These attributes are used to apply promotions based on the occurrence of special dates. |
/schedule/notification |
(Patch Set 5) Stores deferred actions for notifications. |
/tax_exemption_selector |
(Patch Set 5) Stores information about tax exemption selectors, which can be used to apply tax exemptions based of different attributes. |
/config/note_type |
(Patch Set 4) Stores information for account-level notes in Billing Care. |
/deliverable | (Patch Set 4) Stores details about deliverables. |
/deliverable/product | (Patch Set 4) Stores details for a physical good deliverable type. |
/deliverable/service | (Patch Set 4) Stores details about these deliverable types: one-time activities, metered services, and continuous services. |
/entitlement | (Patch Set 4) Stores entitlement information about deliverables. |
/entitlement/allowance | (Patch Set 4) Stores entitlement information for continuous service deliverables. |
/entitlement/allowance/onetime | (Patch Set 4) Stores entitlement information for one-time activity deliverables. |
/entitlement/allowance/recurring | (Patch Set 4) Stores entitlement information for metered service deliverables. |
/entitlement/feature | (Patch Set 4) Stores entitlement information for metered service deliverables. |
/event/activity/job_request | (Patch Set 4) Stores audit data when the PCM_OP_JOB_EXECUTE opcode calls an application in a non-job context. |
/offer_attribute_group | (Patch Set 4) Stores extended attributes defined for pricing components. |
/performance_snapshot/realtime |
(Patch Set 4) Store monitoring information for BRM cloud native. |
/performance_sql_data |
(Patch Set 4) Store monitoring information for BRM cloud native. |
/revenue_basis_item | (Patch Set 4) Stores entitlement information for metered service deliverables. |
/revenue_basis_item/rate_based | (Patch Set 4) Stores revenue basis data, such as the standalone selling price and earning schedule, for continuous service and physical good deliverables. |
/revenue_basis_item/value_based | (Patch Set 4) Stores revenue basis data, such as the standalone selling price and earning schedule, for metered service and one-time activity deliverables. |
/event/job_template |
(Patch Set 3) Stores a notification event for job_template processing. |
/event/job_template/create |
(Patch Set 3) Stores a create event for the job_template. |
/event/job_template/modify |
(Patch Set 3) Stores a modify event for job_template. |
/event/job_template/delete |
(Patch Set 3) Stores a delete event for job_template. |
/job_definition |
(Patch Set 3) Stores the job's running location and usage summary. |
/job_template/custom |
(Patch Set 3) Stores the command for running the custom Business Operations job. |
/history_subscriber_contract |
(Patch Set 2) Stores a copy of the subscriber contract data. This class is created when a contract is renewed or modified. |
/subscriber_contract |
(Patch Set 2) Stores the subscriber contract data. |
/cmt_balances |
(Patch Set 2) Stores the balance data temporarily. |
/tmp_ar_item_to_roll_up |
(Patch Set 1) Stores information for the A/R items of the nonpaying child bill units to roll them up to the paying parent bill unit. |
/event/activity/roll_up |
(Patch Set 1) Records activity related to rolling of items up to the paying parent bill unit. |
/recurring_bundle_history |
(Patch Set 1) Stores information about recurring bundles. |
Changed Storable Classes
Table 8-2 lists the storable classes that have been modified in the BRM 12.0 patch set releases.
Table 8-2 Changed Storable Classes
Changed Storable Class | Description |
---|---|
/config/business_events |
(Patch Set 8) Contains this new field under the PIN_FLD_EVENTS array:
|
/config/distribution |
(Patch Set 8) Contains this new field under the PIN_FLD_DISTRIBUTION array:
|
/config/notification_spec |
(Patch Set 8) Contains these new fields under the PIN_FLD_NOTIFICATION_SPEC array:
|
/deal /event/billing/discount/action /purchased_discount |
(Patch Set 8) Contains this new field under the PIN_FLD_DISCOUNTS array:
|
/process_audit/billing |
(Patch Set 8) Contains this new field under the PIN_FLD_FAILED_ACCOUNTS array:
|
/product |
(Patch Set 8) Contains these new fields:
|
/service |
(Patch Set 8) Contains these new fields:
|
/balance_group |
(Patch Set 7) Contains these new fields under the PIN_FLD_BALANCES array:
|
/collections_scenario |
(Patch Set 7) Contains these new fields under the PIN_FLD_PROMISE_TO_PAY array:
|
/config/business_events | (Patch Set 7) The PIN_FLD_EVENT_TYPE field
includes this new value:
|
/config/credit_profile |
(Patch Set 7) Contains these new fields in the PIN_FLD_PROFILES array:
|
/config/notification_spec | (Patch Set 7) The following fields include
new values:
|
/deal |
(Patch Set 7) Contains these new fields under the PIN_FLD_PRODUCTS array:
|
/discount |
(Patch Set 7) Contains this new field:
|
/event |
(Patch Set 7) Contains these new fields under the PIN_FLD_SUB_BAL_IMPACTS array:
|
/event/activity/collections/promise_to_pay |
(Patch Set 7) Contains this new array:
|
/event/billing/limit |
(Patch Set 7) Contains these new fields in the PIN_FLD_LIMIT array:
|
/event/billing/product/action |
(Patch Set 7) Contains this new field in the PIN_FLD_ACTION_INFO array:
|
/plan |
(Patch Set 7) Contains these new fields in the PIN_FLD_LIMIT array:
|
/product |
(Patch Set 7) Contains this new field:
|
/purchased_deposit |
(Patch Set 7) Contains these new fields:
|
/purchased_product |
(Patch Set 7) Contains this new field:
|
/balance_group | (Patch Set 6) Contains these new fields under
the PIN_FLD_SUB_BALANCES array:
|
/collections_action | (Patch Set 6) Modified to sending messages to
customers through external notification applications. It contains these
new fields:
|
/config/business_events | (Patch Set 6) Modified to support
notifications in Billing Care. The object's PIN_FLD_EVENT_TYPE field is
now set to one of the following:
|
/config/credit | (Patch Set 6) Contains these new fields:
|
/config/delivery_methods | (Patch Set 6) Modified to sending messages to
customers through external notification applications. It contains this
new field:
|
/event/billing/cycle/tax |
(Patch Set 6) The PIN_FLD_TAXES array contains the new PIN_FLD_ITEM_OBJ field, which holds the corresponding charge item POID. |
/event/billing/limit | (Patch Set 6) Modified to support temporary
credit limits. It contains these new fields:
|
/event/billing/loan_fee | (Patch Set 6) Modified to include the PIN_FLD_AMOUNT field to indicate the loan amount. |
/event/billing/payment/cc | (Patch Set 6) Contains these new fields:
|
/event/billing/product/action | (Patch Set 6) The PIN_FLD_NEXT_RETRY_T field is added to record when a subscription for which the subscriber has insufficient balance will next be retried. |
/installment_schedule | (Patch Set 6) Modified to sending messages to
customers through external notification applications. It contains these
new fields:
|
/item |
(Patch Set 6) Modified to include the PIN_FLD_TAX_DATA field, which holds tax-related data about an item such as the tax code, amount taxed, tax, and amount of tax adjusted. |
/payinfo/cc | (Patch Set 6) Contains these new fields:
|
/plan | (Patch Set 6) Contains these new fields:
|
/profile/loan | (Patch Set 6) Contains these new fields:
|
/product | (Patch Set 6) These new fields are used when
PIN_FLD_TYPE for the rate is set to 745, 747, or
748:
|
/purchased_product | (Patch Set 6) The PIN_FLD_NEXT_RETRY_T field is added to record when a subscription for which the subscriber has insufficient balance will next be retried. |
/rate | (Patch Set 6) PIN_FLD_TYPE is modified to
support new values for exceeding credit limits:
These new fields are used when PIN_FLD_TYPE for the rate is set to 747:
|
/balance_group |
(Patch Set 5) Contains these new fields:
|
/batch/rel |
(Patch Set 5) Contains these new fields to handle new processing options for the Rated Event Manager: PIN_FLD_FILES is an array that contains elements that each correspond to a file of CDR data for this batch Rated Event Loader session. Each element contains the following fields:
PIN_FLD_STATUSES is an array that contains elements that each correspond to the status of a retry attempt for a Rated Event Loader session. Each element contains the following fields:
|
/bill |
(Patch Set 5) Contains these new fields:
|
/config/beid |
(Patch Set 5) Contains the new PIN_FLD_ENABLE_EXPIRY_NOTIFICATION field, which specifies whether to generate notifications if a customer's balance is about to expire. |
/config/credit_profile | (Patch Set 5) Contains new fields to
configure the thresholds for triggering automatic loans:
|
/config/subscriber_preferences_map |
(Patch Set 5) The PIN_FLD_TYPE field supports three new values: 6 (TIME), 7 (MULTI SELECT ENUM), and 262 (TIME RANGE). |
/deal |
(Patch Set 5) Contains these new fields in the PIN_FLD_PRODUCTS array:
|
/event | (Patch Set 5) The PIN_FLD_OUTSTANDING_AMOUNT field is added in the PIN_FLD_BAL_IMPACTS array.This field specifies outstanding amounts remaining after an existing balance is used up when exceeding a credit limit. |
/event/billing/discount/action |
(Patch Set 5) Contains these new fields:
|
/event/billing/product/action |
(Patch Set 5) Contains these new fields:
|
/history_bills |
(Patch Set 5) Contains these new fields:
|
/product |
(Patch Set 5) Contains the new PIN_FLD_ENABLE_NOTIFICATION field, which specifies whether to generate notification events for subscriptions that contain this charge offer when it is about to expire or renew. Possible values are:
Also, the existing PIN_FLD_FLAGS field in the PIN_FLD_USAGE_MAP array includes a new possible value of RATE_LIFECYCLE_SUSPEND (0x04), which specifies to continue charging the product when the life cycle state is suspended. |
/profile/subscriber_preferences |
(Patch Set 5) Contains the new PIN_FLD_SUBSCRIBER_PREFERENCES array, which specifies an account's subscriber preferences. |
/purchased_discount |
(Patch Set 5) Contains these new fields:
|
/purchased_product |
(Patch Set 5) Contains these new fields:
|
/rate |
(Patch Set 5) Contains these new fields:
|
/topup |
(Patch Set 5) Modified to support top-ups of noncurrency resources and recurring top-ups, and proration during state changes. It contains these new fields:
|
/transition |
(Patch Set 5) Modified to support proration of cycle fees during state changes. It contains a new PIN_FLD_PRORATION_FLAG field, which specifies how to apply cycle fees when customers transition from one package or bundle to another: prorate both the current and new cycle fees (1), apply the current bundle's fee to this cycle, and then start applying the new bundle's fee next cycle (2), or start applying the new bundle's fee to this cycle, and fully refund the current bundle's fee (4). |
/config/glid | (Patch Set 4) Contains a new PIN_FLD_TYPE field that specifies the GLID type: Standard (0), A/R (1), Revenue (2), Contract (3). |
/deal |
(Patch Set 4) Contains new fields:
|
/discount | (Patch Set 4) Contains a new PIN_FLD_ATTRIBUTE_OBJ field that specifies the POID of the /offer_attribute_group object containing extended attributes for the /discountobject. |
/event/billing/charge/cc | (Patch Set 4) Modified to support Card Type Indicators (CTIs). It includes a new PIN_FLD_TYPE_STR field under PIN_FLD_CC_INFO, which is used to store the CTI returned by Paymentech. |
/event/billing/product/action | (Patch Set 4) Contains these new fields:
|
/event/billing/validate/cc | (Patch Set 4) Modified to support CTIs. It includes a new PIN_FLD_TYPE_STR field under PIN_FLD_CC_INFO, which is used to store the CTI returned by Paymentech. |
/job_template |
(Patch Set 4) Modified to support Business Operations Center on a multischema system. It contains a new PIN_FLD_SCHEMAS array for storing the schema number on which to run a job. |
/plan | (Patch Set 4) Contains a new PIN_FLD_ATTRIBUTE_OBJ field that specifies the POID of the /offer_attribute_group object containing extended attributes for the /plan object. |
/product | (Patch Set 4) Contains new fields:
|
/purchased_product | (Patch Set 4) Contains new fields:
|
/sponsorship | (Patch Set 4) Contains a new PIN_FLD_ATTRIBUTE_OBJ field that specifies the POID of the /offer_attribute_group object containing extended attributes for the /sponsorship object. |
/event/billing/charge/cc | (Patch Set 2) Modified to support stored-credential transactions. |
/event/billing/validate/cc | (Patch Set 2) Modified to support stored-credential transactions. |
/event/customer/nameinfo | (Patch Set 2) Modified to store the POID of the /nameinfo object that changed and is populated for service-level contact information. |
/job/boc | (Patch Set 2) Modified to run workflow jobs in Business Operations Center. |
/job_template/billing | (Patch Set 2) Modified to run workflow jobs in Business Operations Center. |
/job_template/collect | (Patch Set 2) Modified to support workflow jobs in Business Operations Center. |
/job_template/invoice | (Patch Set 2) Modified to support workflow jobs in Business Operations Center. |
/job_template/ledger_report | (Patch Set 2) Modified to support workflow jobs in Business Operations Center. |
/payinfo/cc | (Patch Set 2) Modified to store card credentials for future transactions. |
/rate | (Patch Set 2) Modified to support enhancements in BRM 12.0 Patch Set 2. |
/service | (Patch Set 2) Modified to support enhancements in BRM 12.0 Patch Set 2. |
/tmp_journals_to_process | (Patch Set 1) Modified to store information for the journals of the nonpaying child bill units to roll them up to the paying parent bill unit. |