SG-3504 Screens | Dataspies - Cannot access dataspies tab on BSFUNC "The SQL Statement is invalid: ORA-01427: single-row subquery returns more than one row ." - 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-3504 Screens | Dataspies - Cannot access dataspies tab on BSFUNC "The SQL Statement is invalid: ORA-01427: single-row subquery returns more than one row ."

 Description 

1- Administration - Screen Configuration - Screens

2- Select WSCREW record. (You can use several screen codes to test this)

3- Click Dataspies tab

4- Click Edit to edit Dataspy.

5- On Edit Dataspy popup go to Layout and move Tab Description field from Available Fields → Visible Fields and save

6- Go to list view and now select BSFUNC record and Click Dataspies tab

Error received - The SQL Statement is invalid: ORA-01427: single-row subquery returns more than one row .

Expected Behavior - You should be able to access the tab.

Actual Behavior - Error message The SQL Statement is invalid: ORA-01427: single-row subquery returns more than one row .