Replicat reports OGG-25092 with PLS-00201: identifier 'GG_ADMIN.REPLICATESEQUENCE' must be declared (Doc ID 2779800.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

Oracle GoldenGate (OGG) 19c Integrated replicat with target Oracle 12c target database was configured to replicate sequences.  The following was then reported in the replicat report file:

-- NOTE: <OWNER>.<SEQUENCE_NAME> and #s are substitutions for actual values

INFO OGG-06513 Resolving target sequence :<OWNER>.<SEQUENCE_NAME>.

WARNING OGG-25092 Sequence update did not succeed, error:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'GG_ADMIN.REPLICATESEQUENCE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.

and the replicat discard file shows:

Operation failed at seqno # rba ######
Discarding record on action DISCARD on error 6550
Problem replicating <OWNER>.<SEQUENCE_NAME> to <OWNER>.<SEQUENCE_NAME>.
Mapping problem with compressed update record (target format) SCN:##.##.####...
*
No columns were available

Changes

 OGG was configured for replication of sequences.

Cause

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