Hi, Oracle EBS 12.1.3 Using BI Publisher, how do I display the amounts in Accounting format in Excel? I am able to display the amounts in the currency format using However the business wants it be displayed as below (Accounting format in Excel) where zeroes are displayed as dash. Thanks in advance.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to display amounts in Excel Accounting format?

Sameer

Hi,

Oracle EBS 12.1.3

Using BI Publisher, how do I display the amounts in Accounting format in Excel?

I am able to display the amounts in the currency format using <?format-number:ITEM_TOTAL;'$9G999D99'?>

However the business wants it be displayed as below (Accounting format in Excel) where zeroes are displayed as dash.

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Sameer

@Kevin McDermott-Oracle You on vacation? 😊

Kevin M-Oracle

Nope, I just do not normally monitor this forum.

This is not a feature they can use in EBS 12.1.3.

In 12.2 they could use an Excel layout. But they are not supported in 12.1.3.

Rgds,

Kevin

Sameer

@Kevin McDermott-Oracle Apologies for calling you out :-) You have always answered my BI/XML Publisher questions. Hence! :-)

Thanks for responding. Did I post this question in the wrong forum? This is the BI/XML Publisher forum, right?

Kevin M-Oracle

NP.

This is Analytics, we still have BIP (OAS) under

https://community.oracle.com/mosc/categories/bi_publisher

Kevin

Sameer

Bummer! No wonder you didn't respond :-) Sorry for posting in the wrong forum :-(

Sameer

BTW can you move this question to that forum?

Gianni Ceresa

I would say they can't move the question because it's a different node in the forum platform ("tech" vs "mosc").

This forum isn't technically wrong for a BIP question (ok, the category for OBIEE/OAS would have been a better match), but it's the public one while the MOSC forum require a valid support contract attached to your profile to access it (and there you often find the same categories as in here, or more detailed choice like BIP having a category).

Kevin M-Oracle

Have a good day!

Kevin