On OOB Oracle instance, if a record has an invalid value stored for a Choice list field, you may have failures on multi-dimensional reporting for that column, for example a Multipivot may fail to render.

Steps to Reproduce

1. Login with a user having relevant roles to create report (Report publisher, Report Scheduler, ITIL)
2. Create a Multi-pivot report on table incident on rows - Category, Severity and columns - Priority, Status and save the report

Observe the error.


Fix any invalid choices that you are trying to report on

Related Problem: PRB1406284

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-06-24 02:02:50