Search Results ff_functions_s




Overview
Explore in AI Chat

Overview

APPS.PAY_DBI_STARTUP_PKG is a PL/SQL package body in the Oracle E-Business Suite APPS schema that supports the Oracle Payroll "DBI" (Database Items / Business Intelligence) startup and initialization process. It is a standalone utility package, classified as OTHER, and is not referenced by any other database object, indicating that it is invoked by external callers such as concurrent programs, forms, or installation scripts rather than by other PL/SQL packages.

The package depends heavily on the Oracle FastFormula schema objects (the FF_% family of tables) and HR_UTILITY, and its documented dependencies confirm its role in seeding or initializing FastFormula metadata — specifically functions, routes, and their context and parameter definitions — that Payroll uses when processing payroll runs, calculating balances, and exposing database items to FastFormula.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package body:

  • CREATE_DBI_STARTUP — The central procedure that performs the DBI startup logic. Based on its dependencies on FF_FUNCTIONS, FF_ROUTES, FF_FUNCTION_PARAMETERS, and their context usage tables, it is responsible for creating or refreshing the FastFormula functions and routes required for Payroll database item (DBI) processing. It draws on the _S (translation) tables, such as FF_FUNCTIONS_S and FF_ROUTES_S, to populate language-specific function and route names for the environment's installed languages. No parameter list is documented; consult the package source in the ETRM "show dependent code" output for exact parameter signatures before calling it directly.

Tables Accessed

The package references the following tables and views via APPS synonyms:

  • FF_FUNCTIONS / FF_FUNCTIONS_S — FastFormula function definitions and their translated name rows. The package reads and writes these to define the DBI-related functions used by Payroll formulas.
  • FF_FUNCTION_CONTEXT_USAGES / FF_FUNCTION_PARAMETERS — Context usage and parameter definitions for each function, defining which contexts and parameters a DBI function accepts.
  • FF_ROUTES / FF_ROUTES_S — FastFormula route definitions and their translated rows. Routes map database items to functions and are essential to DBI resolution during payroll formula execution.
  • FF_ROUTE_CONTEXT_USAGES / FF_ROUTE_PARAMETERS / FF_ROUTE_PARAMETERS_S — Context and parameter metadata specific to each route, plus translated parameter names.
  • FF_CONTEXTS — The context definitions referenced by function and route context usage records.
  • DUAL — Used for trivial SELECT statements (for example, to validate availability or return constant values during initialization).
  • HR_UTILITY — A shared HRMS utility package used for common lookups and helper operations.

No tables outside the FastFormula and HRMS utility namespace are documented.

Usage Notes

Because PAY_DBI_STARTUP_PKG is not referenced by any other database object, it is intended to be invoked directly by external mechanisms — typically during Oracle Payroll setup, patch application, or post-install configuration, when the DBI FastFormula metadata must be created or refreshed. In Oracle EBS 12.1.1 and 12.2.2 environments, this class of DBI startup routine is generally executed from a Payroll-related concurrent program or from a setup script rather than from a standard form.

When the term ff_functions_s is searched, the results point to the translated function-name table that this package populates. Custom code should not call CREATE_DBI_STARTUP repeatedly in routine processing, since it writes to shared FastFormula metadata; instead, invoke it only when initializing or repairing DBI definitions. Always review the package source via the ETRM dependent-code link and test in a non-production instance before execution.