Join Fribiz, place bids and win prizes | Next Tip »Home
Written on March 26, 2009 at 2:45 am by neel

Scriptless Siebel solutions – Part2

Filed under Scriptless Siebel Viewed: 4,141 times View Comments
OkAvarageGoodVery GoodExcellent (2 votes, average: 2.00 out of 5)
Loading ... Loading ...
<< Previous in series     Next in series >>

Creating a Workflow:

I used PRM ANI Utility Service (QueryBusComp Method) to Query Action BC and get the record count then used if Stop Step to display error message if record count is 1.

I tried that if I could put details of workflow here but couldn’t find a proper way. So, I am providing the Workflow XML file for you guys to download and see what I had created. I am posting a Screen Shot though to show you how it looks.

workflowscreenshot

Download Workflow Process
I tried a lot of things (such as Named Method n, UP) but finally a runtime event at did the trick. Here are the details of that Runtime Event

Event Detail:
runtimeeventdetails
Sequence: -1
Object Type: BusComp
Object Name: Action
Event: PreDeleteRecord
Conditional Expression: GetProfileAttr(‘Me.ActiveViewName’) = ‘Opportunity Detail – Activities View’
[To limit the execution to just that particular view]
Action Set Name: CheckActivityDelete

Action Set Details:

You need to create two action records for this action set. One will set a profile attribute and other will call the workflow process

runtimeeventaction

Action Details:

Name: OpptyId
Action Type: Attribute Set
Sequence: 1
Profile Attribute: OpptyId
Set Operator: Set
Value: [Opportunity Id]

runtimeeventprofileattr

Name: CallWF
Action Type: BusService
Sequence: 2
Business Service Name: Workflow Process Manager
Business Service Method: RunProcess
Business Service Context: “ProcessName”, “NewTestWorkflow”

runtimeeventbsdetail

Through this scriptess siebel series I will try to share scriptless solution of various requirements that I have faced in Siebel. I would like to thanks Alex for providing the idea and insipiration :) .

Hope this helps !!!

<< Previous in series     Next in series >>

Related Posts


Article by neel

Authors bio is coming up shortly. neel tagged this post with: , , Read 417 articles by neel
  • http://leavingusa.blogspot.com/ Kantesh

    I think you could also try the data validation manager which uses runtime events as well. You could probably use the GetNumBCRows function to get the record count. Just a thought.

  • http://leavingusa.blogspot.com/ Kantesh

    I think you could also try the data validation manager which uses runtime events as well. You could probably use the GetNumBCRows function to get the record count. Just a thought.

  • http://leavingusa.blogspot.com/ Kantesh

    I think you could also try the data validation manager which uses runtime events as well. You could probably use the GetNumBCRows function to get the record count. Just a thought.

  • http://siebel-essentials.blogspot.com/ @lex

    Hi Neel,

    Great solution! I believe that it proves that is is really worth the extra effort to investigate scriptless alternatives. The overall skill level of the Siebel developer increases over time as he/she becomes more familiar with all the administrative solutions like workflow, pre-built business services and runtime events. And the well designed and upgradeable solution comes at the lowest performance penalty.

    have fun

    @lex

  • http://siebel-essentials.blogspot.com @lex

    Hi Neel,

    Great solution! I believe that it proves that is is really worth the extra effort to investigate scriptless alternatives. The overall skill level of the Siebel developer increases over time as he/she becomes more familiar with all the administrative solutions like workflow, pre-built business services and runtime events. And the well designed and upgradeable solution comes at the lowest performance penalty.

    have fun

    @lex

  • Pankaj

    Hi Neel,

    I think there is a very simple way to do it . You went in a very complex way. Since Opportunity is Parent and Action is the Child.There would be a link that is existing bewteen Opportunity and Action.
    There is a function called COUNT(MVL).

    To use that you should have constructed a MVL on top of existing link in Oppty BC.

    Then create a calculated field in Oppty BC and its value would be – COUNT(MVL). It would give you the child record count.

    Then you could have used Runtime Events or WF to just verify the value of this field and then thorwn the Error.

    Let me know your views on this !!

  • Pankaj

    Hi Neel,

    I think there is a very simple way to do it . You went in a very complex way. Since Opportunity is Parent and Action is the Child.There would be a link that is existing bewteen Opportunity and Action.
    There is a function called COUNT(MVL).

    To use that you should have constructed a MVL on top of existing link in Oppty BC.

    Then create a calculated field in Oppty BC and its value would be – COUNT(MVL). It would give you the child record count.

    Then you could have used Runtime Events or WF to just verify the value of this field and then thorwn the Error.

    Let me know your views on this !!

  • bhargav

    hi
    nice work dude !!!!!
    You could have also tried this using a data validation manager.
    as action BC is the child BC you can do validation by selecting all records from the DVM.You can invoke the DVM from workflow using business service and can get the error message captured in the workflow. Added advantage of using a DVM in workflow is, you can display the messages in multilingual format. Main draw back of using DVM is it is not supported on mobile and handheld applications.

  • bhargav

    hi
    nice work dude !!!!!
    You could have also tried this using a data validation manager.
    as action BC is the child BC you can do validation by selecting all records from the DVM.You can invoke the DVM from workflow using business service and can get the error message captured in the workflow. Added advantage of using a DVM in workflow is, you can display the messages in multilingual format. Main draw back of using DVM is it is not supported on mobile and handheld applications.

  • bhargav

    hi
    nice work dude !!!!!
    You could have also tried this using a data validation manager.
    as action BC is the child BC you can do validation by selecting all records from the DVM.You can invoke the DVM from workflow using business service and can get the error message captured in the workflow. Added advantage of using a DVM in workflow is, you can display the messages in multilingual format. Main draw back of using DVM is it is not supported on mobile and handheld applications.

blog comments powered by Disqus

Polls

Do you know how to use replace function?

View Results

Loading ... Loading ...
abs framework audit trail Best Practices Case Study Configuration Data Source Downloads EAI eScript Forum framework Functional Siebel How To Informatica Introduction I Wish I Knew List of Values Logs Metalink Office Humor Oracle MetaLink Performance personal Problem Solutions Product Configurator Runtime Events Scripting Scriptless Siebel siebel Siebel 8.0 Siebel Admin Siebel Administration Siebel Analytics Siebel EAI siebel performance Siebel Testing Siebel Tools Signals SQL Tips User Properties User property Web Services workflow Workflows