Search Results pay_gb_rti_fps




Overview
Explore in AI Chat

Overview

PAY_GB_FPS_NI_AND_OTHERS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports United Kingdom statutory payroll processing. Specifically, it underpins the Fast Payments Service (FPS) and Real Time Information (RTI) functionality required by HM Revenue & Customs, alongside associated National Insurance (NI) balance calculations and BACS payment file generation. The package is a core component of the Oracle Payroll UK localization, providing the computational logic that aggregates NI contributions, produces the cryptographic hashes embedded in FPS/BACS payment files, and manages the pre-processing and rollback of FPS submissions. In EBS 12.1.1 and 12.2.2 the package carries a status of VALID and is classified as an OTHER API, meaning it is not a public, supported interface but is invoked internally by Oracle's own payroll processes.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions. The balance-oriented routines — GET_NI_BALANCES_FOR_ASG, GET_NI_BAL_PAYE_AGGR_FOR_ASG, GET_NI_ONLY_AGG_BAL_FOR_ASG, GET_NI_ONLY_AGG_BAL_SUM_ASG, and GET_NI_ONLY_BAL_RTI_RPT — retrieve National Insurance contribution balances for an assignment, aggregate NI with PAYE amounts, and return NI-only figures for RTI reporting. The hashing routines — FPS_BACS_SHA_256, FPS_HASH, and BACS_RANDOM_DIGIT — generate SHA-256 digests and random digits used to secure and reference FPS/BACS transmissions. FETCH_RANDOM_DIGIT_BACS, FETCH_HASH_FPS_ASG, and FETCH_HASH_FPS_PER retrieve or compute those random digits and hashes at the assignment and person level respectively. FPS_BACS_PREPROCESS and FPS_ROLLBACK prepare payment data prior to submission and reverse the operation when processing fails. RESTORED is a utility procedure associated with state restoration.

Tables Accessed

The package reads and writes a range of payroll and payment tables through APPS synonyms. HR_SOFT_CODING_KEYFLEX provides account coding. PAY_ACTION_INFORMATION, PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS support payroll action tracking and interlock control. PAY_BALANCE_DIMENSIONS, PAY_BALANCE_FEEDS_F, PAY_BALANCE_TYPES, and PAY_DEFINED_BALANCES supply balance definitions and values used in NI aggregation. PAY_EXTERNAL_ACCOUNTS, PAY_ORG_PAYMENT_METHODS_F, PAY_PAYMENT_TYPES, and PAY_PERSONAL_PAYMENT_METHODS_F define the organisational and personal payment methods applied to BACS/FPS output. PAY_GB_BACS_FPS and PAY_GB_FPS_DETAILS store the generated UK-specific BACS and FPS records.

Usage Notes

PAY_GB_FPS_NI_AND_OTHERS is invoked automatically by Oracle Payroll UK processes and by the companion package PAY_GB_RTI_FPS, which both references and is referenced by it. It is not intended for direct invocation by customers. Its procedures are exercised during payroll run completion, RTI FPS submission, and BACS payment file creation, executing as the APPS schema user. Custom code should avoid calling it directly because its classification as an OTHER API means Oracle does not guarantee backward compatibility of its signatures across patch levels or releases. Any extension of UK FPS/RTI behaviour is best achieved through supported payroll configuration and the documented RTI processes rather than by circumventing this internal package.