My Oracle Support Banner

PARGDR: PRC: Generate Draft Revenue Process Errors On One Project ORA-01427 in Cursor 16 (Doc ID 353395.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Project Billing - Version and later
Information in this document applies to any platform.
ConcurrentProgram:PARGDR_SINGLE - PRC: Generate Draft Revenue for a Single Project


On 11.5.10:
When attempting to generate draft revenue for a single project (PARGDR PRC: Generate Draft Revenue for a Single Project),
the following error occurs:

Using standard labor bill rate schedule...
Current system time is 20-JAN-2006 17:14:16
Cursor 16: ORA-01427: single-row subquery returns more than one row

...error during distributing for project.
...rolling back transaction.
...Leaving pardfp()

The issue can be reproduced at will by re-running the process for the same project.


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

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