Friday, August 12, 2011

Oracle SOA/BPM - Searching and Reporting Using Process Payload

For searching business process instances using specific attributes from the payload, the regular way to do so when using the Oracle SOA Suite is by using mapped attributes (formerly known as flex fields).

Using mapped attributes is pretty straight-forward. You configure them in the Administration tab of the Workspace, and map a specific element of the payload onto a mapped attribute. Once it has been mapped, the attribute can be added as a column to the task list and is available for filtering. The mapped attributes can also be used in custom code via the API.


Things to Consider

Mapped attributes have some important aspects to consider:
  • They can only be used for simple type attributes (String, Number, Date),
  • Mappings are task-specific, so to be able to search for example on an order.status element throughout the process you have to map it for each activity,
  • There is a limited amount of mapped attributes (20 Strings, 10 Number and 10 Dates),
  • Changes to mapped attributes are only applied to instances instantiated after the mapping took place,
  • When instances are purged all historical data of those instances will no longer be available. In a production environment, purging of instances typically is done by a Systems Administrator with no (functional) knowledge of specific processes.
Especially the latter two aspects may require a different approach to secure full flexibility regarding searching and reporting on instances. This might for example be the case when there is a requirement that historical data should be kept indefinitely, or should only be purged in a controlled way by a Applications Administrator. In case of BPM, the requirement for a flexible approach on searching and reporting on process instances is pretty common.

In such cases an alternative to using mapped attributes (and reporting using the dehydration store) is to have a some custom database in which significant updates to process data are being stored. The advantage over using flex fields would be that:
  • There is no limitation in the amount of attributes,
  • The data of old instances can be manipulated, e.g. by providing default values for new attributes,
  • Management of the custom database can be delegated to some Application Administrator that does have (functional) knowledge about the process.
The advantage of not needing to create a mapping per task, will obviously be over-compensated by the fact that the process has to do a service call every time the data needs to be saved, but again this buys back a lot of flexibility.

Instead of using service calls to save this data, you may consider composite sensors. A composite sensor is a specific type of BPEL Process Manager Sensors. Be aware though that composite sensors can only monitor incoming and outgoing messages, and not changes of the payload within a process instance. For this reason in most cases this won't be an alternative.

6 comments:

SEO tools said...

Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.

Anonymous said...

Hi Jan,

Thank you for your post. I have a question. I have a flexfield and its type is datetime. This field is optional, so sometimes the user don't fill it in the form, when this happen I have the next error: ORABPEL-77003 Invalid value for assignment. Unable to assign value to data element dateEnd with type.

Do you know if it's possible have optional datetype fields as flexfield? Thank you

Karunia-MU said...

obat wasir
pengobatan wasir secara herbal
obat wasir untuk ibu hamil dan usia
obat wasir tradisional ampuh
obat wasir tanpa operasi
obat wasir ambeien untuk ibu hamil
obat wasir stadium akut
obat wasir stadium 1 2 3 dan 4
obat wasir sehabis melahirkan
obat wasir saat hamil
obat wasir nyeri di anus
obat wasir menahun
obat wasir ambeien kronis
obat wasir keluar benjolan di anus
obat wasir herbal
obat wasir dan diagnosa ambeien
obat wasir cepat sembuh
obat wasir berdarah tuntas
obat wasir berdarah untuk ibu hamil
obat wasir ada benjolan biru di anus
obat wasir bengkak
obat wasir anus nyeri dan pedih
obat pencegah wasir
obat wasir gejala ambeien
cara mengobati wasir

Sukaku said...

thank's
Cara Mengobati Sekitar Kemaluan yang Bernanah
Cara Cepat Mengobati Sekitar Kemaluan yang Bernanah
Cara Mengobati Sekitar Kemaluan Lelaki yang Bernanah
Cara Untuk Mengobati Sekitar Kemaluan yang Bernanah
Cara Mengobati Sekitar Kemaluan Wanita yang Bernanah

Unknown said...

Obat untuk Ambeien Sudah Level Akut
Cara Aman Menyembuhkan Ambeien Berdarah Tanpa Operasi
Cara Ampuh Mengobati Ambeien Akut
Cara Cepat Mengobati Benjolan Kutil di Kemaluan
Obat Wasir Ambeien
Dari Batang Kemaluan Pria Keluar Banyak Nanah
Cara Tradisional Menyembuhkan Ambeien Wasir Tanpa Operasi
Cara Mengobati Ambeien Wasir tanpa Operasi
Obat Ambeien Luar Salep di Apotik
Mengobati Penyakit Ambeien Hemoroid Berdarah Tanpa Operasi
Obat Penyakit Kanker Alami
Cari Obat Kondiloma Akuminata Alami
Pengobatan Kemaluan Wanita Mengeluarkan Nanah dan Darah
Obat Kemaluan Wanita Mengeluarkan Nanah dan Darah
Terapi Mengobati Penyakit Ambeien Parah Tanpa Operasi
Obat Dari Kemaluan Pria Keluar Seperti Nanah
Terapi Pengobatan Kanker Alami
Obat Ampuh untuk Ambeien Ibu Menyusui Sudah Akut
Cara Alami Menyembuhkan Penyakit Ambeien Tanpa Operasi
Cara Mengobati Kutil di dekat Kemaluan
Mengobati Benjolan Kutil di Kemaluan Wanita
Pengobatan Dari Kemaluan Pria Keluar Cairan Nanah
Cara Aman Menyembuhkan Penyakit Ambeien Tanpa Operasi
mengapa dari kemaluan pria keluar nanah
Obat Kondiloma Akuminata Alami di Apotik
Cara Ampuh Buat Mengobati Ambeien
Pengobatan Penyakit Kanker Alami

Anonymous said...

good
Jual Obat Alami Kanker Payudara
Jual Obat Ampuh Kanker Payudara
Jual Obat Herbal Kanker Payudara
Jual Obat Tradisional Kanker Payudara
Pengobatan Kanker Payudara
Obat Kanker Alami Payudara
Obat Herbal Kanker Payudara
Obat Untuk Kanker Payudara
Kumpulan Obat Kutil Kemaluan
Kumpulan Obat Kutil Kemaluan yang di Apotik
Kumpulan Obat Alami Kutil Kemaluan di Apotik
Kumpulan Obat Kutil di Apotik
Resep Obat Ampuh Kutil Kemaluan di Apotik
Resep Obat Alami Kutil Kemaluan di Apotik
Resep Obat Kutil Kemaluan
Resep Obat Herbal Kutil Kemaluan di Apotik
Jual Obat Kutil Kemaluan Apotik
Jual Obat Kutil di Apotik
Jual Obat Ampuh Kutil Kemaluan di Apotik
Jual Obat Alami Kutil Kemaluan di Apotik
Obat Ampuh Kutil Kemaluan di Apotik
Obat Untuk Kutil Kemaluan di Apotik
Obat Herbal Kutil Kemaluan di Apotik
Obat Tradisional Kutil Kemaluan di Apotik