MREL_DISTRIBUTION_ACTIONS

Used to gather information about current workflow steps for any given release distribution in Deployment Management. Contains columns to display the current status of a step, how long that step has been in the current status, whether the step is complete or resulted in an error, details about the step (source and destination Environment), and other relevant details.

To relate information from this view with information from related releases or release distributions, the report designer can use the release and distribution identifiers (RELEASE_ID and DISTRIBUTION_ID columns) to join with other standard views like MREL_RELEASES and MREL_DISTRIBUTIONS.

Sample

A report is needed that takes a release name input from the user running the report, and shows the details of all open distributions of the release:

SELECT release_name                           RELEASE_NAME,
       distribution_name                      DISTRIBUTION_NAME,
       dist_workflow_step_label || ': '|| action_name
                                              ELIGIBLE_STEP,
       duration                               DAYS_ELIGIBLE
FROM   mrel_distribution_actions
WHERE  status_type = 'ELIGIBLE'
GROUP BY release_name,
         distribution_name,
         dist_workflow_step_label || ': '|| action_name,
         duration
ORDER BY 1,2;

The column STATUS is the status name that is displayed in the status tab of distributions in the Deployment Management application.

The internal code STATUS_TYPE is provided to group these status names into logical groupings. For example, there may be many different statuses that all represent a COMPLETE status type. For example, the result value of any workflow step like Approved, Succeeded, Rejected, or Failed QA Test.

While STATUS may have many different possible values, STATUS_TYPE has only the following possible values:

• SUBMITTED

• IN_PROGRESS

• CLOSED_SUCCESS

• ELIGIBLE

• ERROR

• CLOSED_FAILURE

• PENDING

• COMPLETE

• CANCELLED