Search Results create_technical_summary




Overview
Explore in AI Chat

Overview

PER_RI_CONFIG_MAIN is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms the control layer of the Oracle Human Resources "Rapid Implementation" (RI) configuration framework. Its role is to orchestrate the extraction, staging, and loading of enterprise-level HR configuration data between Oracle EBS environments — typically from a source system into a target system, or between a reference environment and a production instance. The package coordinates the activities of the related components PER_RI_CONFIG_DATAPUMP_ENTITY, PER_RI_CONFIG_FND_DEF_ENTITY, PER_RI_CONFIG_FND_HR_ENTITY, and PER_RI_CONFIG_UTILITIES, which together implement a configuration migration utility. Rather than performing low-level table manipulation itself, PER_RI_CONFIG_MAIN drives the higher-level workflow, establishing the processing context and invoking the entity-specific loaders that read from or write to the HR configuration staging tables.

Key Procedures and Functions

  • CREATE_TECHNICAL_SUMMARY — Produces a technical summary of the configuration load run, consolidating the results generated during the load process into a reportable or auditable form. This supports diagnostics and validation of what configuration objects were processed.
  • LOAD_ENTERPRISE_CONFIGURATION — The principal entry point for executing an enterprise configuration load. It drives the loading of configuration data into the target environment, coordinating the entity handlers and the underlying DataPump-based transfer utilities.

The package is documented with a total of two procedures/functions. No parameter signatures are published in the available metadata, and none should be assumed without inspecting the package specification directly.

Tables Accessed

  • HR_API_MODULES — Business group and module configuration records that define which HR API modules are active; consulted to determine the applicable configuration scope.
  • HR_PUMP_BATCH_HEADERS — Header records for each DataPump batch, providing the batch context and status for a configuration load run.
  • HR_PUMP_BATCH_LINES — Individual staging lines within a batch, representing the configuration rows being migrated.
  • HR_PUMP_BATCH_LINE_USER_KEYS — User-key definitions attached to batch lines, used to identify and match records during load.
  • PER_ENT_SECURITY_GROUPS — Enterprise security group definitions required when configuration data is security-group dependent.
  • PER_RI_CONFIG_INFORMATION — The repository of Rapid Implementation configuration metadata and control information that governs the utility.
  • PLITBLM — A standard APPS PL/SQL table (index-by-table) utility object used internally for collection handling.

Usage Notes

PER_RI_CONFIG_MAIN is a server-side utility package invoked by the Oracle HR Rapid Implementation configuration tools rather than by direct end-user action buried in a form. In practice it is driven through the RI configuration concurrent programs and the associated set-up pages, with PER_RI_CONFIG_UTILITIES and the entity packages (PER_RI_CONFIG_DATAPUMP_ENTITY, PER_RI_CONFIG_FND_DEF_ENTITY, PER_RI_CONFIG_FND_HR_ENTITY) calling into it during coordinated configuration migration. Because the object is documented as VALID and APPS-owned, it should be treated as a supported internal API: custom code, integration scripts, or runbooks that need to trigger an enterprise configuration load may call LOAD_ENTERPRISE_CONFIGURATION, and reporting or audit processes may call CREATE_TECHNICAL_SUMMARY after a load. Direct DML against the HR_PUMP_BATCH_* and PER_RI_CONFIG_INFORMATION staging tables is not recommended; the package should be used as the controlled interface. Clients should verify the package specification in their specific patch level, as signatures may vary between 12.1.1 and 12.2.2 and across HRMS family pack rollups.