Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher 11g errors with "A parameter name contains ... is not allowed"
Summary
A parameter name contains any of the characters (~, !, #, $, %, ^, &, *, +, `, |, \",\', \\, <, >, ?, ,, /) is not allowed.
Content
This happens when I add the sql to the edit box. The SQL has been tested verbatim outside BI Publisher, parameters were part of the data model before the current change, any hints would be appreciated.
...
where shp.shipment_gid = 'REGION.' || :P_SHIP_ID
and orej.source_location_gid = 'CUSTOMER.' || :P_DEST
Version
Oracle® Business Intelligence Publisher 11g Release 1 (11.1.1)
Answers
-
Hi,
This is an expected error message. Did you try using anything without those parameters?
BI Publisher 11.1.1.9.x Reports No Longer Allow Special Characters in The BI Parameter Display Label (Doc ID 2149297.1)
Thanks,
Sareesh0 -
I narrowed it down to a line:
to_char(sysdate, 'MM/DD/YYYY HH24:MI') parm_failing,
If I remove the colon ':' it works fine.
That's not the format I need though, any hints?
0