My Oracle Support Banner

ORA-36848:Object Name UNIT Is Different Than TIME (Doc ID 1984360.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Oracle OLAP - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Receiving the following error while trying to view data after upgrading to 11g.

oracle.dss.dataSource.common.QueryRuntimeException: BIB-9009 Oracle OLAP could not create cursor.
oracle.express.idl.util.OlapiException: java.sql.SQLException: ORA-36848: Object name UNIT is different than TIME
ORA-06512: at "SYS.GENCURSORMANAGERINTERFACE", line 42
ORA-06512: at line 1



STEPS TO REPRODUCE:
===================
Connect to database  using Analytical Workspace Manager (AWM). select OLAP 10g as Cube Type when connecting to database in AWM.
Expand AW
Right click on cube UNITS and choose view data. Takes a while but then error pops up.

This works in 10g.

Changes

 Upgraded from 10g to 11g.

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.