Fusion Global Payroll: 'ORA-01795: maximum number of expressions in a list is 1000' Error When Attempt to Delete an Absence Element (Doc ID 2977049.1)

Last updated on OCTOBER 05, 2023

Applies to:

Symptoms

On : 11.13.23.07.0 version, Global Payroll

When attempting to delete a newly created absence element the following error occurs.

ERROR
-----------------------
'ORA-01795: maximum number of expressions in a list is 1000'.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to delete absence element.
2. Error occurs.

Cause

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