Items Used For Rating Are Not Created For Migrated Accounts.

(Doc ID 1384196.1)

Last updated on FEBRUARY 09, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Goal

After an account creation using CMT, for rating process it is necessary to have a couple of items which are used to rate and load CDRs into BRM DB. Those items are configured on the file item_tags.xml as <ItemType precreate="true" type="cumulative">.

For an account created on Customer Center, the items are created when the product related is purchased. For a migrated account, those items will not be created until the first billing cycle on BRM. But, these items are required for rating process before billing.

When a CDR is rated for a migrated account (before billing) and this one is loaded into DB (pin_rel), this error occurs:
ORA-20003: Error -20014error while processing data from event_bal_impacts_t occurred in the update procedure start_obj_id0 = 1421413448019424399 end_obj_id0 = 1421413448019424399 sqlcode = -20014 sqlerrm = ORA-20014: Error -20002 occurred in the update item balances ORA-20002: Error creating item where item_obj_id0 = 2682239 item_obj_db = 1 account_obj_id0 = 607164 bal_grp_obj_id0 = 615373 item_obj_type = /item/usage/local item_obj_rev = 0
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "PIN.PIN_REL", line 3096
ORA-20002: Error creating item where item_obj_id0 = 2682239 item_obj_db = 1 account_obj_id0 = 607164 bal_grp_obj_id0 = 615373 item_obj_type = /item/usage/local item_
ORA-06512: at "PIN.PIN_REL", line 3723
ORA-20014: Error -20002 occurred in the update item balances ORA-20002: Error creating item where item_obj_id0 = 2682239 item_obj_db = 1 account_obj_id0 = 607164 bal_grp_obj_id0 = 615373 item_obj_type = /item/usage/local item_obj_rev = 0


How can those items be created for a migrated account before first billing cycle?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms