Academic Advisement Report In The Student Center When Run Using The Installation Date it Runs Using The As Of An Old Date Instead (Doc ID 2924524.1)

Last updated on JANUARY 31, 2023

Applies to:

Symptoms

When running the academic advisement report using As Of the Installation Date (1/1/3000). It runs as of an OLD date in the student/advisor self-service center. As a result any new changes (flagged) are NOT reflected in the report.


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

1. Set the AA Installation setup to default the AA As Of Date set to 1/1/3000  and select ONLY Academic Structure Records and Student Groups Records sync  options.
2. Set AA Self-Service Setup to Enable Real-Time Processing and select the  Refresh using sync options radio button
3. Define the self-service AA Report type Date Control for As Of Date field  to Installation Date Option.
4. Logged in as an administrative user, navigate to Academic Advisement,  Student Advisement, Request Advisement Report, Add New. Specify a test student's EMPLID and the report type defined to self-service in step 3. 
5. Navigate to Records and Enrollment, Career and Program Information,  Student Program/Plan. Add a new row to a test student's program/plan stack changing the student's plan to a new (different) value.
6. Also under Career and Program Information, navigate to Student Groups.  Select the test student EMPLID and assign the student to group ATHL.
7. Query STDNT_CAREER for the emplid and confirm the Synchronize field = Y
8. Log off as the admin user and log into self-service as the test student.  Navigate to Student Center, then select Academic Requirements and click the GO icon.
9. Review the report. Note that the requirement group where the condition =  ATHL does not appears, and the student's plan requirement groups do not reflect the new plan value.

Cause

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