BI Publisher (MOSC)

MOSC Banner

Etext Outbound FORMAT_NUMBER("PaymentAmount/Value", "999,999.99") or FORMAT_NUMBER(PaymentAmount/Val

edited May 13, 2015 10:01AM in BI Publisher (MOSC) 1 commentAnswered

Hi Kevin

We are based in the UK, and although the standard invoice amount in payments gives us decimals, we need the thousand seperator for:

PaymentAmount/Value

So In my fixed etext I have tried all of these:

FORMAT_NUMBER("PaymentAmount/Value", "999,999.99")

FORMAT_NUMBER("OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value", "999,999.99")

FORMAT_NUMBER(OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value, "999,999.99")

FORMAT_NUMBER("OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value", "999,999.99")

In the output I get: ?????????

What am I doing wrong?

In the etext field the field is defined as follows:

<LEVEL>

DocumentPayable

<POSITION>

<LENGTH>

<FORMAT>

<DATA>

<PAD>

<COMMENTS>

<NEW RECORD>

LINE_DETAILS

1

10

Number

FORMAT_NUMBER("1234567890.0987654321", "999,999.99")

R, ‘ ‘

Thanks In Advance!

Tagged:

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