Tuesday, 13 March 2012

SOA 11g - BPEL Tables and Dehydration store information


BPEL dehydration store :
The Dehydration Store database is used to store process status data, especially for asynchronous BPEL processes.

Key BPEL tables :

Table
Contents
CUBE_INSTANCE
Stores the instance header information: domain, creation date, state (completed, running, stale, canceled), priority, title, and so on
CUBE_SCOPE
Stores the state of the instance, (variable values and so on)
AUDIT_TRAIL
Audit trail information for an instance. This information can be viewed from BPEL Console.
AUDIT_DETAILS
Large detailed audit information about a process instance
DLV_MESSAGE
Callback message metadata
DLV_MESSAGE_BIN
Payload of callback messages
INVOKE_MESSAGE
Invocation messages metadata
INVOKE_MESSAGE_BIN
Payload of invocation messages
DLV_SUBSCRIPTION
Delivery subscriptions for an instance
TASK
Tasks created for an instance (i.e. title, assignee, status, expiration)