How to fix the Oracle error PGU-35009: no transaction rows for statement string, string string: rc string?

In this post, you’ll learn more about the Oracle ErrorPGU-35009: no transaction rows for statement string, string string: rc string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-35009: no transaction rows for statement string, string string: rc string

Reason for the Error PGU-35009: no transaction rows for statement string, string string: rc string

Cause: No Transaction rows were fetched from the PG DD for PGAU SQL statement with transaction name and transaction version . The Oracle error code is . Either the transaction name and version supplied on the GENERATE statement were invalid or the transaction entry is missing from the PG DD. This message is preceded by an Oracle Server message for the specific error encountered.

How to fix the Error PGU-35009: no transaction rows for statement string, string string: rc string ?

You can fix this error in Oracle by following the below steps

Action: Ensure the requested transaction and version are properly defined in the PG DD or correct the GENERATE statement.