Index Mismatch For Blank Data Base And Demo Data Base CI_TXN_DETAIL_STG Table

(Doc ID 2166873.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Goal

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.5.0.1.0-Oracle-Database-MultiPlatform\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
create index XF225P1 on CI_TXN_DETAIL_STG (TXN_DETAIL_ID,TRUNC(TXN_DTTM),DISAGG_SW)
tablespace CISTS_01
pctfree 10
initrans 60
maxtrans 255
storage
(
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 2.5.0.1 for this index issue corrected in v2.4.0.1.

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

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

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms