GP CHE: Payments preparation process fails in case of retro reversal (Doc ID 2135506.1)

Last updated on NOVEMBER 23, 2019

Applies to:

Symptoms

Whenever you try to run a payment preparation process for CHE in case of retro reversal, the SQL step 05 will fail due to a SQL error in the code. 

STEPS

========

1. Navigate to Global Payroll and Absence Management > Payment Processing > Run Payment Prep Process CHE

2. Add a new run control ID and click add

3. Select the appropriate Calendar Group (ex. until Aug 2015) check all processing phases and options and click run

4. Navigate to Workforce Administration > Job Information > Job Data

5. Search for an employee id included in the calendar group and load the page.

6. Terminate the employee in Job data for the Effective date (ex. 7/15/2015) with a new row of data

7. Navigate to Global Payroll & Absence Mgmt > Payee Data > Assign Earnings and Deductions > One Time (Positive Input)

8. Delete positive Input for another employee (ex. KWG107) for the Month (ex. Aug 2015)

9. Navigate to Global Payroll and Absence Management > Payment Processing > Run Payment Prep Process CHE

10. Add a new run control ID and click Add

11. Select the Calendar Group (ex. Sep 2015) Check all Processing Phases and Options and click Run.

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.