ORA-01422 exact fetch returns more than requested number of rows in Package hr_maintain_proposal_swi Procedure insert_salary_proposal (Doc ID 761663.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Relevancy checked 10-Jan-2014***

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production and Patch:

When attempting to add a new salary for one particular employee on the Salary Admin Page the
following error occurs:

ERROR
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms