OTL Tables in Oracle Fusion HCM

In Oracle Fusion HCM, the Oracle Time and Labor (OTL) module manages employee work hours, overtime, and time-off requests. The data related to OTL is stored in various database tables. Below are some of the key tables that store OTL-related information:

1. HXC_TIME_ENTRY_TYPES: This table stores information about different types of time entries, such as regular time, overtime, sick leave, etc.
2. HXC_TIME_ENTRY: This table holds individual time entry records with details like the person’s ID, date, start and end times, time code, hours worked, and other related information.
3. HXC_TIME_PERIODS: This table stores information about the time periods for which time entries are recorded, like pay periods or custom-defined time periods.
4. HXC_ASSIGNMENT_SCHEDULES: This table contains data about the schedules to which employees are assigned. It includes information about shifts, work hours, and other schedule-related details.
5. PER_ALL_PEOPLE_F: While not exclusive to OTL, this table is used to store general information about people (employees) in the organization. It’s often used for joins to associate time entry records with employee details.
6. HXC_ASSIGNMENT_TO_TIME_ENTRY: This table links assignments (job roles, positions, etc.) to time entry records.

Please note that Oracle Fusion HCM’s database schema and table names might evolve with different versions and updates. It’s important to refer to the documentation and data dictionary for the specific version of Oracle Fusion HCM you’re using to ensure accurate information.

While querying these tables directly is an option, Oracle Fusion HCM also provides reporting and analytics tools, such as Oracle Transactional Business Intelligence (OTBI), which offer more user-friendly ways to extract and analyze data, including OTL-related information. When working with database queries, ensure you have a thorough understanding of the schema, apply appropriate filtering conditions, and have the necessary permissions to access the data.