Problem With Pin_rel To Create /Item

(Doc ID 1366285.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-June-2016***

Symptoms

The pin_rel fails when it tries to create the /item/charges.

Reproduction steps:


1) Add the below entries to config_item_types.xml:

<ItemTypeElement>
<ItemTag>gsm_charges</ItemTag>
<ItemDescription>Charges diverses</ItemDescription>
<ItemType precreate="false" type="cumulative">/item/charges</ItemType>
</ItemTypeElement>
<ItemTypeElement>
<ItemTag>adsl_charges</ItemTag>
<ItemDescription>Charges diverses</ItemDescription>
<ItemType precreate="false" type="cumulative">/item/charges</ItemType>
</ItemTypeElement>
<ItemTypeElement>
<ItemTag>bill_charges</ItemTag>
<ItemDescription>Frais a facturer SAP-RMCA</ItemDescription>
<ItemType precreate="false" type="cumulative">/item/charges</ItemType>
</ItemTypeElement>


2) Add the  below entries to config_item_tags.xml:

<ItemTagElement>
<ItemTag>gsm_charges</ItemTag>
<EventType>/event/delayed/session/telco/gsm</EventType>
<ServiceType>/service/*</ServiceType>
</ItemTagElement>
<ItemTagElement>
<ItemTag>adsl_charges</ItemTag>
<EventType>/event/delayed/session/telco/gsm</EventType>
<ServiceType>/service/*</ServiceType>
</ItemTagElement>
<ItemTagElement>
<ItemTag>bill_charges</ItemTag>
<EventType>/event/delayed/session</EventType>
<ServiceType>/service/*</ServiceType>
</ItemTagElement>


3) Loaded above files using below commands from $PIN_HOME/sys/data/config folder:

$PIN_HOME/bin/load_config_item_tags -dv config_item_tags.xml
$PIN_HOME/bin/load_config_item_types -dv config_item_types.xml


4) Restarted cm
5) Created an account using "Standard GSM" plan on 21st July 2011
6) Verify balance : 45Euro and <3600> Free Tel Seconds
7) Process a telephone usage for 300 seconds on 07/24
8) Verify the balance : 45Euro and <3300>  Free Tel Seconds
9) Move pvt to next billing cycle i.e. 08/24 and process a telephone usage for 300 seconds on 08/24 and load the same via pin_rel.

Errors in the log:

Error 02/18/11 5:20:28:0809 PM ( 1298046028809 ) T:main REL IREL1:devbrm:UnknownProgramName:0:main:0:12
98046028:0 Exiting with return code: 1
Error 03/03/11 5:16:53:0101 PM ( 1299169013101 ) T:Update SP Thread 1 REL
RELUpdaterThread 1:devbrm:UnknownProgramName:0:Update SP Thread 1:0:1299169013:0
ORA-20003: Error -20014error while processing data from event_bal_impacts_t occurred in the update procedure start_obj_id0 = 1420727352762276848 end_obj_id0 =1420727352762276848 sqlcode = -20014 sqlerrm = ORA-20014: Error -20002 occurred in the update item balances ORA-20002:
Error creating item where item_obj_id0 = 264516109365062690 item_obj_db = 3 account_obj_id0 = 1150624
bal_grp_obj_id0 = 1148128 item_obj_db = 3 item_obj_type = /item/charges item_obj_rev = 0
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "CPAILLE.PIN_REL", line 2862
ORA-20002: Error creating item where item_obj_id0 = 264516109365062690 item_obj_db = 3 account_obj_id0 =
1150624 bal_grp_obj_id0 = 11481
ORA-06512: at "CPAILLE.PIN_REL", line 3448
ORA-20014: Error -20002 occurred in the update item balances ORA-20002:
Error creating item where item_obj_id0 = 264516109365062690 item_obj_db = 3 account_obj_id0 = 1150624
bal_grp_obj_id0 = 1148128 item_obj_db = 3 item_obj_type = /item/charges item_obj_rev = 0



Cause

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