My Oracle Support Banner

Awards Billing Frequency Not Working (Doc ID 2087707.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Grants Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Awards Billing Frequency not working as expected.

1.) A new award and project with award start date as 10-DEC-2014 and first billing offset days of 21:
  a.) There were seeded expenses for December 201, invoice generation program was run with the value for bill thru date parameter value as 31-DEC-2014 (for December expense) and Invoice#1 with bill thru date as 31-DEC-2014 got created.

  b.) Then seeded January expense and ran the program with bill thru date as NULL (defaulting to system date which is 23-FEB-2015) and the invoice#2 with bill thru date as 23-FEB-2015 got created.

  c.) Then seeded expense for February and ran the invoice program with Null bill thru date (defaulting to system date which is 23-FEB-2015) and found that the invoice#3 did not get created.

The above test was successful

2.) Created a new test with a new award/project - the award has the same award start date (10-DEC-2014) and first billing offset days:

  a.) Seeded December 2014 expenses and ran the invoice generation program with the value for bill thru date parameter value as 31-DEC-2014 and Invoice#1 with bill thru date as 31-DEC-2014 got created. The results are as expected.

  b.) Next seeded January 2015 expenses and ran the invoice generation program with the value for bill thru date parameter value as 31-JAN-2015 and the Invoice#2 with bill thru date as 31-JAN-2015 got created. The invoice got created as we expected. The only difference in our testing from scenario 1.b is that we passed a value of 31-JAN-2015 instead of default bill thru date.

  c.) Seeded February 2015 expenses and then ran the invoice generation program with the value for bill thru date parameter value as null (defaulting to system date) and found that the invoice (invoice#3) got generated for February without the February billing cycle to be over. The billing cycle is First day of the month - so this invoice (invoice#3) should have got created only on or after March 1st. The billing cycle is not working as expected here.

3.) A Third Test was created for a new award with the same award start date and same billing offset days,:

  a.) December 2014 expense we ran the invoice generation program with Null bill thru date parameter value (instead of the bill thru date parameter value as 31-DEC-2014) – invoice#1 for December expense with bill thru date as 24-FEB-2015 got created.

  b.) Seeded expense for January 2015 and ran the invoice generation program with the bill thru date as NULL and no one invoice got created. I expected the invoice#2 would get created since the billing cycle condition is met- but the invoice did not get created. What is the reason? Why is the behavior in this scenario different from the behavior in 1.b and 2.b?

It is not clear when the next invoice for scenarios 1.c (invoice#3) and scenario 3.b (invoice#2) will get created, will it get created on March 1st? The behavior of the invoice generation process seems to be different when we run the program with a value for bill thru date than when we run the program with default bill thru date – it is not clear how this parameter value is controlling the billing cycle. Also the billing cycle is not working in scenario #2.c.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.