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

HxGN EAM Resolved Issues for 12.0.1

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

 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