Awards Billing Frequency Not Working (Doc ID 2087707.1)

Last updated on MARCH 08, 2017

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.) In my testing of the GMS: Generate Draft Invoices for a Range of Awards in Oracle OWC yesterday – for a new award and project with award start date as 10-DEC-2014 and first billing offset days of 21:
  a.) I had seeded expenses for December 2014 and ran the invoice generation program with 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.) I 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.) I 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.

From the above test results during OWC it appeared as if the billing cycle was working.

2.) Today I met our functional users and went thru the tests with a brand new award/project - the award has the same award start date (10-DEC-2014) and first billing offset days:

  a.) We 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 same as we saw in Oracle OWC.
  b.) We then 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.) We then 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.) We further tested this by running the invoice program for a new award with the same award start date and same billing offset days,:

  a.) for 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.) we then 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?

4.) I retested the test scenario#1 with a new award and found the behavior to be the same as we saw in Oracle OWC yesterday.

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.

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