Pin_bill_accts Not Picking Up Dom Change Accounts (Doc ID 729302.1)

Last updated on NOVEMBER 23, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 and later
Information in this document applies to any platform.
**Checked for relevance on 09-Nov-2012***

Symptoms

On 7.0 in Production:
Accounts were not billed because they had a DOM change from 11 to 29 (december). Therefore, the actg_next_t of these accounts was 11-Dec. However, the DOM was changed to 29.

Billing uses a bill control file, which contains the current DOM and two previous ones. When billing was run on 12-Dec, only accounts on DOM: 11, 8 and 6 would have been picked up as only these DOMs would be present in the control file. Therefore, the above accounts (which had their DOM changed from 11 to 29) were not picked up (despite actg_next_t set to 11-Dec).

EXPECTED BEHAVIOR

     Account should get billed.

STEPS

1. Created account on July 13th, and billing cycle is July 13th to Aug 5th ( DOM =5 and delay =3).
2. Moved the pvt Aug 8th and ran pin_bill_accts -pay_type 10001 -file PinBillRunControl.xml from apps/pin_billd dir.
3. Bill got created and billing cycle changed to Aug 5th - Sept 5th.
4. Moved the pvt to Aug 18th. Here robj of billinfo
--------------
nap(20651)> robj - 0.0.0.1 /billinfo 398145
# number of field entries allocated 45, used 45
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 398145 4
0 PIN_FLD_CREATED_T TSTAMP [0] (1279033818) Tue Jul 13 15:10:18 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1281269572) Sun Aug 8 12:12:52 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 399681 0
0 PIN_FLD_ACCT_SUPPRESSED INT [0] 0
0 PIN_FLD_ACTG_CYCLE_DOM INT [0] 5
0 PIN_FLD_ACTG_FUTURE_T TSTAMP [0] (1286236800) Tue Oct 5 00:00:00 2010
0 PIN_FLD_ACTG_LAST_T TSTAMP [0] (1280966400) Thu Aug 5 00:00:00 2010
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1283644800) Sun Sep 5 00:00:00 2010
0 PIN_FLD_ACTUAL_LAST_BILL_OBJ POID [0] 0.0.0.1 /bill 400193 0
------------------
5. From customer center changed the DOM from 5th to 20th.
-----------------
nap(20651)> robj - 0.0.0.1 /billinfo 398145
# number of field entries allocated 45, used 45
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 398145 5
0 PIN_FLD_CREATED_T TSTAMP [0] (1279033818) Tue Jul 13 15:10:18 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1282133134) Wed Aug 18 12:05:34 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 399681 11
0 PIN_FLD_ACCT_SUPPRESSED INT [0] 0
0 PIN_FLD_ACTG_CYCLE_DOM INT [0] 20
0 PIN_FLD_ACTG_FUTURE_T TSTAMP [0] (1284940800) Mon Sep 20 00:00:00 2010
0 PIN_FLD_ACTG_LAST_T TSTAMP [0] (1280966400) Thu Aug 5 00:00:00 2010
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1283644800) Sun Sep 5 00:00:00 2010
0 PIN_FLD_ACTUAL_LAST_BILL_OBJ POID [0] 0.0.0.1 /bill 400193 0
-----------------------
6. Moved the pvt to Sept 8th and ran pin_bill_accts -pay_type 10001 -file PinBillRunControl.xml,  account did not get billed.
-----------------------
nap(20689)> robj - 0.0.0.1 /billinfo 398145
# number of field entries allocated 45, used 45
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 398145 5
0 PIN_FLD_CREATED_T TSTAMP [0] (1279033818) Tue Jul 13 15:10:18 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1282133134) Wed Aug 18 12:05:34 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 399681 11
0 PIN_FLD_ACCT_SUPPRESSED INT [0] 0
0 PIN_FLD_ACTG_CYCLE_DOM INT [0] 20
0 PIN_FLD_ACTG_FUTURE_T TSTAMP [0] (1284940800) Mon Sep 20 00:00:00 2010
0 PIN_FLD_ACTG_LAST_T TSTAMP [0] (1280966400) Thu Aug 5 00:00:00 2010
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1283644800) Sun Sep 5 00:00:00 2010
0 PIN_FLD_ACTUAL_LAST_BILL_OBJ POID [0] 0.0.0.1 /bill 400193 0
0 PIN_FLD_ACTUAL_LAST_BILL_T TSTAMP [0] (0) <null>
---------------------

BUSINESS IMPACT

Many of the accounts which undergo DOM change have to be manually billed and this is causing lots of operational issues.

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