Graduation Processing process SSR_GRAD_RPT Failed With Fatal SQL Error When Attempting To Create AAR Post Bundle 33 (Doc ID 1677461.1)

Last updated on AUGUST 08, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
The following error occurs when running the Graduation Processing process after applying Bundle 33:
 
ERROR
---------------

ORA-01400: cannot insert NULL into ("SYSADM"."PS_SAA_RPT_RQST"."SAA_ADMIN_RQST")
Failed SQL stmt: INSERT INTO PS_SAA_RPT_RQST ( EMPLID , ANALYSIS_DB_SEQ , RPT_DATE , RPT_TYPE , SAA_RPT_IDENTIFIER , INSTITUTION , TSCRPT_TYPE , OPRID , SAA_PROCESSED_DATE , SAA_PROCESSING_CD , FREEZE_REC_FL , ASOF_DATE , WHAT_IF_FL , WHIF_CRSE_COUNT , USE_CMPLT_MODEL , AA_SSTC_MODEL , SAA_CANCEL_RQST)

Process 2286613 ABENDED at Step SSR_GRAD_RPT.AAReq2.Step30 (SQL) -- RC = 1400 (108,524)


WHAT IS WORKING
---------------
The process worked fine before applying bundle 33
 
ENVIRONMENT
---------------
DB Platform - N/A
Tools Version - 8.53
Application & Version - PeopleSoft Enterprise Campus Solutions release 9
System Name - Production
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Navigate to Records and Enrollment - Graduation - Graduation Processing
2. Run the Graduation Processing Process with the option of create Advisement Report Request
3. Notice the process fails with the above mentioned error.


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