Results for “record_4712”

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

Overview

APPS.PAY_NL_IZA_REPORT is a Dutch localization reporting package in Oracle E-Business Suite Payroll (Oracle HRMS). Its documented purpose is the generation of the Dutch Annual Tax Statement report, commonly referred to as the IZA (Inkomensverklaring / annual earnings statement) report. The package body contains the PL/SQL logic that assembles payroll, employer, and participant data for the statutory year-end filing and renders it into an XML-based report structure suitable for XFDF/PDF output.

The package operates against the IZA upload and status infrastructure, which tracks employer and employee records submitted to the Dutch tax authority. Because the report is statutory, the package must reconcile multiple contribution and correction amounts and classify each employee record with a process status and, where applicable, a rejection reason. The naming convention (PAY_NL_IZA_*) and the header string (paynliza.pkb 120.0) indicate it is a Dutch payroll localization object originally shipped for the 11i and 12.0 release stream and carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

• POPULATE_IZA_REPORT_DATA — The primary report-generation procedure. It accepts business group, employer/organization, effective date, process month, and organization structure context, and returns an XFDF BLOB for the report output. It drives two principal cursors: one that retrieves employer-level data (currency, payroll center, province code and its decoded lookup meaning, and zero-padded employer and sub-employer numbers), and one that retrieves employee-level data (exchange number composed from employer, sub-employer, and employee numbers, process status, employee name, date of birth, participant number, contribution and correction amounts, and correction dates). Rejection reasons are derived by decoding process status values such as 'MISSING' against the NL_IZA_REJECT_REASON lookup.
• RECORD_4712 — A supporting routine documented in the package metadata. Its role is to record a specific error or exception condition associated with the IZA report payload, consistent with the numbered-record pattern used elsewhere in Oracle localization packages for diagnostic logging and report exception handling.

Tables Accessed

• PAY_NL_IZA_UPLD_STATUS — The central data source. It holds the employer and employee IZA submission status, contribution and correction amounts, participant numbers, and process status/rejection information consumed by the reporting cursors.
• FND_LOBS — Stores the generated report output as a large object, enabling the XFDF/PDF artifact to be retrieved by the requesting concurrent program or form.
• PER_GB_XDO_TEMPLATES — Provides the XML/XDO report template definition used to render the IZA report layout.
• PLITBLM — The Oracle HRMS PL/SQL index-by table type used internally for passing and storing collections of records during report assembly.

Usage Notes

The package is not exposed as a public API and is not referenced by other packages, indicating it is invoked directly by its owning report or concurrent program rather than through shared application logic. In practice it is executed as the data-generation layer behind the Dutch Annual Tax Statement concurrent request, called with the business group, employer, process month, and organization structure parameters supplied at submission time. The p_xfdf_blob OUT NOCOPY BLOB pattern confirms the procedure is intended to return a rendered binary report to the calling program, which then publishes or retains it via FND_LOBS. Custom code should not call this package directly; use the standard Dutch payroll statutory reporting concurrent programs instead, and treat the decoded lookup-driven status and rejection fields as the authoritative reflection of IZA submission state for the selected tax year and process month.