My Oracle Support Banner

PAAGPPRW: Projects Agreement Workflow Failed Activity 'Get Next Approvers Using AME', Error Message 'ORA-01422: exact fetch returns more than requested number of rows' When an Employee/Approver is Linked to Multiple FND Users (Doc ID 2979999.1)

Last updated on OCTOBER 17, 2023

Applies to:

Oracle Project Billing - Version 12.2.9 and later
Information in this document applies to any platform.


When an employee/approver is linked to multiple fnd_users, Approval Management Engine (AME) fails to get the approver for Projects Agreement Workflow.

When viewing the workflow monitor to monitor the Projects Agreement Workflow, the following error appears on the page:

Failed Activity = Get Next Approvers using AME
Activity Type = function
Error name = -1422
Error Message = ORA-01422: exact fetch returns more than requested number of rows

Steps to reproduce:
1. Using a System Administrator responsibility, navigate to Workflow Status Monitor Search=>Workflows=>Search
2. Query the related workflow name (PAAGPPRW)
3. Select the workflow process and the error appears on the page.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.