LSH 2.4 - CDR_USER_UG_ROLES_A Table Missing Columns (Doc ID 2195768.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.2 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.6 version, Installation and Upgrade

ACTUAL BEHAVIOR
---------------
Few columns in the Apps schema table CDR_USER_UG_ROLES_A are missing:


EXPECTED BEHAVIOR
-----------------------
The table should hold all the 19 columns

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query <CDR_USER_UG_ROLES_A> against 2 different environments

2. Notice the differences

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