Importing Holiday Dates

You can import dates into a holiday rule.

To import holiday dates:

1. In System Settings, select Holiday Rules.
2. Create or select a holiday rule.
3. On the bottom section of Holiday Rules, select Actions, and then Import.

   • Enter the file name, or click Browse to navigate to the CSV import file.

     Example of a holiday date import format:

     "Date","Name"
     "Jan 1, 2014","New Years Day"
     "May 26, 2014","Memorial Day"

   • For Import Type, click one:

     • Replace—Replaces the holiday dates with the holiday dates in the file that you are importing. Does not affect other units that are not specified in the import file.

     • Replace All—Imports a new set of holiday dates that replaces the existing holiday dates. Use this option to replace a unit in one system with an updated definition from another system. Holiday dates that are not specified in the import file are deleted.

4. Date Format

   Note:

   This feature is available only in 11.1.2.4.100 (patch 20307212). For information about new features and updating to release 11.1.2.4.100, see My Oracle Support https://support.oracle.com

   Select a Date Format from the drop down list of allowed date formats. Date formats are not translated. By default, the date format is set to the locale date format of the exported file location.

   For example:

   • MM/dd/yyyy

   • dd/MM/yyyy

   • dd-MMM-yy

   • MMM d, yyyy

5. Select a File Delimiter for the import file: Comma or Tab. Comma is selected by default.
6. Click Import.