BI Publisher (MOSC)

MOSC Banner

etext template is not padding according to the template definition for trailer record

edited Jun 25, 2018 5:13PM in BI Publisher (MOSC) 6 commentsAnswered

I am using a FIXED_POSITION_BASED etext template to produce a positive pay file from Payables. We are passing amount fields in the both the detail and trailer records. The amount fields cannot show any decimals.

The amount field on the detail record is defined as:

Length=10

Format=Number

Pad= R, ‘0’

Data=ROUND ((PaymentAmount/Value *100),2)

Description=Amount. Position 35-44; Format ($$$$$$$$cc). Right-justified, zero-filled, numeric

This is a sample of the detail record produced from the etext template.

20413480000703120000000000000003201458612000ZELLER 800 LASALLE AVENUE LLC         --> Amount = 1458612000

The corresponding XML shows the following:

-<PaymentAmount><Value>14586.12</Value>

The amount field on the trailer record is defined as:

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