My Oracle Support Banner

PAM ACH File Format Issues - Amount Is Rounding To .99 However The Payment Amount Is Not For Line "02" - Negative Amount Is Not absolute However There Is An Indicator For Positive Or Negative For Line "G" (Doc ID 1938851.1)

Last updated on MARCH 25, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, GL Transfer Issues

For PAM ACH File Format:
 - For "02" Line, Amount is rounding to .99 however the Invoice has not.
 - For G records (GTAS payments records), Negative Amount is not absolute however there is an indicator for positive or negative.

RTF File (Format and Template Names):
IBYDE_FV_P_A_en.rtf (Template Name: "Federal PAM ACH Payments Format" , Template Code: IBYDE_FV_P_A , Format Name: "US Federal PAM ACH Format", Format Code: "IBY_PAY_EFT_FED_PAM_ACH")

-------------- RTF (IBYDE_FV_P_A_en.rtf) (Line 02) -----------------------------------------------------------------------------------

1 2 Alpha R, ’ ’ '2' Record type that identifies the type of record Constant, "02"
19 10 Number L, ‘0’ PaymentAmount/Value*100 Amount of payment.There is no decimal in the amount field







Example for "02" Line (Wrong Display for Payment Amount 1900.3 >> 0190030.99) from position 19 to position 28 shows rounding xxxx.99 which is not expected from the User:

The issue can be reproduced at will with the following steps:
1. Run Payment Batch




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.