AME Approval Error "ORA-01427: single-row subquery returns more than one row" or "an Invalid Setup has been detected for the current Transaction Type in Approvals Management " (Doc ID 1501681.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Scenario 1

When managers tries to terminate employee (who is supervisor) from self-service, get following error :

ERROR
----------------------------------
Your changes have not been sent for approval because the following error occurred : ORA-01427: single-row subquery returns more than one row


What is Working
1. if the subordinates are moved to another manager and then terminate the manager, then there is no error.  

2. termination from PUI works fine


Steps to Reproduce
Use responsibility : manager self-service
Navigation :terminations
employee terminations: people in hierarchy
1. press action against an employee

2. termination:effective date options
enter last day of service : 30-oct-2012

3. press continue
termination screen
shows warning : this person is serving as main appraiser for one or more appraisals in progress...

enter reason : resignation

4. press next

5. press submit
get error

Scenario 2

When changing personal information from self-service, approvers to do show, instead error is shown on review page

ERROR
----------------------------------
an Invalid Setup has been detected for the current Transaction Type in Approvals Management

  


Steps to Reproduce
Use responsibility : Employee Self Service
Navigation :Personal Information

1.change a detail like for example first name

2.press next



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