Positive Pay File Issue With Truncate Zero With Decimal_Part (Doc ID 2690759.1)

Last updated on NOVEMBER 13, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Positive Pay File Issue with Truncate Zero with Decimal_Part

Having trouble the positive pay file truncating 0's when the DECIMAL_PART value is 0.

When a check has a "0" in the cents part, it leaves them off. If there is no 0 in the cents portion then there is no issue with the file. Need it to be fixed to 2 decimal places.

Sample from Positive Pay File:
<Customer Specific> "425.0" Incorrect
<Customer Specific> "1027.66" Correct
<Customer Specific> "1249.5" Incorrect
<Customer Specific> "94.03" Correct


Code for this field in the Positive Pay RTF template.
INTEGER_PART(PaymentAmount/Value)||DECIMAL_PART(PaymentAmount/Value)

Advised how to get the 0's to show up?

EXPECTED BEHAVIOR
-----------------------
Customer is expecting the PPP to not truncate the '0' when the Decimal_Part value is 0.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot show the correct PPP file amounts because of the truncated '0'.

Cause

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