Graduation Processing process SSR_GRAD_RPT Failed With cannot insert NULL into ("SYSADM"."PS_SAA_RPT_RQST"."SAA_OVRD_ASOF_DATE") Error When Attempting To Create AAR Post Bundle 35 (Doc ID 1945632.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 35:

ERROR
---------------
SQL error. Stmt #: 1623 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_SAA_RPT_RQST"."SAA_OVRD_ASOF_DATE")
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 , SAA_ADMIN_RQST) VALUES.....

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

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 to Create Academic Advisement Report Request
3. Notice the process fails with the above mentioned error.

IMPACT
---------------
This issue will impact the bundle move to production.

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