Results for “pay_au_recon_summary”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_AU_RECON_SUMMARY is an Oracle EBS payroll package owned by the APPS schema, classified as a component of the Australian (AU) localization within Oracle Payroll. Its central business function is the summarization and reconciliation of payroll balance data for Australian legislative and payment-summary reporting. The package aggregates monetary amounts across assignment-level balances, including gross earnings, allowances, fringe benefits, deductions, and lump-sum termination components, so that downstream reporting — most notably the Payment Summaries and related year-end reconciliation processes — can present correct totals for each employee. Because Australia imposes specific PAYG withholding and payment-summary obligations on employers, the package encapsulates the country-specific logic required to translate raw payroll balances into the reporting categories mandated by the Australian Taxation Office. The package is marked VALID in both 12.1.1 and 12.2.2 environments and is tightly coupled to the Oracle Payroll balance engine (PAY_BALANCE_PKG) and to the standard HR and payroll tables that store assignments, people, and payroll actions.

Key Procedures and Functions

The documented interface exposes 34 procedures and functions that fall into several functional groupings. Balance resolution functions include GET_VALUE_BBR, GET_BAL_VALUE_NEW, and POPULATE_BAL_IDS, which locate and cache the balance identifiers required for subsequent aggregation. Income and earnings totals are produced by TOTAL_GROSS, TOTAL_LUMP_SUM_A_PAYMENTS, TOTAL_LUMP_SUM_B_PAYMENTS, TOTAL_LUMP_SUM_D_PAYMENTS, and TOTAL_LUMP_SUM_E_PAYMENTS, each corresponding to a distinct lump-sum payment category used in Australian termination reporting. Allowance-related logic is handled by ADJUST_RETRO_GROUP_ALLOWANCES, GET_TOTAL_ALLOWANCES, GET_TOTAL_FBT (fringe benefits tax), and GET_TOTAL_WORKPLACE, while deduction and contribution totals are produced by TOTAL_TAX_DEDUCTIONS, TOTAL_UNION_FEES, TOTAL_RESC, and TOTAL_CDEP. Additional country-specific totals are returned by TOTAL_FOREIGN_INCOME and TOTAL_INVALIDITY_PAYMENTS. Termination and post-1983 employment calculations are supported by ETP_DETAILS and POST30JUN1983_VALUE, which underpin eligible termination payment reporting. Together these routines supply the numeric building blocks consumed by the Australian payment summary concurrent program.

Tables Accessed

Through APPS synonyms the package reads and processes data from core payroll and HR tables. Employee and assignment identity is sourced from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S. Payroll run context is retrieved from PAY_PAYROLL_ACTIONS and PAY_ACTION_INTERLOCKS. Balance definition and value data come from PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_ATTRIBUTES, PAY_BALANCE_FEEDS_F, and the PAY_BALANCE_PKG package. Organization and legislative context is provided by HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_UNITS, while FF_GLOBALS_F supplies FastFormula global values. Concurrent processing and messaging information is obtained from FND_CONCURRENT_REQUESTS and FND_NEW_MESSAGES.

Usage Notes

PAY_AU_RECON_SUMMARY is primarily invoked during execution of the Australian Payment Summary concurrent program through its referencing package PAY_PYAURECP_XMLP_PKG, which embeds the summary logic within the BI Publisher report process. It can also be called directly from custom PL/SQL, but such use should respect the package's dependence on an active payroll action and valid balance dimensions. Implementations upgrading from 12.1.1 to 12.2.2 should note the package remains VALID and functionally compatible, though standard patch application is recommended to ensure any localization fixes are present.