Hi Khagesh,
Check this :
What the other SBO Stored Procedures do.
In the 2007 version there are 4 stored procedures:
- SBO_SP_PostTransactionSupport and SBO_SP_TransactionSupport (since SAP Business One 2007)
- SBO_SP_PostTransactionNotice (since SAP Business One 2007)
- SBO_SP_TransactionNotification
The stored procedures SBO_SP_TransactionSupport and SBO_SP_PostTransactionSupport are encoded and cannot be edited by the user. They are database notification stored procedures which can be used by SAP support to add diagnostic code so they are of no use for customer's daily work. Since they are of no use it is planned to remove them in SAP Business One Version 8.8.
SBO_SP_PostTransactionNotice and SBO_SP_TransactionNotification can by edited by the user to add sql code as part of a notification process. The functionalities of both are the same, the only differences being when they are triggered and the ability to use the @error functionality of SBO_SP_TransactionNotification to rollback transactions. SBO_SP_PostTransactionNotice can only be triggered at the end of an action (transaction committed). It is preferable to use SBO_SP_PostTransactionNotice - although as this occurs after the transaction, the @error rollback functionality can not be used.
Further Documentation
The following documenatation is available on the SDN:
o Using the SBO_SP_TransactionNotification Stored Procedure:
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uu
id/e991e2b9-0901-0010-0395-ef5268b00aaf
http://scn.sap.com/thread/941719
http://scn.sap.com/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-proce...
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e991e2b9-0901-0010-0395-ef5268b00...
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.