Results for “accrual_value”

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

Overview

PAY_AU_LEAVE_LIABILITY_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Payroll (PAY) product, implemented as part of the Australian localisation. It consolidates accrued leave liability information for Australian assignments by joining the balance of leave accrual and leave entitlement records held in the Oracle Payroll archive structures. The view presents, for each payroll action, assignment, and assignment action, the associated accrual category, accrual plan, leave entitlement quantity, entitlement value, leave accrual quantity, and accrual value. This makes it a central source for leave liability reporting, financial provisioning, and reconciliation of accrued leave balances that arise from the Australian payroll legislative requirements. Because the object is a view and not a table, it imposes no storage overhead; it derives its results at runtime from the synonym-based archive and payroll tables described below. Its ETRM status is VALID, and it is referenced primarily by Australian payroll reporting and leave liability extracts and by integrations that require a structured, denormalised representation of archived leave balances without directly navigating the generic FastFormula archive schema.

Underlying Base Objects

The view is defined over a set of APPS synonyms that resolve to the underlying Payroll and FastFormula archive tables. The documented referenced base objects are:

• FF_ARCHIVE_ITEMS (SYNONYM) — holds archived FastFormula user entity values, including the leave accrual and leave entitlement items selected by the view.
• FF_ARCHIVE_ITEM_CONTEXTS (SYNONYM) — stores the context values associated with each archive item, supplying the assignment action and accrual plan identifiers.
• FF_CONTEXTS (SYNONYM) — provides the context name definitions (ASSIGNMENT_ACTION_ID, ACCRUAL_PLAN_ID) used to filter context rows.
• FF_USER_ENTITIES (SYNONYM) — defines the user entity names X_LEAVE_ACCRUAL and X_LEAVE_ENTITLEMENT that identify the relevant archive items.
• PAY_ACCRUAL_PLANS (SYNONYM) — supplies the accrual plan definition referenced by the accrual plan context.
• PAY_ASSIGNMENT_ACTIONS (SYNONYM) — links the payroll action, assignment, and assignment action identifiers used as the view's leading columns.

Internally the view text builds three inline subqueries — one for leave accrual, one for leave entitlement, and one for accrual values — each joined to the fast formula archive items through the user entity name and then correlated by ASSIGNMENT_ACTION_ID and ACCRUAL_PLAN_ID contexts. The result set is combined with the assignment and payroll action columns to yield a single flat record per assignment action and accrual plan. The foreign key relationships to PAY_ASSIGNMENT_ACTIONS and PAY_ACCRUAL_PLANS anchor the archived FastFormula data back to the transactional payroll model.

Key Columns

• PAYROLL_ACTION_ID — identifier of the payroll action that produced the archived balances.
• ASSIGNMENT_ID — the employee or applicant assignment to which the leave liability belongs.
• ASSIGNMENT_ACTION_ID — the assignment-level action linking the payroll run to the assignment.
• ACCRUAL_CATEGORY — the category of the accrual, derived from the accrual plan definition.
• ACCRUAL_PLAN_ID — numeric identifier of the accrual plan, converted from the archive context value.
• LEAVE_ENTITLEMENT — entitlement quantity extracted from the X_LEAVE_ENTITLEMENT archive item.
• ENTITLEMENT_VALUE — monetary or valued representation of the entitlement.
• LEAVE_ACCRUAL — accrual quantity extracted from the X_LEAVE_ACCRUAL archive item.
• ACCRUAL_VALUE — monetary or valued representation of the accrued leave liability.

Common Use Cases and Queries

Typical usage includes extracting leave liability provisions for a given payroll period, reconciling accrual values against the general ledger, and validating archived balances after a payroll run. A representative query follows:

• SELECT assignment_id, accrual_plan_id, accrual_category, leave_accrual, accrual_value FROM apps.pay_au_leave_liability_v WHERE payroll_action_id = :p_action_id ORDER BY assignment_id;
• SELECT accrual_category, SUM(accrual_value) FROM apps.pay_au_leave_liability_v GROUP BY accrual_category;
• SELECT a.assignment_id, a.accrual_plan_id, a.leave_accrual, a.accrual_value FROM apps.pay_au_leave_liability_v a, apps.pay_accrual_plans p WHERE a.accrual_plan_id = p.accrual_plan_id AND p.business_group_id = :p_bg_id;

Because the view relies on the FastFormula archive, rows are only available after the relevant payroll action has been archived; queries against unarchived actions return no data. Joins to PAY_ACCRUAL_PLANS and PAY_ASSIGNMENT_ACTIONS are commonly required to add business group, plan name, and assignment context to the output.