Fact Load Is Taking Too Long Especially For Financial and SA Facts (Doc ID 2000459.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.4.0.0.4 to 2.4.0.0.4 [Release 2.4]
Information in this document applies to any platform.

Goal

OUASA 2.4.0.4.0 - Production environment - source application: CCB

Data load is scheduled to run every day during midnight. Fact extracts are done in multiple threads to speed up the extract process which gives multiple files for facts. Nowadays there is too much delay in processing Financial Fact extract files. After processing one set of files its taking 2-3 days to select the second set of files causing files of 2 -3 days remaining in load directory unprocessed.

The following lines are repeated in the FPD log:

 
Can you suggest a workaround to resolve this performance issue?

No customizations are attempted on the FPD parameters file.
The previous files which were selected by FPD for F_FIN_EXT and F_SAARS_EXT are loaded successfully and have no load validation errors.
In ERROR folder, there are no files. There are no *.TMP files in the extract folder.

 

Solution

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