After Applying CS 9.2 Image 8, When Running Update Program Action/Reason Process (AE SAD_APL_PRG), Get Error Invalid Column Name 'sysdate', as Section MAIN Step020 has Hardcoded SYSDATE
(Doc ID 2363402.1)
Last updated on AUGUST 25, 2020
Applies to:
PeopleSoft Enterprise CS Recruiting and Admissions - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
ENVIRONMENT
------------------------------
CS 9.2 PUM Image 8
PeopleTools 8.56
Database: Microsoft SQL Server 2014
When running application engine SAD_APL_PRG, the following error is encountered.
There is hardcoded 'sysdate' syntax in Step 020 of App Engine section SAD_APL_PRG.MAIN, which will not work on Microsoft SQL Server.
Snipit of delivered code for SAD_APL_PRG SECTION:MAIN STEP: Step020 ACTION:SQL is as follows:
ERROR
-----------------------
Msg 207, Level 16, State 1, Line 4
Invalid column name 'sysdate'.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Student Admissions > Processing Applications > Update Applications > Update Program Action/Reason.
2. Run the process (SAD_APL_PRG).
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 |
Cause |
Solution |
References |