Search Results assignment_validations_aggr

Overview

PAY_GB_RTI_FPS_VALIDATE is a UK-specific Oracle Payroll package that supports Real Time Information (RTI) reporting to HM Revenue & Customs. Its stated purpose is to fetch archived data for RTI Full Payment Submission (FPS) processes and validate that data before submission. The package is declared AUTHID CURRENT_USER and resides in the APPS schema. It was created in April 2012 (version 115.0, bug 13918120) and subsequently modified to extend footer validations, to return a result value for header validations, and to introduce procedures supporting aggregated scenarios. The package operates against the archived action information structures maintained by the companion package PAY_GB_RTI_FPS, which supplies the action_info_table and act_info_rec types used as input parameters.

Key Procedures and Functions

Ten procedures are documented for this package, covering header, person, assignment, National Insurance, footer, and economic validation stages of the FPS lifecycle:

• HEADER_VALIDATIONS — Validates the FPS submission header for a given payroll action and returns a status flag through an OUT parameter. A package history entry records that this procedure was modified to return a value for header validations.
• PERSON_ADDRESS_VALIDATIONS — Validates person and address data for an individual (non-aggregated) RTI scenario, returning an EDI validation failure indicator.
• PERSON_ADDR_VALIDATIONS_AGGR — Aggregated counterpart to the person/address validation, added in version 115.3 (bug 14393796). It accepts additional action information record parameters to support aggregated reporting scenarios.
• ASSIGNMENT_VALIDATIONS — Validates assignment-level data for an individual RTI scenario and returns an EDI validation failure indicator.
• ASSIGNMENT_VALIDATIONS_AGGR — Aggregated counterpart to the assignment validation, also introduced in version 115.3.
• NI_VALIDATIONS — Performs National Insurance number and related validation checks on the RTI data.
• FOOTER_VALIDATIONS — Validates the FPS submission footer; modified in version 115.1 to extend footer validation logic.
• ECON_VALIDATE — Supports economic validation checks against the archived RTI data.
• VALIDATE_INPUT — Performs input parameter validation prior to the substantive validation routines.
• DATE_VALIDATE — Validates date values encountered within the RTI FPS data set.

Tables Accessed

The package reads from and writes to the following tables through APPS synonyms:

• PAY_PAYROLL_ACTIONS — Provides the payroll action context for the RTI process being validated.
• PAY_ASSIGNMENT_ACTIONS — Supplies assignment-level action rows used by the assignment validation routines.
• HR_ORGANIZATION_INFORMATION — Source of organisation-level attributes required during header and economic validation.
• PER_ALL_PEOPLE_F and PER_ADDRESSES — Person and address data validated by the person and address procedures.
• PER_ALL_ASSIGNMENTS_F — Assignment data validated by the assignment procedures.
• PAY_MESSAGE_LINES and PAY_MESSAGE_LINES_S — Message line records used to log or surface validation errors and outcomes.

Usage Notes

PAY_GB_RTI_FPS_VALIDATE is not an end-user facing API; it is invoked in the background as part of the UK RTI FPS processing flow, typically from the RTI FPS submission concurrent program or from the parent PAY_GB_RTI_FPS package. It is referenced by one other package in the documented ETRM metadata, confirming its role as a subordinate validation module rather than an entry point. Customisations and diagnostics should treat the package as internal. The header_validations procedure is the appropriate starting point when investigating header-level validation failures, as it returns a status flag indicating whether the submission header passed validation. Because the package is UK legislative and statutory in nature, it is delivered under the APPS schema with restricted support and should be patched only through standard Oracle patch application.