Mass Update Of Assignments, Errors: PLS-00371: At Most One Declaration Is Permitted (Doc ID 2430521.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

On 12.1.3 version RUP11, Human Resources - Person / Assignment Issues

Using the Mass Update of Assignment functionality to update the Supervisor information, receive the following error:

STEPS
The issue can be reproduced at will with the following steps:

1. Navigate to People > Mass Updates for Person > Mass Update of Assignments
2. Enter custom name in Name field > Click the Other Criteria field
3. Enter a supervisor name in Supervisor field > Click OK
4. Click cancel on the People Group - <Company name> Pay Group Flexfield pop-up window
5. Check the Employee checkbox > Click the Query button
6. On the Mass Assignment Update window - click continue on Decision Window
7. Click on the New Tab.
8. Click on the Change List field when the following screen appears
9. Enter the new Supervisor information in the Supervisor field and Change Reason = Supervisor Change > Click OK
10. Click Cancel on the GREs and other data window
11. Click Cancel on the People Group Flexfield
12. Choose Update in Datetrack Mode field > Click Create New button
13. Click OK on Note - Pending record(s) created on New Tab.
14. Click Submit on the Mass Assignment Update screen
15. Process ends in Error

Cause

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