Large Static Table Drivers Migrated from OFSA 4.5 into PFT 6.x Hang When Opening
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)
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.
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