My Oracle Support Banner

Process SF External Award (SSF_EXT_AWDS Application Engine Process) not Selecting/Processing Records in Payment Table (Doc ID 2774909.1)

Last updated on MAY 07, 2021

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running the Process SF External Awards application engine - SSF_EXT_AWDS - some or all students are not getting selected for processing. The number of students indicated as processed in the log file, does not match up to the number of students returned by the query used to select the students for processing. 

The students being missed are expected to be selected and processed, as they are being returned in the results for the specified pop select query; they are active on Financial Aid Term (FA Term) for the term being processed; and the corresponding Student Financial (SF) transactions are verified to exist on the payment table (PAYMENT_TBL), and with a payment amount not equal to the amount sent. 

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

  1. Navigate to Financial Aid > Awards > External Awards > Process SF External Award > SF External Award Feed. 
  2. Enter parameters.
  3. Run the process.
  4. Once the process completes, review the results as follows: click Process Monitor link; click link for the details for the process instance; click View Log/Trace link (not Message Log link); click link for the log file in the file list; note the number of students processed, and compare that to the results returned when running the Pop Select Query entered in step 2. 

Cause

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
Symptoms
Cause
Solution
References


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