Oracle Student Management Cloud Service: Student Management Time Zone Feature (Doc ID 2750794.1)

Last updated on OCTOBER 30, 2023

Applies to:

Details

Actions

Background

If you have course schedule meeting data created before release 21B it’s really important that you follow the steps outlined here in sequence.
A time zone field is added to the course schedule meeting information page. The field is null for existing course schedule data created before release 21B. You need to update course schedule meetings with the time zone that the course schedules were originally created in.

Time Zone Feature Implementation Steps

You should not change any course data until the following steps are completed. If you haven’t created course schedule meeting information and intend to create new courses and course schedule meetings from release 21B and beyond, you don’t need to run Step 3.

Note: It’s essential that you carry out these steps on all environments where you have existing course schedule meeting information created prior to release 21B.

Step 1 – Configure FND_TIMEZONE Site Profile Code

You should first ensure that you have an FND_TIMEZONE site profile code configured:

• Navigation: Setup and Maintenance>Search>Manage Administrator Profile Values
• Profile Option Code = FND_TIMEZONE
• Profile Level = Site
• Profile Value = Customer Default Time Zone, for example, US Pacific Time

Step 2 – Configure Manage Time Zones Settings

In the Manage Time Zone Settings page, you need to add relevant time zones that you then use in the creation of course schedule meetings. This might be one or multiple time zones.
Navigation: Academics>Curriculum>Actions>Manage Time Zone Settings
When you enter the page (having setup the FND_TIMEZONE in step 1), you are prompted to add that time zone here to the Manage Time Zone Settings page.

You can use this time zone as your default, although you can change this later. You must select at least one time zone as the default. You can add any other time zones that your institution supports for course schedule meetings.

Step 3 – Update Course Schedule Time Zones

This is only required to be run for existing course schedule meeting details created prior to release 21B. A new time zone prompt is added to the course schedule meetings page. It is null for any course schedule meetings created before release 21B. Note that the user regional preference time zone is no longer considered when creating course schedule meetings. This is replaced by the new time zone field on the meeting details page. This means that you can always know the time zone the course schedule meeting has been scheduled in, unlike at present.

The curriculum registry items rapid implementation spreadsheet has also been updated to include the time zone column for course schedule meetings.

You should not change any course data until the Update Course Schedule Time Zones has been run. It is advisable that you run this process before opening existing course schedule meetings. After you have updated the Manage Time Zone Settings page and added relevant time zones (step 2), you should immediately run the ‘Update Course Schedule Time Zones’ process before using the application. (Navigation: Tools>Scheduled Processes>Update Course Schedule Time Zones).

It is essential that this process is run before using the environment, otherwise incorrect meeting schedule times will be displayed. Note: If you don’t have course schedule meetings (in any environment) and will be creating course data from new using the Curriculum Registry Items Rapid Implementation Load or manually in the UI from release 21B onwards, you don’t need to run this process. If you have course schedule meetings created prior to the release 21B and have run this process for all courses, you don’t need to run this process again in the future when creating new courses and schedules from the 21B release and beyond. Daylight savings wasn’t previously taken into account when saving the meeting time in UTC in the database. This has now been rectified and is automatically applied when you create new course schedule meeting information. For existing course schedules created prior to release 21B, the ‘Update Course Schedule Time Zones’ process also adjusts for daylight savings where required, when updating the time zone from a null value. This resolves the issue where course schedule meeting times have previously been different by an hour in the storefront. You must test this process in a test environment to ensure that the times and dates of the existing meetings are being displayed as expected in both the course schedule meeting information UI and also on the storefront UI. The dates and times should be the same. If this process is not run incorrect meeting times will be displayed. Note: It is essential that the time zone being updated is the same time zone that was initially used to create the course schedule meetings. If this is not the case, then times and dates won’t be accurate. For example, if the course schedule meetings were originally created in the eastern time zone, and you update them with the pacific time zone, the meeting times will show in pacific time not eastern. It’s advisable that you run the process initially for a small number of courses and schedules using the parameters provided to verify that the times and dates are being updated as expected. After you have verified the data, you update the rest of the courses. Verify that both the course schedule meeting information and the storefront data display the meeting times and dates as expected.

Note: Although this process can be used to update existing time zones this should only be used in exceptional circumstances, as updating time zone information on ‘live’ course schedule meeting times will have an impact on guests and students using the storefront.

Course Meeting Time Zone Addition to the Storefront

The meeting time zone abbreviation, for example EST, is added as a suffix to all pages within the storefront where course schedules are displayed. The time, date, and time zone should be the same in the storefront as it is in the course schedule meeting information page.

Time Zone Display Logic in the Storefront

Authenticated Users

The regional user preference time zone of the user profile is used to display which time zone the course schedule times and dates are displayed in. The regional user preference time zone defaults from the site profile code FND_TIMEZONE as described in step 1. The regional user preference time zone can’t be changed by the user in release 21B, but this functionality will be made available in a future release.

Non-authenticated user

For non-authenticated users such as guests, the time zone is taken from the user machine browser.

Please reference the attached document for a more detailed walk-through (including screenshots).

Contacts

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