OGG 12.3 TRANLOGOPTIONS EXCLUDEUSER in PDB is not working

(Doc ID 2404106.1)

Last updated on MAY 30, 2018

Applies to:

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

Symptoms

The problem is that TRANLOGOPTIONS EXCLUDEUSER does not work in bi-directional replication.Issue is observed on OGG 12.3 running aganist a 12.1 PDB, and want to filter out user
activity with TRANLOGOPTIONS EXCLUDEUSER, but the Extract fails to start with a message that no user with that user_id exists for that username: 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms