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 AUGUST 31, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, GL Transfer Issues

ACTUAL BEHAVIOR
---------------
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) -----------------------------------------------------------------------------------

<POSITION><LENGTH><FORMAT><PAD><DATA> <COMMENTS>
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:


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

Changes

 N/A

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms