Last updated on AUGUST 05, 2016
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.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 v18.104.22.168 install.
Demo Dump was available in Patch – 22480614.
At location \..\RMB-V22.214.171.124.0-Oracle-Database-MultiPlatform\Demo_dump\
'Demo' database has Index XF225P1, but 'blank' DB is missing it.
Now the concern is why RMB v126.96.36.199 install did not add the Index in the 'blank' DB. Is this expected behavior?
Note that Index XF225P1 was introduced in v188.8.131.52 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 184.108.40.206 for this index issue corrected in v220.127.116.11.
Customer is wondering if this patch is available for 18.104.22.168 to add the index.
Please advise what they can do to have the index added in 'blank' Db added via 22.214.171.124 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