My Oracle Support Banner

Index Mismatch For Blank Data Base And Demo Data Base CI_TXN_DETAIL_STG Table (Doc ID 2166873.1)

Last updated on JULY 07, 2021

Applies to:

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


Index mismatch for Blank Database and Demo Database on CI_TXN_DETAIL_STG table.
'Blank' database was added via the RMB v2.5.0.1 install.
Demo Dump was available in Patch – 22480614.
At location \..\RMB-V2.\Demo_dump\

'Demo' database has Index XF225P1, but 'blank' DB is missing it.
Now the concern is why RMB v2.5.0.1 install did not add the Index in the 'blank' DB. Is this expected behavior?

Note that Index XF225P1 was introduced in v2.4.0.1 via patch 23070706 as it was causing a performance issue.
Below is the script to add the index manually:

-- Create/Recreate indexes
tablespace CISTS_01
pctfree 10
initrans 60
maxtrans 255
initial 64K
next 1M
minextents 1
maxextents unlimited

In the installed_fixes log for affected environment, it does not indicate patch 23070706 or 22480614 was installed.
Also there is no confirmation if any Bug/Patch forward ported for RMB for this index issue corrected in v2.4.0.1.

Customer is wondering if this patch is available for to add the index.

Please advise what they can do to have the index added in 'blank' Db added via install.


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.