we are using OAS 5.9, it is a varchar150 datatype containing YYYY/MM/DD HH:MM:SS at the source. It is being converted to date as CAST (LEFT ("XYZ Date",10) AS DATE) in the analysis, in the session log it comes as : cast(substr(XYZ Date , 1, 10) as DATE ) and errors out for ORA-01861: literal does not match format string.

This resulted in from running the migration utility to convert 11g artifacts to 12c, the pivot tables are still normal in 11g instance, no other changes, or any custom style/skin were applied to the catalogs.