My Oracle Support Banner

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

Last updated on MARCH 01, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 to 8.0.0 [Release 6 to 8]
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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.