Multiple Service_t.Item_poid_list Entries Result In Field Overflow

(Doc ID 556878.1)

Last updated on JUNE 11, 2010

Applies to:

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


When rating call details records (CDR) ,multiple items are getting created after sim change.

Later when this is loaded into the database results in an oracle error.

Snippet of the Oracle errors


2007.10.24 01:51:53 FEL Updater_thread_10 MINOR Error running updater
for file /opt/portal/7.2/pin2/ifw/custom/apps/fel/input/REL_CNT_SBS0CHEC10710010031-937974_414086.out.prc: DBD::Oracle::st execute failed:

ORA-20001: Error in startThreadProcessing procedure occured for thread_id: 10 ORA-200
01: Error in startThread2 procedure occured for thread_id: 10

ORA-20003: Error - 20014error while processing data from event_bal_impacts_t occurred in the update
procedure start_obj_id0 = 1395852007389733331 end_obj_id0 = 1395852007389733332
sqlcode = -20014 sqlerrm = ORA-20014: Error -20002 occurred in the update item
balancesORA-20002: Error creating item where item_obj_id0 = 25617529731 item_obj
_db = 1 account_obj_id0 = 25026249483 bal_grp_obj_id0 = 25026251915 item_obj_db
= 1 item_obj_type = /i
ORA-06512: at "BTO_PIN.PIN_FEL", line 306
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) [for Statement "
p_thread_id => :p_thread_id,
p_session_id => :p_session_id,
p_batch_size => :p_batch_size,
p_creation_process => :p_creation_process);
" with ParamValues: :p_thread_id='10', :p_session_id="1395852007389733279", :
p_batch_size="1", :p_creation_process="RATING_PIPELINE"] at ./FELupdate line 160.


The Steps are

1. Create an account having SIM Number assigned for telephony service say account is created on
2. Move pin_virtual_time by 10 Days to 10/01/2010
3. Change the SIM Number in the Services tab of the Customer Center
4. Stop_batch_controller
5. Create an CDR file in the $IFW_HOME/data/in having two records one before
the SIM Change date and 2nd one after the SIM Changing Date
6. After getting processed and out file being generated at
$IFW_HOME/data/out/gsm/telephony, check for the /item/misc poids




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