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 JANUARY 31, 2017

Applies to:

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

Symptoms

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
Error Codes: OAMP2OPY:ACIOA5LN
Assertion failure: false at line 2429 of
C:\ADE\aime_3\bifndn\analytics_web\main/project/webquerymanager/dynamicsql.cpp"

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.

Cause

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