Apex error ORA-01422: exact fetch returns more than requested number of row
Hi folks,
Apex 4.1
I have a page that works like a charm.
Based on my application need I have to perform this same action for different regions. As a best and fast method I copied the page and branched it based on tab for that region.
The issue is that the original page works fine.
I have not changed anything except set parent tab to this copied page and run it and I end up with the above error.
It lets me make first entry on this page but when I try to access the page again it gives me this error.
The error in detail is as below :
is_internal_error: false
ora_sqlcode: -1422
ora_sqlerrm: ORA-01422: exact fetch returns more than requested number of rows
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 214936714355373108
component.name: Fetch Row from EMP_LEAVE_INFO
error_backtrace:
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 806
ORA-06512: at "APEX_040200.WWV_FLOW_DML", line 336
ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 332