[ctcLinkfinaidsupport] UPDATE: Oracle Bug - Packaging Message for Aggregate Limits

[Britney Corbitt]

Good Afternoon FA:

The query mentioned in the previous email has been made available in PRD:


  *
QCS_FA_LN_DEPEND_STAT_BUG


This query identifies students with dependency status of Y (Independent Reject) or X (Dependent Reject) on the Student Aid table, which could trigger the Aggregate Error we reported previously. It also identifies students with originated loans with dependency status of Y or X that need to be updated prior to transmitting to COD. The work around for this process can be found here: FAFSA Simplification 2024-2025 Known Issues in ctcLink - Packaging Message for Aggregate Limits<https://ctclinkreferencecenter.ctclink.us/m/104724/l/1817474-fafsa-simplification-2024-2025-known-issues-in-ctclink#packaging-message-for-aggregate-limits>

Have a wonderful weekend!




[Compass]Britney Corbitt

Functional Analyst, Campus Solutions (Financial Aid)

Washington State Board for Community and Technical Colleges

1300 Quince Street SE

Olympia, WA 98504-2495

bcorbitt at sbctc.edu<mailto:bcorbitt at sbctc.edu> • o: 360-704-1841

sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>



________________________________
From: Molly Groyer <mgroyer at sbctc.edu>
Sent: Thursday, July 25, 2024 11:32 AM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>; dirfinaid at lists.ctc.edu <dirfinaid at lists.ctc.edu>
Cc: Ana Ybarra <aybarra at sbctc.edu>; Britney Corbitt <bcorbitt at sbctc.edu>; Connie Burrow <cburrow at sbctc.edu>; Deborah Englehardt <denglehardt at sbctc.edu>; Jedidiah Lara <jlara at sbctc.edu>; Kelly Forsberg <kforsberg at sbctc.edu>; Stephanie Casino <scasino at sbctc.edu>
Subject: Oracle Bug - Packaging Message for Aggregate Limits


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/20240802/b8ffd889/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/20240802/b8ffd889/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/20240802/b8ffd889/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/20240802/b8ffd889/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 15360 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240802/b8ffd889/attachment-0003.png>