cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction notification

Former Member
0 Kudos

Dear all experts,

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

Thanks & Regards,

Akshata

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184718
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Hi Akshata......

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

Regards,

Rahul