Index Creation on Transformation Table Using Too Much CPU in OFSA 4.5 (Doc ID 203495.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
Transformation ID
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In an Oracle Financial Services Applications (OFSA) module (ex. Performance Analyzer, Risk Manager, etc.), when running a Transformation ID, creating indexes for the Transformation table is using too much CPU.  The transformed table index creation is slow.  The Creating Indexes step takes much more CPU than the other steps.

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