Joining Tables In GoldenGate Extract - ERROR OGG-00312 Closing Parenthesis Missing For WHERE.

(Doc ID 2376401.1)

Last updated on APRIL 06, 2018

Applies to:

Oracle GoldenGate - Version 11.2.1.0.4 to 12.3.0.1.3 [Release 11.2 to 12.3]
Information in this document applies to any platform.

Symptoms

Set up Extract to be selective on what records to capture from a table A using a WHERE clause querying table B, using in the parameter file something like:

table owner.A, KEYCOLS (DOC_ID, LINE_NUM) WHERE DOC_ID = owner.B.DOC_ID AND (owner.B.BILL_HEADER.CLIENT_ID=498 or owner.B.BILL_HEADER.CLIENT_ID=530);

 

Extract abends with:

2018-03-15 23:37:51 ERROR OGG-00312 Closing parenthesis missing for WHERE.

 

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