Index Mismatch For Blank Data Base And Demo Data Base CI_TXN_DETAIL_STG Table
Last updated on OCTOBER 17, 2017
Applies to:Oracle Financial Services Revenue Management and Billing - Version 184.108.40.206.0 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 v220.127.116.11 install.
Demo Dump was available in Patch – 22480614.
At location \..\RMB-V18.104.22.168.0-Oracle-Database-MultiPlatform\Demo_dump\
'Demo' database has Index XF225P1, but 'blank' DB is missing it.
Now the concern is why RMB v22.214.171.124 install did not add the Index in the 'blank' DB. Is this expected behavior?
Note that Index XF225P1 was introduced in v126.96.36.199 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)
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 188.8.131.52 for this index issue corrected in v184.108.40.206.
Customer is wondering if this patch is available for 220.127.116.11 to add the index.
Please advise what they can do to have the index added in 'blank' Db added via 18.104.22.168 install.
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