Search Results pay_action_parameter_values




Overview
Explore in AI Chat

Overview

The PAY_ACTION_PARAMETER_VALUES table is a Payroll (PAY) module data object owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Values for the specified action parameters," indicating that it stores the runtime values assigned to parameters that govern payroll action processing. In Oracle Payroll, actions represent discrete operations — such as running a payroll process, a pre-payment, a costing run, or a quick pay — and each action exposes a set of parameters that control its behavior. This table captures the values supplied for those parameters, grouped by an action parameter group identifier.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table is best modeled as an independent construct rather than a pure hub, link, or satellite, because the documented metadata exposes only a composite unique key over ACTION_PARAMETER_GROUP_ID and PARAMETER_NAME with no declared outgoing foreign keys to other business entities. The classification should be treated as a modeling suggestion rather than a definitive architectural statement.

Key Information Stored

The documented physical schema comprises four columns. The most important are:

  • ACTION_PARAMETER_GROUP_ID — Identifies the parameter group to which a value belongs. It forms the leading component of the business-key unique index and is the principal grouping mechanism for tying related parameter values together.
  • PARAMETER_NAME — The name of the action parameter whose value is recorded. Together with the group identifier, it constitutes the business key of the row.
  • PARAMETER_VALUE — The stored value assigned to the named parameter. This is the payload column and holds the actual setting supplied for the action.
  • ZD_EDITION_NAME — The editioning column introduced by the EBS 12.2 online patching architecture. It participates in the unique index PAY_ACTION_PARAMETER_VALUES_UK and supports edition-based redefinition of the table's contents.

The documented unique index PAY_ACTION_PARAMETER_VALUES_UK (ACTION_PARAMETER_GROUP_ID, PARAMETER_NAME, ZD_EDITION_NAME) is the business-key candidate. The table does not expose a separate surrogate primary key column distinct from this unique key, so the composite of group identifier, parameter name, and edition name serves as the identifying key.

Common Use Cases and Queries

Typical usage centers on auditing and reconstructing the configuration applied to a payroll action run. A frequent pattern retrieves all parameter values for a known group:

  • SELECT parameter_name, parameter_value FROM hr.pay_action_parameter_values WHERE action_parameter_group_id = :group_id;
  • Filtering by edition to isolate the active configuration: ... AND zd_edition_name = 'ORA$BASE';
  • Looking up a specific parameter across groups: SELECT action_parameter_group_id, parameter_value FROM hr.pay_action_parameter_values WHERE parameter_name = :name;

Reporting use cases include verifying that a payroll process was executed with the intended parameter settings, comparing configurations between editions during an upgrade or patch cycle, and feeding parameter values into diagnostic queries that explain payroll run behavior. Because the table carries no documented foreign keys, queries typically join back to parent action/parameter group definitions through the group identifier rather than through enforced constraints.

Related Objects

Because the documented metadata classifies the table as standalone, relationships to other objects are implicit rather than enforced by foreign keys. The most significant associated objects to consider are those that define the action parameter groups and actions referenced by ACTION_PARAMETER_GROUP_ID, along with the Payroll action and run architecture. In practice, analysts correlate this table with:

  • The action parameter group definition entity that supplies the group context for ACTION_PARAMETER_GROUP_ID.
  • The action parameter definition entity keyed by PARAMETER_NAME.
  • Payroll action and process invocation tables that generate the group identifiers consumed here.
  • EBS concurrent request and payroll run history objects used to correlate parameter values with executed processes.

Joins should be constructed on ACTION_PARAMETER_GROUP_ID and PARAMETER_NAME, respecting the ZD_EDITION_NAME column when operating in a 12.2.2 online-patching environment. No additional referential constraints are documented for this object.