My Oracle Support Banner

OBIEE 11G: Error "OAMP2OPY:ACIOA5LN" When Trying to Run a Report Which has a Union, Pivot Table and a New Calculated Item (Doc ID 1505504.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Business Intelligence Suite Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Trying to run a report that was upgraded from 10g to 11g, which has a union, pivot table and a new calculated item.

The following error occurs:

"View Display Error
Error generating view. Error getting cursor in GenerateHead
Error Details
Assertion failure: false at line 2429 of

Steps to reproduce the issue:
Using SampleSalesLite:

  1. Create a report with: Time.Per Name Year, Products.Brand, Base Facts.Revenue
  2. In a criteria tab click {+} icon to combine results based on union and add the same column
  3. In a Result tab, add a pivot view, edit it. Move Products.Brand to the column section above "Measure Labels"
  4. On Products.Brand : add a new calculated item:
    Display Label : Test
    Formula : Sum(*) / 'BizTech'
  5. Click OK. The error will display.


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.