My Oracle Support Banner

GMSRGDR_MASS GMS: Generate Draft Revenue For A Range Of Awards Ending With Error Cursor 1: ORA-20216 in the Log File. (Doc ID 2831702.1)

Last updated on DECEMBER 13, 2022

Applies to:

Oracle Grants Accounting - Version 12.2.3 and later
Information in this document applies to any platform.


When running the "GMS: Generate Draft Revenue for a Range of Awards", the following error is received in the log file:

...about to delete revenue for project id xxxxx
Cursor 1: ORA-20216: No Record Found for Project: xxxxx and Event: xx
...error during event api processing project.
...Leaving parapi()
...rolling back transaction...
Leaving parddr()
Current system time is 21-APR-2021 14:22:47

Reproduce By Steps

  1. Use GMS Forms responsibility
  2. Navigate to Reports > Run
  3. Run the process for a project with previous failed revenue associated with events




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.