My Oracle Support Banner

Add Index Reconciliation To Be Run As Part Of ER Jobs In CS 8125 Version (Doc ID 3009033.1)

Last updated on MARCH 13, 2024

Applies to:

Oracle Financial Services Compliance Studio - Version 8.1.2 and later
Information in this document applies to any platform.

Goal

Add Index Reconciliation to be run as part of ER jobs in CS 8125 version.

a. What changes client is expected to see?
 There is a check introduced in ER job 1 which will check if the indices are in sync with FCC_ER_FULL. This check is introduced before and after the execution of Job 1. In case there is already a mismatch before job 1 is executed then the job will not proceed. Then, Indices needs to be rebuilt using the steps shared within the patch.

b. What will happen if the recon fails?

 If the recon fails at the beginning of ER job 1 then we need to sync the indices with FCC_ER_FULL and then trigger the job again. As part of this fix we are not expecting the recon to fail post Job 1 execution.

c. Is there a table where the recon will be stored? Or the recon will be displayed in the log?
 The recon messages will be displayed in the er-batch.log file. For Ex –

RECORD COUNT FOR FCC_ER_FULL table is 5

RECORD COUNT FOR STG_PARTY_PREV_INDEX is 6

 

 

 

Solution

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
Goal
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.