Workflow Siebel Operation business servce SQLs
We are using the OOTB business service "Workflow Siebel Operation" in one of our sub workflows triggered by the main Submit Order workflow.
The process step in question "Query for Shared Resource in Assets" executes 4 SQLs each time it is called.
You can identify these SQLs be searching for:
1) ObjMgrSqlLog Detail 4 000000024fe815d4:0 2012-06-25 18:06:50 SELECT statement with ID: 1C438D20 (Account)
2) ObjMgrSqlLog Detail 4 000000024fe815d4:0 2012-06-25 18:06:50 SELECT statement with ID: 1C9EBC98 (Asset Mgmt - Asset (Order Mgmt))
3) ObjMgrSqlLog Detail 4 000000024fe815d4:0 2012-06-25 18:08:54 SELECT statement with ID: 1C2E5308 (Asset Mgmt - Asset (Order Mgmt))
4) ObjMgrSqlLog Detail 4 000000024fe815d4:0 2012-06-25 18:08:54 SELECT statement with ID: 1C49DBD8 (UT Account Infrastructure)