A Integrating with Business Intelligence using Process Star Schema Views
This appendix describes how to integrate Oracle BPM with Business Intelligence using process star schema views. It also contains reference material for standard and process specific views.
This appendix contains these topics:
A.1 About Integrating Oracle BPM Process Star Schema with Business Intelligence (BI)
Oracle BPM provides process star schema views. These provide access to the BPM Process Cubes data and can be used by any external BI tool for analysis and reporting purposes.
If cubes are enabled, the the BPM process cubes is populated when BPMN Service engine runs the processes in your project. To view the data stored in these process star schema, you use the dashboards provided by Oracle Business Process Management Workspace.
For more information about generating process metrics, see Oracle Fusion Middleware Modeling and Implementation Guide for Oracle Business Process Management.
For information about how process metrics are displayed in Process Workspace, see Oracle Fusion Middleware User's Guide for Oracle Business Process Management.
Note:
Data in the process star schema is not permanent. It can be deleted as a result of process undeployment. It can result from data expiration configuration in Enterprise Manager. It can also result from executing a purge script to delete a large number of instances at a system level.
Oracle recommends that, for any historic analysis or reporting needs, process star schema data be pulled from a separate data warehouse at a periodic time interval.
Also, for performance reasons, Oracle recommends against analyzing data directly over process star schema views.
A.2 Standard Views
During Oracle BPM installation, standard facts and dimension views are created on top of the process star schema.
This section contains these topics:
A.2.1 Dimension Views
During installation, the following dimension views are created:
-
Process definition view
-
Activity defintion view
-
Role definition view
A.2.2 Standard Fact Views
Standard views contain information about standard metrics—for example, the cycle-time and the number of instances for such standard dimensions as process, activity, and participant. These views contain process and activity data about all available processes. Standard fact views are created during installation time.
Standard views are organized as follows:
A.2.2.1 Views Representing Fact Tables
Table A-1 lists and describes the standard fact views and their corresponding tables.
Table A-1 Standard Fact View Tables
| View | Description | Table |
|---|---|---|
|
Task Performance |
Provides information on standard metrics for completed activities, completed intervals, measurement marks and counters for both in-flight and completed processes. |
|
|
Process Performance |
Provides information on standard metrics for completed processes. |
|
|
Active Activity Instances |
Provides information on standard metrics for in-flight activity and interval instances. This information is relevant only for the snapshot time at which the view is queried. As processes move forward, information in this view changes to reflect the new state. |
|
|
Active Process Instances |
Provides information on standard metrics for in-flight process instances. This information is relevant only for the snapshot time at which the view is queried. As processes move forward, information in this view changes to reflect the new state. |
A.2.2.2 Views Representing Standard Dimension Tables
Table A-2 lists the standard dimension views and the corresponding tables.
A.2.2.3 BPM_ACTIVITY_PERFORMANCE_V
BPM_ACTIVITY_PERFORMANCE_V is the standard task performance view.
A.2.2.3.1 Data Granularity
This view contains a record corresponding to each of the following for both in-flight and completed processes.
-
Completed process activities
-
Faulted process activities
-
Completed intervals
-
Measurement marks
-
Measurement counters
A.2.2.3.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
ACTIVITY_ID
-
PROCESS_INSTANCE_ID
A.2.2.3.3 Metrics Information
Following metrics information is available as part of this view
-
ACTIVITY_START_TIME
-
ACTIVITY_END_TIME
-
ACTIVITY_RUNNING_TIME_IN_MSEC
Table A-3 BPM_ACTIVITY_PERFORMANCE_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
ACTIVITY_ID |
NUMBER |
Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID |
|
ACTIVITY_LABEL |
VARCHAR2 |
Activity Label |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
ACTIVITY_DISCRIMINATOR |
VARCHAR2 |
Used for determining if this record corresponds to a faulted activity. For faulted task performance records, the value of this column is set to "INSTANCE_FAULT" |
|
ACTIVITY_ROLE_ID |
NUMBER |
Role Id. References BPM_ROLE_DEFINTION_V.ROLEID |
|
ACTIVITY_ROLE_NAME |
VARCHAR2 |
Role Name associated with the activity instance |
|
ACTIVITY_START_TIME |
TIMESTAMP |
Time at which activity instance started execution |
|
ACTIVITY_END_TIME |
TIMESTAMP |
Time at which activity instance finished execution |
|
ACTIVITY_RUNNING_TIME_IN_MSEC |
NUMBER |
Duration in millisecs for which activity instance executed |
|
ACTIVITY_PARTICIPANT |
VARCHAR2 |
Participant user associated with the activity instance |
|
ACTIVITY_PRIORITY |
NUMBER |
Priority of activity instance (not available in PS2) |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
A.2.2.4 BPM_PROCESS_PERFORMANCE_V
BPM_PROCESS_PERFORMANCE_V is the standard process performance view.
A.2.2.4.1 Data Granularity
This view contains a record for the following
-
Completed Processes
-
Aborted Processes
-
Faulted Processes
A.2.2.4.2 Unique Key
Following columns form the unique key
-
SEQUENCE_ID
-
PROCESS_ID
-
PROCESS_INSTANCE_ID
A.2.2.4.3 Metrics Information
Following metrics information is available as part of this view
-
PROCESS_START_TIME
-
PROCESS_END_TIME
-
PROCESS_RUNNING_TIME_IN_MSEC
Table A-4 BPM_PROCESS_PERFORMANCE_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_DISCRIMINATOR |
VARCHAR2 |
Used for determining if this record corresponds to a faulted process. For faulted process performance records, the value of this column is set to "INSTANCE_SYSTEM_FAULT" |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
PROCESS_END_TIME |
TIMESTAMP |
Time at which process instance finished execution |
|
PROCESS_RUNNING_TIME_IN_MSEC |
NUMBER |
Duration in millisecs for which process instance executed |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
A.2.2.5 BPM_ACTIVITY_INSTANCE_V
BPM_ACTIVITY_INSTANCE_V view provides information about each in-flight running activity instance across all processes.
A.2.2.5.1 Data Granularity
This view contains a record corresponding to each in-flight activity instance.
A.2.2.5.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
ACTIVITY_ID
-
PROCESS_INSTANCE_ID
A.2.2.5.3 Metrics Information
Following metrics information is available as part of this view
-
ACTIVITY_START_TIME
-
PROCESS_START_TIME
Table A-5 BPM_ACTIVITY_INSTANCE_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
ACTIVITY_ID |
NUMBER |
Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID |
|
ACTIVITY_LABEL |
VARCHAR2 |
Activity Label |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_THREAD_ID |
NUMBER |
Thread id of Process thread executing the activity |
|
ACTIVITY_ROLE_NAME |
VARCHAR2 |
Role Name associated with the activity instance |
|
ACTIVITY_PARTICIPANT |
VARCHAR2 |
Participant user associated with the activity instance |
|
ACTIVITY_PRIORITY |
NUMBER |
Priority of activity instance |
|
ACTIVITY_START_TIME |
TIMESTAMP |
Time at which activity instance started execution |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
A.2.2.6 BPM_PROCESS_INSTANCE_V
BPM_PROCESS_INSTANCE_V view provides information about each in-flight process instance across all processes.
A.2.2.6.1 Data Granularity
This view contains a record corresponding to each in-flight process instance.
A.2.2.6.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
PROCESS_INSTANCE_ID
A.2.2.6.3 Metrics Information
Following metrics information is available as part of this view
-
PROCESS_START_TIME
Table A-6 BPM_PROCESS_INSTANCE_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
A.2.2.7 BPM_PROCESS_DEFINITION_V
BPM_PROCESS_DEFINITION_V view provides the information about BPMN processes.
Table A-7 BPM_PROCESS_DEFINITION_V
| Column Name | Data Type | Description |
|---|---|---|
|
PROCESSID |
NUMBER |
Process id. |
|
PROCESSNAME |
VARCHAR2 |
Name of the process |
|
DOMAINNAME |
VARCHAR2 |
Domain name |
|
COMPOSITENAME |
VARCHAR2 |
Composite name |
|
REVISION |
VARCHAR2 |
Composite Revision |
|
SCALABEL |
VARCHAR2 |
Composite SCA Label |
|
COMPOSITEDN |
VARCHAR2 |
Composite DN |
|
LABEL |
VARCHAR2 |
Process Label (BPMN NAME) |
|
PROCESSTYPE |
VARCHAR2 |
Type of the process (e.g. 'BPMN' etc) |
|
STATUS |
SMALLINT |
Process deployment status. " 1" = Deployed "-1" = Undeployed |
|
UNDEPLOYDATE |
TIMESTAMP |
Process undeployment date |
A.2.2.8 BPM_ACTIVITY_DEFINITION_V
BPM_ACTIVITY_DEFINITION_V view provides the information about activities corresponding to all available BPMN processes.
Table A-8 BPM_ACTIVITY_DEFINITION_V
| Column Name | Data Type | Description |
|---|---|---|
|
ACTIVITYID |
NUMBER |
Activity id. |
|
PROCESSID |
NUMBER |
Process Id. Refers to BPM_PROCESS_DEFINTION_V.PROCESSID |
|
ACTIVITYNAME |
VARCHAR2 |
Name of the Activity (BPMN ID) |
|
ACTIVITYTYPE |
VARCHAR2 |
Type of activity (UserTask, Gateway, Event, Measurement Interval etc.) |
|
LABEL |
VARCHAR2 |
Activity label (BPMN NAME) |
A.2.2.9 BPM_ROLE_DEFINITION_V
BPM_ROLE_DEFINITION_V view provides the information about roles corresponding to all available BPMN processes
A.3 Process-Specific Views
To capture any business dimensions and measures specified for a given Oracle BPM project, you must create views specific to each process.
A process-specific view provides access to data across all corresponding process versions. It has columns for business indicators across all process versions.
For a given process, Oracle Business Process Management resolves all business indicators to their corresponding flex columns across all process versions. It then creates all the process-specific views.
When a BPMN process is deployed, the corresponding process-specific views are created.
When a BPMN process is undeployed, the corresponding process specific views are either:
-
Dropped, if no other versions of the process are currently deployed
-
Recreated, if other versions of the process are still deployed
These views use the following naming convention:
| View | Table |
|---|---|
|
Task Performance |
|
|
Process Performance |
|
|
Active Activity Instances |
|
|
Active Process Instances |
Note:
-
IDENTIFIER is the analytics view identifier defined for a BPMN process during design time. It has a maximum length of 10. If "Analytics View Identifier" is not defined for a process, then process-specific views are not created for that process.
You can define an analytics view identifier for a BPMN process in Oracle BPM Studio.
-
In Oracle BPM Studio, the length of the business indicator name cannot exceed 28 characters.
A.3.1 BPM_ACTV_PERF_<IDENTIFIER>_V
BPM_ACTV_PERF_<IDENTIFIER>_V is the process specific task performance view.
A.3.1.1 Data Granularity
This view contains a record corresponding to each of the following for both in-flight and completed processes.
-
Completed activities
-
Faulted activities
-
Completed intervals
-
Measurement marks
-
Measurement counters
A.3.1.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
ACTIVITY_ID
-
PROCESS_INSTANCE_ID
A.3.1.3 Metrics Information
Following metrics information is available as part of this view
-
ACTIVITY_START_TIME
-
ACTIVITY_END_TIME
-
ACTIVITY_RUNNING_TIME_IN_MSEC
-
All Business indicator values as of activity end time.
Table A-11 BPM_ACTV_PERF_<IDENTIFIER>_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
ACTIVITY_ID |
NUMBER |
Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID |
|
ACTIVITY_LABEL |
VARCHAR2 |
Activity Label |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_THREAD_ID |
VARCHAR2 |
Id of the thread executing the activity. Parallel activities in a process are executed by different thread and hence will have different thread id. |
|
ACTIVITY_DISCRIMINATOR |
VARCHAR2 |
Used for determining if this record corresponds to a faulted activity. For faulted task performance records, the value of this column is set to "INSTANCE_FAULT". For counter records, the value of this column is set to 'MEASUREMENT_COUNTER' |
|
ACTIVITY_ROLE_ID |
NUMBER |
Role Id. References BPM_ROLE_DEFINTION_V.ROLEID |
|
ACTIVITY_ROLE_NAME |
VARCHAR2 |
Role Name associated with the activity instance |
|
ACTIVITY_START_TIME |
TIMESTAMP |
Time at which activity instance started execution |
|
ACTIVITY_END_TIME |
TIMESTAMP |
Time at which activity instance finished execution |
|
ACTIVITY_RUNNING_TIME_IN_MSEC |
NUMBER |
Duration in millisecs for which activity instance executed |
|
ACTIVITY_PARTICIPANT |
VARCHAR2 |
Participant user associated with the activity instance |
|
ACTIVITY_PRIORITY |
NUMBER |
Priority of activity instance |
|
ECID |
VARHCAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
|
D_<dimension1…n> |
VARCHAR2 / NUMBER / TIMESTAMP |
Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables |
|
R_<dimension1…n> |
VARCHAR2 |
Range information corresponding to numeric/date type dimension business indicators associated with the activity instance |
|
M_<measure1…n> |
NUMBER |
Measure business indicators associated with the activity instance |
|
C_<counter1…n> |
NUMBER |
Counter business indicator associated with the activity instance |
A.3.2 BPM_PRCS_PERF_< IDENTIFIER >_V
BPM_PRCS_PERF_< IDENTIFIER >_V is the process specific process performance view.
A.3.2.1 Data Granularity
This view contains a record for the following
-
Completed Processes
-
Aborted Processes
-
Faulted Processes
A.3.2.3 Metrics Information
Following metrics information is available as part of this view
-
PROCESS_START_TIME
-
PROCESS_END_TIME
-
PROCESS_RUNNING_TIME_IN_MSEC
-
All Business indicator values as of process end time.
Table A-12 BPM_PRCS_PERF_< IDENTIFIER >_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_DISCRIMINATOR |
VARCHAR2 |
Used for determining if this record corresponds to a faulted process. For faulted process performance records, the value of this column is set to "INSTANCE_SYSTEM_FAULT" |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
PROCESS_END_TIME |
TIMESTAMP |
Time at which process instance finished execution |
|
PROCESS_RUNNING_TIME_IN_MSEC |
NUMBER |
Duration in millisecs for which process instance executed |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
|
D_<dimension1…n> |
VARCHAR2 / NUMBER / TIMESTAMP |
Dimension business indicators associated with the process instance. These may indirectly refer to some functional tables |
|
R_<dimension1…n> |
VARCHAR2 |
Range information corresponding to numeric/date type dimension business indicators associated with the process instance |
|
M_<measure1…n> |
NUMBER |
Measure business indicators associated with instance |
A.3.3 BPM_ACTV_INST_<IDENTIFIER>_V
BPM_ACTV_INST_<IDENTIFIER>_V view provides information about each in-flight running activity instance corresponding to a particular process.
A.3.3.1 Data Granularity
This view contains a record corresponding to each in-flight activity and interval instance.
A.3.3.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
ACTIVITY_ID
-
PROCESS_INSTANCE_ID
A.3.3.3 Metrics Information
Following metrics information is available as part of this view
-
ACTIVITY_START_TIME
-
PROCESS_START_TIME
-
Business indicator values as of activity start time.
Table A-13 BPM_ACTV_INST_<IDENTIFIER>_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
ACTIVITY_ID |
NUMBER |
Activity Id. References BPM_ACTIVITY_DEFINTION_V.ACTIVITYID |
|
ACTIVITY_LABEL |
VARCHAR2 |
Activity Label |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_THREAD_ID |
NUMBER |
Thread id of Process thread executing the activity |
|
ACTIVITY_ROLE_NAME |
VARCHAR2 |
Role Name associated with the activity instance |
|
ACTIVITY_PARTICIPANT |
VARCHAR2 |
Participant user associated with the activity instance |
|
ACTIVITY_PRIORITY |
NUMBER |
Priority of activity instance |
|
ACTIVITY_START_TIME |
TIMESTAMP |
Time at which activity instance started execution |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
|
D_<dimension1…n> |
VARCHAR2 / NUMBER / TIMESTAMP |
Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables |
|
R_<dimension1…n> |
VARCHAR2 |
Range info for numeric/date type dimensions |
|
M_<measure1…n> |
NUMBER |
Measure Bis associated with the activity instance |
A.3.4 BPM_PRCS_INST_<IDENTIFIER>_V
BPM_PRCS_INST_<IDENTIFIER>_V view provides information about each in-flight running process instance corresponding to a particular process.
A.3.4.1 Data Granularity
This view contains a record corresponding to each in-flight process instance.
A.3.4.2 Unique Key
Following columns form the unique key for this view
-
SEQUENCE_ID
-
PROCESS_ID
-
PROCESS_INSTANCE_ID
A.3.4.3 Metrics Information
Following metrics information is available as part of this view
-
PROCESS_START_TIME
-
Business indicator values as of process start time.
Table A-14 BPM_PRCS_INST_<IDENTIFIER>_V
| Column Name | Data Type | Description |
|---|---|---|
|
SEQUENCE_ID |
NUMBER |
Numeric sequence |
|
PROCESS_ID |
NUMBER |
Process id. References BPM_PROCESS_DEFINTION_V.PROCESSID |
|
PROCESS_NAME |
VARCHAR2 |
Name of the process |
|
REVISION |
VARCHAR2 |
Revision of the process |
|
PROCESS_INSTANCE_ID |
VARCHAR2 |
Instance Id of the bpmn process instance. Refers to CUBE_INSTANCE.CIKEY |
|
COMPOSITE_INSTANCE_ID |
VARCHAR2 |
Instance Id of the SCA composite instance. Refers to COMPOSITE_INSTANCE.ID |
|
PROCESS_START_TIME |
TIMESTAMP |
Time at which process instance started execution |
|
ECID |
VARCHAR2 |
ECID can be used to correlate all the processes across different composites involved in a single business flow and achieve end to end tracking |
|
D_<dimension1…n> |
VARCHAR2 / NUMBER / TIMESTAMP |
Dimension business indicators associated with the activity instance. These may indirectly refer to some functional tables |
|
R_<dimension1…n> |
VARCHAR2 |
Range info for numeric/date type dimensions |
|
M_<measure1…n> |
NUMBER |
Measure Business indicators associated with the activity instance |