Purchase Product With Start Offset=1 Giving Incorrect Bill Result On The 1st Bill (Doc ID 1265666.1)

Last updated on SEPTEMBER 23, 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.
**Checked for relevance on 12th Aug 2013**

Symptoms

Purchase Product with Start Offset=1 giving incorrect bill result on the 1st Bill.

Steps to Reproduce:
----------------------------

1. On 1 June, Activate Subscription with one Recurring Charge product (CHF 15) which has the START_OFFSET=1
Internally it will call PCM_OP_SUBSCRIPTION_PURCHASE_PRODUCT as below :

op_subscription_purchase_product input flist
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 39337775969 0
0 PIN_FLD_PROGRAM_NAME STR [0] "BEPPI_OP_BUSINESS_POL_CHANGE_SUBSCRIPTION_PRODUCTS opcode."
0 PIN_FLD_END_T TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
0 PIN_FLD_PRODUCTS ARRAY [0] allocated 29, used 29
1 PIN_FLD_CYCLE_DISCOUNT DECIMAL [0] 0
1 PIN_FLD_CYCLE_END_DETAILS INT [0] 2
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (0) <null>
1 PIN_FLD_CYCLE_START_DETAILS INT [0] 1
1 PIN_FLD_CYCLE_START_T TSTAMP [0] (0) <null>
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 25334565358 1
1 PIN_FLD_PURCHASE_DISCOUNT DECIMAL [0] 0
1 PIN_FLD_PURCHASE_END_DETAILS INT [0] 2
1 PIN_FLD_PURCHASE_END_T TSTAMP [0] (0) <null>
1 PIN_FLD_PURCHASE_START_DETAILS INT [0] 1
1 PIN_FLD_PURCHASE_START_T TSTAMP [0] (0) <null>
1 PIN_FLD_QUANTITY DECIMAL [0] 1
1 PIN_FLD_STATUS ENUM [0] 1
1 PIN_FLD_STATUS_FLAGS INT [0] 0
1 PIN_FLD_USAGE_DISCOUNT DECIMAL [0] 0
1 PIN_FLD_USAGE_END_DETAILS INT [0] 2
1 PIN_FLD_USAGE_END_T TSTAMP [0] (0) <null>
1 PIN_FLD_USAGE_START_DETAILS INT [0] 1
1 PIN_FLD_USAGE_START_T TSTAMP [0] (0) <null>
1 PIN_FLD_PACKAGE_ID INT [0] 34021
1 PIN_FLD_CYCLE_START_UNIT INT [0] 8
1 PIN_FLD_CYCLE_START_OFFSET INT [0] 1
1 PIN_FLD_PURCHASE_START_UNIT INT [0] 8
1 PIN_FLD_PURCHASE_START_OFFSET INT [0] 1
1 PIN_FLD_USAGE_START_UNIT INT [0] 8
1 PIN_FLD_USAGE_START_OFFSET INT [0] 1
1 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.1 /deal 25334566421 2
1 PIN_FLD_PLAN_OBJ POID [0] NULL poid pointer
1 PIN_FLD_FEE_FLAG INT [0] 1

2.  On 02 July 2009, run Billing for the subscription (Total Bill Amount : 30 CHF). It created 2 events : /event/billing/product/fee/cycle/cycle_arrear, as below:

1st Event
---------
0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 23, used 23
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39337775969 14
1 PIN_FLD_AMOUNT DECIMAL [0] 15
0 PIN_FLD_CYCLE_INFO SUBSTRUCT [0] allocated 20, used 5
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (1249077600) Sat Aug 01 00:00:00 2009
1 PIN_FLD_CYCLE_START_T TSTAMP [0] (1246399200) Wed Jul 01 00:00:00 2009
1 PIN_FLD_FLAGS INT [0] 8
1 PIN_FLD_ORIGINAL_SCALE DECIMAL [0] 1
1 PIN_FLD_SCALE DECIMAL [0] 1

2nd Event
---------
0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 23, used 23
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39337775969 14
1 PIN_FLD_AMOUNT DECIMAL [0] 15
0 PIN_FLD_CYCLE_INFO SUBSTRUCT [0] allocated 20, used 5
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (1249077600) Sat Aug 01 00:00:00 2009
1 PIN_FLD_CYCLE_START_T TSTAMP [0] (1246399200) Wed Jul 01 00:00:00 2009
1 PIN_FLD_FLAGS INT [0] 2056
1 PIN_FLD_ORIGINAL_SCALE DECIMAL [0] 1
1 PIN_FLD_SCALE DECIMAL [0] 1

3. On 02 Aug 2009, run Billing for the subscription (Total Bill Amount : 15 CHF). It created 1 event : /event/billing/product/fee/cycle/cycle_arrear, as below :

0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 23, used 23
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39337775969 15
1 PIN_FLD_AMOUNT DECIMAL [0] 15
0 PIN_FLD_CYCLE_INFO SUBSTRUCT [0] allocated 20, used 5
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (1249077600) Sat Aug 01 00:00:00 2009
1 PIN_FLD_CYCLE_START_T TSTAMP [0] (1246399200) Wed Jul 01 00:00:00 2009



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