My Oracle Support Banner

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 later
Information 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



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

  1.  Navigate to Financial Aid, File Management, ISIR Import, Process ISIRs, ISIR File Load and run the process;
  2.  Click the link to Process Monitor and note when process ends in Error status;
  3.  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


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