WF_USER_ROLES Rows Are Being Deleted - Projects Therefore Cannot Be Approved

(Doc ID 2259484.1)

Last updated on APRIL 26, 2017

Applies to:

Oracle Project Costing - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

Users are receiving these WF error notifications directed at sysadmin user:

Item Type = PAWFPPRA
Item Key = 126348
User Key =

Error Name = WFNTF_ROLE
Error Message = 3205: 'RPT_PAWFPPRA126348' is not a valid role or user name.

To reproduce the issue:

The user submits a 'Project Status Report' to be approved by project approver. The project approver does not approve until after 7 days. When they go to approve, SYSADMIN receives this error in the ap
 

Solution

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