Results for “accrual_code”

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

Overview

The APPS.PAY_EMP_ACCRUALS_ACTION_INFO_V view is a payroll reporting object within the Oracle E-Business Suite Payroll (PAY) module. It exposes employee accrual balances and related action information recorded against payroll assignment records, presenting them in a flattened, query-friendly structure. The view is defined over PAY_ACTION_INFORMATION, an audit table that stores payroll action context data as generic name-value attribute pairs, and joins it to PER_ASSIGNMENTS_F to ensure the returned accrual rows are effective-dated against the assignment that generated them.

Its principal role is to denormalize the cryptic ACTION_INFORMATIONn columns of the underlying action-information table into meaningful business fields such as ACCRUAL_TYPE, ACCRUAL_CODE, CURRENT_AMOUNT, and NET_AMOUNT. This makes the view suitable for reporting, extraction, and downstream integration where a stable, human-readable representation of accrual activity is required. Because it filters on ACTION_CONTEXT_TYPE = 'AAP' and ACTION_INFORMATION_CATEGORY = 'EMPLOYEE ACCRUALS', the view is scoped exclusively to accrual-related action data and does not expose unrelated action-information categories.

As with all APPS views, it is governed by Oracle's row-level security through HR_SECURITY and HR_GENERAL, meaning the rows returned are constrained by the user's security profile. Consumers should therefore not treat it as an unfiltered data feed.

Underlying Base Objects

The documented base objects referenced by this view are:

• PAY_ACTION_INFORMATION (SYNONYM) — the primary data source, supplying action context, tax unit, effective date, and the action-information attributes that are aliased into ACCRUAL_TYPE, ACCRUAL_CODE, CURRENT_AMOUNT, and NET_AMOUNT.
• PER_ASSIGNMENTS_F (VIEW) — the effective-dated assignment view, joined on ASSIGNMENT_ID and constrained so the action effective date falls between the assignment's effective start and end dates.
• FND_NUMBER (PACKAGE) — provides the CANONICAL_TO_NUMBER function used to convert the numeric character values held in ACTION_INFORMATION5 and ACTION_INFORMATION6 into numbers before summation.
• HR_GENERAL (PACKAGE) — supporting HR utility logic.
• HR_SECURITY (PACKAGE) — enforces row-level security for HR/payroll data access.

The join to PER_ASSIGNMENTS_F and the GROUP BY on business group, context, tax unit, effective date, and the two accrual attributes indicate that the view aggregates accrual action lines into one row per assignment-business-group/context/date/type/code combination.

Key Columns

• ACTION_CONTEXT_ID — identifier for the action context under which the accrual information was captured.
• TAX_UNIT_ID — the tax unit (legal employer grouping) associated with the accrual record.
• EFFECTIVE_DATE — the date on which the accrual action information is effective.
• ACCRUAL_TYPE — the accrual classification, derived from ACTION_INFORMATION4.
• ACCRUAL_CODE — the specific accrual code or plan reference, derived from ACTION_INFORMATION7.
• CURRENT_AMOUNT — the summed current accrual amount, computed from ACTION_INFORMATION5 via FND_NUMBER.CANONICAL_TO_NUMBER.
• NET_AMOUNT — the summed net accrual amount, computed from ACTION_INFORMATION6 via the same conversion function.

The columns ACCRUAL_TYPE, ACCRUAL_CODE, CURRENT_AMOUNT, and NET_AMOUNT are the view's value-add: they translate the generic ACTION_INFORMATION slots into business-meaningful attributes, with the monetary columns aggregated numerically.

Common Use Cases and Queries

Typical uses include reconciling employee accrual balances, feeding accrual data to payroll reporting, and validating accrual activity for a given tax unit or effective period. A common starting point filters by accrual type and date range:

• Retrieving accrual balances for a tax unit over a period.
• Reporting accrual activity summarized by ACCRUAL_TYPE and ACCRUAL_CODE.
• Comparing CURRENT_AMOUNT and NET_AMOUNT for reconciliation.

Sample query:

SELECT action_context_id, tax_unit_id, effective_date, accrual_type, accrual_code, current_amount, net_amount FROM apps.pay_emp_accruals_action_info_v WHERE accrual_type = :p_accrual_type AND effective_date BETWEEN :p_start_date AND :p_end_date ORDER BY effective_date, accrual_code;

Because monetary values are aggregated via SUM on canonically converted values, consumers should be aware that the numeric output depends on FND_NUMBER correctly interpreting the stored character representations. Results remain subject to the HR_SECURITY profile applied at runtime.