In Employee Self Service (ESS), No Data is Shown for Prepayments and for QuickPay Prepayments it is Showing Duplicate Records (Doc ID 2959216.1)

Last updated on JULY 10, 2023

Applies to:

Symptoms

When profile 'PAY: Enable Pay Method Changes in Next Pay Period' is set to 'Yes', there are two issues with Payment Methods in Employee Self Service (ESS) for employees with multiple Payment Methods.
  a.  Payment Method will not show up if the prepayment is run for all employees together for a Payroll Run.
      The action type is P not U as coded in the query of FuturePaymentsPLSQLVO, but if Quickpay Prepayment is run, the action type shows as U.

  b. Payment Methods are duplicated in Manager Payment Methods. FuturePaymentsPLSQLVO is probably missing a condition AND sysdate BETWEEN opm.effective_start_date AND opm.effective_end_date


The issue can be reproduced at will with the following steps:

1. In System Administrator responsibility, Navigate to Profiles -> System and set the profile options as below:
   a. Set profile PAY: Enable Pay Method Changes in Next Pay Period to Yes
   b. Set profile PAY: Allow Paymethod Changes after Prepayments to No
2. Under Employee Self Service responsibility, Navigate to Manage Payroll Payments and Enter multiple Pay Methods for Employee as required.
3. Under HRMS Manager responsibility, Run QuickPay and Quick Prepayments for Employee.
4. Under Employee Self Service responsibility, Navigate to Manage Payroll Payments and modify the pay Methods for Employee as required.
5. Rollback QuickPay and Quick Prepayments run of Step 3.
6. Navigate to Payroll -> Payment Methods, make any changes in the Payment Method in Update mode
7. Rerun QuickPay and Quick Prepayments.
8. Run a Quickpay and quickpay Prepay for Next Period
9. In Employee Self Service, navigate to Manage Payroll Payments

Changes

Cause

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