Enter Private Vehicle Fails with "ORA-01422 exact fetch returns more than requested number of rows"

(Doc ID 1942559.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

When trying to enter private vehicle get following error in workflow:

ERROR
----------------------------------
ORA-01422 exact fetch returns more than requested number of rows

hr_workflow_ss..branch_on_approval_flag(HRSSA,365171,312181,RUN) wf_engine_Util.FunctionCall ....


This is only happening for few employees


Steps to Reproduce:
Use responsibility :Employee iExpenses
Navigation : > Private Vehicle Information

     1. Click on Add Private Vehicle

     2. Click on continue after filling the required details

     3. Click on submit



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