Search Results action_information7

Overview

APPS.PAY_EMEA_USR_ELE_ACTION_INFO_V is a reporting view within the Oracle E-Business Suite Payroll (PAY) product family, defined in the APPS schema. It consolidates element definition metadata and per-assignment element information recorded against payroll actions, exposing that data in a denormalized, display-ready format. The view is oriented toward the EMEA localization of Oracle Payroll, where element definitions and element entries are frequently carried as flexfield-style key/value records in PAY_ACTION_INFORMATION rather than as discrete columns.

Its principal purpose is to reconstruct a human-readable "narrative" for each element action, joining the parent element definition row (recorded at the payroll action level) with the child element information rows (recorded at the assignment action level). This makes the view suitable for statutory reporting, payslip-facing extracts, element audit reports, and integration feeds that must present element context, amount, and sequence information in a single flattened row.

Underlying Base Objects

The documented dependencies for this view in ETRM 12.2.2 are:

• FND_DATE (PACKAGE) — used to convert canonical date values to display dates.
• PAY_ACTION_INFORMATION (SYNONYM) — referenced twice, aliased PAI1 for element definition rows and PAI2 for element information rows.
• PAY_ACTION_INTERLOCKS (SYNONYM) — links the locking and locked assignment actions.
• PAY_ASSIGNMENT_ACTIONS (SYNONYM) — referenced twice, aliased APAA (the element action) and PPAA (the locked action).
• PAY_PAYROLL_ACTIONS (SYNONYM) — supplies the payroll action driving the action type filter.

PAI1 is filtered to action_context_type 'PA' and action_information_category 'EMEA ELEMENT DEFINITION', while PAI2 is filtered to action_context_type 'AAP' and action_information_category 'EMEA ELEMENT INFO'. The two are correlated on action_information2 = action_information1 and action_information3 = action_information2, with PAI1.action_information5 fixed at 'F'. Interlock and payroll action joins restrict results to payroll action types 'P' (payroll run) and 'U' (reversal), and a final predicate matches the element ordering attribute.

Key Columns

• action_context_id — identifier of the underlying assignment action; the primary correlation key returned by the view.
• narrative — the element description from PAI1.action_information4, optionally suffixed with PAI2.action_information8 in parentheses.
• context — sourced from PAI2.action_information3; the element context value used to distinguish variants such as action_information3-driven element qualifiers.
• context_description — PAI2.action_information9, the descriptive form of the context.
• amount — PAI2.action_information4, converted with FND_DATE when PAI2.action_information6 equals 'D', otherwise returned as-is.
• main_seq, multi_seq, column_seq — sequence attributes from PAI2.action_information5/6/7 controlling presentation and ordering.

Common Use Cases and Queries

Typical usage includes element audit extracts, payslip detail verification, and EMEA localization reporting. A representative query filters on a known assignment action:

• SELECT narrative, context, context_description, amount FROM apps.pay_emea_usr_ele_action_info_v WHERE action_context_id = :assignment_action_id ORDER BY main_seq, multi_seq, column_seq;
• Joining the view to PAY_ASSIGNMENT_ACTIONS or PER_ASSIGNMENTS to attribute element results to a person or payroll period.
• Searching on context = 'action_information3' values to isolate elements whose context qualifier matches a specific value.

Because the view returns only assignment actions linked through PAY_ACTION_INTERLOCKS to a payroll action of type 'P' or 'U', results are naturally scoped to processed or reversed element entries.