Error FRM-40735 ON-UPDATE TRIGGER RASIED UNHANDLED EXCEPTION ORA-01422 When Trying to Reverse Termination From End Employment Form
(Doc ID 2931241.1)
Last updated on FEBRUARY 28, 2023
Applies to:
Oracle Payroll - Version 12.1 to 12.2 [Release 12.0 to 12.2]Oracle Human Resources - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Symptoms
Problem Statement:
When attempting to reverse termination for one employee, the following error occurs on End Employment form:
PYUPIP Trace is showing:
Sqlerrm>ORA-01422: exact fetch returns more than requested number of rows<
On PYUPIP Trace, above the error, the affected element link id is shown:
begin hr_entry.entry_asg_pay_link_dates
p_session_date:
p_assignment_id:
p_element_link_id: (for example: 2653)
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1) Using HRMS Manager Responsibility.
2) (N) People > Enter and Maintain.
3) Search for the employee > (B) Others > End Employment > Click on Reverse Termination button.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |