Search Results final_process

Overview

APPS.PAY_US_UPDATE_TAX_RECORDS_PKG (shipped as the source file pyusutxr.pkb) is a US-specific payroll utility package in Oracle E-Business Suite that maintains the effective dating of employee-level tax rules when an assignment ends or when a termination is subsequently reversed. Its central business purpose is to align the four US employee tax rule tables — federal, state, county, and city — and the associated Vertex and Workers Compensation element entries with the actual termination date of an assignment, so that no tax rule or tax-related element entry remains open beyond the point at which the employee ceased to be paid.

The package operates against dated (effective-dated) tables, so its logic is built around determining a correct new end date and effective date for each tax record. It is invoked as part of the termination flow rather than as a standalone concurrent program, and it is referenced by three other payroll packages, indicating that it is a shared component of the US payroll termination and reversal processing chain.

Key Procedures and Functions

• TERMINATE_EMP_TAX_RECORDS — Closes out the employee's US tax rule records and related tax element entries as of the termination. The procedure first checks whether any federal tax defaulting rule exists for the assignment; if none is found, it returns immediately, since there is nothing to terminate. Where a rule exists, it derives the new end date and effective date from the process date and the actual termination date. When no process date is supplied and no actual termination date is available, it raises the standard HR error message HR_6153_ALL_PROCEDURE_FAIL with tokens identifying the procedure and step; otherwise it applies the end-of-time value for the new end date and the termination date as the effective date. It also queries employee element entries linked to elements whose names contain VERTEX or equal WORKERS COMPENSATION, confirming that the elements and element links are effective on the processing date. Tracing is emitted through hr_utility.trace.
• REVERSE_TERM_EMP_TAX_RECORDS — Performs the inverse operation, restoring or extending the effective dating of the employee's tax rule records when a termination is undone or reversed. It is the counterpart to the termination procedure and is driven by the same assignment, process date, and termination date inputs, ensuring that the federal, state, county, and city tax rules and the associated element entries are returned to a state consistent with continued employment.

Tables Accessed

• PAY_US_EMP_FED_TAX_RULES_F — queried to establish whether tax defaulting exists for the assignment and to obtain the earliest effective start date used in deriving the new end date.
• PAY_US_EMP_STATE_TAX_RULES_F, PAY_US_EMP_COUNTY_TAX_RULES_F, PAY_US_EMP_CITY_TAX_RULES_F — the state, county, and city tax rule records updated in parallel with the federal rules.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F — joined to identify open tax-related element entries (Vertex and Workers Compensation) for the assignment that remain effective on the process date.

Usage Notes

The package is not user-facing; it is called by the US payroll termination and reversal processes and by the other payroll packages that reference it. Typical invocation occurs during the termination of an assignment in Oracle HRMS/Payroll, when the actual termination date supplied by the user must be propagated to the dated tax rule tables. The "final_process" keyword commonly associated with this object reflects its role at the final stage of the termination flow, where the tax records are definitively closed. The procedures are defensive: the presence of a federal tax defaulting rule is a precondition, and the absence of a process date or termination date is treated as an error rather than a silent no-op. Custom code should call these procedures only with a valid assignment identifier and should expect standard HR error raising on invalid input. Because the package uses effective-dated tables and end-of-time semantics, callers must supply dates consistent with the payroll period being processed to avoid overlapping or prematurely closed tax records.