Results for “element_value”

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

Overview

PAY_IE_EAR_DED_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, classified under the PAY (Payroll) product family. Its documented purpose is narrow and specific: it is used in the Irish (IE) Payslip Advice Report. The view resolves element-level earnings and deductions for a given assignment action so that the payslip advice output can display each element name, its classification as earnings or deduction, and its calculated value.

The view is structurally tied to the concept identified by the search term "assignment_action_id." Rather than exposing the primary assignment action directly, the view derives its ASSIGNMENT_ACTION_ID value from the LOCKING_ACTION_ID column of PAY_ACTION_INTERLOCKS. This means the view reports on the action that locks or depends upon another action, which is the pattern used when a prepayment or calculation process references a prior payroll run. In EBS 12.1.1 and 12.2.2 the view is reported as VALID, confirming that all referenced synonyms and underlying objects resolve correctly at runtime.

Underlying Base Objects

The documented referenced base objects are FND_NUMBER (PACKAGE), PAY_ACTION_INFORMATION (SYNONYM), PAY_ACTION_INTERLOCKS (SYNONYM), PAY_ASSIGNMENT_ACTIONS (SYNONYM), and PAY_IE_PAYMENT_VALUES_V (VIEW), all resolved under APPS. The view text joins these objects as follows:

• PAY_ACTION_INTERLOCKS (aliased LCK) provides the linking actions. LCK.LOCKED_ACTION_ID joins to PAA1.ASSIGNMENT_ACTION_ID, and LCK.LOCKING_ACTION_ID joins to PAA2.ASSIGNMENT_ACTION_ID and is projected as the view's ASSIGNMENT_ACTION_ID.
• PAY_ACTION_INFORMATION (PAI) supplies element definition metadata. It is filtered to ACTION_CONTEXT_TYPE = 'PA' and ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'. ACTION_INFORMATION4 yields the element name and ACTION_INFORMATION5 yields the earning-or-deduction indicator.
• PAY_IE_PAYMENT_VALUES_V (PET) supplies the computed RESULT_VALUE. It joins to PAA1 on ASSIGNMENT_ACTION_ID, and to PAI on ELEMENT_TYPE_ID and INPUT_VALUE_ID.
• PAY_ASSIGNMENT_ACTIONS (PAA1 and PAA2) is referenced twice to relate the locked action and the locking action respectively, and to align each with the correct PAYROLL_ACTION_ID.

The view text is a UNION ALL of two nearly identical branches. The first branch applies when PAI.ACTION_INFORMATION1 IS NULL and matches PAA1 by assignment action only. The second branch applies when PAI.ACTION_INFORMATION1 IS NOT NULL and additionally matches PAA1.PAYROLL_ACTION_ID to PAI.ACTION_INFORMATION1. This bifurcation handles both legacy and payroll-action-scoped element definitions without duplicate rows.

Key Columns

• ASSIGNMENT_ACTION_ID — Projected from LCK.LOCKING_ACTION_ID. Identifies the assignment action whose element results are being reported. This is the column users most frequently search for, and it is the join key back to PAY_ASSIGNMENT_ACTIONS and related payroll run objects.
• ELEMENT_NAME — SUBSTR of PAI.ACTION_INFORMATION4 limited to 30 characters. The display name of the earnings or deduction element.
• E_OR_D — SUBSTR of PAI.ACTION_INFORMATION5 limited to 2 characters. Indicates whether the element is an earning (E) or a deduction (D), driving payslip grouping.
• ELEMENT_VALUE — Taken from PET.RESULT_VALUE. The calculated monetary result for the element on the referenced assignment action.

Common Use Cases and Queries

The primary consumer is the Irish Payslip Advice Report, which reads the view to print itemized earnings and deductions per assignment action. A typical diagnostic query retrieves element detail for a known action:

• SELECT assignment_action_id, element_name, e_or_d, element_value FROM apps.pay_ie_ear_ded_v WHERE assignment_action_id = :p_assignment_action_id ORDER BY e_or_d, element_name;
• Reconciling element results against PAY_ASSIGNMENT_ACTIONS or PAY_RUN_RESULTS for a payroll period.
• Verifying that element definitions in the 'EMEA ELEMENT DEFINITION' category are correctly linked to input values on PAY_IE_PAYMENT_VALUES_V.
• Filtering by e_or_d = 'D' or 'E' to separate deduction and earning totals per payslip.

Because the view is read-only and derives its action identifier through interlock relationships rather than direct assignment action storage, queries should join back to PAY_ASSIGNMENT_ACTIONS when broader payroll context such as payroll period or assignment is required.