Payroll Archive Incorrectly Processes Retropay Elements If Two Different Runs In A Pay Period (Doc ID 1513340.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Custom online payslip that queries off the pay_ac_emp_earn_action_info_v view that is tied to the archive table is getting the wrong results when there are multiple retropay entries in multiple quick pays

Example:

Quick Pay 1 - 16 Retro hours 236.00

Archive after QP1 shows:
ACTION  INFO8 (CURRENT AMT) ACTION INFO9 (YTD AMOUNT) ACTION INFO11 (CURRENT HOURS) ACTION INFO12 (YTD HOURS)
236 0 8 0
236 472 8 16






Quick Pay 2 - 16 Retro hours 236.00

Archive for Quick Pay 2
  - 4 rows for BASE PAY R:

ACTION INFO8 (CURRENT AMT) ACTION INFO9 (YTD AMOUNT) ACTION INFO11 (CURRENT HOURS) ACTION INFO12 (YTD HOURS)
0 0 0 0
236 0 8 0
236 0 8 0
236 944 8 32








In the payslip, they are seeing 24 hours (sum of ACTION INFO 11 rows) and 708.00 (sum of ACTION INFO8 rows)

 


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

For this example:
Step 1: Created BASE PAY element entry in a period that is already processed.
Step 2: Processed Retro jobs to create BASE PAY RETRO in period ending 27-MAY-2012.
Step 3: Processed Quick Pay, Quick Pay Prepayments and Payroll Archive.
Step 4: Created BASE PAY element entry in a period that is already processed.
Step 5: Processed Retro jobs to create BASE PAY RETRO in the same period ending 27-MAY-2012.
Step 6: Processed Quick Pay, Quick Pay Prepayments and Payroll Archive.
Both the Retro Entries are created in the same pay period and quick pay and Payroll Archive are processed for the same time period.
Base Pay Retro is the retro element for element – BASE PAY.




Cause

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