BI Publisher (MOSC)

MOSC Banner

Currency/number fixed format for a text based report

I have a requirement to create a text based report from one of the EBiz R12 XML/BI Publisher extracts (ARSJGLARPT - Sales Journal by GL Acct).    The text report will be later processed by the Monarch application, as it was under R11.

I have found that if I create a non-table rtf template, formatted as courier, and create the output as RTF, I can then save the resulting output as plain text and everything appears to line up properly using a function such as "<?xdofx:rpad(truncate(PARTY_NAME,20),20)?>"    

While this works with currency/number fields, it doesn't show the decimals properly:

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