Search Results pqp_gb_psi_functions




Overview
Explore in AI Chat

Overview

APPS.PQP_GB_PSI_FUNCTIONS is a PL/SQL package body within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Advanced Benefits module, specifically supporting the United Kingdom Pensions (Pension Scheme Information / PSI) statutory reporting requirements. The package provides the core business logic for the PQP Penserver Extract, a concurrent program that extracts pension scheme data for UK payroll employees and transfers it to an external pension provider ("Penserver"). It assembles employee eligibility, pay, and contract data into a structured extract file, validating each record against the criteria defined by the pension scheme configuration.

The object is owned by the APPS schema and holds a VALID status in ETRM for 12.2.2. The package is heavily integrated with Oracle Advanced Benefits (BEN) entities for person, result, and record handling, with Oracle Payroll (PAY) for element and run result data, and with Oracle HRMS (PER/HR) for assignment and people information. According to the documented metadata, the package is referenced by 13 other database objects, confirming its role as a foundational dependency rather than a leaf-level component.

Key Procedures and Functions

The package exposes approximately 50 procedures and functions. Documented examples include:

Tables Accessed

The package reads and writes a broad set of EBS tables via APPS synonyms. Benefit-related access includes BEN_BENEFIT_ACTIONS, BEN_EXT_DFN, and BEN_EXT_RSLT, which supply plan definitions and participant results. Payroll data is drawn from PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES — providing element classification, entry values, and processed run results used to compute pensionable pay. HRMS entities PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F supply assignment and person records. Concurrent program context is retrieved from FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS, and configuration is read from PQP_CONFIGURATION_VALUES, while PQP_GB_PSI_ALLOWANCE_HISTORY stores historical allowance data for the PSI calculation.

Usage Notes

PQP_GB_PSI_FUNCTIONS is normally invoked indirectly through the PQP Penserver Extract concurrent program, which is submitted from the UK Payroll responsibility during the pension scheme reporting cycle. It is not typically called from Oracle Forms; instead, concurrent program submission triggers the extract, which iterates qualifying employees, applies eligibility checks, computes pay and contract values, and writes formatted output to a file via FND_FILE. Because the package is referenced by 13 other objects, customisations that modify its specification risk cascading compile failures. Developers extending UK pension reporting should treat this package as a protected integration point and prefer configuration values over direct modification.