Search Results validate_ni_formula




Overview
Explore in AI Chat

Overview

APPS.PER_RO_NI_VALIDATION is a Romanian localization package within the Oracle E-Business Suite Human Resources (HR) module. Its business purpose is to validate National Identifier (NI) values — commonly referred to as the CNP (Cod Numeric Personal) in Romania — against the country-specific rules that govern the structure and integrity of that identifier. The package header declares AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking schema rather than the defining schema, and it is compiled with the standard Oracle proprietary header (perronival.pkh, version 120.0.12020000.4). Because personal identifier formats vary by country, Oracle delivers localized validation logic such as this to enforce statutory data-capture requirements at the point of entry. The package exposes a small, focused public interface consisting of exactly two callable functions, and it is referenced by two other packages within the APPS schema, confirming that it is a dependency of broader Romanian HR processing rather than an isolated utility.

Key Procedures and Functions

The documented package interface contains two functions:

  • VALIDATE_NI_FORMULA — This function performs validation of a National Identifier string by applying the Romanian check-digit (control-digit) algorithm. It accepts a National Identifier value as input and returns a numeric result indicating whether the supplied identifier conforms to the expected formula. This is the object most frequently sought when users search for "validate_ni_formula," and it represents the pure computational core of the package, independent of person or context data.
  • VALIDATE_NI — This function performs full validation of a National Identifier in the context of an employee or person record. Its parameters supply the person identifier, business group, the national identifier value, sex, date of birth, region of birth, country of birth, citizenship, and residence. It returns a numeric result indicating the outcome of the validation. The breadth of personal attributes passed to this function indicates that the validation logic correlates the identifier against associated person data — for example, verifying that the encoded birth date and sex characteristics within the identifier are consistent with the stored person attributes.

Tables Accessed

The documented metadata records references only to the DUAL pseudo-table, accessed through APPS synonyms. This indicates that the validation formulas are self-contained: the package performs its checks entirely on the values passed into its functions, rather than reading from or writing to HR person tables directly. All person-level data required for validation is supplied by the calling program. Any persistence of the validated National Identifier is therefore the responsibility of the caller, not of this package. The absence of other referenced tables reinforces that PER_RO_NI_VALIDATION is a stateless validation utility.

Usage Notes

This package is typically invoked when Romanian National Identifiers are captured or maintained within Oracle HRMS. The most common invocation points are the person maintenance forms and any localization-specific descriptive-flexfield or date-tracked validation hooks that trigger on entry of a national identifier. It may also be called from concurrent processes or interfaces that load person data in bulk, allowing records to be validated before import. The presence of two referencing packages indicates that it is consumed programmatically within the APPS schema, so customizations should call APPS.PER_RO_NI_VALIDATION.VALIDATE_NI_FORMULA or VALIDATE_NI rather than reimplementing the check-digit logic. Because the functions return a numeric result, callers must interpret the return value in accordance with the package's internal conventions — typically zero or one for failure or success. Developers extending Romanian HR functionality should treat this package as the authoritative source of National Identifier validation in release 12.1.1 and 12.2.2.