Unable To Generate Cycle Rollover Using pin_cmt Utility (Doc ID 1447415.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

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

Symptoms

Rollover events are getting generated but not with the correct values as expected.

1. The rollover_data from the /balance_group obj is not correct.
2. The valid_from field in the /balance_group obj is not populated.

The following is the snippet from the pin_cmt file:

<ActBal> 
<ActBalArr parentRef="" serviceRef="0001760service507626" elem="1" Resource="101111000"> 
<RsvAmt>0</RsvAmt> 
<CrdFlr>0</CrdFlr> 
<CrdLmt>0</CrdLmt> 
<CrdTrsh>0</CrdTrsh> 
<BSBArr elem="1" grtObjRef="/purchased_product"> 
<CurBal>-2.031</CurBal> 
<VldFrm>2011-09-13T00:00:00+0400</VldFrm> 
<ValTo>2011-10-13T00:00:00+0400</ValTo> 
<GrtObj>0001760Produit1440713</GrtObj> 
<UOR>M</UOR> 
<Frq>1</Frq> 
<NetQnty>1</NetQnty> 
</BSBArr> 
</ActBalArr> 
After migration, in the balance group two incomplete arrays are generated, as below (ValidFrom missing, rollover_data not correct: expected values are 65537 and 1073807360).

2 PIN_FLD_VALID_TO_DETAILS INT [0] 0 
0 PIN_FLD_BALANCES ARRAY [109111000] allocated 20, used 7 
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0 
1 PIN_FLD_CREDIT_PROFILE INT [0] 2 
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0 
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0 
1 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10 
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "" 
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 0 
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0 
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5366661 1 
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0 
2 PIN_FLD_ROLLOVER_DATA INT [0] 65536 
2 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null> 
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0 
2 PIN_FLD_VALID_TO TSTAMP [0] (1313179200) Sat Aug 13 00:00:00 2011 
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0 
1 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10 
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "" 
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -18.472 
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0 
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5366661 1 
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0 
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807361 
2 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null> 
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0 
2 PIN_FLD_VALID_TO TSTAMP [0] (1318449600) Thu Oct 13 00:00:00 2011 
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0 
 
The following event cycle rollover is generated with bad sub balances details (valid_from, rollover data) as below : 

0 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/cycle/rollover/monthly 
17592191420243 0 
0 PIN_FLD_CREATED_T TSTAMP [0] (1318428883) Wed Oct 12 18:14:43 2011 
0 PIN_FLD_MOD_T TSTAMP [0] (0) <null> 
0 PIN_FLD_SUB_BAL_IMPACTS ARRAY [0] allocated 20, used 4 
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 5366647 0 
1 PIN_FLD_RESOURCE_ID INT [0] 109111000 
1 PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 5 
2 PIN_FLD_AMOUNT DECIMAL [0] 0 
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "" 
2 PIN_FLD_ROLLOVER_DATA INT [0] 65536 
2 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null> 
2 PIN_FLD_VALID_TO TSTAMP [0] (1313179200) Sat Aug 13 00:00:00 2011 
1 PIN_FLD_SUB_BALANCES ARRAY [1] alloca 
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807361 
2 PIN_FLD_AMOUNT DECIMAL [0] -18.472 
2 PIN_FLD_CONTRIBUTOR_STR 
 

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