Search Results pay_kr_report_pkg




Overview
Explore in AI Chat

Overview

PAY_KR_REPORT_PKG is an Oracle EBS Payroll (PAY) package body owned by the APPS schema that supports statutory reporting for the Korea (KR) localization. The package is classified under the ETRM repository as an OTHER API, meaning it is not a formally published public API but is nonetheless a widely referenced server-side component. It supplies the data-extraction and formatting logic that underpins Korean payroll reporting and year-end regulatory deliverables, where values such as cumulative taxable earnings, deductions, and prior-period adjustments must be resolved from Oracle Payroll balance and run-result structures. The package is documented as VALID and, per the ETRM metadata, is referenced by twenty other database objects, confirming its role as a shared foundation for Korean payroll reporting logic rather than a standalone executable. Although the available documentation presents only limited procedural detail, the documented signatures make clear that the package provides a set of value-retrieval utilities for balances, database items, run results, and archived payroll data.

Key Procedures and Functions

The documented interface comprises 22 procedures and functions. The following are the documented entry points:

Tables Accessed

The package reads payroll data primarily through APPS synonyms. Balance and definition data are drawn from PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_FEEDS_F, and PAY_DEFINED_BALANCES. Element and input value data come from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F. Run-level data is sourced from PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_RUN_TYPES_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ACTION_INTERLOCKS. FastFormula and archive metadata are read from FF_USER_ENTITIES, FF_DATABASE_ITEMS, and FF_ARCHIVE_ITEMS, while FND_SESSIONS, FND_DATE, FND_NUMBER, HR_API, HR_UTILITY, PAY_BALANCE_PKG, and PER_BUSINESS_GROUPS_PERF provide session, conversion, and business-group context. The documented dependency list confirms no write targets, characterizing the package as a read-oriented reporting utility.

Usage Notes

PAY_KR_REPORT_PKG is typically invoked indirectly. Korean statutory reports and year-end settlement extracts are implemented as concurrent programs or report definitions that call these functions to resolve balance amounts, run-result values, and separation details at runtime. Because the ETRM classification is OTHER rather than PUBLIC, the entry points are not covered by Oracle's published API compatibility guarantees, and custom code should treat them as internal. The heavy dependence on FastFormula entities and PAY_BALANCE_PKG reinforces that the package must execute within a properly initialized payroll session with valid business group and session context. Its twenty downstream references indicate that any modification carries broad impact across Korean payroll reporting, so changes should be validated against all dependent report definitions in both 12.1.1 and 12.2.2 environments.