6 Replies Latest reply on Jan 29, 2019 6:59 PM by 3601907

    Account numbers with 3 spaces in database display in OBIEE with only one space


      I have account numbers that are a mix of alpha numeric characters example W_ _ _123456. (The underscores are only to show the number of spaces). This is how the account numbers show in the database and also in SQL Developer when I run a query against the database. When I export to Excel or CSV from SQL Developer after running the query the export files show the spaces. The numbers are shown as reflected in the database. However, in OBIEE when I run the report the numbers are stripped of 2 extra spaces.

      For example  W_ _ _123456 will now show as W_123456. What might be the cause for this issue and anyone knows how I can fix it?

      We are using OBIEE 12c. I recall this was the same issue in 11g.