RSS

Integration of Oracle BPM and Oracle UCM/WCC

31 Jan

This blog is the 3rd in a serie of 3 blogposts. All regarding the different approaches we tested during our project where we had very content rich (a lot of documents) Oracle BPM processes.

  1. Using attachment documents with Oracle BPM Human Tasks
  2. Using a Content Server documents with Oracle BPM Human Tasks
  3. Integration of Oracle BPM and Oracle WCC/UCM

So let’s start with the beginning. The Oracle documentation mentions how to enable this integration from the Human Task configuration. However it’s a bit vage how to configure the UCM/BPM integration itself.

So first we enable this magical checkbox on our Human Task:

01_HumanTask_UseDocumentPackage

Which after deployment results in this error message: Document Store not available. Please configure the document store.

02_Error_DocumentOpslagNietBeschikbaar

When we check our loggings we can see that:


<Error> <oracle.soa.services.common> <BEA-000000><oracle.bpel.services.workflow.repos.UCMUtil.getUCMInfo>
Error retrieving UCM information from the server.
Ensure that credential store map WF-ADMIN-USER with key WF-ADMIN-CREDENTIAL contains UCM server admin username/password.
Also ensure that Workflow configuration parameter UcmIdcUrl contains IDC socket connection url to connect to UCM server and UCM server has permission to let SOA server connect to it using IDC protocol.

Of to work we go. We need to make sure that our SOA/WLS/UCM configuration is correct and these settings are scattered on multiple locations in Oracle Enterprise Manager.

Before we start you need to make sure you have the IDC (IntraDoc) port of your UCM installation. To verify this check your UCM configuration file: %domainhome%/ucm/cs/config/config.cfg
Most likely this will be 4444.

First the SOA/BPM part:
Right-click soa-infra -> SOA Administration -> Workflow config -> “More Workflow Notification Configuration Properties” -> workflow config -> human-workflow.
Make sure the setting UcmIdcUrl is configured correctly to contain the UCM-server hostname and IDC port.

11_SOAINFRA_Config1

Second we configure the username and password the BPM/SOA engine will use to connect to the UCM server which is located in the Weblogic section of EM. So rightclick on your domain in Weblogic Domain -> yourdomain -> Security -> Credentials.

14_WLS_Security1

Create a new Map WF-ADMIN-USER and in that map create a new Key WF-ADMIN-CREDENTIAL

15_WLS_Security2

3rd part is to make sure the UCM server will accept our connection, so let’s rightclick the Oracle Universal Content Management server in the WebCenter section of your Enterprise Manager. Make sure the Intradoc (IDC) serverport is correct and that the IP filter contains the SOA/BPM server hostname.

13_UCM_Security1

Save, restart if needed and check your Workspace Manager again for your attachments.
And voila the error shouldn’t be there anymore and when clicking the Add icon you will now find some additional UCM options. Small cheer here, your BPM/UCM configuration is now working.

Result

You may now upload documents to your task:

21_Task_UploadUCM

Or search UCM for documents:

22_Task_SearchUCM

Success, we have a working configuration between Oracle BPM and Oracle UCM.

In our case we have the additonal requirement to attach the document from the BPM process as mentioned in the earlier blogpost.So instead of mapping the full URLfor our content management server and document in the attachment.URI element, we can just simply use the following function: concat(“ecm://”,bpmn:getDataObject(‘DO_Case’)/ns1:case/…/DocumentNr)
where documentNr is an element containt the ID returned by the UCM servers CheckInUniversal operation.

The attachment.URI element will look something like this: ecm://100
Besides that, make sure to the attachment.StorageType ellement to: UCM

When the task is assigned to the BPM Workspace it will now contain the reference to the correct UCM document.

Attachment

References:

About these ads
 
15 Comments

Posted by on 31-01-2013 in BPM, Oracle, UCM, WCC

 

Tags: , , ,

15 responses to “Integration of Oracle BPM and Oracle UCM/WCC

  1. Pramila

    21-02-2013 at 18:52

    Hi ,

    I followed the steps followed by you.but i am facing issue.

    I am getting the errors like :

    Content Item (‘null’) was not successfully checked in. Content account is not defined. Unable to validate user security.

    Error occur while inserting a task attachment record.

    Please guide me to solve this issues.

    Thanks & Regards :

    Pramila Padam

     
  2. rajendar

    18-03-2013 at 13:39

    by using this i am able to upload document, but our requirement is to add some Customattributes to that document, can u explain how.bz whether i have to configure it in UCM level , i am not able to get that.

     
    • jvzoggel

      29-03-2013 at 11:53

      When we insert documents in UCM with our CheckInUniversal WSDL we also add customization metadata. However I’m not sure how this works from ADF/BPM. Our project is currently building our own custom BPM workspace so we will have to look into the document connection as well.

       
  3. Remco

    29-03-2013 at 11:41

    Is it possible to do this in combination with SSO credentials??

     
    • jvzoggel

      29-03-2013 at 11:49

      I think the connection between SOA and WCC domain configured in EM is purely used for the connection. Our users on ADF/BPM do have the correct access on UCM/WCC for the documents.
      However we are currently on development using 1 domain with both SOA and WCC. This will change very soon with our new TST environment so we will find out :)

       
      • nirmani

        23-04-2013 at 10:32

        Hi,
        Thanks for your great Post …..
        Can you please explain how can we achieve SSO in these two modules …
        Thanks in advance

         
      • jvzoggel

        24-04-2013 at 15:50

        Hi Nirmani. I’m not sure to be honest. We haven’t yet spend time in our project on SSO between BPM Workspace & UCM.

         
  4. asadumar

    29-03-2013 at 13:53

    nice article… but i am still getting the error…. my BPM and WCC are on different weblogic domain… have tried setting the Global trust but didnt work…
    Any comments plz????

     
  5. asadumar

    29-03-2013 at 15:34

    the issue was with the key, it is WF-ADMIN-CREDENTIAL (without an “S”)

    “Create a new Map WF-ADMIN-USER and in that map create a new Key WF-ADMIN-CREDENTIALS”

     
    • jvzoggel

      31-03-2013 at 15:30

      Hi Asadumar,
      Thank you for your reply! I quickly fixed the typo in the blogpost. :)
      regards,
      Jan

       
  6. premita

    12-09-2013 at 06:40

    How can i disable this error from the SOA email notification ?

     
  7. sylvain grosjean

    02-10-2014 at 21:45

    One more time : Thank you Jan for this post !

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 355 other followers

%d bloggers like this: