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.


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.

let it snow said...

good thanks for sharing

hey friend see snow on google
Type “Let It Snow” on @Google If you click and drag you can wipe the snow away. It is great. source:

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

kurnia tani 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

kurnia tani said...

obat gejala dan penyebab wasir
cara mengobati wasir_4
obat ambeien ampuh terbukti cepat sembuh
obat wasir tuntas
obat wasir bengkak_4
obat wasir nyeri di anus_4
obat wasir menahun_4
obat wasir untuk ibu hamil
pengobatan wasir
operasi wasir
obat wasir luar
obat wasir anus keluar benjolan biru
obat wasir ampuh terbukti cepat sembuh
obat wasir saat hamil tua
obat wasir alami_2948
obat tanaman untuk wasir
obat wasir eksternal
obat wasir ampuh
wasir sembuh secara herbal
obat wasir berdarah
atasi wasir tanpa efek samping
obat wasir tradisional
obat oles wasir
obat wasir apotik

kurnia tani said...

obat tradisional wasir eksternal
obat wasir tradisional untuk ibu
iklan obat wasir dan ambeien
jamu wasir
jamu menyembuhkan ambeien
obat manjur wasir kronis
obat ampuh untuk wasir akut
perbedaan wasir dan ambeien
obat wasir dan diagnosa wasir
obat wasir internal
jual obat wasir
harga obat wasir
jamu ambeien internal
jamu ambeien dan diagnosa ambeen
obat ampuh untuk ambeien akut
jamu menyembuhkan ambein
jamu ambeien
obat ambeien tradisional untuk ibu
obat tradisional ambeien eksternal

Sukaku said...

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

Budi Santoso 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

Art Jokja said...

gantungan kunci
gantungan kunci partai
gantungan kunci bahan akrilik
gantungan kunci
pusat gantungan kunci jogja
kado cantik
cara pemesanan ganci
testimoni ganci
gantungan kunci
gantungan kunci
papan strategi
gantungan kunci pemain
cara pemesanan
papan strategi bola
gantungan kunci pemain bola
gantungan kunci
gantungan kunci 2 muka
gantungan kunci foto
gantungan kunci foto
gantungan kunci akrilik untuk kenangan

Art Jokja said...

gantungan kunci
gantungan kunci dealer
gantungan kunci bahan akrilik cetak
gantungan kunci
gantungan kunci kado
gantungan kunci akrilik untuk hadiah
gantungan kunci
grosir souvenir cantik
gantungan kunci cindera mata
souvenir dan gantungan kunci unik
gantungan kunci
grosir souvenir online
grosir souvenir cantik dan murah
grosir souvenir unik
gantungan kunci
gantungan kunci jogja
gantungan kunci
pesan gantungan kunci akrilik untuk
gantungan kunci
gantungan kunci hotel

Art Jokja said...

gantungan kunci akrilik untuk
gantungan kunci
gantungan kunci cinderamata
pesan gantungan kunci akrilik
gantungan kunci
pusat souvenir jogja
gantungan kunci dan souvenir
cinderamata ganci
kado gantungan kunci
papan strategi bola
cara pemesanan ganci
testimoni pelanggan ganci
gantungan kunci
gantungan kunci aklilik
souvenir cntik murah
souvenir dan gantungan kunci unik
cara order souvenir
testimoni pelanggan gancijogja
pesan gantungan kunci akrilik
pesan gantungan kunci
gantungan kunci akrilik