My Oracle Support Banner

Payroll Check_Issue_Date Mismatch (Doc ID 2565727.1)

Last updated on APRIL 27, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

While Reconciliation of check which are cleared, some checks are having mismatch on check issue date.
Bank is fetching the check issue date from positive pay file which we send to bank after every payroll.

While reconciliation of cleared checks we are looking into PAY_PAYROLL_REL_ACTIONS (for SERIAL_NUMBER as Check Number) record and PAY_PAYMT_SEARCH_RESULTS_VL (for PAYMENT_DATE as check issue date) record. We are joining these two records on PRE_PAYMENT_ID field.

The request is:
When user wants to validate a check number, check issue date and check amount, what are the tables/ fields that user need to refer in HCM Cloud ?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.