OTL Tables in Oracle Fusion HCM


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.



Oracle Fusion HCM Training Demo Day 1 Video:

You can find more information about Oracle Fusion HCM Cloud application in this Oracle HCM Cloud Docs Link



Unogeeks is the No.1 Training Institute for Fusion HCM Training. Anyone Disagree? Please drop in a comment

You can check out our Oracle Fusion HCM Training details here Oracle Fusion HCM Training

You can check out our other latest blogs on Oracle Fusion HCM Training in this Oracle Fusion HCM Blogs

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at: info@unogeeks.com

Our Website ➜ https://unogeeks.com

Follow us:

Instagram: https://www.instagram.com/unogeeks

Facebook: https://www.facebook.com/UnogeeksSoftwareTrainingInstitute

Twitter: https://twitter.com/unogeeks


Leave a Reply

Your email address will not be published. Required fields are marked *