Db2 Sqlcode -104 Error When Linking/Unlinking Credits To/From A Match Event In CCB v.1.5.20 (Doc ID 822473.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 1.5.20 and later   [Release: 1.5 and later ]
Information in this document applies to 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 trying to link a payment to a match event by clicking LINK/UNLINK button on the Match Event
page, the following DB2 error occurs:

ERROR
SQL Error code 104 occurred in module CIPFMVTP: XQ020 PREPARE

-- Steps To Reproduce:
1) Create an SA with a positive adjustment
2) Create a payment to the SA using a distribution rule that will not direct the payment to the
SA. Instead, it should go to a suspense SA.
3) Go to the match event of the original SA. You should see the adjustment and the payment which
is not linked to the adjustment's match event.
4) Tick the unmatched check box of the payment. At this point the LINK/UNLINK bottom at the lower
right corner of the page becomes 'click-able'.
5) Press the 'LINK/UNLINK' button

The workaround is to manually update payment FT's match event with the desired Match Event.

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