Static Table Driver Migration Exception from Release 6.1 to 8.0

(Doc ID 2293398.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 to 8.0.4 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.4 version, Table Driver

After executing the migration utility, found static table drivers are not moved properly.

Steps
1) Ran migration utility from 6.1 to 8.0 from <Patch 21223631>.
2) Based on the query provided in the page 15 of the PFT_Metadata_Migration_User-Guidev6 1 x-to-v8.pdf, the query results are matching.
Migration of Static Table Driver will pickup definitions which satisfy below query:
SELECT DISTINCT SYS_ID_NUM A FROM FSI_M_ALLOC_TABLE_DETAILS D, (SELECT DISTINCT TABLE_SYS_ID FROM FSI_M_ALLOC_TABLE_ID) M WHERE D.SYS_ID_NUM= M.TABLE_SYS_ID
However when trying to check using queries below, there is no result for static table driver which were migrated through the utility.
select * from FSI_M_ALLOC_TABLE_ID_UI where TABLE_SYS_ID = <table sys id>
select * from FSI_M_ALLOC_TABLE_ID_VALUES where TABLE_SYS_ID = <table sys id>
Data is not present for the static table drivers which got migrated through the utility.


Cause

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