OBIEE Adapter Is Not Visible In LSH GUI (Doc ID 2166411.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
=================
Planning to setup OBIEE for LSH, unfortunately the OBIEE Adapter is not displayed in LSH GUI (The adapter required to create Oracle Business Intelligence visualizations of Oracle LSH data).

"Run the Post-Installation Program" step was re-executed. It does NOT display errors, but still do not show the OBIEE Adapter loaded in to LSH GUI:

1 create a Business Area and select "Business Area/Adapter Type"
2. Navigate to remote location tab -> click create remote location button -> select OBIEE adapter not visible.

3. Running as APPS user the following queries indicate the OBIEE Adapter is already installed and in correct status $WASTATUSES$INSTALLED :


a) select * from cdr_workareas where obj_id in ( select namespace_obj_id from cdr_namings where object_Type_rc='$OBJTYPES$PROGRAMINST' and NAME='OBIEE_temp_prog');

COMPANY_ID OBJ_ID OBJ_VER LABEL WORKAREA_STATUS_RC WA_RUNTIME_STATUS_RC USAGE_INTENT_RC LAST_STATUS_CHANGE_TS CLONED_FROM_COMPANY_ID CLONED_FROM_OBJ_ID CLONED_FROM_OBJ_VER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN
1604 1248108101 1 $WASTATUSES$INSTALLED $WA_RT_STATUS$ACTIVE 3/6/2013 2:39:29 PM 1355 3/6/2013 2:39:01 PM 1355 3/6/2013 2:39:29 PM -1

b) select * from cdr_workareas where obj_id in ( select namespace_obj_id from cdr_namings where object_Type_rc='$OBJTYPES$PROGRAMINST' and NAME='OBIEE_runtime_prog');

COMPANY_ID OBJ_ID OBJ_VER LABEL WORKAREA_STATUS_RC WA_RUNTIME_STATUS_RC USAGE_INTENT_RC LAST_STATUS_CHANGE_TS CLONED_FROM_COMPANY_ID CLONED_FROM_OBJ_ID CLONED_FROM_OBJ_VER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN
1604 1248108101 1 $WASTATUSES$INSTALLED $WA_RT_STATUS$ACTIVE 3/6/2013 2:39:29 PM 1355 3/6/2013 2:39:01 PM 1355 3/6/2013 2:39:29 PM -1



EXPECTED BEHAVIOR
====================
Expect the OBIEE Adapter is displayed to be able to use it.

Changes

This is an old instance, but it is the first time trying to use OBIEE Adapter

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