Verifying Model Setup

After the initial sync process is complete:

1. Verify that the model is set up.

select *

from mdadm.b1_checkpoint

where group_name = 'CCB1AE';

If the record does not exist, it indicates that the Oracle GoldenGate scripts for CCB1AE model were not deployed.

2. Verify that the table data is in sync.

select *

from mdadm.b1_table_sync

where model_cd = 'CCB1AE';

select *

from ccb1rep.ci_acct_char;

If there is no entry it indicates that the B1_SYNC_CONTEXT scenario was not executed. Or, if it was executed, the Oracle GoldenGate scripts were not deployed at that time.

Important:

• Enable all the replication tables required for customization and follow the steps mentioned in the sections Creating Replicated Tables and Executing Initial Sync.

• Ensure that each model does not include more than 100 tables.