My Oracle Support Banner

OBIEE Report Generates ACIOA5LN Error Code After Upgrade To (Doc ID 2421875.1)

Last updated on FEBRUARY 02, 2020

Applies to:

Oracle Exalytics Software - Version and later
Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version, OBIEE

When attempting to expand a hierarchy from a second subject area, the following error occurs.


View Display Error
Assertion failure: !hHierarchy.isNull() at line 36 of project/webviewbase/hhierarchyimpl.h
  Error Details
Error Codes: ACIOA5LN

The issue can be reproduced at will with the following steps:
1. Open and expand the hierarchy in the report/dashboard successfully in
2. Upgrade OBIEE to and now the same report/dashboard results in the above error expanding the hierarchy.
3. The SQL is referring to the primary subject area in the Advanced tab, not the second subject area where the hierarchy comes from and as seen in


 Upgrade from to


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.