Search Results create_dbi_startup

Overview

APPS.PAY_DBI_STARTUP_PKG is an Oracle E-Business Suite PL/SQL package that belongs to the Oracle Payroll (PAY) application schema. It is classified as an "OTHER" API in the ETRM metadata for EBS 12.1.1 and 12.2.2, meaning it is not published as a supported public interface but rather serves an internal startup/bootstrap role. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the definer, which is consistent with its role as a seed-data loader invoked during environment setup.

The historical header comment, sourced from pystrdbi.pkh, states that the package exists to create "the start up data for database items, namely the routes and the appropriate contexts." In Oracle Payroll and FastFormula terminology, "database items" (DBIs) are the named data elements exposed to formulas. Routes and contexts define how those database items are resolved at runtime. This package therefore populates the foundational routing and context metadata that the FastFormula engine depends upon. The package was originally created in April 1993 and renamed from an earlier package to pay_dbi_startup_pkg in October 1994.

Key Procedures and Functions

The package exposes a single documented procedure:

• CREATE_DBI_STARTUP — The sole entry point. According to the source comment, it is "called from the main start up file" and is responsible for creating the startup data required for database items, specifically the routes and their associated contexts. No parameter list is documented; the procedure is defined without arguments in the package specification, indicating it operates as a self-contained loader that reads and writes the FastFormula dictionary tables directly.

No functions are documented in this package. The absence of other procedures confirms its narrow, single-purpose design.

Tables Accessed

The documented table references, resolved through APPS synonyms, are all FastFormula (FF) dictionary objects:

• FF_CONTEXTS — Stores context definitions used to qualify routes.
• FF_FUNCTIONS and FF_FUNCTIONS_S — Define and hold the translatable/base records for formula functions, including the database item functions this startup data supports.
• FF_FUNCTION_CONTEXT_USAGES — Links functions to the contexts in which they are valid.
• FF_FUNCTION_PARAMETERS — Holds parameter definitions for those functions.
• FF_ROUTES and FF_ROUTES_S — Define routing information for database items, with the _S table storing the underlying single-language or base rows.
• FF_ROUTE_CONTEXT_USAGES — Associates routes with their applicable contexts.
• FF_ROUTE_PARAMETERS and FF_ROUTE_PARAMETERS_S — Store parameter definitions for routes.
• DUAL — Used for singleton selects and control-flow queries common in PL/SQL initialization logic.

Collectively these tables form the metadata backbone that maps formula database items to their underlying data sources at runtime.

Usage Notes

PAY_DBI_STARTUP_PKG is not a routine application API. It is an internal bootstrap utility invoked during installation, upgrade, or environment initialization of the Payroll and FastFormula components. The comment "called from the main start up file" indicates it is triggered programmatically by an Oracle-supplied startup driver rather than through a form or concurrent program. It is not referenced by any other documented package (0 dependents), reinforcing its role as a lower-level seed loader. Custom code should generally not invoke CREATE_DBI_STARTUP directly; doing so outside the prescribed startup sequence risks inserting duplicate or inconsistent route and context rows. Developers requiring insight into Payroll database item setup should treat this package as reference material for understanding how DBI routing metadata is originally seeded in EBS 12.1.1 and 12.2.2.