Search Results action_information18

Overview

APPS.PAY_EMP_DETAILS_ACTION_INFO_V is a reporting and integration view in the Oracle E-Business Suite Payroll (PAY) schema. It exposes the employee details rows stored in the generic action information flexfield table, filtered to a specific action information context. The view selects all rows from PAY_ACTION_INFORMATION whose ACTION_INFORMATION_CATEGORY value matches the pattern '__ EMPLOYEE DETAILS' (a two-character prefix followed by a space and the literal string "EMPLOYEE DETAILS").

The object is particularly relevant to implementers searching for the action_information9 column, since the view materializes the full set of thirty descriptive flexfield segments (ACTION_INFORMATION1 through ACTION_INFORMATION30) as individually named columns. This makes it convenient to query the ninth segment directly rather than resolving the flexfield segment name through the descriptive flexfield definition. In EBS 12.1.1 and 12.2.2 the view is owned by APPS and is typically used by payroll and HR reporting, data migration scripts, and downstream integrations that need to read employee-level action information without joining to the flexfield metadata.

Underlying Base Objects

The view is defined over a single documented base object: the synonym PAY_ACTION_INFORMATION, which resolves to the underlying PAY_ACTION_INFORMATION table in the PAY schema. As a synonym-based view in the APPS schema, it inherits the standard EBS security model, so grants to the APPS schema (and the PUBLIC or specific responsibility roles) determine who can query it.

Because it is a simple projection — SELECT of the columns listed, FROM PAY_ACTION_INFORMATION, with a WHERE filter on ACTION_INFORMATION_CATEGORY — the view carries no aggregation or grouping. It is effectively a filtered, pre-flattened window onto the descriptive flexfield data for employee details. All thirty segment columns are exposed as VARCHAR2 attributes, along with the flexfield context identifiers.

Key Columns

• ACTION_CONTEXT_ID — Identifies the action context (e.g., an action or assignment context) to which the employee details information is attached.
• ACTION_CONTEXT_TYPE — The context type descriptor distinguishing the kind of context record this information belongs to.
• TAX_UNIT_ID — The tax unit (legal employer / reporting unit) associated with the record.
• ACTION_INFORMATION_CATEGORY — The descriptive flexfield context value; here filtered to the "EMPLOYEE DETAILS" category.
• ACTION_INFORMATION1 … ACTION_INFORMATION30 — The thirty generic descriptive flexfield segments. The user-requested action_information9 maps to the ninth segment, whose business meaning is determined by the flexfield segment configuration for the EMPLOYEE DETAILS context.

Common Use Cases and Queries

The view is commonly used when reporting or extracting employee details captured through the action information flexfield, or when migrating such data between environments. A typical query retrieving the ninth segment for a given employee context is:

• SELECT action_context_id, action_context_type, tax_unit_id, action_information_category, action_information9 FROM apps.pay_emp_details_action_info_v WHERE action_context_id = :p_context_id;
• Bulk extraction of all employee details segments: SELECT * FROM apps.pay_emp_details_action_info_v WHERE tax_unit_id = :p_tax_unit_id;
• Validation or reconciliation of segment 9 across contexts: SELECT action_context_id, action_information9 FROM apps.pay_emp_details_action_info_v WHERE action_information9 IS NOT NULL ORDER BY action_context_id;

Because the view filters only on the category pattern, additional predicates on ACTION_CONTEXT_ID, ACTION_CONTEXT_TYPE, or TAX_UNIT_ID are generally required to scope results to the relevant action context. For best performance, join or filter on the underlying PAY_ACTION_INFORMATION columns and confirm that the EMPLOYEE DETAILS descriptive flexfield context is enabled in the target instance.