Search Results execute_error

Overview

FFDBITEM is an internal Oracle FastFormula PL/SQL package owned by APPS that provides utility routines for accessing database item SQL definitions and resolving their runtime values within Oracle E-Business Suite release 12.1.1 and 12.2.2. Database items are named tokens (for example, EMPLOYEE_NUMBER or PAY_RATE) that may be embedded inside FastFormula expressions. When the FastFormula engine encounters such a token it must translate the token into the underlying SQL statement stored in the data dictionary, bind the correct context and route parameter values, execute the query, and return a typed value. FFDBITEM encapsulates these lookup and execution mechanics so that the formula compiler and runtime engine do not have to duplicate that logic. The package is classified as OTHER in the ETRM repository, indicating it is an internal support library rather than a published API, and it is referenced by zero other documented packages.

Key Procedures and Functions

The ETRM metadata documents two public program units, both oriented toward resolving database item metadata and values:

• GET_DBITEM_INFO — Returns descriptive information about a database item, such as its data type, associated context usages, and the SQL or route definition stored in the FastFormula data dictionary. It is the metadata accessor used before a value can be queried.
• GET_DBITEM_VALUE — Resolves and returns the runtime value of a database item for a given user entity. This routine invokes the stored SQL through native dynamic SQL and applies the appropriate context filter so that the returned value corresponds to the correct assignment, organization, or business group.

The package body additionally contains private code, including execute_error, which sets an HR message name and three message tokens through HR_UTILITY and raises the associated exception, and process_route_parameters, which substitutes route parameter values for the user entity being processed. These private routines support error reporting and parameter replacement for route-driven database items and are not part of the documented public interface.

Tables Accessed

FFDBITEM reads from the core FastFormula dictionary tables through APPS synonyms:

• FF_DATABASE_ITEMS — stores the database item definitions and their SQL text.
• FF_CONTEXTS, FF_FTYPE_CONTEXT_USAGES, FF_ROUTE_CONTEXT_USAGES — define which contexts a formula type or route requires and how the database item is scoped.
• FF_ROUTES, FF_ROUTE_PARAMETERS, FF_ROUTE_PARAMETER_VALUES — supply route definitions and the parameter values substituted into database item SQL.
• FF_USER_ENTITIES — identifies the user entity (person, assignment, or organization) for which values are resolved.
• DBMS_SQL — the Oracle-supplied dynamic SQL package used to parse, bind, execute, and fetch from the generated database item query.

Usage Notes

FFDBITEM is an internal dependency of the FastFormula engine rather than a customer-facing API. It is normally invoked indirectly whenever FastFormula is executed, including from the FastFormula form, from formula-enabled concurrent programs such as payroll and benefits processes, and from any custom PL/SQL that calls the standard FastFormula evaluation entry points. Because the package is not documented as a supported public interface, direct calls from custom code are discouraged; customizations should instead use the supported FastFormula APIs. When the internal execute_error logic is triggered, the resulting error surfaces as an HR message (application 802) with tokens 1, 2, and 3 populated from the failing database item or route context. In 12.2.2 online patching environments, the package executes under the APPS edition and its dictionary reads depend on the editioned FastFormula tables, so care should be taken when troubleshooting errors during an active patching cycle.