Unable To Explain The Gl Test Results To Finance Team For Product Tests (Doc ID 1353557.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

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

Symptoms


Problem Description:
1. BRM product configured for 3years (cycle start- 4th Jan 2011 and cycle end dates- 4th Jan 2014) with $13 as the price (which is set during account creation)
2. This product is purchased on an Account 10 times corresponding to 10 accounts that are created with following cycle start and end dates. (End date gives the date when the product is cancelled on the account)
Account Start Date End Date Action Date
1 1/4/2011 1/4/2014 n/a
2 1/4/2011 1/10/2012 1/10/2012
3 1/4/2011 1/10/2012 1/10/2012
4 1/4/2011 7/4/2012 7/4/2012
5 1/4/2011 7/5/2012 7/5/2012
6 1/4/2011 7/18/2012 7/18/2012
7 1/4/2011 1/15/2013 1/15/2013
8 1/4/2011 1/19/2013 1/19/2013
9 1/4/2011 1/24/2013 1/24/2013
10 1/4/2011 1/31/2013 1/31/2013

For example for GL of month 1st March 2013 (31 day month), revenue of $3.68 is being realized for 10 accounts but the reversal for cancelled accounts varies from $0.36 to $0.37.

START LEDGER_REPORT_T.TYPE GL_ID FIN-44000 REVENUE ACCOUNT_NO
1-Mar-13 PREV_BILLED_EARNED 300001 0.37 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.37 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.36 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.36 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.36 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.37 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 -3.68 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.74 SF_Sponsor
1-Mar-13 PREV_BILLED_EARNED 300001 0.37 SF_Sponsor

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