CCB Source Configuration Failed While Adding CI_SA_REL Table In Replication
(Doc ID 2752476.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, System Wide
OUA Source Configuration process fails with the following error while implementing CDC:
ODI-15021: Journalizing requires a Primary Key on the Table: CI_SA_REL
The issue is also observed with the tables F1_SVC_TASK,UM_IN_MKTMSG and UM_OUT_MKT_MSG.
These tables are identified as Effective Dated tables by the JKM
however the Effective Date column is not a part of the primary key for this table.
Steps to Reproduce
1. Enable the replication for the above mentioned tables
2. Run Source Configuration process
3. Notice that the process fails with the aforementioned error
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