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