How To Update Events In Public Holiday Calendar In HRMS (OTL)?

(Doc ID 2247623.1)

Last updated on MARCH 25, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How to update events in bulk in public holiday calendar?
We are trying to update below mentioned tables:

1. HXT_HOLIDAY_DAYS
2. HXT_HOLIDAY_CALENDARS

These tables are used to keep data for for public holiday events for different countries.
We have more than 100 calendars and each calendar have more than 10 public holidays each year, so we have to update more than 1000 records manually every year.
We are trying to simplify this manual entry process by updating the table through an automated program, but we are avoiding to update the tables directly so looking for any Public API or any other standard procedure recommended by oracle, which can help us in updating the table.

Is there  any API provided by oracle to update the same.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms