Fact Load Is Taking Too Long Especially For Financial and SA Facts
(Doc ID 2000459.1)
Last updated on MARCH 29, 2019
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 18.104.22.168.4 to 22.214.171.124.4 [Release 2.4]
Information in this document applies to any platform.
OUASA 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document