In Oracle, whenever you create a (certain) multipivot report, it ends with an error and the report is not generated


Description

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.

Workaround

Fix any invalid choices that you are trying to report on


Related Problem: PRB1406284