Pin_bill_accts Errors Out For Billinfos Having DOM 31 (Doc ID 1519044.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


There are many billinfos having DOM 31. These billinfos will be billed on the last day of the month. Considering the fact that Sep has got only 30 days, these billinfos were supposed to be billed on Sep30.
But these billinfos are not been billed rather they have got the ACTG_LAST_T and ACTG_NEXT_T set as Sep30. Also same values exists for LAST_BILL_T and NEXT_BILL_T.

Below is the log snippet for the same.

 

Replication Steps:
------------------------

1) On 7/31, Create CC account with BDOM=31
2) On 7/31, Run pin_bill_day.
3) On 8/31, run pin_bill_day
4) On 9/13, do a billing profile update.

Input flist for Step 4:

===> database 0.0.0.1 from pin.conf "userid"
nap(2143)> r PCM_OP_CUST_UPDATE_CUSTOMER.ifl 1
nap(2143)> d 1
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4066495 0
0 PIN_FLD_BILLINFO ARRAY [0] allocated 20, used 8
1 PIN_FLD_PAY_TYPE ENUM [0] 10003
1 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 4064959 0
1 PIN_FLD_ACTG_FUTURE_DOM INT [0] 31
1 PIN_FLD_CURRENCY INT [0] 840
1 PIN_FLD_CURRENCY_SECONDARY INT [0] 0
1 PIN_FLD_PAYINFO_OBJ POID [0] 0.0.0.1 /payinfo/cc 4063935 0
1 PIN_FLD_BILLINFO_ID STR [0] "test_cc1"
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 4066751 0
0 PIN_FLD_PAYINFO ARRAY [0] allocated 20, used 4
1 PIN_FLD_INV_TYPE ENUM [0] 0
1 PIN_FLD_POID POID [0] 0.0.0.1 /payinfo/cc 4063935 0
1 PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_CC_INFO ARRAY [0] allocated 20, used 9
3 PIN_FLD_SECURITY_ID STR [0] ""
3 PIN_FLD_NAME STR [0] "test003"
3 PIN_FLD_DEBIT_EXP STR [0] "XXXX"
3 PIN_FLD_DEBIT_NUM STR [0] "XXXX"
3 PIN_FLD_COUNTRY STR [0] "USA"
3 PIN_FLD_ZIP STR [0] "53546-9160"
3 PIN_FLD_STATE STR [0] "WI"
3 PIN_FLD_CITY STR [0] "JANESVILLE"
3 PIN_FLD_ADDRESS STR [0] "4700 DRESSER DR"
1 PIN_FLD_PAY_TYPE ENUM [0] 10003

Check op_bill_pol_spec_future_cycle output flist.

# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4066495 0
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1348988400) Sun Sep 30 00:00:00 2012
0 PIN_FLD_ACTG_FUTURE_T TSTAMP [0] (1348988400) Sun Sep 30 00:00:00 2012

  
  

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