My Oracle Support Banner

Generating Data Extract Views fail (Doc ID 2426694.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Oracle Clinical - Version 5.1.0 to 5.2.0 [Release 5.1 to 5.2.0]
Information in this document applies to any platform.

Symptoms

When generating data extract views the jobs fail. The output file displays the error:

Create account succeeded

Connecting to account

ERR level 1

connect_as_user

Error setting role for <USER>$CURRENT   <--- This is the User creating the DX View. 

ERR level 1

maintain_account

Error when calling connect_as_user

RXCDXBVB EXIT WITH FAILURE

The log file displays the error:

OS User=opapps

In set_role 11b:ORA-01924: role 'RXCLIN_SEC' not granted or does not exist

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.