BI Publisher 11.1.1.9.x Reports No Longer Allow Special Characters in The BI Parameter Display Label (Doc ID 2149297.1)

Last updated on MAY 05, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.0 to 12c [Release 11.1 to 12.0]
Information in this document applies to any platform.

Goal

E-Business Suite 12.2 BI Publisher 12c, Enterprise Data Model issues

 

To workaround issues where special characters are not allowed on some of the reports by BIP.

Here are some special characters that is failing:

asterisk "*", space " ", comma "," , left "(" and right ")" parenthesis, and ampersand "&"...
 

Some of the latest guidelines for BI:

1. Do not use the following invalid characters (~, !, #, $, %, ^, &, *, +, ', |, :, \", \\, <, >, ?, ,, /,.) for Data Set Name.
2. Data set names should not include special characters.These are used for nodes, keep them simple.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms