E1: ORCH: How to Do Nested Iteration with Multiple Steps (Doc ID 2776233.1)

Last updated on JULY 07, 2023

Applies to:

Goal

This is the requirement. Find certain type of equipment that needs maintenance, create work order if not already created.
DR-a find list of equipment, DR-b iterate over result from DR-a to find equipment of certain age because this info is in another table.
DR-c iterate over result from DR-b to see if work order exist, create work order if not exist.
DR = Data Request
orch = Orchestration

Why this does not work ? Main orch calling child orch (lets refer this child as orch-O)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.