Search Results hr_snp_ins




Overview
Explore in AI Chat

Overview

HR_SNP_INS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under the ETRM as an "OTHER" API type rather than a public or private interface. Its name follows the Oracle Human Resources snapshot naming convention, where the _SNP_ token denotes snapshot processing and _INS denotes an insert-oriented operation. The package therefore exists to insert snapshot rows into the HR transaction snapshot tables, capturing point-in-time representations of HR transactional data so that downstream processes, reporting, and reconciliation logic can compare current and historical states.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. It depends on HR_SNP_SHD, the shadow/staging component of the snapshot architecture, and on the SYS STANDARD package. In turn, HR_SNP_INS is referenced by itself and by HR_TRANSACTION_SNAPSHOT_SWI, the snapshot worker/interface package that orchestrates snapshot processing. This dependency chain confirms that HR_SNP_INS is an internal helper invoked by the snapshot engine rather than a standalone entry point.

Key Procedures and Functions

  • SET_BASE_KEY_VALUE — Establishes the base key value used during snapshot insertion. In snapshot designs, a base key identifies the source row or driving entity so that related snapshot records can be correlated consistently. This procedure sets that key prior to the insert operation, ensuring each snapshot row carries the correct identifying value.
  • INS — Performs the core insert of snapshot data. It writes the captured HR transaction snapshot row(s) into the underlying snapshot tables, using the key established by SET_BASE_KEY_VALUE. This is the primary data-manipulation routine of the package and the reason HR_TRANSACTION_SNAPSHOT_SWI calls into it.

Only three documented procedures exist in total, of which the two above are named explicitly. No parameter lists are published in the ETRM metadata, and none are asserted here. The remaining third entry is not itemized in the supplied documentation.

Tables Accessed

The package reads and writes two documented tables accessed through APPS synonyms:

  • HR_TRANSACTION_SNAPSHOT — the primary snapshot table holding captured HR transaction records. HR_SNP_INS inserts records here through its INS procedure.
  • HR_TRANSACTION_SNAPSHOT_S — the corresponding shadow table. Oracle HR snapshot architecture pairs a base table with an _S shadow table to maintain the snapshot copy alongside the live data, and the package's dependency on HR_SNP_SHD aligns with this shadow-table pattern.

Together these tables store the snapshot state that later comparison, audit, or correction processes consume.

Usage Notes

HR_SNP_INS is an internal implementation package and should not be invoked directly by custom code. It is called by HR_TRANSACTION_SNAPSHOT_SWI, which drives snapshot creation, typically from HR concurrent programs or from transactional processing that triggers a snapshot of HR transaction data. Its procedures are designed to run within the transaction initiated by the calling snapshot worker, using SET_BASE_KEY_VALUE to seed the key and INS to persist the rows.

Because the package is classified as OTHER rather than as a supported public API, Oracle does not guarantee its signature across releases or patches. Customizations should integrate at the documented snapshot interface level (HR_TRANSACTION_SNAPSHOT_SWI or the relevant concurrent program) rather than calling HR_SNP_INS directly. Where troubleshooting is required, dependency analysis on HR_SNP_SHD and STANDARD confirms the package's position in the snapshot stack.