My Oracle Support Banner

Troubleshooting Retropay: How to Use SQL to Find the Source of Retro Entries (Doc ID 2080545.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Payroll - Version and later
Information in this document applies to any platform.


Oftentimes, Retropay by Element or Retropay (Enhanced) creates one or more retro entries that are unexpected and the user is unable to find an explanation for the creation of the entries. 

This document is intended to provide information about using SQL queries to help find the source of those entries.  Attached is a document showing two examples of how this is accomplished.


Troubleshooting Steps

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
Troubleshooting Steps
 Step 1:  Examine the pay_process_events table
 Step 2: Examine the pay_element_entries_f table
 Step 3: Find the source of the retro entry
 A. If the CREATOR_TYPE is 'EE'
 B. If the CREATOR_TYPE is "RR'

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