R12: Cash Management Payroll EFT Payments NACHA And Batch Reconciliation (Doc ID 1359075.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payroll - Version 12.0 HRMS RUP11 to 12.2.4 [Release 12.0 to 12.2]
Oracle Cash Management - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

A. Reconciliation of Payroll EFT Payments?
B. Reconciliation is not working for Payroll Checks with Zero Padded?

C. Auto Reconciliation of Payroll EFT fails due to leading spaces generated during batch name derivation.

D. Reconcile Manually Payroll EFT Payments:
E. BACS process has been customized to summarize lines and pay as one amount (batch level):
CM reconciliation however occurs at line level, meaning that reconciliation of Bank statements based on transaction number has become impossible. Is there any way to reconcile at summary level within CM?
Customer confirmed that customization applied as follows:
1). Seeded BACS request is run.
2). BACS output file is generated.
3). Custom BACS program reads this file and puts it in a table, identifying specific fields in the standard 18 format seeded BACS file like Account Number, Sort Code, Reference Field, Name etc..
4). Records in the table are selected and grouped by the account number and sort code.
5). Grouped data is again written to a custom BACs file, maintaining the Standard18 format

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms