Db2 Sqlcode -104 Error When Linking/Unlinking Credits To/From A Match Event In CCB v.1.5.20
Last updated on OCTOBER 18, 2016
Applies to:Oracle Utilities Customer Care and Billing - Version: 1.5.20
Information in this document applies to any platform.
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:
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.
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