Search Results pay_nz_eft




Overview
Explore in AI Chat

Overview

PAY_NZ_EFT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports New Zealand electronic funds transfer (EFT) payment processing within the Oracle Payroll module. Its role is to generate the outbound payment file formats required to remit net pay to employee bank accounts through the New Zealand banking clearing system. The package operates as a supporting component of the Oracle Payroll external payment architecture, where country-specific EFT packages encapsulate the formatting, validation, and record-layout rules that differ between national payment systems. In the New Zealand localization, PAY_NZ_EFT bridges the generic payroll payment model and the specific data expectations of New Zealand banks.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents a single procedure within this package:

  • ADD_CUSTOM_XML — a customization hook that allows the EFT output to be extended with additional XML content. This provides an extension point so that site-specific or legislative data elements not present in the standard EFT record layout can be appended to the generated payment file without modifying Oracle seeded code. No parameter information is exposed in the documented metadata, and the procedure should therefore be treated as a controlled extension point rather than a general-purpose API.

Because the package exposes only this single documented procedure, the bulk of its logic is contained in the package body and is invoked internally during the EFT generation cycle rather than being called directly by external programs.

Tables Accessed

The package references a set of payroll and payment tables, largely through APPS synonyms:

Usage Notes

PAY_NZ_EFT is not normally invoked directly by end users or custom code. It is called by the Oracle Payroll external payment process during the EFT file generation step, which is executed when a payroll payment run produces net pay for employees whose payment method is EFT. The package is typically triggered through the standard payroll payment and magnetic media concurrent programs rather than through a form. Customizations are intended to flow through the ADD_CUSTOM_XML extension point, avoiding direct modification of seeded package logic. Because the ETRM metadata lists no dependent packages that reference it, it should be regarded as a leaf-level localization component. Customers implementing a New Zealand payroll should validate bank-specific file layout requirements against the standard output before relying on the package.