DB2 with Comma as a Decimal Delimiter: SQL ERROR 104 upon Clicking on the Matched Debit Link in Match Events.

(Doc ID 787473.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 1.5.20
This problem can occur on any platform.

Symptoms

This note is only applicable for a DB2 database  using the COMMA as a DECIMAL DELIMITER instead of the point, mainly in European countries.

When looking at the match events for a payment transaction created by the system, click on the
Matched debit link for the transaction, the following error occurs:

ERROR
SQL Error code 000000104 occurred in module CIPFMVL:XQ010

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