Skip to Content
0
Former Member
Apr 21, 2009 at 09:26 AM

Transaction Notification Bug

20 Views

Hi

The SP_TransactionNotification stored procedure is not working properly for Outgoing Payments (Object Type = 46). The SP seems to ignore "ADD" transaction type, but works for other transaction types, such as "Update" or "Cancel".

We are working on version SBO 2007B Patch Level 10 with MS SQL server 2005 database on Windows 2003 server platform.

After investigating a bit, I found that SBO is substituting wrong value for @object_type variable and hence the issue and this is happening ONLY for the Outgoing Payment - Add transaction.

The actual values must be (@object_type = '46' AND @transaction_type = 'A'), but the substituted values are (@object_type = '30' AND @transaction_type = 'A'). Moreover, it seems that a random number is being copied on to the variable @list_of_cols_val_tab_del.

Is there anyone who encountered this problem and how it was fixed?

With Regards,

MariKannan