R12.1.3 NO_FUNDING ERROR AT REVENUE ACCRUAL FOR PROJECT AGREEMENTS WITH EXPIRATION DATES (Doc ID 2109701.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Revenue

When we try to generate revenue for a project that uses an agreement with a date in the future the revenue is not generated. Customer found the last 2 digits of the year must be the same as the last 2 digits as the event date AND the month of the agreement must be prior to the month of the event. In other words,the revenue generation process is truncating the agreement end date and only dealing with the last 2 digits of the year. So when revenue is generated, it is comparing the agreement end date which in this case with the truncated year is 30-SEP-15 which is prior to the event date of 20-NOV-2015. However after user entered an agreement earlier with the expiration date of 30-SEP-3016 and an event using 20-NOV-2015 and revenue generated without any issues.

This is only occurring for projects using the date-effective funds consumption.


ERROR
-----------------------

The Log file show the revenue was rejected for rej_reason=NO FUNDING but the output report shows: *** No Data Found ***



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Agreement for a project using the date effective funds consumption functionality. The agreement date is 30-SEP-3016 - this is 1000 years in the future
2. Create the agreement using the completion date of 20-Nov-2016
3. Submit the generate revenue process. No revenue generated but the log file shows NO FUNDING
4. Update the agreement to a date in 2016 and resubmit the process. Revenue is generated as expected.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate revenue without making numerous updates to the agreements and events before and after the revenue is generated.

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