Error ORA-20001: FND_CANT_INSERT_USER_ROLE When Assigning A Responsibility To A User On R12 Upgraded From 11i

(Doc ID 559347.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Workflow Cartridge - Version 12.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Checked for relevance on 08-DEC-2012


Symptoms

You upgraded from E-Business Suite 11i to E-Business Suite Release 12.

Trying to assign a responsibility to a user, you receive the error below:

Oracle Error -20001: ORA-20001: FND_CANT_INSERT_USER_ROLE has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

The Workflow events involved in responsibility assignments do not have the subscriptions to call packages WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF, WF_ROLE_HIERARCHY.Cascade_RF,
WF_ROLE_HIERARCHY.Denormalize_User_Role_RF, as can be verified using the SQL below :

 

Changes

Upgraded from E-Business Suite 11i to E-Business Suite Release 12

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