Search Results per_ose_rki

Overview

The APPS.PER_OSE_RKI package is a row-level trigger implementation package within the Oracle E-Business Suite (EBS) Human Resources (PER) module. The naming convention _RKI identifies it as a Row-level trigger Kernel Implementation package, which is the standard Oracle EBS architecture for separating row-level trigger logic (defined on the table) from the implementation code (defined in the package body). This separation is a core tenet of the EBS "Seed Data" and "Table Handler" design pattern, where the _RKI package encapsulates complex validation and derivation logic that cannot be expressed declaratively in the table definition itself. In Oracle EBS 12.1.1 and 12.2.2, such _RKI packages are frequently generated or maintained by the Oracle Forms and database trigger generation utilities, and they serve as the exclusive implementation layer for row-level triggers on critical HRMS tables.

Key Procedures and Functions

The ETRM documentation for this object identifies a single documented procedure:

• AFTER_INSERT — This procedure contains the implementation logic for the AFTER INSERT row-level trigger on the associated underlying table (referenced as PER_OSE_INS). Its purpose is to execute supplemental database operations that must occur after a new row is successfully inserted but before the transaction is committed or the statement completes. Typical responsibilities include populating denormalized columns, inserting audit or history rows, propagating data to dependent entities, or invoking additional business rule validations that depend on the newly inserted primary key values. The procedure operates within the context of the triggering statement, meaning any failure propagates back to the original DML operation.

No other procedures or functions are documented in the provided metadata. The exact parameter list is not supplied, and per EBS convention, the trigger on the table invokes this procedure while passing the relevant column values via the trigger's :NEW pseudorecord, either as individual parameters or through a standard trigger context.

Tables Accessed

The ETRM excerpt does not enumerate specific tables referenced by PER_OSE_RKI through APPS synonyms. Based on the reference to PER_OSE_INS and the _RKI naming family, the package is associated with an HRMS table whose name likely begins with PER_OSE — a range of tables in the PER schema used for HRMS entity storage, possibly related to object or setup entities. The AFTER_INSERT procedure may perform additional INSERT or UPDATE operations on related PER tables, and may read from lookup or reference tables to derive values. Because the object is documented only at the package level with one procedure, the precise set of table references cannot be confirmed from the metadata alone.

Usage Notes

PER_OSE_RKI is not intended to be invoked directly by end users, concurrent programs, or custom code. It is a trigger support package that is called automatically by the database trigger defined on its associated table. The dependency information shows that PER_OSE_RKI is referenced by PER_OSE_INS, confirming that the AFTER INSERT trigger dynamically or statically binds to this package's AFTER_INSERT procedure. This package itself references only SYS.STANDARD, indicating a self-contained implementation with no external package dependencies.

When extending or troubleshooting HRMS data operations, developers should be aware that insert operations on the underlying table will fire this package's logic. Disabling or modifying the trigger should be done with caution, as the AFTER_INSERT logic may be essential to maintaining data integrity and denormalized data consistency. Customizations should never modify PER_OSE_RKI directly; instead, they should be applied through supported extension points or by creating separate triggers with distinct names to avoid conflicts during patching and upgrades. In Release 12.2.2 online patching environments, any alteration to this package or its triggers must account for editioning and the AD_ZD utility framework.