Extracting Data from ofsa_node_desc Runs Very Slow During Migration from 6.1 to 8.0.x

(Doc ID 2272910.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Slow Performance
Migration / Migrate


During the v6.1 to 8.0.2 PFT-FTP Migration process, the exports were taking long time, hence it was suggested to backup these two tables OFSA_NODE_DESC and OFSA_LEAF_DESC in Legacy system (v6) and truncate the tables and run the EXPORT.  After import into pft-ftp v8.0.0, it was recommended to re-populate these OFSA_NODE_DESC and OFSA_LEAF_DESC, run the REVERSE_POPULATION in v.8.0.0.

What are the proper steps?


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