Using Swiss DTA Format "IBY_PAY_EFT_DTA_CH" and IBYDE_D_CH Template, Swiss DTA Totals Has Too Many Decimals/Precision (Doc ID 1628408.1)

Last updated on SEPTEMBER 06, 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, Pmt PayReports PBatch & Prepay

ACTUAL BEHAVIOR
---------------
Using seeded Payment Process Profile (Code: IBY_PAY_EFT_DTA_CH, Name: Swiss DTA), and seeded Format (Code: IBY_PAY_EFT_DTA_CH, Name: Swiss DTA Format), and seeded Template (Code: IBYDE_D_CH, Name: Swiss DTA Format), Swiss DTA totals has too many decimals for example, "0002389000223134,219999999"

Swiss DTA payment total has 9 decimal places. The currency precision for the using currency is defined as 2 and the file is being rejected by the bank.


EXPECTED BEHAVIOR
-----------------------
Expect to be able to read the total of payment in only two precision. For example, "0002389000223134,21       ".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit PPR using PPP "IBY_PAY_EFT_DTA_CH"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the total of payments as expected. For example, "0002389000223134,21       ".

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