Search Results hrdpp_create_sit




Overview
Explore in AI Chat

Overview

HRDPP_CREATE_SIT is an Oracle EBS PL/SQL package owned by the APPS schema that supports the HR Data Pump (HRDPP) batch processing infrastructure. The "SIT" suffix refers to a Situation or batch scope construct used during the staging and validation of inbound HR data before it is loaded into the core HR tables. The package serves as a utility layer within the HR Data Pump framework, handling the creation and population of batch-level and line-level staging records, along with the associated translation ("SIT" / language-dependent) rows and descriptive flexfield or key flexfield user key entries. It is classified in ETRM as an OTHER API, indicating it is an internal, non-public interface rather than a supported external API.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions. Their names are terse, reflecting an internal coding convention, and each plays a specific role in materializing batch data:

  • DC (Data Create): Creates the primary batch data records within the Data Pump staging tables, establishing the header or batch context for the incoming data set.
  • D (Delete): Removes staging records, typically used to clean up prior or failed batch loads before reprocessing.
  • N (Name/Non-translated): Populates the non-translated (base language) attribute values on the batch staging rows.
  • DD (Data Details / Data Delete): Operates on detailed batch line records, either creating detail rows or performing detail-level maintenance within the Data Pump staging structure.
  • ND (Name Detail / Non-translated Detail): Populates non-translated detail-level attribute values on batch line records.
  • INSERT_BATCH_LINES: Inserts batch line records into the HR_PUMP_BATCH_LINES and HR_PUMP_BATCH_LINES_S tables, forming the core of the line-level data pump process.
  • CALL: Serves as the package's entry point or dispatcher, orchestrating invocation of the above procedures as part of a larger Data Pump workflow.

Tables Accessed

The package reads and writes several HR Data Pump staging tables, accessed via APPS synonyms:

  • HR_PUMP_BATCH_EXCEPTIONS: Stores exceptions and error conditions arising during batch line processing.
  • HR_PUMP_BATCH_LINES: The primary staging table holding individual data lines of a pump batch.
  • HR_PUMP_BATCH_LINES_S: The language-dependent (_S) translation table for batch lines.
  • HR_PUMP_BATCH_LINE_USER_KEYS: Holds user-defined key flexfield values associated with batch lines.
  • HR_PUMP_BATCH_LINE_USER_KEYS_S: The language-dependent translation table for the user key records.

Together these tables constitute the Data Pump staging area that precedes validation and final load into HR.

Usage Notes

HRDPP_CREATE_SIT is an internal, unpublished package and is referenced by zero other documented packages in ETRM, indicating it is invoked indirectly through the broader HR Data Pump concurrent program flow or Data Pump setup forms. Clients should not call it directly from custom code, as it lacks a supported public API contract. In Oracle EBS 12.1.1 and 12.2.2, HR Data Pump operations are typically driven by concurrent programs that stage inbound data into the HR_PUMP_BATCH_* tables; this package is one of the worker components performing that staging. Modification of its behavior is unsupported, and direct manipulation of the staging tables it populates is discouraged outside the Data Pump framework.