New Index On Table CI_APAY_CLR_STG Needed For Performance Purposes
(Doc ID 2441303.1)
Last updated on MARCH 22, 2019
Applies to:Oracle Financial Services Revenue Management and Billing - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, BNK - Banking Control Central
A new index on Table CI_APAY_CLR_STG is needed for Performance Purposes.
After discussions and performance tests, we identified that SETTLEMENT_ID_NBR column on the CI_APAY_CLR_STG table is a good candidate for a new index, as lookups based on acknowledgement are executed using this column.
This new index will speed up this lookups considerably for performance purposes on Production environments.
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