My Oracle Support Banner

Goldengate: Error ORA-28100: Policy Function Schema APPS Is Invalid (status = 28100) (Doc ID 2425487.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Replicat was getting below error:

2018-07-17 14:52:32 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: SQL error 28100 mapping SRC.TBL to TRG.TBL OCI Error ORA-28100: policy function schema APPS is invalid (status = 28100), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "<schema name>"."<table name>" ("<col1>"....".
2018-07-17 14:52:32 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: Error mapping from SRC.TBL to TRG.TBL.
2018-07-17 14:52:32 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: PROCESS ABENDING.

Cause

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
Symptoms
Cause
Solution
References


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