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 22.214.171.124.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 v126.96.36.199 install.
Demo Dump was available in Patch – 22480614.
At location \..\RMB-V188.8.131.52.0-Oracle-Database-MultiPlatform\Demo_dump\
'Demo' database has Index XF225P1, but 'blank' DB is missing it.
Now the concern is why RMB v184.108.40.206 install did not add the Index in the 'blank' DB. Is this expected behavior?
Note that Index XF225P1 was introduced in v220.127.116.11 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 18.104.22.168 for this index issue corrected in v22.214.171.124.
Customer is wondering if this patch is available for 126.96.36.199 to add the index.
Please advise what they can do to have the index added in 'blank' Db added via 188.8.131.52 install.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms