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)