SunGard Higher Education Banner Financial Aid Defect Resolution SYSTEM: Banner Financial Aid RELEASE: 8.13 DATE: 12/14/2011 ====================================================================== DEFECT #: 1-10Q8J88 PROGRAM: DOCUMENTATION,FINAID81201NY.PDF PROBLEM: Page 10 of the New Year Checklist includes the following entry: _______RORDATA Review the indicators for logging, Pell corrections, and INAS override fields to ensure that these fields are correctly set for the new aid year. Prerequisites The release for the new aid year is installed. Comments SunGard Higher Education delivers the values on this form with the new aid year updates of Banner Financial Aid. These values only become available with the install of the new release. The word INAS should not be included in this description. RORDATA entries are used for FM logging and will be delivered with the New Year Reg Release (8.13). No RORDATA records are used with IM/Early Decision processing, so RORDATA records are not delivered with the 8.12.1 Early Decision Release. IMPACT: The RORDATA entry on page 10 of the 2012-2013 New Aid Year Checklist incorrectly mentions INAS. RESOLUTION: The RORDATA description was corrected in the 2012-2013 New Aid Year Checklist version that will be delivered with the 8.13 Winter release. ====================================================================== DEFECT #: 1-10BH0PB PROGRAM: DOCUMENTATION,RNRPINI PROBLEM: The Banner Financial Aid 8.12 Release Guide inadvertently omitted the note that rnrpini, the process used to start the “Listener” Mode Online Processing Performance Enhancement using Oracle Pipes/ Advanced Queuing is not supported under Linux or Microsoft Windows. NOTE: If rnrpini is used under Linux, the listener will appear to start correctly, but when the RPEDISB, RPEPELL or RNEINxx process is run online, it will appear to hang until it times out and an ORA-06512 error will appear in the program_1.clg. Below is an example of the error in rpedisb_1.clg: SQLCODE=-000001937 SQLERRM=F ORA-06512: at "SYS.DBMS_SESSIO *** JOB TERMINATED ABNORMALLY *** COBOL:rts: ERROR: JMP [PID:0000364D TID:00004000] U OPEN LOGS FILE-LOCK 310 PGM=RPEDISBO IMPACT: Oracle Pipes/Advanced Queuing not being supported under Linux or Microsoft Windows via the RNRPINI was not established in the initial release documentation on the subject (Banner Financial Aid Release 8.12). RESOLUTION: The Banner Financial Aid User Guide (Release 8.13) has been updated to include a note to indicate that the RNRPINI process is not designed to function in a Windows NT or Linux environment to make use of Oracle Pipes/Advanced Queuing. ====================================================================== DEFECT #: 1-YSWSM4 MODULE: Budgeting PROGRAM: RBAABUD PROBLEM: The "No RCRAPP2 record" error is received when exiting the RBAABUD form. A student was manually placed in a Budget Group and they do not have a FAFSA application. The error is received when the Pell Calc tries to run when exiting the form. The same message is received if the Budget is deleted. There is not problem in processing an Alternative Loan or other non-Federal Aid. IMPACT: The error message could cause customer confusion and inconvenience. RESOLUTION: The 'No RCRAPP2 record' error message was created for Alternate Pell processing to indicate to the user that budget components in the student's budget affecting the calculation of an Alternate Pell award had changed, but no FAFSA yet existed for the student. Values from the FAFSA RCRAPP2 record were used in this calculation. The edit should have originally been made dependent on the Alternate Pell Schedules Used indicator found on ROAUSIO, in which case this logic would be bypassed, since Alternate Pell processing was discontinued several years ago. However with the 8.12.2 release, all Alternate Pell logic is being removed from the Banner product, so this error message will no longer appear. ====================================================================== DEFECT #: 1-VHRPM1 MODULE: Requirements Tracking PROGRAM: RB_REQUIREMENT PROBLEM: A TEACH Entrance requirement must be completed each year that the student receives a TEACH grant. However, the 8.11 RB_REQUIREMENT API will satisfy the TEACH Entrance in multiple aid years. For example: - A student has a TEACH Entrance Type on RPILECS with an Associated Aid Year 1011. - The student's 1011 TEACH Entrance Requirement is automatically satisfied by the API. - When a 1112 TEACH Entrance Requirement is created, it is automatically satisfied. This only happens when the TEACH grant fields are added on ROAUSIO as described in the 8.11 RG. The entry on ROAUSIO was meant to replace putting the TEACH requirement code & status into the RERIM12 parameter. For TEACH, the API should only automatically update a TEACH entrance requirement for the specific aid year on RPILECS. IMPACT: TEACH Grant entrance requirements are being satisfied improperly for aid years where the requirement should remain unsatisfied. RESOLUTION: The process has been modified to limit the satisfaction of TEACH Grant entrance requirements to the single aid year associated with the RPILECS record which signals that the requirement has been satisfied. ====================================================================== DEFECT #: 1-HD6XMI MODULE: Record Creation PROGRAM: RCRTP13 PROBLEM: When loading CSS Profile international records with RCRTP12, the CSS Country code is looked up on STVNATN and if the code does not exist on STVNATN, an error message occurs: "SPRADDR API - State or nation are required". The CSS Country codes should be translated similar to the COD Nation codes. IMPACT: Nation codes from PROFILE files may not be loaded correctly into SPRADDR. RESOLUTION: Crosswalk Code (RTVCCOE_CROSSWALK_CODE) has been added to the CSS Country Coefficient and Crosswalk Validation table and form. For CSS Nation codes which do not have corresponding values in STVNATN, the user will populate this value with an appropriate existing value from STVNATN. When a value exists in this column, RCRTP13 will use this value in the Nation code for new Student addresses in SPRADDR. If a crosswalk value doesn't exist, the process will use the CSS value if it exists in STVNATN. Otherwise, the SPRADDR address will be created with a null Nation Code, provided that a valid State or Province Code was also received in the CSS file. If neither a valid country code, a country code with a valid crosswalk value on RTVCCOE, or a valid State/Province code were loaded from the CSS file, the address will not be loaded and the message ‘SPRADDR API State or nation are required’ will be printed in the error file for rcrtp13. ====================================================================== DEFECT #: 1-ZN524Q MODULE: Loan Processing PROGRAM: rekci121.sql PROBLEM: If the tag has a value for AdditionalUnsubsidizedEligibilityIndicator or AbilityToBenefitTestAdministratorCode with a length >35 the file will not load into Banner. As a workaround the field value can be reduced to 35 characters and the file will load. IMPACT: and tag names exceed 35 characters in length. When the tag name is returned in the , the process will fail because it can handle only up to a maximum of 35 characters. RESOLUTION: The process will truncate the at 35 characters. ====================================================================== DEFECT #: 1-10GZO43 MODULE: Electronic Data Exchange PROGRAM: REREX12 PROBLEM: The COD files that are extracted in the REREX12 process will not validate against the Federal Schema in an xml editor. It will not validate because of the / after the version number in the header record. It does not affect COD processing the file It will validate without the slash: IMPACT: XML files created by the 2011-2012 COD extract process do not validate in some editors such as XMLSpy. There is no impact with COD's processing of these files. RESOLUTION: A slash in the CommonRecord header schemaLocation was replaced with a space so that it validates in editors such as XMLSpy. RESOLUTION: This defect resolution does not impact or require any additional documentation. ====================================================================== DEFECT #: 1-10GZO6E MODULE: Electronic Data Exchange PROGRAM: REREX12 PROBLEM: Changes made to the Direct Loan dependency status are not extracted correctly. FAFSA corrections were made and accepted but the changes to the accepted Direct Loan were rejected by COD. COD rejects the record with the is blank. The REREX12 process is extracting a change record with the tag and causes the reject. The RPADLCR and ROAALOG entries are correct indicating that the dependency status is changing from an 'I' to a 'D'. Changing the tag in the xml file to D allows COD to accept the change record. IMPACT: The 2011-2012 COD extract process is not extracting changes to the dependency status. RESOLUTION: The 2011-2012 COD extract process (REREX12) was modified to extract changes logged to the student's dependency status. ====================================================================== DEFECT #: 1-YNY05J MODULE: Loan Processing PROGRAM: REREX12 PROBLEM: The following error occurs intermittently when REREX12 is run in an 8.12 environment: java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORA-04088: error during execution of trigger 'FAISMGR.RT_RPRLADB_USERACTIVIT_INSUPD' ORA-06512: at "BANINST1.DML_RPRLADB", line 69 ORA-06512: at "BANINST1.RB_LOAN_DISBURSEMENT", line 2087 ORA-06512: at "BANINST1.REKCE12", line 3542 ORA-06512: at line 1 REREX12 only hits the cursor limit when it's getting a high number of students that need to be extracted (it doesn't consistently error out at any particular number of students). However, if there's few or no students to extract, it'll complete successfully. IMPACT: REREX12 does not run to completion for large batches. RESOLUTION: The 2011-2012 COD extract process (REREX12) was modified to close the high school data result set correctly so that the process does not exceed the open cursors limit. ====================================================================== DEFECT #: 1-Z5KX1L PROGRAM: RESFORM.SHL,.BAT,FAISFCMP.SHL,BAT PROBLEM: The script to generate the forms delivered with 8.12 came in 2 versions: faisfcmp.shl/bat (10g) and fasifcmp11g.shl/bat (11g). However, resform.shl/bat was delivered for 10g only and subsequent patches had 10g-only scripts. Both 10g and 11g versions of the forms compile scripts are needed. Workaround: Copy the code from the 8.12 faisfcmp11g.shl/ .bat and the list of "generate_it formname.fmb" commands from resform.shl/bat or the patch faisfcmp.shl/ bat to create 11g versions of the compile scripts. Alternately, the forms can be manually generated. IMPACT: Clients at 11g Form Compiler cannot successfully compile the library roqrpls.pll during mass compilations of forms due to the presence of "strip_source=yes" attribute in the compile rule within the mass compile scripts (resform.bat/resform.shl) RESOLUTION: With 8.12.1 release, a new mass compile script for 11g form compiler clients ,resform11g.shl and resform11g.bat have been provided where the attribute "strip_source=yes" has been removed for the compile rule of libraries. Additionally, the two scripts have been attched to the defect (resform11g.shl and resform11g.bat) for convenience. ====================================================================== DEFECT #: 1-US1ROQ PROGRAM: RFRMGMT PROBLEM: The 'Use Repeat Course Checking' indicator is not when the Copy fund feature is performed and the indicator is set to Y (checked) for the fund you are copying from. IMPACT: The 'Use Repeat Course Checking' indicator is not copied correctly. RESOLUTION: Modified RFRMGMT so that the 'Use Repeat Course Checking' indicator is now copied when the Copy fund feature is used. ====================================================================== DEFECT #: 1-10VX0GM MODULE: Common Functions PROGRAM: RNAOV07,RNAOV08 and RNAOV09 PROBLEM: After applying p1-zcrqa1_res8120004 and res81201, the forms RNAOV07, 08 and 09 do not come up in Banner due to invalid version. In patch p1-zcrqa1_res8120004, the RNAOVxx forms are all updated to version 8.12.0.4. The 8.12.0.4 versions of these forms are also delivered with res81201. However, applying res81201 sets the versions for RNAOV07, 08 and 09 right back to 8.12.0.2. Workaround: 1. Manually update the form versions to 8.12.0.4 in GSASECR; Or 2. Run the scripts below: start gsanobj rnaov07 ban_default_m '8.12.0.4' R ban_finaid_c start gsanobj rnaov08 ban_default_m '8.12.0.4' R ban_finaid_c start gsanobj rnaov09 ban_default_m '8.12.0.4' R ban_finaid_c IMPACT: Forms RNAOV07,RNAOV08,RNAOV09 do not come up due to invalid version error RESOLUTION: The security script delivered with 8.13 release,has been corrected to 8.12.0.4, to reflect the right version of the forms that were delivered with Banner Financial Aid 8.12.1 release. Alternatively, the corrected script, rsec81201.sql is attached with this defect. ====================================================================== DEFECT #: 1-ZCRQA1 PROGRAM: rnaov07.fmb,rnaov08.fmb,rnaov09.fmb, rnaov10.fmb,rnaov11.fmb,rnaov12.fmb PROBLEM: Making a new record current on RNAOV12 causes a change to the locked IM SC and IM PC on RNARS12. IMPACT: Making a new record current on RNAOV12 causes a change to the locked IM SC and IM PC on RNARS12. RESOLUTION: The RNAOVxx forms were modified to set the student ID to be processed correctly when switching from another Banner Financial Aid form and Student ID. ====================================================================== DEFECT #: 1-10YYTHB MODULE: INAS PROGRAM: RNAOV13 PROBLEM: Calculating Need via the F3 key does not actually run the calculation but will bring you to RNARS13 with the old results. You must first use Options-Calculate Need from RNAOV13 and once this is done the F3 key will work on RNAOV13 provided you do not rollback or exit the form. IMPACT: Calculating Need via the F3 key on RNAOV13 is intermittent. RESOLUTION: Calculating Need via the F3 key on RNAOV13 now works consistently. ====================================================================== DEFECT #: 1-XFTOE7 MODULE: Common Functions PROGRAM: RNAOVxx,RNAPRxx,RNASUxx,RNANAxx PROBLEM: The following forms no longer compile successfully after the 8.12 upgrade: RNAOV09, RNAPR09, RNASU09, RNANA09 RNAOV08, RNAPR08, RNASU08, RNANA08 RNAOV07, RNAPR07, RNASU07, RNANA07 Sample compile error: Compiling SET_STATUS_LINE trigger on form... Compilation error on SET_STATUS_LINE trigger on form: PL/SQL ERROR 306 at line 2, column 3 wrong number or types of arguments in call to 'P_GET_STATUS_SUMMARY' PL/SQL ERROR 0 at line 2, column 3 Statement ignored All the above mentioned forms show error: FRM-40735: SET_STATUS_LINE trigger raised unhandled exception ORA-04062: of has been changed ORA-01403: no data found IMPACT: After the 8.12 upgrade, several need analysis forms fail to compile and produce errors in Banner. RESOLUTION: A call to the ROKSUMM package has been modified. The following forms now compile: RNAOV09, RNAPR09, RNASU09, RNANA09 RNAOV08, RNAPR08, RNASU08, RNANA08 RNAOV07, RNAPR07, RNASU07, RNANA07 ====================================================================== DEFECT #: 1-G53QGF MODULE: Need Analysis PROGRAM: RNARS11 PROBLEM: If a user updates the value of the Reported Non-Custodial PC on RNAPR11/12 after an EDE record is loaded, the Reported Non-Custodial PC value on RNAPR11 disappears. This only impacts the display of the value on RNARS11/12 and does not impact the calculated PC or EFC on RNARS11/12, RNINAIQ or RPAAWRD. Workaround: If there is a need to update the Reported Non-Custodial PC after an EDE record is loaded, run RCPIMFM and the value will get updated on RNARS11/12. IMPACT: If Reported Non-custodial PC is updated on RNAPRxx after EDE record loaded, RNARSxx value not updated RESOLUTION: Modified how Reported Non-Custodial PC value is queried in both RNARS12 and RNARS13. ====================================================================== DEFECT #: 1-QI6MQM PROGRAM: RNARS12,RNARS13 PROBLEM: Manual Update of Independent FM SC on RNARS12 changes EFC TOTAL value to Estimated (RCRAPP4_C_INST_1_TFC_OFFL_EST) preventing packaging of the student per RPROPTS setup. Workaround -Change the FM SC, then set the FM PC to Official (from None), the TOTAL will then appear as Official. IMPACT: Manual Update of Independent FM SC on RNARS12 changes EFC TOTAL value to Estimated (RCRAPP4_C_INST_1_TFC_OFFL_EST) preventing packaging of the student per RPROPTS setup. RESOLUTION: The following scenarios are now valid: FM SC – Official FM PC – Official Total – Official FM SC – Estimated FM PC – Estimated Total – Estimated FM SC – none FM PC – none Total – none FM SC – Official FM PC – none Total – Official FM SC – Estimated FM PC – none Total – Estimated FM SC – none FM PC – Estimated Total – Estimated FM SC – none FM PC – Official Total – Official RESOLUTION: This defect resolution does not impact or require any additional documentation. ====================================================================== DEFECT #: 1-RCGOP7 MODULE: Packaging and Disbursements PROGRAM: RNKNEED PROBLEM: When student has a Pell Aid Period for 1011 and 1112 and a summer crossover period for 0910, the crossover data displayed in the Summary block of RPAAWRD, RPAAPMT or ROARMAN may be from the incorrect aid year. Example: 0910 Aid Period is fall, spring, summer (0910 more beneficial than 1011) 1011 Pell Aid Period is summer, fall, spring, summer (1011 more beneficial than 1112) 1112 Pell Aid Period is summer, fall, spring, summer On RPAAWRD for 1112, the crossover Pell information displayed is from 0910 instead of 1011 On RPAAWRD for 0910, the crossover Pell information displayed is from 1112 instead of 1011 IMPACT: Pell Crossover data from wrong aid year may display and create confusion for clients. RESOLUTION: Modified p_get_crossover_data to add test that the award's period must be a crossover for the parameter year. If a student has 2 summer crossover periods in their aid year, the earlier aid year Crossover Pell Award and Crossover Aid Year will be displayed on RPAAWRD/RPAAPMT/ROARMAN. Example 1011 has summer crossover with 0910 and 1112. The data on 1011 RPAAWRD/RPAAPMT/ROARMAN will display Crossover Pell Award and Crossover Aid Year from 0910. ====================================================================== DEFECT #: 1-M20GQ5 PROGRAM: RNRGL12 PROBLEM: When user tries to navigate (Item Next) from Untaxed Pension Distributions to VA Non-Education Benefits, user is taken to Marital Status. However, if do Item Previous when in Marital Status field, user is taken properly to VA Non-Education Benefits. IMPACT: Navigation to VA Non-Education Benefits field not working properly. RESOLUTION: Navigation has been modified on RNRGL13 only and now goes from Untaxed Pension Distributions to VA Non-Education Benefits, and then to Marital Status. ====================================================================== DEFECT #: 1-109U65T PROGRAM: ROAENRL PROBLEM: RORATND (Financial Aid Enrollment By Date window of ROAENRL) & ROVSATD (Current Enrollment By Date window of ROAENRL) sort order is currently by TERM_CODE desc. This sort order should be: Order by: TERM_CODE descending, ATTEND_DATE descending, FINAID_CREDIT_HR descending. IMPACT: RORATND and ROVSATD sort order is currently by Term Code descending, not by Attend Date/Credit Hour. RESOLUTION: Modified RORATND and ROVSATD block sort order to be by Term Code, Attending Date descending, Credit Hours descending. ====================================================================== DEFECT #: 1-10N8AIY MODULE: Common Functions PROGRAM: ROAINST PROBLEM: The label on the new field (ROBINST_BANINAS_INSTALLED_IND) that indicates the INAS IM Need Calculation is installed for the 1213 aid year is 'BANINAS IM Need Calculation Installed'. BANINAS is a directory and not known to end users. IMPACT: Confusing Label on ROAINST IM Calc field. RESOLUTION: This information has been addressed in the Banner Financial Aid 8.13 Release Guide and reference to the field's updated label was added to the 8.13 version of Financial Aid Online Help. RESOLUTION: ROBINST_BANINAS_INSTALLED_IND label has been modified to 'IM/EFM Need Calculation Installed'. ====================================================================== DEFECT #: 1-W5DH76 MODULE: Loan Processing PROGRAM: ROAUSIO PROBLEM: ROAUSIO permits the Direct Loan Advance Pay Indicator to be updated after authorizations and payments exist whether they have been extracted and sent to COD or not. Per page 3-10 of the Banner Financial Aid 2011-2012 COD Handbook, "You cannot change the Advance Pay for Direct Loan field after you have extracted Direct Loan disbursement records for the aid year." IMPACT: ROAUSIO permits updates to the Direct Loan Advance Pay Indicator after disbursements have been paid to the student account or have been extracted and sent to COD. RESOLUTION: The US Institutional Options (ROAUSIO) form was modified to prevent the DL Advance Pay Indicator from being updated once any Direct Loan disbursement has been paid or sent to COD. ====================================================================== DEFECT #: 1-UQLIE7 PROGRAM: rokmisc_period PROBLEM: The following functions should return 0 instead of NULL when no hours are calculated. rokmisc package: f_calc_attend_stud_adj_hrs f_calc_attend_stud_bill_hrs f_calc_attend_stud_credit_hrs f_calc_stud_adj_hrs f_calc_stud_bill_hrs f_calc_stud_credit_hrs rokmisc_period package: f_calc_attend_stud_adj_hrs f_calc_attend_stud_bill_hrs f_calc_attend_stud_credit_hrs f_calc_stud_adj_hrs f_calc_stud_bill_hrs f_calc_stud_credit_hrs f_calc_fa_credit_hrs f_calc_fa_bill_hrs f_calc_fa_adj_hrs p_disp_period_attend_fa_hrs The objects which use these functions are: rokmisc, rokmisc_period, RORFS07, RORFS08, RORFS09, RORFS10, RORFS11, RSRENRL, RRREXIT, ROVSATD, ROVSTU1, ROVSTU2, RPVAWT1, RPVAWT2, ROAENRL, RRRAREQ, RPKLOAN, RPBLMID, and RORREGS. IMPACT: Some rokmisc and rokmisc_period members inconsistently return NULL and 0 values. This causes confusion when these values are visible, such as on form ROAENRL. RESOLUTION: Modified rokmisc and rokmisc_period to return 0 instead of NULL for affected members. DEPENDENCIES: Version 8.13 of rokmisc can replace version 8.12 Version 8.13 of rokmisc_period can replace version 8.12.1 Version 8.13 of rpkloan can replace version 8.12 ====================================================================== DEFECT #: 1-XFTO70 PROGRAM: rokrpts1.sql,view scripts(see description) PROBLEM: Schools with Banner Student 8.2 installed get the following errors: See Defect 1-XFTO70.doc attachment for full detail of the error messages. The following objects fail to compile due to incorrect dependency on Banner Student 8.2.1. rokrpts1.sql rcvapl0.sql rcvapl1.sql rcvapl2.sql rovstu0.sql rovst u1.sql rovstu2.sql rovstu3.sql rpvawt0.sql rpvawt1.sql rpvawt2.sql rpvawy0.sql rpvawy1.sql rpvaw y2.sql IMPACT: Clients who have not upgraded to at least Student 8.2.1 will not be able to install Financial Aid 8.12. RESOLUTION: ROKRPTS package body script rokrpts1.sql has been modified. The six invalid SHRRPEQ columns which were used as TYPE references have been replaced by equivalent columns from tables SHRTCKN, SHRTRIT and SHRTRAM. ====================================================================== DEFECT #: 1-W30OQ9 MODULE: Record Creation PROGRAM: RORBPST PROBLEM: If students exist in Banner in a prior year but do not have a RORSTAT or RCRAPP record in the current year, Batch Posting a Current Record Lock will insert the RORSTAT record with the Current Record Lock. These student do not have a RNANAxx record for the year. If nothing else is done on this student, you will receive errors upon entering the form but the RORSTAT is already created. The error "No Current Record Exists. Cannot Lock Record" is received even though the lock is already present. You can remove the lock and you will receive the message "No current record exists for this applicant" but the RORSTAT is already created for the year. These students have already been run through the grouping process and are falling into the default group. IMPACT: The process can set on the Current Record Lock for students without an ISIR. RESOLUTION: The process will disallow updates to the Current Record Lock for students without an ISIR. ====================================================================== DEFECT #: 1-YWTPMJ PROGRAM: RORFS11.pc PROBLEM: RORFS11 may report students as less than full-time when they should be reported full-time. For example, if the student has the following enrollments they are reported correctly as full-time. Fall 12 Spring 12 However if they registered for Summer, as a trailer, but then dropped the courses they are counted as less than full-time. The student was not paid any aid for the summer term. The following is an example of when they would be counted as less than full-time in the FISAP. Fall 12 Spring 12 Summer 0 Since the hours in the last term are zero, the enrollment of Full-time for the previous, in this case, Spring, term should be used. Workaround: Use ROAFSAP to update records as appropriate. IMPACT: A student's enrollment status could be reported incorrectly. RESOLUTION: When determining whether a student was full or part time, the process was failing to exclude terms with enrollment hours of zero; such terms will no longer be considered in the enrollment status calculation. ====================================================================== DEFECT #: 1-109U61T PROGRAM: RORMVAL,RORATBT PROBLEM: Effective Nov. 18, 2011 COD will begin to accept a new ATB test code of "11" for SABE = Spanish Assessment of Basic Education. The valid date range for the completion date for this assessment is November 1, 2002 to Present. The new code will be accepted for all award types for the 1112 aid year and forward. 2 Required Data Scripts are needed: RORMVAL will need to have "11=SABE" added. RORATBT will need to have the Completion Start Date of November 1, 2002 and the Completion End Date of January 1, 9999 for "11=SABE". IMPACT: Effective Nov. 18, 2011 COD will begin to accept a new ATB test code of "11" for SABE = Spanish Assessment of Basic Education. This code will not be available to use in Banner unless scripts are delivered to add the new value. RESOLUTION: Two new data scripts are being delivered with the Banner Financial Aid 8.13 release to insert the new valid value of "11=SABE" for the COD Ability to Benefit Test Code. The rules for this code can be viewed on the Ability to Benefit Test COD Rules Inquiry Form (ROIATBT) and can be assigned on the Applicant High School and Admission Data Form (ROAHSDT). ====================================================================== DEFECT #: 1-10Q68B0 MODULE: Loan Processing PROGRAM: rpaldsb.fmb PROBLEM: Feed Indicator of F is display value only (per auto-hint) and Banner correctly changes the Feed Indicator to an F when the loan has successfully paid. If someone manually changes the Feed Indicator to F, the loan will not pay. Therefore, manual update must be prevented. Additionally, the Feed Indicator cannot be manually changed back to a Y without using SQL. Users should only be able to manually update the Feed Indicator to N or Y. IMPACT: Display ONLY Feed Indicator can be manually updated to F. RESOLUTION: Manually updating the Feed Indicator to F is now prevented. ====================================================================== DEFECT #: 1-XXHODG MODULE: Loan Processing PROGRAM: RPALORG PROBLEM: User receives “*ERROR* Edit disbursements gross amount must be reduced to 0 and accepted by COD before changing the loan period” when changing the loan period for a 2nd loan with the same fund code. User cannot change a loan period of a 2nd loan, even on a newly created loan, if another loan with the same fund code exists with Edit disbursements for a term not associated with the new loan period. IMPACT: The loan period cannot be changed on a new origination for the same fund code. RESOLUTION: RPALORG has been updated so that the edit that prevents a loan period change on an origination with accepted edit disbursements > 0 only checks for disbursement records that exist for the loan origination being updated. ====================================================================== DEFECT #: 1-WGRTL1 MODULE: Electronic Data Exchange PROGRAM: RPALORG,REREX12 PROBLEM: When erroneous data is entered into the Parent SSN, Student SSN or SAR transaction number field on RPALORG and REREX12 is run in batch, all students will be processed and their records updated to Sent but no file is created for the students processed/updated. For a workaround, please contact the ActionLine. IMPACT: REREX12 needs to be run in debug mode to find students with invalid data when it fails on XML validation. RESOLUTION: The Direct Loan Origination form (RPALORG) was modified to prevent incorrect data from being entered for SSN, Phone Number and Zip. Also, no changes will be allowed to the origination record when it is a Sent or Rejected status. Note: Changes can still be made to fields on the form in tables other than PRLAPP and also to the Disclosure Reprinting Requested indicator. RESOLUTION: The COD extract database package (rekce12) was modified to allow a zip code of less than 5 characters for foreign addresses. The COD extract java process (REREX12) was modified to print the XML output in the log file for debugging purposes if a XML validation error occurs. The XML in the log file can be used to identify the student and invalid tag. After the data is corrected, the batch may be sent to COD using the resend parameter. ====================================================================== DEFECT #: 1-YA3Z7F MODULE: Loan Processing PROGRAM: rpalorg.fmb PROBLEM: When a loan is being canceled with COD 'edit accepted' or 'accepted' disbursements, the Loan Requested (RPRLATR_REQUEST_AMT) and Approved amounts (RPRLATR_APPROVE_AMT) null out for the second period on the Loan Schedule tab of RPALORG. For example, a loan for $2000 is split 50% Fall and 50% Spring and displays on the loan schedule tab for each period. After the disbursements are 'edit accepted', the loan is reduced to zero. The loan schedule tab will display the Fall Loan percent as zero with the requested amount of zero and the approved amount of zero. The Spring percent as zero but the requested and approved amount null. Overtyping the 0 in RPRLATR_LOAN_PCT will repopulate those fields with zero. This does not cause any problems in Banner processing but may affect ad hoc reports. IMPACT: RPALORG Period Requested and Approved amounts null out when cancelling a loan. RESOLUTION: RPALORG Period Requested and Approved amounts are now set to zero when cancelling a loan. ====================================================================== DEFECT #: 1-ZEO6AQ MODULE: Loan Processing PROGRAM: rpalorg.fmb PROBLEM: The disbursement status is not set to Null when reducing or zeroing an edit disbursement on RPALORG. This results in the disbursement percent not being updated and also results in REREX12 not picking up the edit disbursement to report the changed amount. This can cause disbursements for a prior term to be rejected if they were also reduced when the edit disbursement was reduced. Workaround: When reducing or zeroing out an edit disbursement record, also set the disbursement status to Null. When the disbursement status is set to Null and the record is saved, the disbursement percent will automatically update to the correct value and REREX12 will pick up the record to send to COD the next time DL disbursement records are extracted. IMPACT: Problem Reducing or zeroing out loans on RPALORG. RESOLUTION: Modified to make sure Disbursement Status is set to Null when reducing or zeroing an edit disbursement. ====================================================================== DEFECT #: 1-Y6WQ5N PROGRAM: RPAUCOD PROBLEM: Getting 'FRM-40505: ORACLE error: unable to perform query' when executing query on RPAUCOD 8.12 To recreate: Go to RPAUCOD, next block, Enter Query/F7, enter a student's SSN or Name and hit Execute Query/F8: Error on bottom of screen: FRM-40505: ORACLE error: unable to perform query If you go to the Help menu, Display Error, you will see the search criteria appended to the SQL statement after the order by clause: SQL Statement in error: SELECT ROWID,RPTUECS_AIDY_CODE,..... FROM RPTUECS WHERE RPTUECS_AIDY_CODE = :1 AND RPTUECS_ENTRANCE_TYPE IN ('S','P') ORDER BY RPTUECS_COMP_DATE and (RPTUECS_LAST_NAME=:2) ORA-00933: SQL command not properly ended Workaround: Set Sort Order to Student SSN or Name in Key Block, then next block and scroll through the results. IMPACT: Getting 'FRM-40505: ORACLE error: unable to perform query' when executing query. RESOLUTION: Modified query separating the ORDER_BY clause from the Where clause. ====================================================================== DEFECT #: 1-W9ZEH9 PROGRAM: RPAUCOD,RPALORG.fmb,RERIM12.jar PROBLEM: Starting in July 2011 COD began sending a new tag to indicate whether or not the Borrower authorizes remaining PLUS loan balances to pay non-institutional charges. The new tag is received in the PLUS Application record (SP document type). This data must be captured in Banner when the SP documents are imported. Workaround: Continue to obtain this authorization to pay non-institutional charges as you have in the past. IMPACT: The data received in PLUS Application records in the tag is not captured and imported to Banner. RESOLUTION: Added support to the COD import (RERIM12) for the new XML tag in PLUS and Grad PLUS application records. The data from the tag will now be imported to the RPRLAPP_SCHOOL_CR_BALANCE_OPT column on matched records and the RPTUAPP_SCHOOL_CR_BALANCE_OPT column on unmatched records. RESOLUTION: A new field has been added to RPALORG to display the data in the RPRLAPP_SCHOOL_CR_BALANCE_OPT column. A field has been added to RPAUCOD to display the data in the RPTUAPP_SCHOOL_CR_BALANCE_OPT column. ====================================================================== DEFECT #: 1-VYZSP3 MODULE: Packaging and Disbursements PROGRAM: RPBDISB PROBLEM: RPBDISB report may display incorrect enrollment hours when attending hours are used for a Pell or Teach grant. The actual load calculation and calculation of the disbursement amount are correct. IMPACT: Clients who use attending hours to disburse Pell or Teach grants may be confused when the enrollment hours displayed on the report are not actually the hours that were used to calculated the disbursed amount. RESOLUTION: The UCLRTN Load Calculation routine, used by the RPEDISB Disbursement process to calculate enrollment loads, has been corrected. It now correctly updates the value of enrollment hours which is displayed on the RPBDISB report when attending hours are used for the fund.. ====================================================================== DEFECT #: 1-10N0B7Z MODULE: Packaging and Disbursements PROGRAM: RPEDISBS.pco PROBLEM: Using Advance Pay for DL, RPEDISB creates incorrect transaction under certain conditions. Example. Setup RFRMGMT – If ineligible before and after cutoff is set to backout. First disbursement has been paid. Disb 1/Seq 1 Actual disbursement date record is added and accepted by COD. Disb 1/Seq 2 Additional Disbursement amount is added, accepted by COD but not paid. Disb 1/seq 3 Student becomes ineligible for disbursement of the loan. Disbursement process is run. Disbursement 1/seq 3 is marked as fed but is not. Tran no 0 Disbursement 1/seq 4 is created reversing both initial and subsequent disbursements. This transaction is also marked as fed but is not. Tran no 0. This causes loan disbursements to be out of sync with financial aid paid amounts, AR and COD. IMPACT: When DL Advance Payment option is being used and a disbursement is authorized, approved by COD, paid to A/ R, then later adjusted and approved by COD, if the adjustment transaction is rejected during disbursement due to holds or other reasons, an incorrect adjustment is created by RPEDISB, leaving the student account out of balance with A/R and COD. RESOLUTION: The RPEDISBS Disbursement process has been corrected. Prior to the correction, the amount of the adjustment record created due to disbursement rejects incorrectly included both the adjustment being backed out and previously paid disbursement amounts. The new version of the process backs out only the adjustment which is being processed at the time of the reject, and does not include any prior paid amounts. ====================================================================== DEFECT #: 1-BU0EZB MODULE: Packaging and Disbursements PROGRAM: RPEPCKG PROBLEM: Algorithmic packaging does not work like packaging when repackaging a student who has an award that has been authorized. In packaging, these funds are ignored, while algorithmic packaging will continue to award more money each time packaging is run, resulting in doubling and tripling the award amount. While Banner does not completely support automatic repackaging, if it is run via algorithmic packaging it should ignore any funds with a memo/auth/disb record. IMPACT: When funds exist which are memo, authorized, or paid, the packaging process will incorrectly award additional funds. RESOLUTION: If the fund exists within the applicant's package and is memoed, authorized or paid, the fund will not be packaged . A message is provided on the RPRAWRD output: "No recalc; Memo, Authorized, or Paid" ====================================================================== DEFECT #: 1-BU01NP PROGRAM: RPRADSB PROBLEM: When the total awards accepted and awards disbursed exceeds $100 million, RPRADSB prints the amounts as follows: TOTAL AMOUNT ##,###,###D## ##,###,###D## The formatting for these two total amounts does not accommodate amounts over 100 million. Workaround: Use the Term Code, Fund Code or Population Selection parameter options. IMPACT: When the total awards accepted and awards disbursed exceeds $100 million, RPRADSB prints the amounts as ##, ###,###D##. RESOLUTION: This defect resolution does not impact or require any additional documentation. RESOLUTION: Adjusted the formatting of the total amount from 99G999G999D99 to 999G999G999D99 and table definition to accommodate larger value. ====================================================================== DEFECT #: 1-QTMNYH PROGRAM: RPRADSB PROBLEM: RPRADSB gives warnings when transaction numbers exceed 3 digits and only prints 3 of the digits on the report. Example warnings: WRN-LONGTOK: Token "1003" exceeds containing column width (3) WRN-LONGTOK: Token "1004" exceeds containing column width (3) rpradsb completed with warning(s) IMPACT: The Report gives warnings when transaction numbers exceed 3 digits and only prints 3 of the digits on the report. RESOLUTION: This defect resolution does not impact or require any additional documentation. RESOLUTION: Changed the table definition to accommodate four digits for transaction number. ====================================================================== DEFECT #: 1-109VLPZ MODULE: Electronic Data Exchange PROGRAM: RPRDUXX PROBLEM: RPRDUxx may incorrectly update a cash entry on RPACASH for schools using more than one school code. Example: School A and B each have a $99,999 transaction dated 7/27/11. Both are entered on RPACASH with appropriate GAPS control numbers. In August both a DSDF, disbursement level, and DSLF, loan level file are sent to school A with each containing the same cash entry of $99,999 on 7/27/11. When the RPRDUxx process runs loading the DSDF and DSLF file for school A both cash transactions are updated with the same information. When the DSDF and DSLF files are loaded for school B, the cash entry for school B is not updated because it was updated by school A. Workaround: Make cash transactions unique by date and amount. IMPACT: RPRDUxx may incorrectly update a cash entry on RPACASH for schools using more than one school code. RESOLUTION: The 2011-2012 DL Flat-File Upload process (RPRDU12) was modified to update the GAPS Control Number on RPACASH only when it is blank or matches the number in the upload file. ====================================================================== DEFECT #: 1-UZNM7T MODULE: Loan Processing PROGRAM: RPRLORC PROBLEM: The error message, "no SGBSTDN record" now displays in the lis file for student with loans in a canceled or declined status. The error message will also display for offered loan awards even when parameter 02 is set to N. This error message should only display for students with accepted loan awards, or offered loan awards and parameter 02 is set to Y, that do not have a SGBSTDN record. Workaround: Use population selection to select students with loans needing processing. IMPACT: The message, "no SGBSTDN record" now displays in the lis file for students with cncl/decl loans. RESOLUTION: The Direct Loan Creation Process (RPRLORC) has been modified to print the "No SGBSTDN record" error in the lis file only when the student's award is in accepted status or offered status and parameter 2 "Create if Awrd in Offer Status" is Y. It will not display for cancelled and declined awards. ====================================================================== DEFECT #: 1-108F40K PROGRAM: RRREXIT PROBLEM: Banner Financial Aid 8.12 rrrexit.pc segmentation fault (core dump) at runtime. or the following error may happen: Run Sequence Number........................: ORA-20100: ::Pidm is not valid.:: ORA-06512: at "BANINST1.RB_APPLICANT_STATUS_RULES", line 719 ORA-06512: at "BANINST1.RB_APPLICANT_STATUS", line 1454 ORA-06512: at "BANINST1.RP_APPLICANT_STATUS", line 1209 This text is written to the student_message variable and is greater than 31 characters declared for the variable causing the core dump. "Low Enrollment - no show for current term" Workaround: change this line from static TMCHAR student_message[31] = {0}; to static TMCHAR student_message[43] = {0}; Recompile rrrexit.pc IMPACT: Running RRREXIT on certain environments will failed if a student has a low enrollment with a no show status. RESOLUTION: Increase the error message variable to accommodate for the larger message. DEPENDENCIES: Version 8.13 of rrrexit.pc can replace version 8.12.1. ====================================================================== DEFECT #: 1-TEP2KT MODULE: Loan Processing PROGRAM: RRREXIT PROBLEM: RRREXIT does not select no show students under certain circumstances. Scenario 1 Student was paid on a consortium agreement in the previous term, was not enrolled at least half-time at the home school in that term, and the student is a no show in the current term. Scenario 2 Student was enrolled at least half-time in the previous term, has a degree awarded from ANY time in the past, and is a no show in the current term. IMPACT: Student's consortium enrollment hours are not been included consistently for calculation of enrollment for RRREXIT. Student who has a degree in a prior term but has received a loan after graduation is not being processed to determine if the student is a no show in the current term. RESOLUTION: Update process RRREXIT to include consortium enrollment hours for the purpose of calculating Low Enrollment and No Enrollment. DEPENDENCIES: Version 8.12.1 of rrrexit.pc can replace version 8.12. Version 8.12.1 of rokmisc_period0.sql & rokmisc_period1.sql can replace version 8.12. ====================================================================== DEFECT #: 1-OI0MH5 PROGRAM: RTVARSC PROBLEM: The RPRARSC table does not have a foreign key integrity constraint for RTVARSC_CODE. This allows the deletion of codes on the RTVARSC form when child records exist in the RPRARSC table. IMPACT: Resource codes can be deleted on RTVARSC even if they have been assigned on RPAARSC. RESOLUTION: The Resource Code Validation form (RTVARSC) has been modified to prevent deletion of resource codes that have been assigned on the Resource Maintenance form (RPAARSC). ====================================================================== DEFECT #: 1-VFBSFD MODULE: Loan Processing PROGRAM: RTVINTL PROBLEM: The RTVINTL table contains aid year specific system required data which is required to be rolled. It should NOT be included as part of ROPROLL because the rolling of data by the ROPROLL process is optional. If ROPROLL is run with parameter 08 Perform roll of COMMON data = N, then the required data is not rolled. This results in users being able to enter international data lengths which can cause REREXxx to abend. The RTVINTL table should have 172 records for the 1112 aid year. If it does not, please contact the ActionLine. IMPACT: RTVINTL requires a run of ROPROLL without which invalid data is being allowed in Banner Financial Aid forms. RESOLUTION: A required data script (rtvintli_081201.sql) is being delivered with the Early Decision release to roll RTVINTL records from the 2011-2012 aid year over to 2012-2013. No RTVINTL records will be rolled by the ROPROLL process if it is run after the script is applied since the data will already exist for the aid year. ====================================================================== DEFECT #: 1-XVUOVO PROGRAM: FM CALC PROBLEM: Defect 1-XVUOVO - FM Calc - finaid81100hshb.pdf has incomplete documentation for creating a new Machine in WebLogic The FM Calc - finaid81100hshb.pdf has incomplete documentation for creating a new Machine in WebLogic. Attached to this defect is an example of the detailed steps needed to do this in WebLogic 10.3.4 - Defect 1-XVUOVO - Steps to create a new Machine in WebLogic 10.docx IMPACT: Financial Aid Hosted Handbook is written based on iAS 10.1.3.5 and Weblogic 10.3.3.0. For institutions with other versions of iAS or Weblogic, some of the steps may not match exactly. RESOLUTION: The Financial Aid Hosted Handbook was updated to indicate that the version of iAS used is 10.1.3.5 and Weblogic is 10.3.3.0. Some steps in the Handbook may not match exactly with other versions iAS and Weblogic. ====================================================================== DEFECT #: 1-R5G8ST PROGRAM: FM Needs analysis PROBLEM: On some platforms, running RNPFM12 through Online (eg RNANA12, ROAIMMP, etc) leaves the temp axis2 jar files in /tmp/_axis2 without it being removed until a subsequent batch run of RNPFM12 through GJAPCTL, where it will remove all axis2 jar files and generates new temp axis2 jar files for the number of threads used. The jar files being created in /tmp/_axis2 are 3MB each. Workaround Attached is a beta patch to correct this issue. Please rename and place this file in your $BANNER_HOME/finaid/ java directory and link it to $BANNER_LINKS. IMPACT: On some environments, process rnpfm12 is not deleting temporary files uses by 3rd party libraries. This would leave unused files that take up disk space on the job submission servers. RESOLUTION: Modify process rnpfm13 to force 3rd party libraries to clean up after the process have finished running. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-SHJ5D0 PROGRAM: Hosted Services Handbook PROBLEM: Banner Financial Aid 8.11 Hosted Services Handbook Section 6-C has the following: NOTE: Institutions that are running the FM Need Analysis solution locally (On-Premise) MUST upgrade to the latest version of the service PRIOR to installing Banner Financial Aid 8.11. Refer to the Banner Financial Aid Hosted Services Handbook (Release 8.11) document for instructions. For the 8.11 release there are no new Web service updates. This requirement is in error. If an institution is already on 8.10 and is On-Premise, they have the latest available Web Service installed. IMPACT: Version 8.11 of the Financial Aid Hosted Handbook for On-Premise clients mentioned that a new version of the Webservice must be downloaded when there is no new service for the release. RESOLUTION: Update the Financial Aid Hosted Handbook to generically say to check for a new version of the Webservice and download and installed as needed. ====================================================================== DEFECT #: 1-K6VE4B PROGRAM: RNAVR11 PROBLEM: After running Calc Need (RNEIN11) from RNAVR11, it gives error "FRM-40654 Record has been updated by another user. Re-query to see change." Once you click OK, you are able to make changes and Save. IMPACT: After running Calc Need from RNAVR11, it gives "FRM-40654 Record has been updated by another user." RESOLUTION: This defect resolution does not impact or require any additional documentation. RESOLUTION: Modified RNAVR13 so that after Calc Need is run, the form is requeried before viewing RNARSxx. The 'Record has been updated by another user' message no longer appears. ====================================================================== DEFECT #: 1-H3KAM9 MODULE: Need Analysis PROGRAM: RNEIN12 PROBLEM: This issue occurs when the IM Global options on RNRGL12 are set to not allow the IM SC and/or PC to be lower than the FM SC and/or PC. The problem is that the INAR prints the IM EFC calculated by INAS rather than the higher FM EFC. The database is correct, this is only a reporting issue on the INAR. IMPACT: If the client is using the INAR as a basis for reviewing the results on RNARS12 or RNINAIQ and the INAR does not reflect the operation of the global options to prevent the IM EFC from dropping below the FM EFC, then the client might incorrectly report an error. RESOLUTION: INAS2012.pco, IMCALC12.pco, ININAR12.pco and MVISIR12 have been modified to move the current FM PC and SC values into INAS for use in determining whether or not the "IM cannot be lower than FM" global option applies to a given student. If so, the INAR will report the higher FM PC and SC values for the IM PC and SC rather than the calculated IM PC and SC values. ====================================================================== DEFECT #: 1-GTLW9F MODULE: Need Analysis PROGRAM: RNEIN12,RNECP12 PROBLEM: The comparison report (produced when RNEIN12 is run and RNRGL12 has the Student and/or Parent Compare flags set to Y) may display miscellanous data at the bottom of certain pages of the report (usually the last page) that is not related to any students' data. This does not impact the results of the report. IMPACT: The miscellaneous characters which, when seen, typically print on the last page of the report are distracting and may lead a client to assume that an error has taken place with the printing of the comparison report. In fact, no error has occurred and the printing of student data is not affected. RESOLUTION: RNECP12.pco has been modified to print no more than 16 lines of data differences which is the maximum number of differences reported by INAS. Not printing extra lines resolved this "miscellanous characters" issue. ====================================================================== DEFECT #: 1-10S44RR PROGRAM: RNPFM12 PROBLEM: When a student does not have an assumption or reject override, RNPFM12 is not picking up the professional judgment flag and sending it to the FM calculator for consideration in FM calculation assumption and reject edits. This can result in the assumptions that allow the parent to be included in the number in college to not be applied correctly when a professional judgment exists. Workaround: Set the Assumption 1 override Parents in college assumed 1 (Number in college is greater than 6) to checked on RNAOV12. While this is not an override to the specific assumption in question, it will allow the professional judgment flag to be passed to the FM calculation so that the parent can be considered in the number in college. IMPACT: Process rnpfm12 is not consistantly extracting the professional judgment flag for calculation. RESOLUTION: Update process rnpfm13 to always extract professional judgment flag when it is available. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-113EHB5 PROGRAM: RNPFM12 PROBLEM: Defect 1-113EHB5 - rnpfm12.shl references xbean.jar yet the file never ships The rnpfm12.shl has these 3 references :$VAPPR/finaid/ java/xbean.jar\ :$BANNER_HOME/finaid/java/xbean.jar\ : $BANNER_PROD_HOME/finaid/java/xbean.jar\ The file xbean.jar never shipped and is not present in $BANNER_HOME/finaid/java No known runtime error results from this missing file reference and it can safely be ignored. IMPACT: Process run script rnpfm12.shl has a reference to xbean.jar that is not used. This does not cause any run time issues with the process. RESOLUTION: Update rnpfm13.shl to no longer reference the unused xbean.jar file. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-O8Q3RH PROGRAM: RNPFM12 PROBLEM: RNPFM12 may not populate the Student Contribution from Assets field. However the FM Student Contribution will contain the Student Contribution from Assets data. Example, Student's Discretionary Net Worth is $500 and the conversion rate is 20%. The Student Contribution from Assets is $100. The $100 will display in the Student Contribution but does not display in Student Contribution from Assets. IMPACT: Process rnpfm12 is not updating the Student Contribution from Assets for Dependent students. This only affects the interim calculation as displayed on RNINAIQ and does affect the overall EFC calculation. RESOLUTION: Modify process rnpfm13 to correctly update the Student Contribution from Assets. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-OO406Q PROGRAM: RNPFM12 PROBLEM: Running EFC calculations for FM Need Analysis with the jobsub option and seeing response times varying from 15 seconds to 2 mins +. Have noticed timing gets worse when we run calculations at time intervals > 10mins. IMPACT: Running online Need Calculation with the jobsub option on RORPARM, process rnpfm12 has poor performance for large schools. RESOLUTION: Modify process rnpfm13 to separates the driving select statement into two; one statement for batch processing and one for running online. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-SHCI9N PROGRAM: RNPFM12 PROBLEM: FM Parent Contribution will not calculate if the student is married. This will happen if the student is independent by marriage whether the PC option is set globally on RNRGL12 or individually on RNAOV12. IMPACT: Process rnpfm12 will not calculate the Parent Contribution for an independent student if the student is married. RESOLUTION: Modify process rnpfm13 to allow a Parent Contribution to calculate for a married independent student when requested. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-TU0FTG PROGRAM: RNPFM12 PROBLEM: Running RNPFM12 in batch in a Windows environment does not automatically produce the RNEIN12 or RNRNA12 output. These processes would have to be run separately to produce the output necessary. Windows Only. IMPACT: Process rnpfm12 is not chain running process rnein12 and rnrna12 on Windows environment. RESOLUTION: Modify process rnpfm13 to name the temporary files, that is used by the Perl script "rnpfm13.pl", in the format of "___ .". This is the default naming convention for processes running on Windows environment. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-TUC7P3 PROGRAM: RNPFM12 PROBLEM: Assumption edits 2028 and 2029 call for making assumptions about whether or not the student is a citizen or eligible non-citizen if the citizenship status field is blank. These assumptions are not being applied correctly by the calculator and are instead returning a rejected record. Workaround: Update the student's Citizenship Status on RNANA12 to the correct status for the student and re-run the need calculation. IMPACT: Need Analysis calculation is not handling the assumption edits 2028 and 2029 correctly. Instead it is returning these assumptions as rejects. RESOLUTION: Update the cloud Need Analysis calculator to handle the the assumption edits 2028 and 2029. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-JQ2R6J PROGRAM: RNPFM12.COM PROBLEM: RNPFM12.COM contains 5 statements that look like this: $ IF (F$SEARCH(RNEINCLG) .NES. "") THEN $ JTR3 -n 'SEQ' -l 'RNEINCLG -j 'JOB' -w 'UID' 'UIPW' $ ENDIF VMS requires the THEN to be on its own line for this type of statement. As delivered, it causes the following error: %DCL-E-INVIFNEST, invalid IF-THEN-ELSE nesting structure or data inconsistency Client-suggested resolution: Update all 5 occurrences to move "THEN" to its own line. The statements should look similar to the following: $ IF (F$SEARCH(RNRNALOG) .NES. "") $ THEN $ JTR4 -n 'SEQ' -l 'RNRNALOG -j 'JOB' -w 'UID' 'UIPW' $ ENDIF IMPACT: On OpenVMS process rnpfm12 will not run without modifying the script rnpfm12.com first. RESOLUTION: Fix the 5 syntax errors in script rnpfm13.com. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-HX98WH PROGRAM: rnpfm12.shl PROBLEM: Defect 1-HX98WH - Running RNPFM12 and getting AxisFault InvalidAlgorithmParameterException the trustAnchors parameter must be non-empty Running RNPFM12 in FINAID 8.10 and getting this error below org.apache.axis2.AxisFault: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty at org.apache.axis2.AxisFault.makeFault(AxisFault.java: 430) at org.apache.axis2.transport.http.SOAPMessageFormatter.wr iteTo(SOAPMessageFormatter.java:83) ... Possible Paper Fix Edit $BANNER_LINKS/ rnpfm12.shl Find this line -Dcert=$BANNER_HOME/finaid/java/infinity.keystore \ Change it to -Dcert_HOLD=$BANNER_HOME/finaid/java/infinity.keystore \ Retest RNPFM12 See attachment details on Support Center IMPACT: By default process rnpfm12 is using the infinity.keystore file. This can cause some environment to fail to connect to the Need Calculation service in the cloud. RESOLUTION: The infinity.keystore file is no longer supported. With the release of rnpfm13, the process is no longer referencing this file. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-GSM19F MODULE: Need Analysis PROGRAM: RNPFM13 PROBLEM: In the first 2 circumstances below, the Available Data column is not displaying correctly. In the 3rd and 4th circumstances it is displaying properly. In all circumstances below the Dependency status information is displaying correctly. In all circumstances below, the Student Tax Filer and Parents Tax Filer information are not displayed 1) When an FM EDE record and IM Manual record exist, the Available Data column shows F = Federal Record Only. 2) When an FM Manual record and IM Manual record exist, the Available Data column shows F = Federal Record Only 3) When an FM EDE and IM CSS record exist, the Available Data column shows B = Federal and IM Record 4) When an FM Manual record and CSS record exist, the Available Data column shows B = Federal and IM Record IMPACT: Under certain conditions, the RNPFM12 process is not updating the Available Data field on RNINAIQ correctly. RESOLUTION: Modify process rnpfm13 to correctly update the Available Data field. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-I7JVSX PROGRAM: RNPFM13 PROBLEM: Primary System EFC on RNIAPPL exceeds 99,999 under certain conditions. Example: On RNARS12 FM PC: 99,999 FM SC: 14,000 TOTAL: 99,999 On RNIAPPL Primary Pell EFC 99999 Primary System EFC 113999 IMPACT: Process rnpfm12 is not limiting the maximum EFC to match with the sum of the Parent and Student contribution. RESOLUTION: Modify process rnpfm13 to limit the maximum EFC to 99, 999. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-QKL130 MODULE: Common Functions PROGRAM: RNPFMxx,RNARS11,RNARS12 PROBLEM: The 'Official/Estimated Indicator' is not prevented from update when the bottom line results are locked on RNARS11 and RNARS12. The FM SC (RCRAPP2_C_1_CTRB_OFFL_EST), the FM PC (RCRAPP2_C_PAR_1_CTRB_OFFL_EST), the total EFC (RCRAPP4_C_INST_1_TFC_OFFL_EST) and the Pell EFC (RCRAPP2_PELL_PGI_OFFL_EST) Official/Estimated fields will change when the Need Analysis Calculation is performs even though the results are locked. Once they are changed to "estimated", you are prevented from changing it back to "Official" until it is unlocked. The message is "field is protected against update". In addition, the reject message is populated with the reject condition even though the results are not updated with new Contributions. IMPACT: Process rnpfm12 is calculating FM Need when there are FM EFC values that are locked. RESOLUTION: Modify process rnpfm13 to not calculate FM Need for students with FM EFC values that are locked. When this scenario occurs a message will display on the form and in the rnpfm13 output indicating that the FM Need calculation could not be run due to locked FM EFC values. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-FFSSNM PROGRAM: RNPFMXX.WAR SSL PROBLEM: Defect 1-FFSSNM - No documentation exists for SSL FM Calc Servlet - rnpfmxx.war No Banner documentation exists detailing how to secure your FM Calc servlet- rnpfmxx.war using SSL on the OAS 10.1.3.x server One Client fixed this issue ERROR. IOException - sun.security.validator.ValidatorException: No trusted certificate found by pointing the ssl-config keystore to the Oracle Wallet on the box in secure-web-site.xml. IMPACT: The Financial Aid Hosted Handbook does not outline setup for SSL connection between Internet Native Banner and the servlet rnpfmxx.war. RESOLUTION: Added setup and guideline to the Financial Aid Hosted Handbook for institutions that wishes to enable SSL connection between Internet Native Banner and the servlet rnpfmxx.war. ====================================================================== DEFECT #: 1-H22MHL PROGRAM: RNRNA12 PROBLEM: The RNRNA12 report displays a field for "Country:" however, no data is printed to the report. The data in the RCRAPP4_PAR_CNTRY_CODE_RES column on the IM record (sequence = 0) should be displayed for this field on the report. IMPACT: Report RNRNA12 is not printing the Parent's Country of Residence when it is available. RESOLUTION: Fix report RNRNA13 to print Parent's Country of Residence when it is available. DEPENDENCIES: None. ====================================================================== DEFECT #: 1-GI19Q0 PROGRAM: RORPARM PROBLEM: Solution: Validation for this form requires additional packages and table. Defect 1-GI19Q0 - RORPARM -- USE_JOBSUB parameter allows you to enter a lower case y but still uses Servlet. The RORPARM 8.8.1 version of form allow you to enter USE_JOBSUB parameter as lower case "y" yet it still runs in Servlet mode instead of jobsub mode. You must enter an UPPER CASE "Y" to get it to run the online FM Calc in JOBSUB mode. The form should have validation routines for all the parameters and automatically uppercase some values to avoid issues like this. Currently any value can be entered for USE_JOBS for example "x" and it still runs in Servlet mode by default. IMPACT: Form RORPARM, Project Based Parameter Setup, has no validation. An institution can update values that are not supported which breaks the Need Analysis calculation. RESOLUTION: Added an database package to support table RORPARM. The package will enforce only valid values before the form can be saved. Update the RORPARM form to use a database package for all updates and inserts. DEPENDENCIES: Version 8.12.1 of rorparm.fmb can replace version 8.8.1. ====================================================================== ************* CONFIDENTIAL BUSINESS INFORMATION ************* SunGard Data Systems and/or its subsidiaries in the U.S.A. and other countries is the owner of numerous marks, including "SunGard," and the SunGard logo. SunGard Higher Education and/or its subsidiaries in the U.S.A and other countries is the owner of "Banner," "PowerCAMPUS," "Advance," "Luminis," "DegreeWorks," "fsaATLAS," "Course Signals," and "Open Digital Campus." Other names and marks used in this material are owned by third parties. © 2011 SunGard Higher Education. All rights reserved. The unauthorized possession, use, reproduction, distribution, display or disclosure of this material or the information contained herein is prohibited. Contains confidential and proprietary information of SunGard Higher Education and its subsidiaries. Use of these materials is limited to SunGard Higher Education licensees, and is subject to the terms and conditions of one or more written license agreements between SunGard Higher Education and the licensee in question. In preparing and providing this publication, SunGard Higher Education is not rendering legal, accounting, or other similar professional services. SunGard Higher Education makes no claims that an institution's use of this publication or the software for which it is provided will insure compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting and other similar professional services from competent providers of the organization’s own choosing.