SBO_TransactionNotification Problem Drafts - 2005A SP01 PL22

[vincent_provendier]

Hi Gurus,

We have an issue about the SP SBO_TransactionNotification with drafts.

When we create or update a draft (object_Type = 112) in SBO from any documents, the SBO_TransactionNotification stored procedure doesn't run.

I added this code in the SP to test it.

+====================================================

DECLARE @numlinii int

IF @transaction_type IN (N'A', N'U') AND(@Object_type IN (112)) AND (@num_of_cols_in_key = 1)

BEGIN

SELECT TOP 1 @numlinii = (LineNum +1) FROM DRF1 inner join ODRF on DRF1.DocEntry = ODRF.DocEntry

WHERE DRF1.DocEntry = @list_of_cols_val_tab_del

ORDER BY Linenum ASC

IF (ISNULL(@numlinii, 0) <> 0)

BEGIN

SET @error = 10

SET @error_message = N'Test SP: ' + CONVERT(nvarchar(4), @numlinii)

END

END

====================================================+

However, for the others documents (SO, PO, ...), everything is going well.

Please let me know what 's going wrong?

Best regards,

Sébastien

SBO 2005A SP01 PL22

DB: SQL 2000

[vincent_provendier]

After searching, It is a bug and It should be solved in the 2005A SP01 PL31.

Regards,

Sébastien

[former_member583013]

Couple of things I found out.

1) SBO only has the ADD 'A' event for Drafts. Even though you update the Draft, there is no Update event that I could see.

2) The system message in Green for success over rides and the message that you set to @error_message does not show.

If you set the @error to anything other than 0, SAP does not add that document to the database.

Suda

[former_member583013]

Vincent,

The Object_Type variable if you notice is a nvarchar, so try adding a single quote '112',

one more suggession would be to try using OR instead of IN( x, y)

Suda

[vincent_provendier]

Hi Suda,

Thank for your answer.

The main problem is not the code added even if it is better to follow your recommendation but mostly the fact that the SP doesn't track the draft status in B1.

If you paste the code added in the SP and you specify no constraint in the clause WHERE, you will see that there is no error at the bottom when you add a draft or update one.

We are using as well the add-on iBOLT.

Best regards,