4 Replies Latest reply: May 18, 2012 11:28 AM by Sachin Saxena RSS

    How to integrate UCM Workflow Approval with Webcenter

    792994
      Hi,

      I have a requirement where in I need to integrate the Oracle UCM Approval Workflow with Webcenter application, meaning When a user creates a CDF or updates the content in the Webcenter Application it will be sent to the approver for approval and the approver can see his pending workflow assignments only when he logs into UCM, but is there a way we can integrate this workflow in UCM to Webcenter so that the approver can see the pending approvals in the Webcenter Application itself instead of logging into UCM?

      Any help appreciated.

      Thanks,

      Swathi Patnam
        • 1. Re: How to integrate UCM Workflow Approval with Webcenter
          Sachin Saxena
          Hi Swathi,

          For this requirement you need to call IDC services using RIDC apis to get the workflow queue. Code snippet for calling any service in UCM :

          IdcClientManager manager = new IdcClientManager();
          IdcClient idcClient = manager.createClient("idc://localhost:4444");
          IdcContext userContext = new IdcContext(<username>, <password>);
          DataBinder binder = idcClient.createBinder();
          binder.putLocal ("IdcService", "serviceName");
          binder.putLocal ("paramName", "paramValue");
          ServiceResponse response = idcClient.sendRequest (userContext, binder);
          DataBinder serverBinder = response.getResponseAsBinder ();

          Using the above code snippet call the IdcService - LOAD_WORKFLOW_QUEUE:
          dataBinder.putLocal("IdcService", "LOAD_WORKFLOW_QUEUE");

          After this access the result set "WorkflowInQueue"

          DataResultSet resultSet =
          serverBinder.getResultSet("WorkflowInQueue");

          Iterate through the result set and access the data object rows to get all the document info.
          • 2. Re: How to integrate UCM Workflow Approval with Webcenter
            Sachin Saxena
            Also, if you need more details then you can get the workflow history for each document in queue.

            LOAD_WORKFLOW_QUEUE service will give you dDocName, dWfName and other security and user attributes. To get the workflow history pass the dDocName and dWfname to IdcService (GET_WORKFLOW_INFO_BYNAME).
            Get the result set :
            DataResultSet resultSet =
            serverBinder.getResultSet("WorkflowInQueue");

            For workflow approval call service - WORKFLOW_APPROVE for the particular document id.

            Also, you can use this url - /cs/idcplg?IdcService=REVIEW_WORKFLOW_DOC&dDocName=<>&dwfName= to review the workflow.

            Also, if you need more details then you can get the workflow history for each document in queue.

            LOAD_WORKFLOW_QUEUE service will give you dDocName, dWfName and other security and user attributes. To get the workflow history pass the dDocName and dWfname to IdcService (GET_WORKFLOW_INFO_BYNAME).
            Get the result set :
            DataResultSet resultSet =
            serverBinder.getResultSet("WorkflowInQueue");

            For workflow approval call service - WORKFLOW_APPROVE for the particular document id.

            Also, you can use this url - /cs/idcplg?IdcService=REVIEW_WORKFLOW_DOC&dDocName=&dwfName= to review the workflow.


            After doing all this you can create the collection of data fetched from the above services and render it on your custom page.

            Edited by: Sachin Saxena on May 11, 2012 5:48 PM

            Edited by: Sachin Saxena on May 11, 2012 5:52 PM
            • 3. Re: How to integrate UCM Workflow Approval with Webcenter
              783906
              Another option, would be to try out the content portlet suite that comes with UCM.
              It has a WorkFlow queue Portlet that can maybe satisfy your requirements.

              http://docs.oracle.com/cd/E14571_01/doc.1111/e10637/c03_producer.htm#BGBEFFBE

              Hope it helps !
              -Jeevan
              • 4. Re: How to integrate UCM Workflow Approval with Webcenter
                Sachin Saxena
                You are right. I think standard way to implement is to use CPS portlets.