Search Results per_ri_configuration_swi




Overview
Explore in AI Chat

Overview

PER_RI_CONFIGURATION_SWI is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Human Resources (PER) product family and is classified within the ETRM repository as an "OTHER" API type. The suffix "SWI" conventionally denotes a "Server-Wide Implementation" or internal service-layer package, indicating that the package exposes lower-level configuration management logic that is consumed by other HR setup components rather than being published as a public, user-facing API.

The package is responsible for managing configuration records that support Oracle HRMS regulatory and information (RI) reporting and setup infrastructure. In practice, it provides the programmatic creation, maintenance, and removal of configuration entries that control how HR regulatory reporting functionality behaves for a given business group or legislative context. The package is marked VALID in the ETRM documentation, and its dependency footprint is deliberately narrow: it references only APPS.HR_API (the standard HR error-handling and utility API) and SYS.STANDARD. It is not referenced by any other documented package, which confirms its role as a terminal service component invoked directly by forms, concurrent processes, or custom extensions rather than by peer APIs.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents three procedures on this package:

  • CREATE_CONFIGURATION — Inserts a new configuration record. This procedure is the entry point for establishing a configuration for the target regulatory or reporting context, performing validation and applying the prerequisite defaults before the record is persisted.
  • UPDATE_CONFIGURATION — Modifies an existing configuration record. It is used when attributes of an already-established configuration must be changed without recreating it, preserving the identity of the original setup.
  • DELETE_CONFIGURATION — Removes a configuration record. Invoked when a configuration is retired or superseded, subject to the integrity constraints enforced by the HR schema.

All three procedures rely on HR_API for consistent error reporting, message stack handling, and standard validation semantics. No parameter lists are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

The ETRM documentation for this object does not enumerate specific base tables accessed through APPS synonyms. This is consistent with the package's classification as an internal service component: table access is likely encapsulated behind the package body and may be routed through other HR setup entities. What the metadata does confirm is that the only external unit referenced by the package is APPS.HR_API, which is used for error and message handling rather than data retrieval. Because no table dependencies are documented, integration reviews should treat the data footprint as opaque and verify actual table access by inspecting the package body in the target instance.

Usage Notes

PER_RI_CONFIGURATION_SWI is not a public API and does not appear in the list of packages referenced by other documented APIs. It is therefore invoked either from Oracle HRMS setup forms, from concurrent programs that seed or migrate configuration data, or from custom PL/SQL that deliberately targets the internal service layer. Because it depends on HR_API, callers should have a valid HR session context — including business group and effective date — in place before invocation, and should expect standard HR_API error propagation. Custom code that calls this package directly should be treated as an unsupported extension, since the package is subject to change without notice in Oracle HRMS patches and upgrades. For release-specific behavior, the package body should be reviewed in the actual 12.1.1 or 12.2.2 instance.