My Oracle Support Banner

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

Last updated on MAY 04, 2022

Applies to:

Oracle Fusion Student Management Cloud Service
Information in this document applies to any platform.

Details

 

Purpose statement

This document provides an overview of features and enhancements included in release 21B. It is intended solely to help you assess the business benefits of upgrading to 21B and to plan your I.T. projects.

Disclaimer

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle software license and service agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle. Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

 

Note: In the images or examples included in this document regarding: user details, company names, addresses, emails, and/or telephone numbers represent a fictitious sample of data (based upon made up data used in a demo environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

 

 

 

 

 

 

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:

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Disclaimer
Actions
 Background
 Time Zone Feature Implementation Steps
 Step 1 – Configure FND_TIMEZONE Site Profile Code
 Step 2 – Configure Manage Time Zones Settings
 Step 3 – Update Course Schedule Time Zones
 Course Meeting Time Zone Addition to the Storefront
 Time Zone Display Logic in the Storefront
Contacts

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