My Oracle Support Banner

R12: Get "395: Duplicate Role" error when submitting project for approvals (Doc ID 2063962.1)

Last updated on JULY 27, 2020

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 <Employee Name>('APPR_PAPROWF426505')


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


Step 1: A Capital Project is created in Oracle Projects.
User populates Key Members who will be the Approvers for the project
and submit the project for approval by changing the project status changed to
“Submit for Approval” which launches the PAPROWF workflow.

Step 2: For the <Project Number> was routed to
PA Responsibility => Primary Approver 1 => Primary Approver 2 => Primary Approver 3 without any problem.

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



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


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