My Oracle Support Banner

"PRC: Generate Draft Revenue For A Range Of Projects " Fails With ora-01403 (Doc ID 1955554.1)

Last updated on AUGUST 10, 2018

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 attempting to run PRC: Generate Draft Revenue for a Range of Projects,
the following error occurs.

Entering parupf()
Current system time is 25-NOV-2014 10:35:18
...about to decrease accrued amount in fundings by=6088.19 for task -1
Leaving pauoarchn()
Leaving pauoarchn()
Cursor 11: ORA-01403: no data found
Current system time is 25-NOV-2014 10:35:18
...returning from parupf() with error...inadequate funding
Leaving parupf()
...rolling back transaction...

The issue can be reproduced at will with the following steps:
1. Run PRC: Generate Draft Revenue for a Range of Projects

The issue has the following business impact:
Due to this issue, users crirtical Financial impact. They can't run the PARGDR module for the range of projects.
Possible impact on month-end closing.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.