Several Fields in Aid Year 2024-2025 ISIR File ISIR25OP are Mapped to the Wrong Corresponding Fields in the ISIR_00 Staging Tables After Running Import Federal Data Files (FA_INBOUND) (Doc ID 2999174.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

After running the Import Federal Data Files FA_INBOUND application engine process to load a 2024-2025 ISIR file (ISIR25OP), several fields in the file are found to have been mapped to the wrong fields in the staging tables. A spreadsheet with the current mapping is linked at the attachments section at the end of this document.

The mapping from file to staging is expected to be correct for every field, otherwise the fields will also not load correctly to the application tables.

The list of fields being mapped incorrectly includes the following:

• The fields for 'Ward of Court?' and 'In Foster Care?' (fields 48-49 at positions 566-567) are being switched, which is also reflected in the spreadsheet. 
• The fields for 'Net Worth of Current' Investments' (field 106 at position 861-867) and 'Net Worth of Businesses and Investment Farms' (field 107 at position 868-874) are being switched, which is also reflected in the spreadsheet. 
• The fields for 'Student Spouse SSA Match Status', 'Parent SSA Match Status' and 'Parent Spouse or Partner SSA Match Status' (fields 564-566 at positions 3885-3887) are each being mixed up with one of the others - Student Spouse with Parent; Parent with Parent Spouse; and Parent Spouse with Student Spouse.  In this case, the spreadsheet indicates the correct/intended mapping, not the actual/incorrect mapping. 

There are also four 'Date Consent Granted' fields that are not populating in staging at all. For more detail on the issue with these fields, see Note 3001225.1.

The issue can be reproduced with the following steps:

1. Navigate to Financial Aid > File Management > Import Federal Data Files > FA Inbound and run the process for a ISIR25OP file.
2. Query the data populated in ISIR_00_1_EC and ISIR_00_2_EC to confirm any discrepancies. Use the current version of the file mapping spreadsheet linked in Note 2870029.1 for the file to table field comparisons. 

Changes

The issue occurs after applying the fixes delivered in Patch 35043037 - 2024-2025 ISIR UPDATE: FAFSA SIMPLIFICATION 

Cause

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