Search Results pqp_gb_psi_location_codes




Overview
Explore in AI Chat

Overview

PQP_GB_PSI_LOCATION_CODES is an Oracle Application Object Library package owned by the APPS schema that forms part of the Oracle Payroll legislative extensions for the United Kingdom. In Oracle E-Business Suite 12.1.1 and 12.2.2, it supports the statutory Payment Summary Information (PSI) reporting obligations that UK employers must satisfy for Her Majesty's Revenue and Customs. Specifically, the package manages the extraction, validation, and post-processing associated with the location codes that appear on statutory payment summary output.

The object is classified as OTHER within the Extract, Transform, Report model, reflecting its role as a supporting utility rather than a public application programming interface. Its status is VALID in the ETRM repository, and it is not referenced by any other documented package, which confirms that it operates as a leaf-level routine invoked principally through concurrent processing or from within the broader GB statutory reporting framework.

Key Procedures and Functions

  • LOCATION_EXTRACT_MAIN — The principal processing entry point. It drives the extraction of location-related data required for the PSI output, coordinating the reading and transformation of address and location information held against payroll and business group records.
  • CHK_LOCATION_CODES_CRIT — Applies the validation criteria governing location codes. It evaluates the location data against the rules required for successful PSI generation, allowing the parent process to identify and handle non-conforming records.
  • LOCATION_CODES_POST_PROCESSING — Performs the final stage of the location code workflow, executing the follow-up logic that must occur after the primary extract and validation steps have completed.
  • DEBUG, DEBUG_ENTER, DEBUG_EXIT, DEBUG_OTHERS — A standard instrumentation set. DEBUG controls diagnostic output, DEBUG_ENTER and DEBUG_EXIT mark procedure entry and exit boundaries for tracing, and DEBUG_OTHERS provides a centralised exception handler that records unexpected errors encountered during execution.

Tables Accessed

  • HR_LOCATIONS_ALL — The base locations table, supplying the address and location definitions validated and extracted during processing.
  • HR_LOCATION_EXTRA_INFO — The descriptive flexfield-bearing companion table, providing the additional location attributes required by the UK statutory definitions.
  • HR_UTILITY — A shared HR utility dependency used for common business-group and date-effective resolution logic.
  • PER_BUSINESS_GROUPS — Used to scope location processing to the correct business group, which is essential in multi-organisation installations.

Usage Notes

PQP_GB_PSI_LOCATION_CODES is an internal component rather than a callable business API. It is typically invoked indirectly by the UK PSI statutory reporting concurrent programs and related payroll processes; the ETRM record shows no external packages referencing it, so it is not exposed as a dependency for customer or partner extensions. Practitioners investigating PSI errors should treat the package as a diagnostic target: enabling its DEBUG instrumentation can surface location data that fails CHK_LOCATION_CODES_CRIT or that is not correctly resolved from HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO. Direct invocation from custom PL/SQL is not supported and should be avoided, since the routine relies on business-group context established by the calling payroll process. The package behaves consistently across 12.1.1 and 12.2.2, and no online form is documented as calling it directly.