Positive Pay File Issue With Truncate Zero With Decimal_Part
(Doc ID 2690759.1)
Last updated on NOVEMBER 13, 2020
Applies to:
Oracle Fusion Payables Cloud Service - Version 11.13.20.04.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |