Graphs migrated from 11g to 12c showing "0.000" on data labels when no data exists

Question

As the title says, some of the bar graphs migrated into 12c are displaying 0 values when they shouldn't be.  The requirement is to display data labels, but in 11g null or 0 values would not show (which is correct).  However in 12c, we get nasty looking "0.000" for data points where there should not be a label.

The "Show null values as 0" is already unchecked - checking or unchecking this has no effect.  I also tried using the NULLIF function in the formulas but this has no effect on the graph data labels either.

My guess is this is some sort of bug that happens during the migration.  Newly created graphs in 12c do not have this problem.  Currently getting the run around from Oracle.  IT would obviously be a ton of work to have to re-create all the graphs where this is a problem.

jepva · Answer

Oracle got back to me and it is a known bug after all.  Thanks for your suggestion though, I will try comparing XML and see if there is a tag causing this somewhere.

Gianni Ceresa · Answer

As you can create a chart without the issue why don't you just compare for a same chart the migrated one with the newly created XML?

You will be able to identify what is different and maybe find out it's just an attribute or 2 in the XML and a search/replace in the catalog will fix your issues.