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 laterInformation in this document applies to any platform.
Symptoms
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.
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 |
Cause |
Solution |
References |