SG-1519 Work Orders | Permits - Hyperlink on the Permits tab on a cloned Work Orders screen gives error ORA-01422: exact fetch returns more than requested number of rows |
Description |
|
When going to Work | Permit To Work | Permit to Work Request | Permits, in this customer environment Hyperlink in field PTW gives error : The SQL Statement is invalid: ORA-01422: exact fetch returns more than requested number of rows ORA-06512 : at "EAM117_00105.O7GETDATASPYNAME", line 8 Possible Data Corruption Issue has been reproduced in environment of the client. Steps to reproduce # Log in environment provided # Navigate to Work | Permit To Work | Permit to Work Request | Permits # Open screen designer # On Field PTW (see attachment), right click and click on “Hyperlink“ # Error message display (see attachment) Expected result User will be redirected to Hyperlink screen Actual result Error message is displayed |