Transaction notification

[Former Member]

Dear all experts,

Please intimate me, may transaction notification affect the add on reports?

Thanks & Regards,

Akshata

[former_member184718]

Hi Akshata,

It depends on the user code which can be inserted into Transaction Notification stored procedure.

In practical you can update and remove the entries using SQL commands but it is not a good practice and not recommended which may result into complication and crash.

Thanks.

Hari

[Former Member]

Dear sir,

We are not removing or updating the entries through SQL. The transaction notification doesn't have any command like Update....It has only If-then command.

I want to ask one more question this transaction notification query may affect while Upgrading SAP.

Thanks & Regards,

Akshata

[Former Member]

Hi Akshata.......

Not necessary to remove SP while upgradation as it does not affect.

I tried for No. of times and mine goes smooth........

Regards,

Rahul

[former_member186095]

Hi,

I suggest to comment out the transaction notification to avoid failure upgrade.

You may check the solution part of this sap note below:

1477614  - Upgrade to 8.8 failed when upgrading Legal List Format

Version   4   Validity: 19.10.2010 - active Language   English

Content:      Summary    |    Header Data    |    References    |    Validity    |    Attachments 

Symptom

You upgrade the company database to 8.8. Although the pre-check is passed, the upgrade fails when upgrading Legal List Format, when there are user codes in store procedure [SBO_SP_TransactionNotification] or [SBO_SP_PostTransactionNotice] referring to user tables which are not existing.

 

Cause

Application error.

 

Solution

Workaround: Please temporarily comment out the code in the store procedure [SBO_SP_TransactionNotification] or [SBO_SP_PostTransactionNotice] before the upgrade.
(Section: ADD YOUR CODE HERE)

It should be the same as in the attached SBO_SP_TransactionNotification.txt or SBO_SP_PostTransactionNotice.txt file.
Upon completion of the upgrade, you can set it again to the required status.

SAP intends to provide a patch or patches in order to solve the problem described.
The section Reference to Related Notes below will list the specific patches once they become available.
The corresponding Info file of the patches in SAP Service Marketplace will also show the SAP Note number.
Be aware that these references can only be set at patch release date.
SAP will deliver patches only for selected releases at its own  discretion, based on the business impact and the complexity of the implementation.

 

Other terms

Upgrade, Upgrade failure, Upgrade failed, UPG, SAP Business One, Legal List Format, Legal List, OLLF

   
       

Header Data

Released On	19.10.2010 08:41:55
Release Status	Released for Customer
Component	SBO-BC-UPG Upgrade
Priority	Correction with high priority
Category	Program error

  
      

References

This document refers to:

  SAP Business One Notes

1565800

Overview Note for SAP Business One 8.8 Patch 20

This document is referenced by:

   SAP Business One Notes (1) 

1565800

Overview Note for SAP Business One 8.8 Patch 20

   
    
      

Validity

Software Component	Version
SAP BUSINESS ONE	8.8

   
      

Attachments

File Name	File Size (KB)	Mime Type
SBO_SP_PostTransactionNotice.txt	1	text/plain
SBO_SP_TransactionNotification.txt	1	text/plain

    

JimM

[Former Member]

Hi Akshata......

It does not affect anything if it has no update command.

Regards,

Rahul