Slow Performance With FAPCODIN Step of Import COD Response Data (CODIN) Process (Doc ID 2830561.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

Performance problems have been noted with the FAPCODIN step of the CODIN process, when volume is very high. For example, in one case the problem was experienced when processing for multiple institutions with up to 4000 to 5000 total rows of data in the message classes being read in.

The problem will likely not be experienced with lower volume and may only happen in the most extreme cases as noted above.

The issue can be reproduced at will with the following steps:

1. Navigate to Financial Aid > File Management > COD Full Participant > Import COD Response Data.
2. Populate the parameters, such as to process a very large number of records.
3. Click Run then OK to run the process.
4. Click 'Process Monitor' link to view the process status.
5. Click Refresh button as needed until the run status says "Success".
6. Click the 'CODIN' link to see the details for the two child processes.
7. Click the link for the 'FAPCODIN' step and note the begin and end times listed for the step.

Cause

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