A SQL Error Occurs When Clicking the 'Calc SAP' button on Both The Maintain SAP Student Data Page And the Simulate SAP Page (Doc ID 2168090.1)

Last updated on FEBRUARY 15, 2017

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When clicking on the 'Calc SAP' button on either the Maintain Student SAP Data page or the SAP Simulation page a SQL error occurs.


ERROR
-----------------------
Error from the Simulate SAP Page:

A SQL error occurred. Please consult your system log for details
Process 3930574 ABENDED at Step SFA_SAP_LIB.STATAYR.Step015 (SQL -- RC= 1427 (108,524)
CallAppEngine: Application SFA_SAP_1DRV:AppEngine error.(2,653) SFA_SAP_STDNT_SIM.GBL.SFA_SAP_WK.SFA_SAP_CALC_BT.FieldChange PCPC:2535 Statement32

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

Error from the Maintain SAP Student Data Page:

Process 10437127 ABENDED at Step SFA_SAP_LIB.STATTRM.Step020 (SQL) -- RC = 805 (108,524)
CallAppEngine: Application SFA_SAP_1DRV: AppEngine error. (2,653) SFA_SAP_STDNT.GBL.SFA_SAP_WK.SFA_SAP_CALC_BT.FieldChange PCPC:2407 Statement:31

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Financial Aid --> Satisfactory Academic Progress --> Simulate Student Eligibility or Maintain Student SAP Data
2. Enter search record fields: EMPLID, Institution and Career
3. Enter Terms/Aid Year on the page and click the calc SAP button
4. Review results

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot simulate eligibility for the same student for multiple terms/aid years nor can an online Calculation occur.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms