Open Work Order/Discrete Job with Entity Type Closed [Maintenance Job/Discrete Job] Throw Different Errors within the Application (Doc ID 2349125.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Case 1 - [EAM] Enterprise Asset Management Work Order

When attempting to complete a work order, the following error occurs.

The issue can be reproduced at will with the following steps:
1. Responsibility Maintenance Super User
2. Navigation Work Orders tab
3. Search for work order
3. Complete work order and observe error

Case 2 - [WIP] Work in Process Discrete Job

When trying to close discrete job, the following error occurs.

The issue can be reproduced at will with the following steps:
1. Responsibility Manufacturing and Distribution Manager
2. Navigation WIP -> Discrete -> Close Discrete Jobs (Form)
3. Search for job and observe error

General validation

The issue can throw different type of errors depending on the page or form, but the root cause is the fact that entity type is
- Closed Maintenance Job for EAM Work Order
- Closed Discrete Job for WIP Discrete Job

The entity type can be checked for any work order by reviewing the output
- of the collect_job_eam.sql script, from below note
Enterprise Asset Management - Work Order Data Collection Script (Doc ID 1448341.1)

- of the collect_job_wip.sql, from below note, for the discrete job in question
Work In Process - Discrete / Lot Based Job Data Collection Script (Doc ID 1476250.1)

Changes

Cause

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