EFC_STATUS for the Non-Standard Award Period is Unofficial, but Official for the Academic Award Period. (Doc ID 3073659.1)

Last updated on FEBRUARY 26, 2025

Applies to:

Symptoms

The EFC_STATUS for the non-standard award period is Unofficial but Official for the academic award period.

Due to this mismatch in EFC_STATUS (O vs. U) on STDNT_AWD_PER between the AWARD_PERIOD values of 'A' and 'N' may lead to the exclusion of many students from packaging selection and or usage in disbursement rules.

The issue can be reproduced at will with the following steps:
1. Load an ISIR
2. Navigate to: Financial Aid -> View Packaging Status Summary or View Financial Aid Status
3. Click the Need Summary Link from either component.
4. Toggle through the rows or do a View All
5. Note that for the Award Period = Academic the SAI Status = Official and the Award Period = Non Standard the SAI Status = Unofficial.

or run the following:

SELECT A.*
FROM PS_STDNT_AWD_PER A, PS_STDNT_AWD_PER B
WHERE A.EMPLID = B.EMPLID
  AND A.INSTITUTION = B.INSTITUTION
  AND A.AID_YEAR = B.AID_YEAR
  AND A.AID_YEAR = '2025'
  AND A.AWARD_PERIOD = 'A'
  AND A.EFC_STATUS = 'O'
  AND B.AWARD_PERIOD = 'N'
  AND B.EFC_STATUS = 'U'
ORDER BY 2, 1;

and

SELECT A.*
FROM PS_STDNT_AWD_PER A, PS_STDNT_AWD_PER B
WHERE A.EMPLID = B.EMPLID
  AND A.INSTITUTION = B.INSTITUTION
  AND A.AID_YEAR = B.AID_YEAR
  AND A.AID_YEAR = '2025'
  AND A.AWARD_PERIOD = 'A'
  AND A.EFC_STATUS = 'O'
  AND B.AWARD_PERIOD = 'N'
  AND B.EFC_STATUS = 'O'
ORDER BY 2, 1;

Cause

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