Results for “action_context_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_APAC_PAYSLIP_ACCRUALS_V is a predefined Oracle E-Business Suite view owned by the APPS schema and validated against the Payroll (PAY) product module. It exposes APAC-specific payslip accrual information stored within the generic payroll action information framework. The view filters Payroll action information records to those associated with the action context type 'AAP' and the action information category 'APAC ACCRUALS', thereby presenting a focused, region-specific data set that supports payslip display, accrual reporting, and downstream integration for Asia-Pacific payroll operations.

Because the view is a thin projection over PAY_ACTION_INFORMATION rather than a dedicated accrual table, it provides a stable, semantic interface for accrual plan data without requiring consumers to know the underlying context type or category discriminator values. This is significant in Oracle EBS 12.1.1 and 12.2.2, where rapid patches and regional legislative changes are common; the view insulates reports and interfaces from structural changes to the base action information storage.

Underlying Base Objects

The view is defined over the synonym PAY_ACTION_INFORMATION, which resolves to the base Payroll action information table. Two additional PL/SQL packages are referenced within the view text and are documented in the ETRM metadata:

• PAY_ACTION_INFORMATION — the primary source table, filtered by ACTION_CONTEXT_TYPE = 'AAP' and ACTION_INFORMATION_CATEGORY = 'APAC ACCRUALS'.
• FND_NUMBER — a package whose CANONICAL_TO_NUMBER function converts the canonical character representation in ACTION_INFORMATION4 into a numeric value, used for the BALANCE column.
• HR_GENERAL_UTILITIES — a package whose GET_LOOKUP_MEANING function resolves the code in ACTION_INFORMATION5 against the 'HOURS_OR_DAYS' lookup type, producing the unit of measure (UOM) value.

This design means the view inherits the security and partitioning characteristics of PAY_ACTION_INFORMATION and depends on the availability and validity of the two referenced packages. Any invalidation of those packages can render the view unusable for querying, so DBAs should monitor object status in both 12.1.1 and 12.2.2 environments.

Key Columns

The documented columns exposed by the view are:

• ACTION_CONTEXT_ID — identifier linking the accrual record to its parent action context; used to join back to the originating payroll action or assignment context.
• ACTION_CONTEXT_TYPE — always 'AAP' within this view, reflecting the APAC action context classification.
• ACCRUAL_PLAN_NAME — derived from ACTION_INFORMATION1; the name of the accrual plan associated with the payslip accrual.
• ACCRUAL_CATEGORY — derived from ACTION_INFORMATION2; the accrual category (the term commonly searched as "accrual_category"), classifying the type of accrual such as leave or benefit accrual.
• BALANCE — the numeric accrual balance, produced by FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION4).
• UOM — the unit of measure for the balance, obtained via HR_GENERAL_UTILITIES.GET_LOOKUP_MEANING('HOURS_OR_DAYS', ACTION_INFORMATION5), typically Hours or Days.

Common Use Cases and Queries

This view is typically consumed by APAC payslip generation, accrual balance reporting, and data extraction interfaces. A representative query retrieves accrual balances for a given context:

• SELECT accrual_plan_name, accrual_category, balance, uom FROM apps.pay_apac_payslip_accruals_v WHERE action_context_id = :p_context_id;
• SELECT accrual_category, SUM(balance) FROM apps.pay_apac_payslip_accruals_v GROUP BY accrual_category;
• SELECT * FROM apps.pay_apac_payslip_accruals_v WHERE accrual_plan_name = :p_plan;

Typical scenarios include reconciling accrual balances shown on APAC payslips against payroll balances, feeding accrual liability extracts into general ledger or third-party systems, and validating that accrual categories and units of measure are populated correctly. When troubleshooting, confirm the base PAY_ACTION_INFORMATION category value equals 'APAC ACCRUALS' and that the FND_NUMBER and HR_GENERAL_UTILITIES packages are valid; otherwise BALANCE or UOM may return null.