External Award Load Batch Process FAPPKEAL not Selecting Unprocessed Records After Error With Original Batch (Doc ID 2547571.1)

Last updated on AUGUST 25, 2023

Applies to:

Symptoms

An instance of the batch external award load process results in some portion of the records being processed, and the rest remaining unprocessed, due to an error that caused the process to halt in the middle of the batch.  After resolving the error, and attempting to re-run the process to load the remaining records, nothing happens. The expectation is the students should be selected and processed based on having been marked or left unprocessed on the View External Award Detail component (SFA_EA_LOAD_DTL table). 

As an example, one school saw the process halt due to a system problem (data deadlock) not directly related to the external award application functionality. However, the scenario could be observed in any situation where the batch load process encountered an error, causing the program to halt in the middle of processing the batch. 

The issue can be reproduced with the following steps:

1. Navigate to Financial Aid > Awards > External Awards > Load External Awards > Load External Awards. 
2. Enter parameters.
3. Run the process. 
4. Review Process Monitor and note the process errors. 
5. Review View External Award Load detail or SFA_EA_LOAD_DTL to note which records processed and which did not. 
6. Resolve the conditions which caused the error. (This step will obviously vary depending on the specific situation.) 
7. Re-do steps 1-3. 
8. Review Process Monitor and note the process ended successfully. 
9. Click process details, View Log/Trace, and FAPPKEAL log file, and note that it says "0 EXTERNAL AWARDS SELECTED FOR POSTING" and "0 STUDENTS PROCESSED".
10. Review SFA_EA_LOAD_DTL and note that the records left unprocessed the first time still did not process. 

Cause

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