Search Results psb_wrhr_extract_process




Overview
Explore in AI Chat

Overview

PSB_WRHR_EXTRACT_PROCESS is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Workforce Human Resources (WRHR) extract functionality used by Oracle Public Sector/HRMS integrations. Its principal business function is to extract HR and payroll-related information from EBS source tables and stage it into the PSB interface tables, where it is subsequently validated and made available to downstream processes or external systems. The package is classified as an API of type OTHER within ETRM and is a VALID, compiled object on 12.1.1 and 12.2.2. It depends on FND_API, the Oracle EBS applications API utility package, indicating the extraction logic follows standard EBS API conventions including the use of the standard concurrent processing pattern. The package contains no references to it from other PL/SQL packages, so it is intended primarily to be invoked directly through concurrent programs rather than as a subordinate routine.

Key Procedures and Functions

The package exposes 22 documented procedures and functions covering the extract lifecycle:

Tables Accessed

The package reads and writes a set of PSB interface and control tables via APPS synonyms. Principal interface tables include PSB_POSITIONS_I, PSB_ELEMENTS_I (referenced through the entity set tables), PSB_EMPLOYEES_I, PSB_EMPLOYEE_ASSIGNMENTS_I, PSB_ATTRIBUTE_VALUES_I, PSB_SALARY_I, and PSB_COST_DISTRIBUTIONS_I. Control and configuration tables include PSB_DATA_EXTRACTS, PSB_DATA_EXTRACT_ORGS, PSB_ENTITY_SET, PSB_ENTITY_SET_S, PSB_ERROR_MESSAGES, and PSB_REENTRANT_PROCESS_STATUS. DUAL is used for scalar lookups. These tables hold the staged extract output, organization scoping, error logging, and process status used across the population and validation routines.

Usage Notes

PSB_WRHR_EXTRACT_PROCESS is typically invoked through the Oracle EBS concurrent manager, where the CP-suffixed procedures are registered as concurrent program execution routines. The extract runs in stages: pre-create, population of positions, elements, employees, attributes, assignments, and cost distributions, followed by validation and post-processing. INTERFACE_PURGE is normally invoked before a fresh extract to clear residual rows. Because the package is not referenced by any other PL/SQL package, custom code should call the documented CP entry points rather than rely on internal routines. Error conditions are recorded in PSB_ERROR_MESSAGES, and process control information is maintained in PSB_REENTRANT_PROCESS_STATUS, allowing the extract to be monitored and restarted. On both 12.1.1 and 12.2.2 the object remains VALID and compiles against the same dependency set.