Population Update of Payment Period End Dates - SFA_PAYPR_END_DT on LOAN_DISBMNT and PELL_PAYPR_END_DT on PELL_DISBMNT - Still Cannot be Performed Using Population Select With the Fields Added to SFA_PU_LDSB_BND and SFA_PU_PDSB_BND (Doc ID 2891640.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

When using Population Update to update the Payment Period End Date fields -  SFA_PAYPR_END_DT on LOAN_DISBMNT and/or  PELL_PAYPR_END_DT on PELL_DISMNT - the fields can now be incorporated into Population Selection, after the fields were added to the respective bind records SFA_PU_LDSB_BND and SFA_PU_PDSB_BND. The previous issue, of the fields not having been added to the bind records, is documented in <Note 2874840.1>.

However, even after this change to add the fields to those two binds, the fields are still not being updated on LOAN_DISBMNT and PELL_DISMNT. The Population Update process runs to success, with the log file indicating records updated, but the fields are not actually updated with the new values specified within the Population Select query (or other method).

The issue can be reproduced with the following steps, which are given for LOAN_DISBMNT; the same equivalent steps can be performed also for PELL_DISBMNT.

1. On Set Up SACR > System Administration > Utilities > Population Update > Population Update Setup > Population Update Setup, add record for LOAN_DISBMNT.
2. In the field dropdown, choose SFA_PAYPR_END_DT.
3. On Set Up SACR > System Administration > Utilities > Population Update > Population Update Process > Population Selection Update, choose LOAN_DISBMNT.
4. In Population selection section, choose PSquery, click magnifying glass and choose a query written to incorporate SFA_PU_LDSB_BND and a field defining the value(s) for SFA_PAYPR_END_DT.
5. Run the process. Click link to Process Monitor and note when process finishes in Success status. Then click into log or message log which indicates the number of records updated.
6. Navigate to Financial Aid > Loans > Direct Lending Management > Manage Direct Loan Application > Application Financial > SULA tab for one of the students and loans included in the update. Click the SULA Disbursement Fields link for the disbursement id that was supposed to be updated, and note the Payment Period End Date field is not showing the expected updated value in the 'Override SULA Values' column.

Changes

 The issue is observed after applying the fix for <Bug 34171171>, which delivered the changes to the SFA_PU_LDSB_BND and SFA_PU_PDSB_BND records.

Cause

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