Search Results pay_nl_cbs_file




Overview
Explore in AI Chat

Overview

The concurrent program PAY_NL_CBS_FILE is a Payroll (PAY) module component in Oracle E-Business Suite, presented to end users under the name Dutch CBS File. Its documented purpose is the process for generating the CBS (Centraal Bureau voor de Statistiek) file, the statutory statistical reporting output required for Dutch payroll operations. The program is enabled and available for submission in both Oracle EBS 12.1.1 and 12.2.2 environments where the Dutch localization for Payroll has been installed.

Although the user-facing identity is specific to Dutch statutory reporting, the underlying architecture is generic. The ETRM metadata identifies the executable as PYUGEN, described as the Generic Payroll Execution Process. This means PAY_NL_CBS_FILE is a configuration shell around a shared payroll driver: the localized logic, data selection criteria, and output formatting for the CBS file are determined by the program definition and its arguments rather than by a dedicated standalone binary.

Execution Details

The documented execution attributes are:

  • Product/Module: PAY - Payroll
  • User Name: Dutch CBS File
  • Description: Process for generating CBS File
  • Enabled: Yes
  • Execution Method: Spawned
  • Argument Method: Database fetch
  • Executable: PYUGEN
  • Execution Filename: PYUGEN
  • Subroutine Name: (none specified)

The Spawned execution method indicates that the program runs as an operating-system-level spawned process invoked by the Concurrent Manager, rather than as an in-process PL/SQL or Java concurrent program. The Database fetch argument method means parameter values are not entered interactively by the user; instead, they are retrieved from the database at runtime according to the program definition. This is consistent with the program functioning as a predefined localization wrapper around PYUGEN.

How to Run

Users submit PAY_NL_CBS_FILE through the standard Submit Request (SRS) window, navigating to Requests > Run and selecting Dutch CBS File from the list of available concurrent programs. Because the argument method is Database fetch, the parameter set is populated automatically from the program definition and any associated configuration, so users typically do not supply ad hoc parameter values at submission time. The effective selection — payroll, reporting period or tax year, and business group context — is derived from the program's stored argument configuration and, where applicable, from the user's environment and responsibility.

Standard practice is to verify the localization setup before first submission: confirm that the Dutch payroll statutory reporting configuration and any required legislative data are in place, and validate the request in a test environment before scheduling it in production. For recurring statutory obligations, the program can be scheduled as a recurring request aligned to the CBS reporting calendar.

Related Objects

As a spawned process built on the PYUGEN generic payroll execution infrastructure, PAY_NL_CBS_FILE draws on the same underlying payroll data structures used by core payroll processing and reporting, including payroll action and assignment-level results generated by the payroll run. Related technical objects commonly examined alongside it include the concurrent program definition and its executable registration for PYUGEN, the concurrent manager queue and log/output files produced at runtime, and the Dutch localization components that supply statutory reporting rules. Output is directed to the Concurrent Manager report output rather than to a database interface table by default, so retrieval is normally performed through the View Output function of the Requests form or via the standard concurrent output file location on the application server.