Search Results fnd_sessions_u1




Overview
Explore in AI Chat

Overview

APPS.PAY_IE_SOE_PRSI_DETAILS_V is a reporting view in the Oracle E-Business Suite Payroll (PAY) module, designed to expose Irish Pay Related Social Insurance (PRSI) detail information for a payroll assignment action. The view aggregates the "Contribution Class" and "Subclass" input values attached to element entries created from the seeded "IE PRSI Detail" element, which is legislated for Ireland (legislation_code = 'IE'). It returns one summarized row per assignment_action_id, presenting the PRSI contribution class and any overridden subclass value as discrete columns derived from the normalized pay_run_result_values rows.

This view is typically consumed by statutory reporting features such as the Irish Statement of Earnings (SOE) and related PRSI reporting extracts. Rather than requiring the calling process to pivot the underlying input value rows manually, the view performs the DECODE/MAX pivot internally, presenting the two attributes side by side alongside the assignment action identifier that links the data to a specific payroll run result. Its role is therefore one of denormalization and convenience for downstream reporting and integration, rather than transactional processing.

Underlying Base Objects

The view is defined over five documented base objects, all referenced in the APPS schema via synonyms:

  • FND_SESSIONS — Supplies the current effective session date through FND_SESSIONS, filtered on session_id = USERENV('sessionid'). The session's effective_date is used to drive effective-dated joins.
  • PAY_ELEMENT_TYPES_F — The element type definition table. It is filtered to element_name = 'IE PRSI Detail' and legislation_code = 'IE'. This is where the PAY_ELEMENT_TYPES_F_UK2 index is referenced, matching the user's search term.
  • PAY_RUN_RESULTS — The payroll run results table, joined to the element type and providing the assignment_action_id returned by the view.
  • PAY_INPUT_VALUES_F — Defines the input values for the element, filtered to the names 'Contribution Class' and 'Subclass', effective-dated against the session date.
  • PAY_RUN_RESULT_VALUES — Stores the actual value captured for each input value on a run result, joined via run_result_id and input_value_id.

Effective dating is enforced by requiring the session effective_date to fall between the effective_start_date and effective_end_date of both the element type and the input value definitions.

Key Columns

  • ASSIGNMENT_ACTION_ID — Identifier linking the summarized PRSI detail to a specific payroll assignment action; the view groups by this column.
  • CONTRIBUTION_CLASS — The result value of the input value named 'Contribution Class', extracted by DECODE and aggregated with MAX.
  • OVERRIDDEN_SUBCLASS — The result value of the input value named 'Subclass', similarly extracted and aggregated. The name implies the value represents a subclass that overrides the default PRSI classification.

Common Use Cases and Queries

Typical usage retrieves PRSI classification for payroll reporting or validates captured input values during reconciliation:

  • Feeding Irish SOE / PRSI statutory extracts with contribution class and subclass detail.
  • Auditing which assignment actions carried an overridden subclass.
  • Reconciling payroll run results against expected PRSI classifications.

Illustrative query:

  • SELECT assignment_action_id, contribution_class, overridden_subclass FROM apps.pay_ie_soe_prsi_details_v WHERE assignment_action_id = :p_action_id;

Because the view depends on USERENV('sessionid') and effective-dated joins, it must be queried within a valid EBS session context, ensuring the session effective date aligns with the element type and input value effective periods.