BI Publisher (MOSC)

MOSC Banner

ETEXT Template truncating number on right when left truncation is needed

edited Aug 16, 2013 4:33AM in BI Publisher (MOSC) 5 commentsAnswered
Hi, I have a AP Payment NACHA etext template.  the field in question is the Entry Hash total that is a number and is 10 digits long.  However, when the Hash Total is longer than 10 digits it is truncating the right side of the number and I need it to truncate the left.  

For example I have a 11 digit hash total of 13499042841 and it is coming out on the output as 1349904284  when it needs to be 3499042841.

Here is the "code" from my etext template...

<LEVEL>

OutboundPaymentInstruction

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

BATCH_CONTROL



22

10

Number

L, ‘0’

SUM(TO_NUMBER

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