PIN_REL Throws Error While Loading Rated CDR After Billing Day
(Doc ID 1050312.1)
Last updated on JANUARY 16, 2020
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.
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:
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 :
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:
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! |
In this Document
Goal |
Solution |