CCSEVCMP - SEVIS F/M alert Process fails on SEV_REV_EMP
Last updated on NOVEMBER 01, 2017
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
On : CS9 version, SEVIS
CCSEVCMP - SEVIS F/M Alert Process
We are running into an error when Running the SEVIS Alerts the process halts after going through 1197 students and gives us this error:
/apps/peoplesoft/ps9/sqr/ccsevcmp.sqr: CCSEVCMP.SQR - SQL Statement =
CCSEVLIB.SQC,Insert-REV-EMP,Insert,PS_SEV_REV_EMP
SQL Status = 1847, SQL Error = ORA-01847: day of month must be between 1 and last day of month
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
ERROR
-----------------------
SQL Status = 1847, SQL Error = ORA-01847: day of month must be between 1 and last day of month
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the SEVIS alerts and get error
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete running the SEVIS process
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