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.
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
Select a File Delimiter for the import file: Comma or Tab. Comma is selected by default.