Wednesday Jan 28, 2015

SOA Instance States Table

Oracle SOA Suite composite instance state ids and descriptions table.[Read More]

Monday Jan 26, 2015

BPM Actionable Email Configuration

Step 1: Create e-mail account with mailbox.It means that account can get e-mail.

Step 2: Update user messaging driver

Step 3: Update Workflow properties

Step 4: Check driver config file (driverconfig.xml) from server. Config file path is "/data/oracle/domains/SOABPM-TEST-DMN/config/fmwconfig/servers/SAOBPM/applications/usermessagingdriver-email/configuration/".

Step 5: Restart SOA servers

Step 6: Create Test Composite

Step 7: Make humantask notification actionable

Step 8: Deploy & Test it.

You can download test application Click!

[Read More]

Tuesday Dec 16, 2014

Close and ReOpen Process as a New Instance

Step 1: Create Main Process

Step 2: Call Sub Process with Send Task

Step 3: Return from Sub Process with Receive Task

Step 4: Call Sub Process for Creating new instance

Step 5: Create Sub Process

Step 6: Sub Process Start activity

Step 7: Sub Process Cancel activity

Step 8: Sub Process End activity for cancel

composite.xml file

[Read More]

Wednesday Nov 19, 2014

Call SubProcess N Times and wait All Of Them are Completed!

Step 1: Create Main Process

Step 2: Create Sub Process

Step 3: Create DB Adapter for getting instance count

You can read my blog post about how to create and use DBAdapter. Click for read.

Step 4: Check your "composite.xml" file.

Step 5: Calling your Sub Process with "Service Task"

Step 6: Call DB Adapter with "Service Task"

Step 7: Check Process Instance Count with "Exclusive Gateway"

If count equals 1, all off subprocesses are completed with/without error. Otherwise there must be a subprocess that is running, because all of subprocesses are generated with same ECID that is as same as main process ECID

[Read More]

Tuesday Nov 18, 2014

Execute Pure SQL With DBAdapter

Step 1: Create DB Adapter

Step 2: Call DB Adapter with Service Task

[Read More]

BPM Set Instance Title

Step 1: Create BPM Application

Step 2: Add "Script" activity called "SetInstanceTitle"

Step 3: Using "ora:setCompositeInstanceTitle()" XPATH function.

Step 4: Check it on EM console

[Read More]

Friday Apr 25, 2014

Deployment failed because of "unrecoverable incompatibilities"

Edit composite.xml and add a new property.

<property name="oracle.bpm.bpmn.force.deploy">true</property> 

[Read More]

Thursday Apr 17, 2014

How To Reuse UserLogin in OIM

After delete a user, you can reuse userlogin in OIM. Please follow the steps below.

Step 1:  Login system admin screen and click on "System Configuration"

Step 2: Search and find "User Id Reuse property" and set value to "TRUE"

Step 3: Connect OIM database and find "UDX_USER_LOGIN" index and copy its sql script.

Step 4: Drop index.

Step 5: Recreate index as nonunique index. 

[Read More]

Change Email Validation For Uniqueness in OIM

Change email validation for uniqueness in OIM. Please follow the steps below.

Step 1:  Login system admin screen and click on "System Configuration"

Step 2: Search and find "Email Uniqueness property" If you do not click on "Create"

Step 3: Research and be sure :)

[Read More]

Tuesday Apr 08, 2014

Custom Flow History Table

Step 1: Create BPM Application

Step 2: Create Business Module

Step 3: Create Business Objects

Step 4: Update Business Objects

Step 5: Create Custom Test Flow

Step 6: Modify Script Tasks in Test Flow

Step 7: Create Custom user interface for task

Step 8: Add table into user interface.

End: Deploy & Run

[Read More]

Thursday Apr 03, 2014

Certification tab in OIM 11g R2 PS2

Step 1: Open Sysadmin Console (http://[hostname]:[port]/sysadmin)

Step 2: System Configuration

Step 3: Search [*Display*]

Step 4: Change Value

Step 5: Save and Restart Server

[Read More]

Sunday Mar 02, 2014

Parallel Approval with using "List of Approvers"

Step 1: Create "Parallel Approval" human task

Step 2: Create Approver List

Step 3: Create approver string (Str_ApproverList) using with approver list.

Use this formula:

[Read More]

Wednesday Feb 26, 2014

How to Find Last Approver of HumanTask

In this workflow you can find last approver of UserTask with using the steps below.

These steps are:

1 - Create and associate "TaskId" attribute.

2 - Use this formula: "hwf:getPreviousTaskApprover(bpmn:getDataObject('TaskId'))"

[Read More]

Monday Jan 27, 2014

Oracle Book: The World of Big Data

This book explores the ways in which big data is changing the world around us and looks at how businesses and consumers are being influenced by the high-speed analysis of the data we create through our everyday lives and transactions. The book delves beneath the hype of big data and looks at tangible examples of how it can work: from anticipating when we might buy an engagement ring to reducing crime, via proving who are the safest drivers on the road, winning the world’s oldest sporting trophy and showing how selling turkeys can be a delicate balancing act for 24 hour supermarkets.

06 Jan 2014


Softcopy of a little book about big data, containing use cases, scenarios and discussion about this issues of big data in the real world.


You may download and use the images on this site, but please ensure that you attribute them to Oracle when you use them.

[Read More]

Monday Jan 20, 2014

What’s New in Oracle Identity Manager 11gR2 PS2?

Oracle Identity Manager is a highly flexible and scalable enterprise identity administration system that provides operational and business efficiency by providing centralized administration & complete automation of identity and user provisioning events across enterprise as well as extranet applications. Part of the Oracle Identity Governance Suite, it provides role lifecycle management and privileged account management, ensuring consistent enforcement of identity based controls thereby reducing ongoing operational and compliance costs. This blog post highlights key new features introduced in Oracle Identity Manager 11gR2 PS2. 

  • Dynamic Organization Membership 
  • Simplified Request Management 
  • Collaborative Certification Process 
  • Improved Diagnostics 
[Read More]

I am a member of the Fusion Middleware Applications Consultancy team.

I focus on tips and tricks FMW applications consultancy but also have a strong interest in ADF Development & Achitecture, Oracle BPM, Oracle Identity Manager and Oracle SOA Suite.

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.


« February 2016