Search Results per_ri_config_import_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_RI_CONFIG_IMPORT_PKG is a PL/SQL package that resides in the APPS schema and forms part of the Oracle Human Resources (HR) configuration infrastructure within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to load and import configuration metadata that governs how the product's "responsive" or regulatory-information style interfaces behave, populating the underlying PER_RI_CONFIG tables from external or staged configuration definitions. The package is classified as OTHER in the ETRM registry, meaning it is not a formally published open API but an internal utility used by Oracle's own configuration and import processes. The package is documented as VALID and exposes both a package specification and a package body, with its only external dependency being the SYS.STANDARD package, confirming that it relies predominantly on native PL/SQL constructs rather than on other application APIs.

Key Procedures and Functions

Three documented program units are exposed by the package:

  • LOAD_CONFIGURATION — Serves as the primary entry point for importing configuration definitions. It orchestrates the loading of a complete configuration set, typically driving the population of the configuration header records that identify and describe a given setup.
  • LOAD_CONFIG_INFORMATION — Loads the detailed configuration information associated with a configuration, handling the finer-grained attribute or parameter rows that describe individual configuration elements.
  • LOAD_CONFIG_LOCATION — Loads configuration location data, mapping configurations to the specific locations or contexts in which they apply.

No parameter lists are documented in the ETRM metadata, and none are inferred here; the callable signatures should be reviewed in the package specification within the database before invocation.

Tables Accessed

The package operates against three application tables, all referenced through APPS synonyms:

  • PER_RI_CONFIGURATIONS — The header table holding top-level configuration definitions; LOAD_CONFIGURATION writes to and reads from this table.
  • PER_RI_CONFIG_INFORMATION — Stores the detailed attribute or information rows belonging to a configuration; populated by LOAD_CONFIG_INFORMATION.
  • PER_RI_CONFIG_LOCATIONS — Stores the location-level mapping of configurations; populated by LOAD_CONFIG_LOCATION.

These tables collectively provide the persistent store for imported HR configuration data, and the three procedures correspond directly to the three tables.

Usage Notes

Because PER_RI_CONFIG_IMPORT_PKG is not a published API and is referenced by zero other packages, it is not intended for general application-level consumption. It is most likely invoked from configuration-loading routines, installation or patching scripts, or a dedicated concurrent program used by Oracle support or implementation teams to seed and maintain HR configuration data. In practice it may be called directly from custom migration or setup scripts when an implementation needs to bulk-load configuration records. Developers should exercise caution: the package writes directly to configuration base tables without the validation and business-rule enforcement that published APIs provide, so use should be limited to controlled setup and migration scenarios, and testing should be performed in a non-production environment first. As with any APPS-owned object, customization or direct calls should be avoided in favour of supported interfaces whenever one exists.