"395: Duplicate Role" Error When Submitting Project For Approvals (Doc ID 2063962.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version with 17839156 (R12.PJ_PF.B.DELTA.6) , Project Access

When submitting projects for approvals, the following error occurs.

ERROR
-----------------------
395: Duplicate role Michael Liberatone('APPR_PAPROWF426505')


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


Step 1: A Capital Project (referred to as a CAR) is created in Oracle Projects.
E-CAR Analyst populates Key Members who will be the Approvers for the project
and submit the CAR project for approval by changing the project status changed to
“Submit for Approval” which launches the PAPROWF workflow.

Step 2: For the CAR project 15IDS055 was routed to
E-CAR Manager => Primary Approver 1 => Primary Approver 2 => Primary Approver 3 without any problems:


Step 3: However, after Primary Approver 3 approved the CAR, the workflow runs into the
325: Duplicate Role error in “Select_Project_Approver” function itself



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