Search Results validate_hr_summary

Overview

APPS.HR_EFC_INFO is a PL/SQL package in Oracle E-Business Suite (12.1.1 and 12.2.2) that supports the Electronic File Converter (EFC) functionality used to migrate and load HR and payroll-related information into Oracle HRMS. The package operates with AUTHID CURRENT_USER and exposes a set of public functions and procedures that orchestrate the batched conversion process. Its central role is to read the single active conversion process recorded in the HR_EFC_ACTIONS table (identified by a status of 'P' for in-progress), resolve the associated business group and currency, chunk the incoming data for processing, and write validated results into the EFC worker and component tables. The package header carries a legacy identifier (hrefcinf.pkh) reflecting its long-standing presence in the HRMS data-conversion layer.

Key Procedures and Functions

The documented interface comprises 35 procedures and functions, of which the following are representative:

• GET_BG — Returns the business_group_id for the currently active conversion process, based on the single HR_EFC_ACTIONS row with status 'P'.
• GET_BG_CURRENCY — Returns the currency associated with a given business group.
• GET_CHUNK — Supports partitioning of input data into processable chunks.
• PROCESS_TABLE — Drives conversion processing over a supplied table structure.
• VALIDATE_CURRENCY_CODE, VALIDATE_TOTAL_WORKERS, VALIDATE_HR_SUMMARY — Perform data validation on currency, worker totals, and HR summary data respectively.
• CONVERT_ABS_INFORMATION, CONVERT_AEI_INFORMATION, CONVERT_NUM_VALUE, CONVERT_PPY_VALUE — Convert source values (absence information, additional earnings information, numeric and per-pay-period values) into target representations.
• GET_ACTION_DETAILS — Retrieves details of the current conversion action.
• INSERT_LINE, ADD_OUTPUT, ADD_HEADER, ADD_AUDIT_ROW — Write output lines, headers, messages, and audit records.
• CHK_MAPPING_EXISTS, FIND_MAP_ID — Determine whether a mapping exists and resolve its identifier.
• INSERT_OR_SELECT_COMP_ROW, INSERT_OR_SELECT_WORKER_ROW — Insert or locate component and worker rows during conversion.

The package also declares global variables (g_efc_message_line, g_efc_error_app, g_efc_error_message) and a currency_null exception used for error signalling. This package is referenced by six other packages within the application.

Tables Accessed

Documented table access proceeds through APPS synonyms. The core EFC tables include HR_EFC_ACTIONS (the driver of the active conversion), HR_EFC_PROCESS_COMPONENTS and its _S shadow table, HR_EFC_WORKERS and _S, HR_EFC_WORKER_AUDITS and _S, and HR_EFC_ROUNDING_ERRORS and _S, which record rounding discrepancies encountered during conversion. PAY_PAYMENT_TYPES is read for payment-type information. HR_API_USER_HOOK_REPORTS is referenced in the API hook context. Metadata-driven operations use ALL_TABLES and ALL_TAB_COLUMNS, while DBMS_LOCK provides concurrency control and DBMS_SQL supports dynamic SQL against the conversion table structure.

Usage Notes

HR_EFC_INFO is invoked during HRMS electronic file conversion runs rather than through direct end-user form interaction. It is typically called from concurrent programs and from other EFC-related packages (the six documented referrers) that manage the overall conversion lifecycle. Customizations that extend EFC normally call these routines to obtain the active business group and currency, validate and convert incoming values, and persist results to the EFC worker and audit tables. Concurrency protection via DBMS_LOCK and the single-row 'P' assumption in HR_EFC_ACTIONS constrain the package to one active conversion at a time.