cancel
Showing results for 
Search instead for 
Did you mean: 

SBO_SP_TransactionNotification and object 58

Former Member
0 Kudos

I am trying to catch an "Issue for Production" event in SBO_SP_TransactionNotification. The variables come through as follows:

@object_type nvarchar = 58

@transaction_type nchar = A

@num_of_cols_in_key = 2

@list_of_key_cols_tab_del nvarchar = TransNum Instance

@list_of_cols_val_tab_del nvarchar = 11399 0

Where, in which table, can I find the TransNum 11399? My goal is to relate this to the "Issue for Production" number. Any ideas?

Thanks,

Rob

Any Idesa??

Edited by: Rob Burke on Feb 13, 2009 1:34 AM

Accepted Solutions (1)

Accepted Solutions (1)

former_member206488
Active Contributor
0 Kudos

what you actually want to do...

Issue for Production object type is 60...

explain in detail regarding what you want to do using SBO_SP_TransactionNotification

Regards,

Neetu

Former Member
0 Kudos

Thanks Neetu.

I put the following code in SBO_SP_TransactionNotification

set @error = 1

set @error_message = @object_type + ': ' + @transaction_type + ': ' + CAST(@num_of_cols_in_key as VARCHAR(5)) + ': ' + @list_of_key_cols_tab_del + ': ' + @list_of_cols_val_tab_del

The result when I entered an Issue for Production event was an object_type 58 with other data I could not understand. I also see the 60 object type come through after. I will use the type 60.

We use SQL BIDs for printing based on events in B1 by passing data out from SBO_SP_PostTransactionNotice, that is why I'm looking for the event. Problem solved, thank you,

Rob

0 Kudos

Hi Rob,

I was stuck at the same point and i resolved selecting the field BASE_REF from table OINM where transnum = the weird code you get

works great!

0 Kudos

The way you did only works in update mode, I think... working with transid also works for (A)dd mode

regards

Answers (0)