Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Is there a possibility to restrict the BefProcMap.Py event for one Target application ?

HI Team,

I have the deadlock situation in FDMEE using the BefProcMap.Py even script ?

When we seen some of performances issues with the one of the Location where this job use to took for 1.5 hours to process the FDMEE import and Oracle has recommended to have the Index created against the table and also BefProcMap.Py script in place with the below script update and in turn this helped us to resolve the performance issue from 1.5 hours to 3 minutes.


fdmAPI.executePLSQL("BEGIN dbms_stats.gather_table_stats(user,?,estimate_percent=>dbms_stats.auto_sample_size,force=>TRUE); END;", ["TDATAMAP_T"], False);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center