Search Results pay_ip_startup_util




Overview
Explore in AI Chat

Overview

PAY_IP_STARTUP_UTIL is a utility package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as a UTIL (utility) API. Its role is to support the installation, upgrade, and installation-tracking operations associated with the Oracle Payroll "IP" (install/upgrade process) startup routines. In practice, the package orchestrates a series of install-time and upgrade-time activities: it seeds ownership records, creates and maintains key flexfield structures, populates shadow staging tables prior to committing data to production tables, and configures run types, balance types, balance categories, element classifications, and enhanced retroactive setup definitions. Because these operations touch both Oracle Payroll core objects and Oracle Application Object Library (FND) configuration objects such as menus, functions, and flexfields, the package is best understood as a controlled bootstrap utility used when installing or upgrading the payroll product family rather than as a runtime business API.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. Their purposes, grouped by functional area, are as follows:

No parameter lists are published in the ETRM metadata; the preceding descriptions state purpose only.

Tables Accessed

The package reads and writes through APPS synonyms across several schemas. Oracle Application Object Library tables underpin configuration and menu setup: FND_APPLICATION, FND_FORM_FUNCTIONS, FND_MENUS, FND_MENU_ENTRIES, FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_STRUCTURES, FND_PRODUCT_INSTALLATIONS, and FND_TERRITORIES_TL. Flexfield routing is handled through FF_ROUTES, FF_ROUTE_CONTEXT_USAGES, and FF_ROUTE_PARAMETERS. Ownership and legislation context is drawn from HR_APPLICATION_OWNERSHIPS, HR_S_APPLICATION_OWNERSHIPS, HR_LEGISLATION_INSTALLATIONS, and HR_STU_EXCEPTIONS. Together these accesses explain the package's install/upgrade focus: it must verify what is installed (FND_PRODUCT_INSTALLATIONS), establish ownership and legislation applicability, and configure flexfields, menus, and routes before payroll setup records can function.

Usage Notes

PAY_IP_STARTUP_UTIL is referenced by only one other package and is not intended for direct invocation from application forms or standard concurrent program submissions. It is typically exercised indirectly during product installation, patching, or upgrade cycles, or by other Payroll startup packages that call it as part of their own orchestration. Oracle EBS 12.1.1 and 12.2.2 environments treat it as an internal utility whose procedures should be invoked only through the sanctioned installation or upgrade driver, not from custom code. The INSERT_OWNERSHIP, CHECK_TO_INSTALL, MOVE_TO_SHADOW_TABLES, MOVE_TO_MAIN_TABLES, and SETUP procedures in particular carry sequencing dependencies and staging-table state assumptions; invoking them out of order risks inconsistent payroll configuration data.