Search Results fetch_random_digit_bacs

Overview

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 is a UK-specific Oracle Payroll package that supports the Real Time Information (RTI) Full Payment Submission (FPS) process mandated by HM Revenue & Customs. Its purpose, as stated in the package header, is to fetch live data and National Insurance (NI) balances required by FPS RTI processes. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than its owner. It was originally created in December 2012 and was subsequently enhanced in March 2013 to add an assignment identifier OUT parameter to FETCH_HASH_FPS_PER. In Oracle EBS 12.1.1 and 12.2.2, the package serves as a data aggregation and hashing layer within the RTI reporting pipeline, supplying the NI contribution and PAYE figures that populate the FPS submission along with the associated BACS hashing values required for the RTI submission file.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, grouped by purpose:

• NI balance aggregation: GET_NI_BALANCES_FOR_ASG and GET_NI_BAL_PAYE_AGGR_FOR_ASG retrieve NI balance values for an assignment, populating the standard NI letter categories (A, B, C, D, E, J and L). GET_NI_ONLY_AGG_BAL_FOR_ASG — the routine matching the user's search term — returns aggregated NI-only balances for an assignment. GET_NI_ONLY_AGG_BAL_SUM_ASG produces summed NI-only aggregate balances, and GET_NI_ONLY_BAL_RTI_RPT provides NI-only balances specifically formatted for RTI reporting.
• Hashing and BACS utilities: FPS_HASH, FETCH_HASH_FPS_ASG and FETCH_HASH_FPS_PER generate hash values used in the FPS submission; the per-assignment variant was modified to return the assignment identifier. FPS_BACS_SHA_256 performs SHA-256 hashing for BACS data. BACS_RANDOM_DIGIT and FETCH_RANDOM_DIGIT_BACS derive the random digits required for BACS reference validation.
• Processing control: FPS_BACS_PREPROCESS performs preparatory validation and setup for the BACS/FPS data set, while FPS_ROLLBACK and RESTORED handle reversal and restoration of FPS-related state when a process fails or must be unwound, safeguarding data integrity across the RTI run.

Tables Accessed

The package reads and writes the core Oracle Payroll and RTI tables. PAY_ACTION_INFORMATION and PAY_ASSIGNMENT_ACTIONS supply the assignment action context that drives balance retrieval. PAY_BALANCE_FEEDS_F, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES and PAY_BALANCE_DIMENSIONS provide the balance definitions and dimensions against which NI and PAYE balances are resolved. PAY_PAYROLL_ACTIONS and PAY_ACTION_INTERLOCKS govern payroll action state. RTI-specific storage resides in PAY_GB_FPS_DETAILS and PAY_GB_BACS_FPS. Payment and account configuration is drawn from PAY_ORG_PAYMENT_METHODS_F, PAY_PERSONAL_PAYMENT_METHODS_F, PAY_PAYMENT_TYPES, PAY_EXTERNAL_ACCOUNTS and HR_SOFT_CODING_KEYFLEX, which together determine how FPS payments and BACS instructions are constructed.

Usage Notes

PAY_GB_FPS_NI_AND_OTHERS_13 is not intended for direct end-user invocation. It is called internally by the UK RTI FPS processing programs and, per the ETRM metadata, is referenced by one other package, which orchestrates the overall FPS run. Implementation and support teams typically encounter it when tracing NI or hash values on an FPS submission, diagnosing BACS-related RTI errors, or extending the UK payroll legislative solution. Because the package is AUTHID CURRENT_USER and relies on APPS synonyms for all table access, custom code calling it must be executed in a context with the appropriate APPS grants. Any diagnostic or extension use should occur in a controlled, non-production environment, as the routines participate directly in the RTI submission lifecycle.