My Oracle Support Banner

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:

Oracle Human Resources - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.


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:


ORA-06550: line 1, column 12695:
PLS-00371: at most one declaration for 'L_COLLECTIVE_AGREEMENT_ID' is permitted
ORA-06550: line 1, column 12695:
PL/SQL: Statement ignored
ORA-06550: line 1, column 17425:
PLS-00371: at most one declaration for 'L_COLLECTIVE_AGREEMENT_ID' is permitted
ORA-06550: line 1, column 14084:
PL/SQL: Statement ignored

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


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.