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
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
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.
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.
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????
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
premita
12-09-2013 at 06:40
How can i disable this error from the SOA email notification ?
sylvain grosjean
02-10-2014 at 21:45
One more time : Thank you Jan for this post !
jvzoggel
02-10-2014 at 22:34
Your welcome Sylvain :)
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.
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 .
Rafael
24-05-2016 at 21:17
Hi integration worked perfectly but only with weblogic User is possible to associate a group credentials?
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