ORA-01403: no data found / ORA-06512: at "APPS.FND_NET_SERVICES"

We are getting below error when attempting to run autoconfig on DB tier.

Issue:

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_NET_SERVICES", line 877
ORA-06512: at line 1

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level

Cause:

Table DUAL existed not owned by SYS.

Table DUAL not owned by SYS should not exist as this can cause issues with EBS.

Fix:

Remove table DUAL not owned by SYS

The existence of this can be checked using:

SQL> column OWNER format a15;
SQL> column OBJECT_NAME format a20;
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED from dba_objects where object_name='DUAL';

Ref: (Doc ID 2054876.1)