Search Results pay_au_module_parameters




Overview
Explore in AI Chat

Overview

PAY_AU_MODULE_PARAMETERS is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to define the parameters associated with a module used in the generic code framework. In the Australian payroll localization, modules represent discrete units of generic processing logic, and this table records the individual input, output, context, and result parameters that each module exposes. The table therefore acts as the metadata registry that allows the generic code engine to bind values to module parameters at runtime without hard-coding their definitions.

From a dimensional modeling perspective, the FK structure suggests a satellite-leaning classification. The table carries a single foreign key to PAY_AU_MODULES plus descriptive and flag attributes, which is characteristic of a satellite attached to a parent hub or link. This classification is a heuristic derived from the foreign key topology and should be treated as a modeling suggestion rather than a documented Data Vault design.

Key Information Stored

The table contains 21 documented columns. The most significant are:

Common Use Cases and Queries

Typical usage includes diagnosing why a generic payroll module fails to receive or return a value, and documenting the parameter interface of a module before extending it. A common query lists all enabled input parameters for a module:

  • SELECT p.internal_name, p.external_name, p.data_type, p.database_item_name FROM pay_au_module_parameters p WHERE p.module_id = :module_id AND p.input_flag = 'Y' AND p.enabled_flag = 'Y';
  • SELECT m.module_name, p.internal_name, p.output_flag, p.result_flag FROM pay_au_module_parameters p, pay_au_modules m WHERE p.module_id = m.module_id ORDER BY m.module_name, p.internal_name;
  • Join to PAY_AU_MODULES to resolve module identifiers, and filter on ZD_EDITION_NAME when querying in an edition-based redefinition environment.

Report usage centers on configuration auditing — identifying modules whose parameters reference obsolete database items or constants, and comparing parameter definitions across environments.

Related Objects

  • PAY_AU_MODULES — parent table; joined on PAY_AU_MODULE_PARAMETERS.MODULE_ID = PAY_AU_MODULES.MODULE_ID. This is the sole documented foreign key relationship.
  • PAY_AU_MODULE_PARAMETERS_PK and PAY_AU_MODULE_PARAMETERS_U1 — the primary key and unique index supporting direct lookups.
  • PAY_AU_MODULE_PARAMETERS_UK1 — business-key unique index on MODULE_ID and EXTERNAL_NAME, preventing duplicate parameter names within a module.
  • Generic code engine routines and Australian payroll fast formulas that consume module parameter definitions at runtime.