SG-3615 CLONE - Work Orders | Parts - ORA-00904 error when trying to access the tab - HxGN EAM - 12.0.0.1 - Release Bulletin - Hexagon

HxGN EAM Resolved Issues for 2023

Language
English
Product
HxGN EAM
Search by Category
Release Bulletin
HxGN EAM Version
12.0.0.2

SG-3615 CLONE - Work Orders | Parts - ORA-00904 error when trying to access the tab

 Description 

When clicking on the Parts tab of the Work Order screen, the following error message appears:

_The SQL Statement is invalid: ORA-00904: "ISNULL": invalid identifier ._

*Steps to reproduce:*

# Navigate to the Work | Work Orders screen

# run the default dataspy and load the list of WO, then select any record

# click on the Parts tab

*Expected result:*

The Parts tab should open successfully

*Actual result:*

The Parts tab does not open, instead the user is prompted with the ORA-00904 error