ORA-01422 Exact Fetch Returns More Than Requested Number Rows In Hr_maintain_proposal_swi
(Doc ID 1673527.1)
Last updated on AUGUST 10, 2020
Applies to:Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to add a new salary for one particular employee on the Salary Admin Page the following error occurs:
ORA-01422: exact fetch returns more than requested number of rows in Package hr_maintain_proposal_swi Procedure insert_salary_proposal
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. HR Manager Responsibility
2. People --> Enter and Maintain --> Query Employee
3. Click Assignment --> Salary --> Add New Salary
4. After entering details and clicking Apply, getting this 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