PARGDR_SINGLE: PRC: Generate Draft Revenue for a Single Project Throws Error Cursor 197: ORA-01427: Single-Row Subquery Returns More Than One Row
(Doc ID 2981585.1)
Last updated on OCTOBER 19, 2023
Applies to:
Oracle Project Billing - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to generate revenue for a project by running PRC: Generate Draft Revenue for a Single Project,
the following error occurs :
"Cursor 197: ORA-01427: single-row subquery returns more than one row"
The issue can be reproduced at will with the following steps:
1. Log in to Projects Responsibility.
2. Navigate to View > Requests > Submit a new request
3. Run the PRC: Generate Draft Revenue for a Single Project program.
4. Check the log file for the error.
Changes
NA
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |