Oracle Time and Labor formulas access HCM data through Database Items (DBIs). DBIs are predefined shortcuts that retrieve specific information from application database tables. Each formula type (e.g., Time Entry Rule, Time Calculation Rule) has a set of registered DBIs that it can use. These DBIs are not limited to the time card object; they can fetch a wide range of worker data, such as assignment details, grade, location, and payroll information, directly from the HCM database tables. This allows formulas to perform complex validations and calculations based on the worker's broader HCM profile, not just the data entered on the time card.

B: This is incorrect because formulas can directly access HCM data via DBIs. It is not mandatory to first configure and store all external data on the time card layout.

C: This is incorrect. While formulas can call subroutines for reusable logic, this is not the required mechanism for accessing HCM data. The primary method is using Database Items (DBIs).

D: This is incorrect. There is no such mandatory AP suffix naming convention for formulas to enable access to external HCM data. Formula functionality is determined by its type, not its name.

1. Oracle Cloud HCM: Using Fast Formulas (Release 23D)

Chapter 3: Database Items

Section: Database Items in Formulas.

This section explains the fundamental role of DBIs: "A database item is a mechanism for the formula to retrieve a value from a database table... When the formula runs

it replaces the database item with its value from the database." This confirms that formulas access the database directly via DBIs.

2. Oracle Cloud HCM: Implementing Time and Labor (Release 23D)

Chapter 11: Time and Labor Fast Formulas

Section: How You Use Database Items in Time and Labor Formulas.

This section explicitly states

"You can use database items in your time and labor formulas to retrieve information that isn't available from the time card entry

such as a person's bargaining unit

grade

or location." This directly supports answer A and refutes the limitation described in answer B.

3. Oracle Cloud HCM: Implementing Time and Labor (Release 23D)

Chapter 11: Time and Labor Fast Formulas

Section: Formula Performance Best Practices.

This section advises on the efficient use of DBIs

stating

"Use database items that retrieve a set of data rather than single values." This implicitly confirms that direct DBI access to a wide range of data is the standard

intended mechanism.