My Oracle Support Banner

Social Insurance Pay Base Retro Error (Doc ID 2568686.1)

Last updated on JULY 23, 2019

Applies to:

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


On : version, AE - United Arab Emirates Legislation

When we run the retro for person number "1234", the following error is encountered:

"A system error ORA-20001: The employment level entered is not eligible for the element Social Insurance Pay Base Retro on 2019-07-01. Details: You cannot grant the element to the payroll relationship, terms or assignment unless it meets the element eligibility criteria and has an element costing record. Ensure that a suitable element costing rule exists for the element, and that the eligibility criteria for a person matches those defined on the costing rule. ORA-06512: at "FUSION.PAY_RETRO_PKG", line 1816 ORA-06512: at 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. Submit the Retroactive pay process
2. Error encountered




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.