My Oracle Support Banner

PIN_REL Throws Error While Loading Rated CDR After Billing Day (Doc ID 1050312.1)

Last updated on NOVEMBER 08, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
Checked for relevance on 28-Nov-2011
Checked for relevance on 31-May-2013.
Checked for relevance on 29-Nov-2014.

Goal

When one loads a rated CDR after the end of billing cycle, while billing is not completed yet, pin_rel throws an error as described in the following scenario.

Note : cm pin.conf has the following entry:

#- fm_bill config_billing_delay 10

Scenario:

1. Dec 22 : created account with "Standard GSM Telephony" product
2. Bill cycle is : Dec 22 - Jan 22
3. Jan 22 : Did not run billing
4. Jan 23 : rated a CDR dated Jan 23
5. Jan 23 : using pin_rel , tried loading the rated output
6. error in rel.pinlog is as below :

Error 12/22/09 6:17:06:0450 AM ( 1261491426450 ) T:Update SP Thread 1 REL
RELUpdaterThread 1:test:UnknownProgramName:0:Update SP Thread 1:0:1261491426:0
ORA-20003: Error -20014error while processing data from
event_bal_impacts_t occurred in the update procedure start_obj_id0 =
1410330370809201133 end_obj_id0 = 1410330370809201133 sqlcode = -20014
sqlerrm = ORA-20014: Error -20002 occurred in the update item balances
ORA-20002: Error creating item where item_obj_id0 = 423667 item_obj_db = 1
account_obj_id0 = 411167 bal_grp_obj_id0 = 411423 item_obj_type =
/item/misc item_obj_rev = 0
ORA-20001: Error selecting from bill_t where poid_id0 = 0 AND poid_db = 1
ORA-06512: at "PIN3108.PIN_REL", line 1825
ORA-01403: no data found
ORA-06512: at "PIN08.PIN_REL", line 3024
ORA-20002: Error creating item where item_obj_id0 = 423667 item_obj_db = 1
account_obj_id0 = 4
ORA-06512: at "PIN08.PIN_REL", line 3643
ORA-20014: Error -20002 occurred in the update item balances ORA-20002:
Error creating item where item_obj_id0 = 423667 item_obj_db = 1
account_obj_id0 = 411167 bal_grp_obj_id0 = 411423 item_obj_type =
/item/misc item_obj_rev = 0
ORA-20001: Error selecting from
Error 12/22/09 6:17:06:0466 AM ( 1261491426466 ) T:main REL IREL
1:kalel:UnknownProgramName:0:main:7:1261491426:0
Error encountered in the Update Stored Procedure: 8003
The update stored procedure encountered an error on an update statement.
Error 12/22/09 6:17:06:0466 AM ( 1261491426466 ) T:main REL IREL
1:kalel:UnknownProgramName:0:main:7:1261491426:0
Exiting with return code: 8
 

Questions:

1.  Why is the error thrown ?
2.  In the BRM documentation, one can see the following statement:

"Loading the rated events into the BRM database: You use Rated Event (RE) Loader to load rated events into the BRM database. Before updating items in the database, RE Loader checks the updater flag in the RE Loader Infranet.properties file. If the flag value is 1, RE Loader creates in the database the new item objects that were added. By default, the flag is set to 1"

That does mean REL should create the new item object successfully, correct?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.