ODMR_USER_WORKFLOW_NODES

You can query information about the individual nodes, such as node name, node status, node ID and so on, that are part of a workflow, by using the ODMR_USER_WORKFLOW_NODES repository view.

Table 8-13 provides more information about this view.

Table 8-13 ODMR_USER_WORKFLOW_NODES Repository Views

Column Data Types Description

PROJECT_ID

NUMBER

This is the ID of the project in which the workflow was created in.

PROJECT_NAME

VARCHAR2 (30 CHAR)

This is the name of the project in which the workflow was created in.

WORKFLOW_ID

NUMBER

This is the ID of the workflow.

WORKFLOW_NAME

VARCHAR2 (30 CHAR)

This is the name of the workflow.

NODE_TYPE

VARCHAR2 (30 CHAR)

This is the node type.

NODE_NAME

VARCHAR2 (30 CHAR)

This is the name of the node.

NODE_ID

NUMBER

This is the ID of the node.

NODE_STATUS

VARCHAR2 (10 CHAR)

  • INVALID: Indicates that the node is not valid, and it cannot be run.

  • WARNING: Indicates that the node has run but with warning.

  • READY: Indicates that the node is ready to run.

  • FAILURE: Indicates that the node run has failed.

  • COMPLETE: Indicates that the node run has completed successfully.

Parent topic: Repository Views