Search Results get_bal_reporting_name

Overview

PAY_AC_UTILITY is an Oracle EBS HRMS (Payroll) utility package owned by the APPS schema and defined with AUTHID CURRENT_USER. It provides shared lookup and translation services used throughout the Oracle Payroll balance architecture, including balance definition resolution, balance name translation, and reporting name retrieval. The package is classified as OTHER within the ETRM API registry and is a low-level dependency of a large portion of the Payroll schema — it is referenced by 64 other packages, indicating that it functions as a foundational utility rather than an end-user facing module.

The header comment identifies the source file as pyacutil.pkh (version 120.2), with an original purpose centered on Mexico localization. The best-documented function, get_defined_balance_id, returns the defined_balance_id for a given balance name and dimension, and includes explicit rules for resolving the combination of business group ID and legislation code, as well as treating a leading underscore in the dimension name as a database item suffix. Over time the package has grown into a general-purpose balance metadata access layer reused across multiple legislations.

Key Procedures and Functions

• GET_DEFINED_BALANCE_ID — overloaded function that resolves a defined balance identifier. Documented overloads accept either a balance type ID or balance name, together with a dimension name, business group ID, and legislation code. Because AUTHID CURRENT_USER is specified, the resolution honors the caller's schema privileges.
• GET_BALANCE_NAME — returns the translated value of a balance name for a supplied balance type ID, providing NLS-aware display text.
• GET_BAL_REPORTING_NAME — returns the translated reporting name of the balance. This is the object most commonly searched by developers and report authors seeking the human-readable label used in payroll reporting output.
• GET_BALANCE_TYPE_ID — derives the balance type identifier used as an input to the name and reporting name functions.
• GET_VALUE — general-purpose value retrieval routine within the package.
• RANGE_PERSON_ON — person-level range processing helper.
• GET_GEOCODE — geographic code lookup, consistent with the US counties and states tables referenced below.
• PRINT_LOB — LOB output routine used to emit large object content, ordinarily to the concurrent request output file.

Tables Accessed

The package reads the core Payroll balance definition model through APPS synonyms: PAY_BALANCE_TYPES and PAY_BALANCE_TYPES_TL supply balance type definitions and translated names; PAY_DEFINED_BALANCES holds the defined balance records resolved by GET_DEFINED_BALANCE_ID; and PAY_BALANCE_DIMENSIONS supplies dimension metadata. Reporting name resolution draws on PAY_REPORT_FORMAT_MAPPINGS_F and PAY_REPORT_FORMAT_PARAMETERS. Geographic lookups use PAY_US_COUNTIES and PAY_US_STATES, while HR_ORGANIZATION_INFORMATION provides organization context. DBMS_LOB, PLITBLM, and UTL_RAW are used by PRINT_LOB and related large-object handling.

Usage Notes

PAY_AC_UTILITY is invoked indirectly rather than by end users. Its callers are other PL/SQL packages in the Payroll schema, as well as Payroll forms and concurrent programs that need to translate stored balance identifiers into display or report text. A typical custom-code call pattern resolves a defined balance ID from a balance type and dimension, then passes that ID to GET_BALANCE_NAME or GET_BAL_REPORTING_NAME to obtain NLS-translated labels for Fast Formulas, BI Publisher reports, or custom extracts. Because the package is AUTHID CURRENT_USER, executing users must hold direct privileges on the underlying PAY tables through APPS synonyms, and customizations should call the package rather than querying PAY_DEFINED_BALANCES or PAY_BALANCE_TYPES_TL directly in order to remain consistent with Oracle's balance resolution rules in both 12.1.1 and 12.2.2.