My Oracle Support Banner

OBIEE12c: Custom Text Format Under Column Properties Doesnt Display Correct Selection After Migrating To OBIEE 12C. (Doc ID 2697634.1)

Last updated on JULY 22, 2023

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Business Intelligence Server Enterprise Edition - Version and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


several report functionalities/ display formats have been built using custom text format option under column properties using OBIEE 11g and after the migration to OBIEE 12C the display formats are not working as expected despite of being able to use the custom text format option.

It should display either " Y " or " N" for the 3rd column organization but it display what has been entered in the Custom Text Format option under column properties

It display Y;N instead of Y or N

Screenshot of the issue:

Steps to reproduce using Sample Sales Lite:

  1. Create an analysis using:Office->Department, Oraganization and Organization
  2. Edit Column Properties for Third Column Organization and in Data Format->check the check box for 'Override Default Data Format'->Treat Text As:'Custom Text Format'
  3. under Custom Text Format enter the Value Y;N
  4. Save the Analysis
  5. Run the Results
  6. In Results you will See Y;N instead of Y or N

This worked well in OBIEE 11g.


 Upgraded to OBIEE 12c


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.