EPY: Why Does the Check Reconciliation Report pay015B.Sqr Not Create Expected Data After Updating to PUM Image 40 and Beyond? (Doc ID 2963002.1)

Last updated on JULY 21, 2023

Applies to:

Goal

After Updating to the latest PUM Image there appears to be changes made to the Check Reconciliation process.

When running the Check Reconciliation report, PAY015B.SQR, the report details like the check number, amounts, transit number and account number are missing.

When reviewing the code, it looks like the values stored in the TRANSIT_NUM and ACCOUNT_NUM fields have been moved to the PS_PY_BNKACCT_XREF table.

Check Reconciliation is a two-part process, consisting of PAY015A and PAY015B.  Below is the navigation for both:

     PAY015A: Payroll for North America > Periodic Payroll Events USA > Check Reconciliation > Reconciliation Request
     PAY015B: Payroll for North America > Periodic Payroll Events USA > Check Reconciliation > Reconciliation Report

1) What PUM was this change made?

2) What is the reason for this change? 

3) How does the PS_PY_BNKACCT_XREF table get updated?

4) What steps are required to make this work again?
 

Solution

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