BI Publisher (MOSC)

MOSC Banner

Spaces in the etext RTF file

edited Sep 9, 2020 12:25AM in BI Publisher (MOSC) 4 commentsAnswered

We are developing a CSV file for Payments. for this purpose we are creating a delimited Etext rtf and attaching it to XML format used by Payment Process Profile.

The file is generating as expected only problem is

for Invoice Number field I have a max length of 250 characters, but when the Invoice length is less then the 250 characters it is coming up as blank.

Is there a way to remove this space and just display only the Characters.

Curently it is displaying as :

23128-10530,testext8                                          ,08/31/2020,3300.00     ,178853,09/01/2020   

Expected:

23128-10530,testext8,08/31/2020,3300.00,178853,09/01/2020   

Etext Code Used:

<LEVEL>

OutboundPaymentInstruction/OutboundPayment

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

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