HOUSING_TYPE Field on FAN_AIDATRBT_VW is Missing and Therefore is Not Available for Use in Packaging Equation; Attempting to Reference from STDNT_AID_ATRBT Results in Award Validation Edit 9545 (Doc ID 3020748.1)

Last updated on MAY 03, 2024

Applies to:

Symptoms

When attempting to write a packaging equation using the HOUSING_TYPE field, it can't be found to be referenced from the FAN_AIDATRBT_VW table where fields on the Packaging Status Summary page are normally found. The field can be referenced from STDNT_AID_ATRBT instead, but in that scenario the packaging equation causes award validation to with edit 9545 - 'Incorrect or inconsistent equation data'.

The issue can be reproduced at will with the following steps:

1. Query FAN_AIDATRBT_VW to verify HOUSING_TYPE is not on the record.
2. On Set Up SACR > Common Definitions > Equation Engine > Equation Editor, write an equation referencing the field directly from STDNT_AID_ATRBT.
3. Link the equation to the Item Type in the packaging plan on Set Up SACR > Product Related > Financial Aid > Awards > Packaging Plan > Packaging Rules 1.
4. On Financial Aid > Awards > Award Processing > Assign Awards to a Student > Student Aid Package, enter the packaging plan and click 'Retrieve'.
5. Note the item type linked to the equation fails to be assigned, and click 'Message' link to verify the validation edit 9545.

Changes

The issue occurs after applying all of the available fixes related to FAFSA Simplification up through and including the 13 fixes delivered in PeopleSoft Release Patchset (PRP), Patch 36421711 (Post-Regs 2 PRP for 2024-2025 FAFSA Simplification Update #3 & FM Need Analysis Calculator Update # 2).

Cause

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