My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.