My Oracle Support Banner

New Index On Table CI_APAY_CLR_STG Needed For Performance Purposes (Doc ID 2441303.1)

Last updated on SEPTEMBER 04, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

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


Cause

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
Symptoms
Cause
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.