Search Results l_acc




Overview
Explore in AI Chat

Overview

HR_NZ_BANK_ACCT_VALIDATION is a New Zealand localization package in the Oracle E-Business Suite (12.1.1 and 12.2.2) responsible for validating New Zealand bank account numbers captured in Oracle HRMS payroll and payment flows. New Zealand bank account numbers follow a structured format consisting of a bank identifier, a branch number, a base account number, and a suffix. Because the country operates a defined set of registered banks, each with its own branch numbering rules and account number lengths, incorrect values can cause electronic payment rejections or misdirected salary and vendor payments. This package centralizes those country-specific rules so that they are applied consistently wherever an NZ bank account is entered or processed.

The package body is owned by APPS and is classified as OTHER in the ETRM documentation, signifying it is an internal validation utility rather than a public API. The header comments date back to May 1999, with subsequent changes supporting individual institutions such as KiwiBank. The most recent documented revision, dated February 2008, expanded branch number validations.

Key Procedures and Functions

The documented interface consists of one function: VALIDATE_ACCT. Its purpose is to perform format and range validation of a supplied New Zealand bank account and return a result indicating whether the account is valid. Internally, the validation logic enforces:

  • Bank identifier validation against the recognized set of New Zealand banks.
  • Branch number validation, including bank-specific rules for institutions such as KiwiBank (bank code 38), which were introduced and refined under documented change requests.
  • Account number validation, including length and structure checks for banks whose account numbering conventions differ from the standard.
  • A suffix component check, where applicable.

The precise parameter list of VALIDATE_ACCT is not recorded in the available ETRM metadata and is therefore not reproduced here. Callers pass in account components and receive a validation outcome.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. The absence of documented table references is consistent with a self-contained validation routine whose rules are encoded directly in the package body, including the institution-specific checks documented in the change list. The package therefore performs no reads or writes against payroll or payment tables as part of validation. Dependent business logic is expected to persist validated account details separately, for example through the external bank account or payroll payment structures that invoke the validation.

Usage Notes

HR_NZ_BANK_ACCT_VALIDATION is referenced by one other documented package, which acts as the primary caller. It is typically invoked during the entry or maintenance of New Zealand bank account details in Oracle HRMS, where validation is triggered before an account can be saved or used for payment. Common invocation points include payroll payment method setup and any customization that captures NZ bank account information.

Because the package is classified as OTHER rather than as a certified public API, direct invocation from custom code should be undertaken only after reviewing the underlying source, as the function signature and returned values are not part of Oracle's published interface contract. Customizations should also account for the possibility that the package body may be modified or patched, particularly in relation to individual bank rules. Sites upgrading between 12.1.1 and 12.2.2 should confirm that the deployed version reflects the most recent branch and KiwiBank validation fixes documented in the change history.