When Attempting to Log Into RMS With Non-Default Roles, ORA-04067 Error Is Encountered (Doc ID 1611761.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2, when we attempt to log in to RMS with non-default roles, the following error is encountered:

Steps to Reproduce:

1. Create a role in RMS and grant the role to all the objects.
2. Create an RMS user and assign the role as non-default.
3. Log in to RMS as this user.
4. Notice the ORA-04067 error message.

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