Search Results action_information2




Overview
Explore in AI Chat

Overview

APPS.PAY_APAC_BALS_ACTION_INFO_V is a reporting view in the Oracle E-Business Suite HRMS/Payroll schema that consolidates balance-definition and balance-result action information for the APAC (Asia-Pacific) localization. It is documented in the ETRM repository as part of the Oracle EBS 12.1.1 / 12.2.2 object set and is owned by the APPS schema. The view joins action information records for two distinct action context types — "PA" (payroll action level, category EMEA BALANCE DEFINITION) and "AAP" (assignment action level, category EMEA BALANCES) — and links them through the payroll action interlock framework (PAY_ACTION_INTERLOCKS) and the assignment action hierarchy (PAY_ASSIGNMENT_ACTIONS). The result is a denormalized, narrative-style projection of balance values that report authors and integration developers can query without manually reproducing the multi-table interlock and context join logic. Although the naming references APAC, the internal action-information categories carried through the view retain the EMEA balance-definition naming used by the shared balance-definition framework, which is a common characteristic of localized balance views in the payroll module. The view is read-only and exposes no maintenance capability; it is intended purely for queries and downstream reporting.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PAY_ACTION_INFORMATION (synonym) — referenced twice, aliased PAI1 and PAI2. PAI1 supplies the balance-definition records (action_context_type = 'PA', category EMEA BALANCE DEFINITION); PAI2 supplies the balance-result records (action_context_type = 'AAP', category EMEA BALANCES).
  • PAY_ACTION_INTERLOCKS (synonym) — aliased LCK. Provides the locking relationship between the action that generated the balance and the action against which the balance was locked.
  • PAY_ASSIGNMENT_ACTIONS (synonym) — referenced twice, aliased PAA1 and PAA2. PAA2 is the assignment action corresponding to the balance record; PAA1 is the source (locked) assignment action.
  • PAY_PAYROLL_ACTIONS (synonym) — aliased PPA. Restricts the result set to payroll actions of type 'P' (payroll run) or 'U' (update/reversal type).
  • FND_NUMBER (package) — used via FND_NUMBER.CANONICAL_TO_NUMBER to convert the canonical balance value stored in PAI2.ACTION_INFORMATION4 into a numeric value.

The join path ties the definition record to the result record via PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1, and ties the assignment action to the interlock chain and to the payroll action on which the balance definition is anchored.

Key Columns

  • ACTION_CONTEXT_ID — the assignment action ID of the balance-result action information record (PAI2.ACTION_CONTEXT_ID). Effectively identifies the assignment action that produced the balance.
  • NARRATIVE — a display string built from PAI1.ACTION_INFORMATION4 (the definition name or description), optionally suffixed with the parenthetical value PAI2.ACTION_INFORMATION5. Intended for human-readable reporting.
  • CONTEXT — exposes PAI2.ACTION_INFORMATION2, the context key that links the balance result back to the definition. It is the column most commonly referenced when a user searches for "action_information2".
  • CONTEXT_DESCRIPTION — exposes PAI2.ACTION_INFORMATION6, a descriptive label for the context; may be NULL when no contextual description is supplied.
  • VALUE — the numeric balance value, being the canonical-to-number conversion of PAI2.ACTION_INFORMATION4.

The final ORDER BY clause sorts results by NVL(TO_NUMBER(PAI2.ACTION_INFORMATION5),1) DESC and then by PAI2.ACTION_INFORMATION_ID, so the highest sequence value appears first.

Common Use Cases and Queries

Typical uses include reconciling balance results to their definitions, extracting balance values for a specific payroll action or assignment action, and producing narrative balance listings for audit or localization support. A representative query is:

  • SELECT action_context_id, narrative, context, context_description, value FROM apps.pay_apac_bals_action_info_v;
  • Filtering to a single balance definition or action: SELECT * FROM apps.pay_apac_bals_action_info_v WHERE context = :p_context;
  • Joining back to PAY_ASSIGNMENT_ACTIONS on action_context_id to retrieve the assignment and payroll action context.

Because the view already enforces the interlock, source_action_id, and payroll action type constraints, it is preferable to querying the base action-information tables directly when the objective is a localized APAC balance listing rather than raw action information maintenance.