CCSEVCMP - SEVIS F/M alert Process fails on SEV_REV_EMP (Doc ID 2127243.1)

Last updated on JANUARY 30, 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