Purchase Start Date Add One Extra Day After Billing (Doc ID 860426.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
Information in this document applies to any platform.

Symptoms

Resource start validity date has been added one extra day with purchase start date during billing.

-- Steps To Reproduce:
1. create product with purchase fee that grants a free resource, start validity must be immediately.
2. create deal/plan.
3. create account on date D.
4. purchase product with start date set to D+2.
5. move pvt (pin_virtual_time) to D+3.
6. run pin_bill_day.

Notice that PIN_FLD_VALID_FROM is set to D+3, instead of D+2.

  nap(28087)> # number of field entries allocated 20, used 14
  0 PIN_FLD_POID           POID [0] 0.0.0.1 /balance_group 255511 2
  0 PIN_FLD_CREATED_T    TSTAMP [0] (1251932180) Wed Sep  2 15:56:20 2009
  0 PIN_FLD_MOD_T        TSTAMP [0] (1252191713) Sat Sep  5 16:01:53 2009
  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 258023 0
  0 PIN_FLD_BATCH_CNTR      INT [0] 0
  0 PIN_FLD_BILLINFO_OBJ   POID [0] 0.0.0.1 /billinfo 254999 0
  0 PIN_FLD_EFFECTIVE_T  TSTAMP [0] (1251932179) Wed Sep  2 15:56:19 2009
  0 PIN_FLD_NAME            STR [0] "Balance Group<Account>"
  0 PIN_FLD_OBJECT_CACHE_TYPE   ENUM [0] 0
  0 PIN_FLD_REALTIME_CNTR    INT [0] 2
  0 PIN_FLD_BALANCES      ARRAY [978] allocated 20, used 4
  1     PIN_FLD_CONSUMPTION_RULE   ENUM [0] 0
  1     PIN_FLD_CREDIT_PROFILE    INT [0] 0
  1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
  1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
  0 PIN_FLD_BALANCES      ARRAY [1000090] allocated 20, used 5
  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] -1200
  2         PIN_FLD_DELAYED_BAL  DECIMAL [0] 0
  2         PIN_FLD_GRANTOR_OBJ    POID [0] 0.0.0.1 /purchased_product 261412 1
  2         PIN_FLD_NEXT_BAL     DECIMAL [0] 0
  2         PIN_FLD_ROLLOVER_DATA    INT [0] 0
  2         PIN_FLD_VALID_FROM   TSTAMP [0] (1252191713) Sat Sep  5 16:01:53 2009 =====> the date should be Sep 04.
  2         PIN_FLD_VALID_FROM_DETAILS    INT [0] 0
  2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
  2         PIN_FLD_VALID_TO_DETAILS    INT [0] 0
  nap(28087)>


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