Search Results pai_add

Overview

APPS.PAY_IE_P45_ADDRESS_DETAILS is a reporting view within the Oracle E-Business Suite Payroll module that exposes archived address information captured during the generation of Irish P45 end-of-employment tax documents. The view is part of the PAY_IE_P45_ARCHIVE construct, a package and supporting object set used to persist the exact address data reported to the Irish Revenue Commissioners at the time a P45 was produced. Because statutory P45 output must reflect the values in effect when the document was issued rather than current employee records, this view reads from archived action information rather than from live HR address tables.

The user search term "ie_postal_code" is directly relevant: the POST_CODE column is derived from an Irish postal code lookup, and the view is one of the few places where P45-era postal code data is surfaced for reconciliation and audit. The view returns one row per assignment action associated with a completed Irish P45 archive payroll action, making it suitable for statutory reporting, payroll audit, and downstream integration.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is owned by APPS and is defined over the following referenced base objects:

• PAY_PAYROLL_ACTIONS (SYNONYM) — supplies the payroll action header, filtered to REPORT_TYPE = 'P45', REPORT_QUALIFIER = 'IE', REPORT_CATEGORY = 'ARCHIVE', and ACTION_STATUS = 'C' (completed).
• PAY_ASSIGNMENT_ACTIONS (SYNONYM) — joins on PAYROLL_ACTION_ID to provide the assignment-level action and the ASSIGNMENT_ACTION_ID used as the driving key.
• PAY_ACTION_INFORMATION (SYNONYM) — holds the archived address values in ACTION_INFORMATION5 through ACTION_INFORMATION12, joined on ACTION_CONTEXT_ID with ACTION_CONTEXT_TYPE = 'AAP' and ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'.
• PAY_IE_P45_ARCHIVE (PACKAGE) — provides the GET_LOOKUP_MEANING function used to decode the Irish county and postal code lookups.

The join is row-per-assignment-action, with the USE_NL hint indicating a nested-loops execution plan driven from PPA to PAA to PAI_ADD.

Key Columns

• ASSIGNMENT_ACTION_ID — the primary correlation key to the assignment action, used to link back to payroll run results and P45 archive rows.
• ADDRESS1, ADDRESS2, ADDRESS3 — the first three address lines, sourced from ACTION_INFORMATION5, 6, and 7 respectively, each truncated via SUBSTR to 30 characters.
• COUNTY — decoded from ACTION_INFORMATION9 through GET_LOOKUP_MEANING for the 'IE_COUNTY' lookup type.
• POST_CODE — decoded from ACTION_INFORMATION12 through GET_LOOKUP_MEANING for the 'IE_POSTAL_CODE' lookup type. This is the column returned when users search on "ie_postal_code".
• PHONE_NO — returned as a literal NULL, retained for structural compatibility with the P45 address record layout.

Common Use Cases and Queries

Typical uses include auditing the addresses printed on archived Irish P45s, reconciling postal codes against the IE_POSTAL_CODE lookup, and feeding address data to downstream tax-reporting integrations.

Sample query retrieving address details for a completed Irish P45 archive:

• SELECT assignment_action_id, address1, address2, address3, county, post_code FROM apps.pay_ie_p45_address_details WHERE post_code IS NOT NULL;
• SELECT d.assignment_action_id, d.address1, d.post_code FROM apps.pay_ie_p45_address_details d WHERE d.county = 'DUBLIN';

Because POST_CODE is decoded via a package function, filters on that column may prevent index use; restricting the driving set through PAY_PAYROLL_ACTIONS or ASSIGNMENT_ACTION_ID first generally yields the best performance.