Integration of Oracle BPM and Oracle UCM/WCC

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.

Using attachment documents with Oracle BPM Human Tasks
Using a Content Server documents with Oracle BPM Human Tasks
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:

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

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.

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.

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

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.

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.

You may now upload documents to your task:

Or search UCM for documents:

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.

References:

Oracle – Storing Documents in Oracle Enterprise Content Management
Alaa & Perco @ Oracle Forums – BPM 11.1.1.5.0 Features Pack: UCM integration issue

19 responses to “Integration of Oracle BPM and Oracle UCM/WCC”

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

Reply
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.

Reply
- 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.
  
  Reply
Remco

29-03-2013 at 11:41

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

Reply
- 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 :)
  
  Reply
  - 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.
Pingback: Integration of Oracle BPM and Oracle UCM/WCC by Jan van Zoggel | SOA Community Blog
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????

Reply
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”

Reply
- jvzoggel
  
  31-03-2013 at 15:30
  
  Hi Asadumar,
  Thank you for your reply! I quickly fixed the typo in the blogpost. :)
  regards,
  Jan
  
  Reply
premita

12-09-2013 at 06:40

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

Reply
Pingback: Oracle BPM, UCM and Humantasks | My Fusion MiddleWare Experiences
sylvain grosjean

02-10-2014 at 21:45

One more time : Thank you Jan for this post !

Reply
- jvzoggel
  
  02-10-2014 at 22:34
  
  Your welcome Sylvain :)
  
  Reply
AD

24-01-2015 at 18:09

Thanks Jan for the great post!

Do you know how the uploaded documents can be accessed for a completed task.

Reply
mostafa amin

26-10-2015 at 15:02

thx for useful information , i have question about search pop-up can i customize it (I mean add more field in search criteria ) or no .

Reply
Rafael

24-05-2016 at 21:17

Hi integration worked perfectly but only with weblogic User is possible to associate a group credentials?

Reply
Lakshmi Hari

28-03-2017 at 14:37

Hi Jan,

Great post, one quick question.
Can we have an integration with Documentum in the same way ?

Thanks,
Hari

Reply

J@n van Zoggel