Creating Holiday Rules

To create holiday rules:

  1. In System Settings, select Holiday Rules.
  2. Click Actions, and then New.
  3. Enter:
    • Holiday Rule ID

      This is the attribute that will uniquely identify the record for LCM purposes. Holiday Rule ID is mandatory and must be unique.

    • Name

      The name of the holiday rule is mandatory and can be up to 50 characters. Uniqueness is not required.

    • Year

      The Year attribute behaves as a filter option. Users need not select a value for this attribute. If they do, then the table should be filtered to display the dates associated with the selected year.

  4. To name a holiday, in the Holiday section, click ImportImport button to import the list of holidays.
  5. 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.

  6. 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

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