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.

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