Search Results this_pay

Overview

APPS.PAY_IE_P45_PAYE_DETAILS is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as PAY.PAY_IE_P45_PAYE_DETAILS. It exposes Irish (IE) P45 payroll year-end detail, aggregating cumulative pay, tax, and Universal Social Charge (USC) figures for an assignment action. The view exists primarily to simplify Forms coding rather than to serve as a supported reporting interface; Oracle explicitly warns that it should not be queried or used to alter data, as its definition may change dramatically across minor or major releases.

In the context of Oracle EBS 12.1.1 and 12.2.2, the view is a presentation layer over the Irish payroll P45 processing logic. It surfaces the monetary and reference values that a P45 form generation or archival routine requires, presenting them in a flat, form-friendly projection so that concurrent programs and Forms blocks can retrieve the relevant totals without reconstructing the underlying legislative calculations directly. The presence of a TOTAL_PAY column places it in the family of views used when reporting gross pay totals and their associated deductions for statutory Irish end-of-employment documentation.

Underlying Base Objects

The documented dependencies show that the view is defined over a combination of payroll transaction tables, assignment/action context tables, and legislative reference data, together with supporting PL/SQL. The base objects include PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_LEGISLATION_RULES, and PER_TIME_PERIODS. The FND_DATE package and the PAY_IE_P45_ARCHIVE package are also referenced, the latter indicating that the view participates directly in the P45 archival flow. Correspondingly, APPS.PAY_IE_P45_ARCHIVE references this view, confirming a bidirectional relationship between the archive package and the P45 paye detail projection.

The reliance on PAY_LEGISLATION_RULES and PER_TIME_PERIODS reflects the Irish legislative basis: tax credits, standard cut-off points, and USC thresholds are derived from legislative rules and period definitions rather than being hard-coded. The join to PAY_ASSIGNMENT_ACTIONS anchors each row to a specific assignment action, while PAY_ACTION_INFORMATION and PAY_PAYROLL_ACTIONS supply the running action totals.

Key Columns

The view exposes seventeen columns. The primary key-like column is ASSIGNMENT_ACTION_ID (NUMBER), which links each row to a processed assignment action. Cumulative monetary values include TOTAL_TAX, TOTAL_PAY, TOTAL_USC, and TOTAL_USC_PAY, each NUMBER. Period-level context is provided by MONTH_NO and WEEK_NO.

• MONTHLY_TAX_CREDIT, MONTHLY_STD_CUT_OFF, WEEKLY_TAX_CREDIT, WEEKLY_STD_CUT_OFF — the Irish tax credit and standard rate cut-off values applied on a monthly and weekly basis.
• TOTAL_PAY — the cumulative gross pay figure, central to the user's search for "total_pay".
• LUMP_SUM — any lump-sum payment element included in the P45 calculation.
• TOTAL_TAX, EMERGENCY_TAX — tax deducted and any emergency-basis tax indicator or value.
• THIS_PAY, THIS_TAX, THIS_USC_PAY, THIS_USC — VARCHAR2 text representations of the current-period pay, tax, and USC figures.
• TOTAL_USC, TOTAL_USC_PAY — cumulative Universal Social Charge and the pay amount on which it is assessed.

Common Use Cases and Queries

Because the view is a Forms-support supplementary view, its practical use is limited to P45 processing, archival, and diagnostic verification of cumulative totals for a given assignment action. The canonical query retrieves all exposed columns:

• SELECT ASSIGNMENT_ACTION_ID, MONTH_NO, WEEK_NO, TOTAL_PAY, TOTAL_TAX, TOTAL_USC FROM APPS.PAY_IE_P45_PAYE_DETAILS;
• To inspect a single assignment action: SELECT * FROM APPS.PAY_IE_P45_PAYE_DETAILS WHERE ASSIGNMENT_ACTION_ID = :p_action_id;
• To compare monthly and weekly cut-offs: SELECT MONTH_NO, MONTHLY_TAX_CREDIT, MONTHLY_STD_CUT_OFF, WEEKLY_TAX_CREDIT, WEEKLY_STD_CUT_OFF FROM APPS.PAY_IE_P45_PAYE_DETAILS;
• To reconcile USC totals against gross pay: SELECT TOTAL_PAY, TOTAL_USC_PAY, TOTAL_USC FROM APPS.PAY_IE_P45_PAYE_DETAILS WHERE TOTAL_PAY > 0;

Users seeking "total_pay" should note that TOTAL_PAY is a cumulative numeric value tied to ASSIGNMENT_ACTION_ID, not a standalone payroll balance. For production reporting, Oracle recommends querying the underlying payroll tables or using supplied reports rather than this view, which is subject to change without notice.