Search Results insert_routes_db_items




Overview
Explore in AI Chat

Overview

HRSTRDBI is a seeding and start-up package within the Oracle E-Business Suite HRMS (Human Resources Management System) schema. Its specific business function is to create the initial "start-up data" for database items (DBIs) related to personnel, including the underlying routes and the appropriate contexts in which those routes operate. In Oracle EBS, FastFormula and the associated database item framework depend on a consistent set of metadata held in a family of FF_* tables. HRSTRDBI exists to populate and rebuild this metadata during setup or upgrade activities, rather than to support day-to-day transactional processing.

The package header identifies the historical script as pestrdbi.pkh and notes a series of maintenance revisions between 1993 and 2002, confirming the package's long-standing role as a foundational setup utility. The API is classified as OTHER, reflecting that it is not a general-purpose business API but a controlled utility used by the application during initialization.

Key Procedures and Functions

The documented package exposes seven procedures, all intended for start-up data creation:

  • INSERT_CONTEXT — Creates the contexts associated with personnel database items, establishing the initial context records used by the FastFormula engine.
  • INSERT_ROUTES_DB_ITEMS — Inserts the routes and their corresponding database items, forming the navigation paths through which formula database items are resolved.
  • INSERT_FUNCTIONS — Inserts the function definitions used by formulas and database items, added in the March 1999 revision as noted in the header history.
  • INSERT_FORMULA — Inserts the formula definitions required for the start-up dataset; it was introduced alongside INSERT_FUNCTIONS in the same 1999 revision.
  • INSERT_USER_TABLES — Loads the user table definitions referenced by database items, added in April 1999.
  • INSERT_MONETARY_UNITS — Populates monetary unit data, a routine added in April 2002.
  • CREATE_DBI_STARTUP — The top-level orchestration procedure that invokes the individual insert routines to complete the full start-up data creation process.

No parameter lists are documented, and none should be assumed; the procedures are presented in the package specification as parameterless calls.

Tables Accessed

The package operates against the FastFormula metadata tables through APPS synonyms. The primary targets are FF_CONTEXTS and FF_CONTEXTS_S, which store context definitions and their translations; FF_FUNCTIONS and FF_FUNCTIONS_S for function definitions; FF_FORMULAS_F and FF_FORMULAS_S for formula definitions and translations; FF_ROUTES and FF_ROUTES_S for routes and their translations; and FF_DATABASE_ITEMS for the database item registry. Supporting reference tables include FF_FORMULA_TYPES and FF_FORMULA_TYPES_S, FF_FUNCTION_PARAMETERS, and the usage mapping tables FF_FTYPE_CONTEXT_USAGES, FF_FUNCTION_CONTEXT_USAGES, and FF_ROUTE_CONTEXT_USAGES, all of which tie functions, formula types, and routes to their applicable contexts.

Usage Notes

HRSTRDBI is typically invoked during initial HRMS setup, patch application, or upgrade processes rather than from end-user forms. The package is referenced by zero other packages according to the documented dependency metadata, indicating it sits at the top of the call chain in this area of the application. Custom code should exercise caution: because the procedures insert core FastFormula metadata, calling them outside the intended setup sequence can produce duplicate or conflicting context, route, or function records. Administrators performing rebuilds should invoke CREATE_DBI_STARTUP, which coordinates the individual insert routines in the correct order.