EAM-55762 Parts - query gives error ORA-01422: exact fetch returns more than requested number of rows - HxGN EAM - Version 12.0 - Hexagon

EAM-55762 Parts - query gives error ORA-01422: exact fetch returns more than requested number of rows

 Description 

This is a data specific issue

When running dataspy for specific values, the system gives error "The SQL Statement is invalid: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "EAM117_00026.O7GTPMPN", line 31 ORA-06512: at line 1 ."

Seps to reproduce:

1. go to Parts screen

2. select dataspy "All Parts In Service"

3. click F7 and in Part field enter 12 or 48 and hit F8. Here's when the error appears.

Expected Results: View list of records matching the criteria used in the search

Actual Results: Error message is displayed