Importing Holiday Dates

You can import dates into an existing holiday rule.

To import holiday dates:

1. In Account Reconciliation, select Manage, and then System Settings. 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:

     "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. It 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. Click Import.