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

Last updated on NOVEMBER 13, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.