GoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN()

GoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN()

Extract process return error (904, ORA-00904: : invalid identifier) selecting data in ORAUTIL_getCurrentSCN()

The goldengate user has been granted the DBA role in database,
And has execute permissions on DBMS_FLASHBACK
grant execute on DBMS_FLASHBACK to <gguser>

In some environments, this issue can be resolved by just giving the execute on dbms_flashback to <ggsuer> without granting DBA role.
But the accepted approach is still to grant the DBA role in database to the user.

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.