Fact Load Is Taking Too Long Especially For Financial and SA Facts
Last updated on JUNE 13, 2017
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 184.108.40.206.4 to 220.127.116.11.4 [Release 2.4]
Information in this document applies to any platform.
OUASA 18.104.22.168.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.
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