Not Able To Terminate Orphan Role In Oracle User Account.
Last updated on SEPTEMBER 08, 2017
Applies to:Oracle Access Portal - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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;
SQL Error: ORA-01733: virtual column not allowed here
01733. 00000 - "virtual column not allowed here"
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