After Applying Patch 36159970, ISIR Load Fails With Error 'Invalid bind variable number' on Stored Statement FAP00SLD_U_SADPER
(Doc ID 3011555.1)
Last updated on SEPTEMBER 26, 2024
Applies to:
PeopleSoft Enterprise CS Financial Aid - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
After applying all fixes delivered in Patch 36159970 - 2024-2025 FM ADDITIONAL UPDATES #3, the ISIR load process is failing.
The following error appears in the FAPSAR00 COBOL output log file.
Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: PROCESS-SETUP(BIND)
With Return Code: 08001
Error Message : Invalid bind variable number
Stored Stmt : FAP00SLD_U_SADPER
SQL Statement : UPDATE PS_STDNT_AWD_PER SET FED_EFC = :1, EFC_STA
TUS = :2, FED_STDNT_CONTRB = :3, FED_PARENT_CONTRB
= :4, FED_NEED = :5, PRORATED_STU_CNTRB = :6, PR
ORATED_PAR_CNTRB = :7, PRORATED_EFC = :8 WHERE EMPLID
= :9 AND INSTITUTION = :10 AND AID_YEAR
= :11 AND AWARD_PERIOD = 'A'
Application Program Failed
In Pgm Section : ERROR INSERTING U-SADPER (FAP00SLD)
With Return Code: 08001
Error Message : Invalid bind variable number
Action Type : SQL UPDATE
In Pgm Section : SQLRT: PROCESS-SETUP(BIND)
With Return Code: 08001
Error Message : Invalid bind variable number
Stored Stmt : FAP00SLD_U_SADPER
SQL Statement : UPDATE PS_STDNT_AWD_PER SET FED_EFC = :1, EFC_STA
TUS = :2, FED_STDNT_CONTRB = :3, FED_PARENT_CONTRB
= :4, FED_NEED = :5, PRORATED_STU_CNTRB = :6, PR
ORATED_PAR_CNTRB = :7, PRORATED_EFC = :8 WHERE EMPLID
= :9 AND INSTITUTION = :10 AND AID_YEAR
= :11 AND AWARD_PERIOD = 'A'
Application Program Failed
In Pgm Section : ERROR INSERTING U-SADPER (FAP00SLD)
With Return Code: 08001
Error Message : Invalid bind variable number
The issue can be reproduced at will with the following steps:
- Navigate to Financial Aid, File Management, ISIR Import, Process ISIRs, ISIR File Load and run the process;
- Click the link to Process Monitor and note when process ends in Error status;
- Click details link for the process instance, then the link that says 'View Log/Trace', then the link to the .log file in the file list, and note the detailed error message.
Changes
Patch 36159970 - 2024-2025 FM ADDITIONAL UPDATES #3 was applied.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |