BI Publisher (MOSC)

MOSC Banner

Incorrect number in BI Publisher text field (rtf template)

edited Dec 3, 2019 4:00AM in BI Publisher (MOSC) 1 commentAnswered

Hi there,

BI Publisher data model returns 2 numbers as chars:

select

fiscalyear,

Fromdate,

Todate,

aww AWWtest,

sww SWWtest,

to_char(aww,99.99) AWW,

to_char(sww,99.99) SWW,

When I run the query in PL/SQL Developer I get expected values for AWW, SWW:

But rtf template field below converts it to 38 in one BI Publisher Test environment, but works fine in another.

What is the issue with BI Pub configuration when it shows 38 instead of 37.5 in pdf output file?

Here is how those fields are defined in rtf template.

Thanks,

Edward.

Howdy, Stranger!

Log In

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

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center