My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

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


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".



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

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