SFP: Error Expiring Anticipated Aid Manually When AID_YEAR Is Blank (Doc ID 2890054.1)

Last updated on JUNE 19, 2023

Applies to:

Symptoms

Receiving an error when trying to expire private loans that do not have an aid year attached to them manually.

Replication:

1. Load a FPOV2 where the <AwardYear> tag is missing
2. Use the component Expire SFP Anticipated Aid or Batch Expire SFP Anticipated Aid to change the Anticipated_Aid.DISB_EXPIRE_DT to the system date so it is no longer displayed on the SF Customer Account

  -OR - 

1. To create the FPOV2, load a CommonLine Response file in SFP to add this Loan to the student’s Package

SFP setup:

• FUND_TYPE = NFR_LOAN for <FundCode>ASON (SFP baseline config)
• SFP Security may need to be updated to grant access to CommonLine Management.

CS Setup:

• Populate ANTICIPATED_AID where one Award has the AID_YEAR populated and one Award has the AID_YEAR blank:
• Item type for Pell should be reviewed for similar setup (AID_YEAR will be populated)
• Item Type for NFF 900000000336 is setup as follows (AID_YEAR will be blank):

• Note: The Loan is a NFF (Non Federal Fund) and if the Award should populate when Fund Status is Estimated, then the SFP Term Setup NFF Estimated Award Start Date must be populated per Career/Academic Year.

 Load the FPOv2 and query ANTICIPATED_AID to verify a row(s). AID_YEAR will be blank (screen shot is only showing the one Award)

Navigation: Campus Community> SFP Interface>Expire SFP Anticipated Aid

Expire Pell (AID_YEAR) is populated:

 Expire SFP ASON is not populated:

Select Expire Anticipated Aid.

Page: SCC_SFP_ANTAID_EDT

Notice the Disb Expire Date has been updated from 04/03/2023 to the System Date.  Tap Save.
ANTICIPATED_AID.AID_YEAR and DISB_EXPIRE_DT were updated. (AID_YEAR will be populated with the User Default for Aid Year value)

Navigating away from page it will respond with Do you want to save?  Select No (data has already been saved).

View Customer Account>Anticipated Aid for Spring 2023.  Both Pell and ASON have expired and no longer displayed.

Test Batch: Navigation: Campus Community> SFP Interface>Batch SFP Anticipated Aid

SQL update Anticipated_aid for item type 900000000336 where AID_YEAR is blank And DISB_EXPIRE_DT is a future date.

Create Pop Select Query:

Run SFP_XANTAID.  ANTICIPATED_AID.DISB_EXPIRE_DT is updated with system date and Aid_Year is left blank.

FPOV2 Examples:

Non Federal Fund with <AwardYear>
<FundCode>CHAFEE</FundCode>
<FundName>California Chafee Grant</FundName>
<NfrPeriods>
<NfrPeriod>
<NfrPeriodNumber>12</NfrPeriodNumber>
<StartDate>2020-03-31</StartDate>
<EndDate>2020-07-30</EndDate>
<AwardYear>2019-2020</AwardYear>
<FundStatus>Awarded</FundStatus>
<FundMaxAmount>1200.0</FundMaxAmount>
<AwardAmount>1200.00</AwardAmount>
<DisbursementHoldIndicator>false</DisbursementHoldIndicator>
<FundAcceptanceRequiredIndicator>false</FundAcceptanceRequiredIndicator>
</NfrPeriod>
</NfrPeriods>
</Nfr>
</Funds>
</AcademicYear>
</AcademicYears>
</Program>
</Programs>
</FasFinancialPlanOutboundV2Event>

Non Federal Fund CommonLine Loan without <AwardYear>
CommonLine Loans
<FundCode>ASON</FundCode>
<FundName>PrvLn-SLMA Smart Option</FundName>
<NfrPeriods>
<NfrPeriod>
<NfrPeriodNumber>11</NfrPeriodNumber>
<StartDate>2019-11-01</StartDate>
<EndDate>2020-03-29</EndDate>
Missing <AwardYear> tag
<FundStatus>Awarded</FundStatus>
<FundMaxAmount>5100.0</FundMaxAmount>
<AwardAmount>5100.00</AwardAmount>
<DisbursementHoldIndicator>false</DisbursementHoldIndicator>
<FundAcceptanceRequiredIndicator>false</FundAcceptanceRequiredIndicator>
</NfrPeriod>
<NfrPeriod>
</Nfr>
</Funds>
</AcademicYear>
</AcademicYears>
</Program>
</Programs>

Changes

Cause

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