OGL EPF : Dimension Rules Running Slowly - Performance Issue

(Doc ID 418135.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
OGL EPF Data Integration
FEM
This problem can occur on any platform.

Symptoms

Whilst executing the Dimension Rules from EPF, there are a number of processes that are consuming excessive CPU; these are all FEM_INTG_DIM_RULE_WORKER.

Dimension Rules have not finished after running 24 hours loading about 8 million records from GL into FEM.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Run the dimension rules using the 'Submit All Rules' button from Enterprise Performance Foundation Administrator -> Data Rules -> Oracle Dimension Sources -> Chart of Accounts and wait until the final processes are completing that relate to the OGL map update of fem_intg_ogl_ccid_map table with the CCIDs.

Changes

Patch Level: FEM.D.1 Rollup 2

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