Database Reference
In-Depth Information
Table
Description
AUDIT_TRAIL
This table stores the audit trail for instances. The audit
trail viewed in Oracle SOA Suite
11g
Enterprise Man-
ager console is created from an XML document. As an
instance is processed, each activity writes events to
the audit trail as XML. The table contains a column
named LOG which is a Large Object RAW Column.
Each step in a process gets logged into the LOG
Column in XML zipped form.
CUBE_INSTANCE
Process instance metadata such as the instance cre-
ation date, current state, title, and process identifier
are stored in this table. For each process instance an
entry gets created in this table. The table also con-
tains the relationship between parent and child in-
stances in fields:
cikey, parent_id
, and
root_id
.
CUBE_SCOPE
This table stores the scope data for an instance (that
is, all variables declared in the process flow and some
internal objects that help route logic throughout the
flow).
DLV_MESSAGE
The DLV_MESSAGE table stores callback messages
when they are received by running instances. It only
stores the metadata for a message such as the cur-
rent state, process identifier, and receive date.
