Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

BI Publisher (MOSC)

BIP seems to add line break to some data

Mar 10, 2016 8:15AM edited Mar 10, 2016 9:57AM in BI Publisher (MOSC) 1 commentAnswered

Hello everyone,

I'm seeing some strange behavior coming from BI Publisher 11.1.1.7.1500714

Whenever it generates the data for a report, I see some fields like this:

and it should actually be like this:

In the database, the data is fine:

This extra line in the data is a bad thing for the reports. Any ideas on what could be causing it? Because it is not for all the fields.

All these fields are VARCHAR(4000) in the DB but BI Publisher recognizes them as CLOB. Why is that?

There is also another field VARCHAR(2000) recognized as CLOB, but this one doe snot have the extra line for each field of data.

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

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

Category Leaderboard

Top contributors this month