My Oracle Support Banner

Retro process error for multiple assignments employee with different payrolls attached (Doc ID 2715605.1)

Last updated on SEPTEMBER 30, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Global Payroll

When attempting to run retro process for an employee having multiple assignments with different payrolls attached  below error occurs

A system error ORA-20001: The identifier 300000058948405 for the payroll relationship, employment terms, or assignment passed to the entry level ID parameter is invalid. Details: The employment level ID included with the entry for the Salary Retroactive element must be a valid ID number for the employment level indicated. The employment level must also match the employment level at which entries can be created for this element. For example, you can't use an assignment ID to create a terms level entry, and the assignment occurred in table pay_retro_pkg.create_retro_entry at location 3065. Contact your help desk

The issue can be reproduced at will with the following steps:
1. run retro
2. error occurs




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

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