How find Source of Emails Sent from Siebel

How find Source of Emails Sent from Siebel

During Siebel development, we have many development environments like DEV, QA, BUILD, and PRODUCTION. And we may get mails or end-users may get mails from Siebel, but we don’t know which the originating environment is. Hence, it takes time to debug and find the source of emails.


Solution:

The emails are sent by the server component – Outbound Communication Manager. Outbound Communication Manager Business service inserts records with parameters in two tables – S_SRM_ACTION and S_SRM_DATA. The action name is stored in S_SRM_ACTION. S_SRM_DATA stores the various parts of the mail like TO, CC, BCC, MESSAGE BODY, and SUBJECT in the DATA_VAL column. We can quickly run the below sqls in various environments to find the SOURCE.

Example:

Let’s say our email contains string like this – “An Service Request is updated in Siebel Call Center and you may need to take action on it.”

1. Connect to database and run the below query -

SELECT * FROM SIEBEL.S_SRM_DATA WHERE DATA_VAL LIKE %An Service Request is updated in Siebel Call Center and you may need to take action on it% ORDER BY CREATED DESC

Take the PAR_ID of one record.

2. Take the PAR_ID of the one record from above query result and run the below query -

SELECT * FROM SIEBEL.S_SRM_DATA WHERE PAR_ID = .

The output of query will completely describe your message. You can query in the S_SRM_ACTION with row_id = PAR_ID, and you can get the action corresponding to it.