Search Results update_shadow_tables

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:

• Installation and ownership: INSERT_OWNERSHIP records application ownership entries; CHECK_TO_INSTALL determines whether installation steps are required; SETUP performs the primary orchestration of the install sequence.
• Data migration and staging: MOVE_TO_SHADOW_TABLES, UPDATE_SHADOW_TABLES, and MOVE_TO_MAIN_TABLES manage the staging workflow that copies and promotes data between shadow tables and the main application tables; INSERT_HISTORY_TABLE records historical snapshots.
• Flexfield and route configuration: CREATE_KEY_FLEXFIELD builds key flexfield definitions; CREATE_LEG_RULE creates legislation rules; CREATE_RUNTYPE establishes payroll run types; CREATE_GEN_UPG_DFN creates generic upgrade definitions; CREATE_ENH_RETRO_SETUP configures enhanced retroactive processing setup.
• Translation maintenance: UPDATE_ELE_CLASS_TL, UPDATE_BAL_TYPE_TL, UPDATE_RUN_TYPE_TL, and UPDATE_BAL_CATEGORIES_TL maintain translated (TL) descriptive text for element classifications, balance types, run types, and balance categories.
• Logging: WRITE_LOG records execution activity for diagnostics and audit purposes.

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.