How to Prevent Duplicate Maintenance Work Orders for the Same Asset

Hello All,

In Oracle Fusion Maintenance Cloud, we have a business requirement where only one active (open) maintenance work order should exist for an asset at a time.

Currently, the system allows us to create multiple work orders for the same asset, even if there is already an open work order in Draft or Released status. This creates challenges in execution and tracking, as duplicate work orders may get scheduled for the same asset.

Requirement:

• When creating a new work order, the system should validate if the asset already has an open work order (Draft/Released).
• If yes, the system should either: