Search Results populate_cost_distributions_cp
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:
- PERFORM_DATA_EXTRACT / PERFORM_DATA_EXTRACT_CP / SUBMIT_DATA_EXTRACT — Entry points to execute the extract; the CP-suffixed variants are structured as concurrent-program-callable routines, while SUBMIT_DATA_EXTRACT submits the extract request.
- PRE_CREATE_EXTRACT_CP, POST_EXTRACT_CP, VALIDATE_EXTRACT_CP — Pre-processing, post-processing, and validation stages of the extract flow.
- ASSIGN_POSITION_DEFAULTS_CP, COPY_ATTRIBUTES_CP, COPY_ELEMENTS_CP, COPY_POSITION_SETS_CP, COPY_DEFAULT_RULES_CP — Copy and defaulting routines that propagate attributes, elements, position sets, and default rules for the extraction.
- POPULATE_POSITIONS_CP, POPULATE_ELEMENTS_CP, POPULATE_EMPLOYEES_CP, POPULATE_ATTRIBUTES_CP, POPULATE_COST_DISTRIBUTIONS_CP, POPULATE_POS_ASSIGNMENTS_CP — Population routines that load staged records into the corresponding PSB interface tables.
- INTERFACE_PURGE — Removes previously staged interface data prior to or following an extraction.
- GET_DEBUG, INSERT_ORGANIZATIONS — Utility routines for debugging and organization-level setup.
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.