Not Able To Terminate Orphan Role In Oracle User Account.

(Doc ID 2159187.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Access Portal - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

A customer has one user account where in the role is assigned but there is no responsibility attached to role. When trying to end date this role assignment through UAM portal we are not successful, and there is no error.

Attempts to end date this role assignment through back end update using below statement results in an error

update APPS.FND_USER_RESP_GROUPS set END_DATE = (sysdate-3) WHERE USER_ID = 23963 AND RESPONSIBILITY_ID = 56578;

ERROR
-----------------------
SQL Error: ORA-01733: virtual column not allowed here
01733. 00000 - "virtual column not allowed here"

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