Search Results convert_2_xml

Overview

PAY_GB_RTI_FPS_OUTPUT is a United Kingdom-specific Oracle Payroll package body that supports Real Time Information (RTI) reporting to HM Revenue & Customs. Its stated purpose, per the package header, is to fetch archived data produced by RTI Full Payment Submission (FPS) processes, convert that data into XML format, and merge the resulting XML with an EText file to generate the statutory output. The package is owned by APPS and is classified as OTHER within the ETRM repository. It is a component of the legislative reporting infrastructure introduced for UK RTI compliance and is not intended for general-purpose payroll processing. The current header version, pygbrtifpsop.pkb 120.0.12020000.2, dates from March 2013 and carries the "noship" designation, indicating it is part of the shipped application code managed through Oracle's standard patching cycle. The package body is therefore relevant to both Oracle EBS 12.1.1 and 12.2.2 installations that have applied the UK RTI legislative patches.

Key Procedures and Functions

The package exposes five documented program units. A sixth private function, CONVERT_2_XML, appears in the visible source excerpt and is directly relevant to the search term supplied by the user; it converts an individual data value into an XML-tagged fragment, accepting the data value, a tag name, and optional datatype and format attributes. The five ETRM-documented units are:

• RANGE_CURSOR — a private procedure that returns the driving SQL string used by the Oracle Reports/Payroll action parameter architecture. Based on the visible source, it selects distinct PERSON_ID values by joining PER_PEOPLE_F to PAY_PAYROLL_ACTIONS on the current PAYROLL_ACTION_ID and business group, ordered by person.
• ACTION_CREATION — the action-creation routine invoked during the payroll action lifecycle to establish the assignment-level action rows required for the RTI FPS run.
• FPS_HEADER_PROC — assembles the header segment of the FPS XML document, including the submission identifiers and scheme-level information required by the HMRC schema.
• FPS_EMPLOYEE_PROC — builds the per-employee XML segments, drawing on the archived RTI data for each person processed within the action.
• END_OF_FILE — finalises the output, producing the trailer segment and completing the XML/EText merge.

Tables Accessed

The documented table references reflect the package's dual role of identifying the population to report and reading archived RTI payload data. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS (with its _S shadow table) supply the action context and assignment-level action rows needed for action creation and range processing. PER_ALL_ASSIGNMENTS_F, together with PER_PEOPLE_F in the range cursor, identifies the employees in scope. PAY_ACTION_INFORMATION holds the archived RTI data retrieved for XML conversion, and DUAL is used for singleton value derivations and PL/SQL expression evaluation.

Usage Notes

PAY_GB_RTI_FPS_OUTPUT is not referenced by any other documented package, confirming that it sits at the outer edge of the RTI reporting chain rather than acting as a shared utility. It is typically invoked through the UK RTI FPS concurrent program, which runs after the payroll action has completed and the RTI data has been archived. The generated XML is merged with the associated EText template to produce the file transmitted to HMRC. Because the package is UK legislative code, it is not exposed through standard Oracle Forms and should not be called directly from custom code; any extension or override must be implemented as a wrapper that respects the archived-data and EText contract described in the package header.