Remote program SRPCATRC failed with return code: 1400 .Reason: ORA-01400: cannot insert NULL into ("SYSADM"."PS_ATTEND_TMPLT"."ATTEND_TO_TIME") When Generating an Attendance Roster (Doc ID 1530042.1)

Last updated on APRIL 01, 2016

Applies to:

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

Symptoms

On : Campus Solutions Attendance Roster Generation by Class,
a cobol error occurs when trying to generate the Attendance Roster for some classes.

ERROR
-----------------------
Remote program SRPCATRC failed with return code: 1400 .Reason: ORA-01400: cannot insert NULL into ("SYSADM"."PS_ATTEND_TMPLT"."ATTEND_TO_TIME"). In section: SQLRT: EXECUTE-STMT (2,-1) DERIVED_SR_ATND.ATTEND_CREATE1_PB.FieldChange PCPC:1111 Statement:5

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Curriculum Management > Attendance Roster > Attendance Roster by Class and access one of the affected classes.
2. Fill in the run control information and then click on the Create button.
3. Review error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate an attendance roster for some classes.

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