BI Publisher Data Model Creation Errors On 11G, And How to use '&' In SQL Query Of Dataset when creating Data model in Bi Publisher
(Doc ID 1490701.1)
Last updated on JANUARY 03, 2023
Applies to:BI Publisher (formerly XML Publisher) - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
When creating a Data Set in BI Publisher (SQL) the ampersand '&' character appears to be throwing an error. This is an issue especially when looking at a field that contains this character.
WHEN (A.REPAYMENT_TYPE = 'P&I' AND A.REMAINING_TERM >= 10 AND A.REMAINING_TERM
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