Editing Data Sets For SQL Queries In Existing Data Model in BIP 11G Freezes (Doc ID 1676809.1)

Last updated on DECEMBER 20, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.7.x [Release 11.1]
Information in this document applies to any platform.

Goal

After an OBIEE 10g to 11g upgrade, editing the existing data model with sql query hangs and doesn't finish the task.

Example sql query => "SELECT ASSETMGMTREP_DG_PACK.GET_ASSETMGMT_FUNC(:fundcode,:fromdate,:todate,:reporttype,:reportgroup)FROM DUAL".

 

Solution

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