Backdating With 31 Days Billing And MoveDayForward = LastDay Calculates Wrong Cycle_End_T (Doc ID 1302067.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

If backdating a purchase back to a day that is suppose to be a BDOM, e.g. BDOM is 31, backdate to 2/28, this is valid billing date.

The backdate purchase treats this as a pro-ration (from 2/28 to 4/30) instead of a full cycle (from 2/28 to 5/31) for a quarterly product.

Scenario 1 (with a quarterly tailormade product):
1) Create an account on Jan 31, 2013
2) Run billing on Feb 28th 2:00AM
3) Purchase a quarterly tailormade product on Mar 1st to Feb 28th 3:00AM
    a) Tailormade product cycle from Feb 28th to May 31st
    b) Base product cycle from Feb 28th to never

When doing a normal purchase on Feb28th, it has a full cycle from Feb 28th to May 31st.


Scenario 2 (with a normal quarterly product):
1) Create account with dummy plan on Jan 31st 2013
2) Run billing on Feb 28th
3) Move PVT (pin_virtual_time) to Mar 1st
4) Backdate purchase to Feb 28th
    Product cycle with Quarterly Cycle Fee: 28/Feb/2013 to Never
 
Observe CF (Cycle Forward) for the period 28th Feb to 3rd March is charged.


Configurations
:

1. bus_params_billing.xml has:

<?xml version="1.0" encoding="UTF-8"?>

<BusinessConfiguration
xmlns="http://www.portal.com/schemas/BusinessConfig"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.portal.com/schemas/BusinessConfig business_configuration.xsd">

<!-- Sample file. Modify according to guidelines. -->
<BusParamConfigurationClass>

<BusParamsBilling>
<BillingCycleOffset>0</BillingCycleOffset>
<MoveDayForward>lastDay</MoveDayForward>
<RemoveSponsoree>enabled</RemoveSponsoree>
<ProdEndOffsetPlanTransition>10</ProdEndOffsetPlanTransition>
<GenerateJournalEpsilon>disabled</GenerateJournalEpsilon>
<ApplyCycleFeeForBillNow>disabled</ApplyCycleFeeForBillNow>
<RerateDuringBilling>disabled</RerateDuringBilling>
<AutoTriggeringLimit>2</AutoTriggeringLimit>
<ValidateDiscountDependency>disabled</ValidateDiscountDependency>
<RolloverCorrectionDuringBilling>disabled</RolloverCorrectionDuringBilling>
<EnableARA>disabled</EnableARA>
<CreateTwoBillNowBillsInDelay>disabled</CreateTwoBillNowBillsInDelay>
<SubBalValidity>Cut</SubBalValidity>
<SequentialCycleDiscounting>disabled</SequentialCycleDiscounting>
<CacheResidencyDistinction>disabled</CacheResidencyDistinction>
<DefaultBusinessProfile>Convergent</DefaultBusinessProfile>
<AcctCycleDelayPeriod>-1</AcctCycleDelayPeriod>
<GeneralLedgerReporting>enabled</GeneralLedgerReporting>
<BackdatingPastGlPostedDate>enabled</BackdatingPastGlPostedDate>
<CustomJournalUpdate>enabled</CustomJournalUpdate>
<PerfAdvancedTuningSettings>0</PerfAdvancedTuningSettings>
</BusParamsBilling>
</BusParamConfigurationClass>
</BusinessConfiguration>



2. 31 day billing is configured:

nap(6287)> robj - 0.0.0.1 /config/fld_validate 606
# number of field entries allocated 20, used 13
0 PIN_FLD_POID POID [0] 0.0.0.1 /config/fld_validate 606 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1298485629) Wed Feb 23 10:27:09 2011
0 PIN_FLD_MOD_T TSTAMP [0] (1298485629) Wed Feb 23 10:27:09 2011
0 PIN_FLD_READ_ACCESS STR [0] "G"
0 PIN_FLD_WRITE_ACCESS STR [0] "S"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
0 PIN_FLD_DESCR STR [0] "Field Validation"
0 PIN_FLD_HOSTNAME STR [0] "-"
0 PIN_FLD_NAME STR [0] "Actg_cycle"
0 PIN_FLD_PROGRAM_NAME STR [0] "-"
0 PIN_FLD_VALUE STR [0] ""
0 PIN_FLD_VERSION STR [0] ""
0 PIN_FLD_VALIDATION SUBSTRUCT [0] allocated 20, used 6
1   PIN_FLD_FIELD_TYPE INT [0] 1
1   PIN_FLD_FLAGS INT [0] 0
1   PIN_FLD_MAXIMUM DECIMAL [0] 31
1   PIN_FLD_MAX_LENGTH INT [0] 0
1   PIN_FLD_MINIMUM DECIMAL [0] 1
1   PIN_FLD_MIN_LENGTH INT [0] 0



3. Set sys/cm/pin.conf :
   - fm_bill calc_cycle_from_cycle_start_t 1

This issue is observed on 7.4 Patch Set 7 (PS7).

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