[ctcLinkfinaidsupport] Oracle Bug - Packaging Message for Aggregate Limits

[Molly Groyer]

Hello FA!

We have received reports from colleges about loans being cancelled for students who have not reached their aggregate loan limits. The packaging message below is displayed when staff select Validate on the Assign Awards to a Student page:
[A close-up of a message  Description automatically generated]
This issue is due to an outstanding bug with Oracle. The bug is causing the dependency status value to be X (dependent students) or Y (independent students) on the STUDENT_AID record.

At this time, we highly recommend that ISIRs should not be deleted once an award has been made, because of this bug & others mentioned in the OVD guide & on the FAFSA Simplification 2024-2025 Known Issues in ctcLink webpage.

Next steps:
A fix from Oracle is expected in the next PRP. We will send updates when we have additional information.

In the meantime, we have developed a query to identify these students. Once this query is available in Production, we will send a notification. You can then run the query to look for students who have the incorrect dependency status value of X or Y. Once you have confirmed that a student has not reached their loan aggregates & has met all other eligibility to receive the loans, you should be able to award the loan on the Invoke Professional Judgment page.

To determine if a loan will need the dependency status value updated, navigate to Financial Aid > Loans > Direct Lending Management > Override Loan Application Data. Select the Direct Loan Demo Ovrd tab. If the dependency status value is X or Y, override it to D (dependent students) or I (independent students).
[A screenshot of a computer  Description automatically generated]
The override will then be included on your next outbound loan file.
If you would prefer to wait to award a student’s loans until the resolution is delivered by Oracle & tested by our team, that is completely fine. 😊

Thank you,

[cid:image006.png at 01DADE86.44ADB670]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240725/3f3deafb/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 13886 bytes
Desc: image001.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240725/3f3deafb/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 39874 bytes
Desc: image005.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240725/3f3deafb/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 17866 bytes
Desc: image006.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240725/3f3deafb/attachment-0001.png>