Receiving "ORA-06508: PL/SQL: could not find program unit being called" when a trigger on a replication table tries to call a package.
The same code was working fine at first and it is failing later. And the package is valid and we have all grants in place. Also we tried dropping and recreating both the trigger and the package including the grants. Still facing same error.
Try to trace the behavior in Oracle Database. You can use the 10046 trace to list all SQL commands that GoldenGate is issuing. Extract the commands from the trace and run them manually on the target database. You should be able to see the same error and be able to track the source of it.