Results for “reverse_consol_id”

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

Overview

PAY_REVERSE_PAYROLL_V is a reporting view owned by the APPS schema within the Payroll (PAY) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented purpose is to support the user interface of the Reverse Payroll flow, presenting those payroll actions that are eligible for reversal together with the consolidation set information required to interpret them. Functionally, it is a candidate-selection view: it returns only payroll actions of type 'R' (Reverse) and 'Q' (QuickPay/related reversal context) whose assignment actions have reached a status of 'C' (Completed), and it excludes any action currently locked by a PAY_ACTION_INTERLOCKS record, thereby preventing concurrent or conflicting reversal attempts.

The view is session-aware. It joins FND_SESSIONS and filters on USERENV('SESSIONID'), and it constrains all effective-dated joins (PER_ALL_ASSIGNMENTS_F, PAY_PAYROLLS_F, PAY_RUN_TYPES_F_VL) to the session effective date. This ensures the form or concurrent program invoking the view sees data consistent with the user's current date-track context. The user search term "consolidation_set_name" is directly relevant here: the view exposes both the consolidation set name of the payroll action and the consolidation set name of the payroll being reversed, which is central to correctly interpreting reversal scope.

Underlying Base Objects

The view is defined over the following documented base objects:

• PAY_PAYROLL_ACTIONS (synonym) — the driver table, aliased PPA, supplying effective date, action type, consolidation set, and audit columns.
• PAY_ASSIGNMENT_ACTIONS (synonym) — aliased PAA, supplying assignment-level detail and action status.
• PAY_CONSOLIDATION_SETS (synonym) — joined twice (PCS and PCS2) to resolve the action's consolidation set name and the reverse consolidation set name.
• PAY_PAYROLLS_F (view) — aliased PPF, the payroll definition carrying CONSOLIDATION_SET_ID for the reversed payroll.
• PER_ALL_ASSIGNMENTS_F (synonym) — PAF, linking assignment to payroll and effective dates.
• PAY_RUN_TYPES_F_VL (view) — PRT, an outer-joined source of run type names.
• HR_LOOKUPS (view) — HR_T, resolving the ACTION_TYPE lookup code to a meaning.
• FND_SESSIONS (synonym) — the session date-track source.
• PAY_ACTION_INTERLOCKS (synonym) — used in the NOT EXISTS clause to exclude locked actions.

Packages HR_API, HR_GENERAL, and HR_SECURITY are also referenced, supporting security and API-level logic applied through the view's dependencies.

Key Columns

• CONSOLIDATION_SET_NAME — name of the consolidation set assigned to the payroll action (from PAY_CONSOLIDATION_SETS via PCS).
• REVERSE_CONSOL_NAME — name of the consolidation set on the payroll being reversed (via PCS2, keyed from PAY_PAYROLLS_F).
• REVERSE_CONSOL_ID — the corresponding consolidation set identifier on the payroll definition.
• ACTION_TYPE / ACT_TYP_MEANING — the raw action type and a decoded meaning, suffixed with the run type name where a run type exists.
• ACTION_STATUS — assignment action status; the view returns only 'C' (Completed) rows.
• PAYROLL_ACTION_ID, ASSIGNMENT_ACTION_ID, SOURCE_ACTION_ID — identifiers linking the reversal to its originating action.
• EFFECTIVE_DATE, BUSINESS_GROUP_ID, ASSIGNMENT_ID, PAYROLL_ID — the standard date-track, operating unit, assignment, and payroll keys.

Common Use Cases and Queries

Typical usage is to drive a reversal LOV or verification report, confirming which completed actions may be reversed and under which consolidation set. A representative query is:

• SELECT payroll_action_id, action_type, act_typ_meaning, action_status, consolidation_set_name, reverse_consol_name, reverse_consol_id, effective_date, assignment_id, payroll_id FROM apps.pay_reverse_payroll_v WHERE consolidation_set_name = :p_cons_name ORDER BY effective_date DESC;
• SELECT DISTINCT consolidation_set_name, reverse_consol_name FROM apps.pay_reverse_payroll_v ORDER BY consolidation_set_name;
• SELECT assignment_id, payroll_action_id, act_typ_meaning FROM apps.pay_reverse_payroll_v WHERE action_type = 'R' AND action_status = 'C';

Because the view depends on FND_SESSIONS and USERENV('SESSIONID'), it must be queried within an active EBS session (for example, from a form or a concurrent program invoked in-session); direct SQL*Plus queries outside a form session may return no rows unless a matching session row exists. Queries should therefore restrict on consolidation set name, action type, or assignment to narrow result sets in interactive use.