Running U6678700.drv step Fnduserresp.ldt ORA-20001: Oracle error -20001: ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_ROLE]

(Doc ID 1922665.1)

Last updated on FEBRUARY 03, 2016

Applies to:

Oracle Workflow - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to apply upgrade driver u6678700.drv (upgrading from 11.5.9.2 to 12.1.1 E-Business suite applications),
the following error occurs in the log file US_fnduserresp_ldt.log calling the FNDLOAD function:

FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afscursp.lct @FND:patch/115/import/US/fnduserresp.ldt -

Error loading seed data for FND_USER_RESP_GROUPS:  USER_NAME = SYSADMIN, RG_APPLICATION_SHORT_NAME = FND, RG_RESP_KEY = FND_FUNC_DEV, SG_KEY = STANDARD,  ORA-20001: Oracle error -20001: ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_ROLE] NAME=FND_RESP|FND|FND_FUNC_DEV|STANDARD ORIG_SYSTEM=FND_RESP ORIG_SYSTEM_ID=24076 has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT. has been detected in FND_USER_RESP_GROUPS_API.UPLOAD_ASSIGNMENT.


The issue can be reproduced at will with the following steps:
1. Attempting to apply upgrade driver u6678700.drv (upgrading from 11.5.9.2 to 12.1.1 E-Business suite applications).

The issue has the following business impact:
Cannot upgrade from 11.5.9.2 to  12.1.1

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