Generating Academic Requirement Report FLUID Error 'Remote program SRPCAARC failed with return code 1400: ORA- 01400 Can not insert null into ("SYSADM"."PS_SAARPT_ERROR".RPT_DATE")'; in Classic, must Navigate Away/Back from My Academics Tab to Generate (Doc ID 2834650.1)

Last updated on JANUARY 19, 2022

Applies to:

Symptoms

When attempting to Generate an Academic Requirement Report for the first time for a new student, problems occur in both the FLUID and Classic versions of Self Service. 

In FLUID, the following error is displayed on the page:

In Classic, the page shows the message "Generating Academics Requirements report." But the report will not actually display unless the user navigates away from then back to the My Academics tab. 

The issue does not occur for currently or previously enrolled students who have had the report generated previously. 

The issue can be reproduced at will with the following steps:

1. In Academic Advising Setup, check the 'Create Report if not run' box to generate the report for new students. 
2. Log in as Student, and go to FLUID Home Page, Academic Progress. 
3. On Academic Progress Summary tab, note error displayed on the page. 
4. Navigate to Student Center, My Academics. 
5. Note the message displayed indefinitely: "Generating Academics Requirements report."
6. Navigate away from the tab, then back, to see the report generated. 

Changes

The issue is seen after applying the functionality, to create an academic requirement report, first delivered in CS 9.2 PUM Image 7. 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.