R12.1.3 NO_FUNDING ERROR AT REVENUE ACCRUAL FOR PROJECT AGREEMENTS WITH EXPIRATION DATES
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.
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.
The Log file show the revenue was rejected for rej_reason=NO FUNDING but the output report shows: *** No Data Found ***
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms