Large Static Table Drivers Migrated from OFSA 4.5 into PFT 6.x Hang When Opening (Doc ID 1918701.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1x, after running the OFSA 4.5 migration process, you cannot open Static Table Drivers created from your 4.5 Table IDs.  When you try to edit the Static Table Driver, the browser crashes and you get an "Internal Server Error".

You notice the size of the data stored for the 6.1 Static Table Driver increased significantly when compared to the data stored for the 4.5 Table ID.  For example, in OFSA 4.5, a Table ID had 1,242 rows (524 key members, 718 target members) in OFSA_IDT_TABLE.  The migrated Static Table Driver in 6.x has over 86,000 rows for the same Table ID in FSI_M_ALLOC_TABLE_DETAILS.

The Static Table Driver appears to hang or have slow performance when loading this large quantity of records.

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