Data performance issue on list data in TF
(Doc ID 2789085.1)
Last updated on JULY 07, 2021
Applies to:Oracle Financial Services Transaction Filtering - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
User want to create an index on FSI_RT_LIST_DATA table since its taking huge time if it contains more than 6 M records in it.
Same way they need for FSI_RT_LIST_DATA_STG and FSI_RT_LIST_DATA_PROCESSED tables.
Steps to reproduce:
Step 1 : Load 6M records in EDQ
Step 2 : Execute the Job under watchlist management
Step 3 : Check for the performance.
User expecting less time for data load.
Performance issue occurs and user want to generate an index on below tables.
FSI_RT_LIST_DATA, FSI_RT_LIST_DATA_STG and FSI_RT_LIST_DATA_PROCESSED tables.
Issue Encountered :
Performance impacted to load the data into tables.
6Million records of data has been loaded into edq system.
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