Running oracle.apps.fnd.security.AdminDesktop raises java.sql.SQLException: ORA-01403: no data found (Doc ID 1336976.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

Running the following command:

java oracle.apps.fnd.security.AdminDesktop <apps user>/<apps pwd> CREATE \
NODE_NAME=<node name of the external application server> \
[IP_ADDRESS=<IP address of external application server>] \
DBC=<full name and path of existing standard dbc_file>

Raises the following error:

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 91
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 136
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 567
ORA-06512: at line 1
raised error performing CREATE
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 91
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 136
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 567
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
at oracle.apps.fnd.security.AdminDesktop.addSvrToDB(AdminDesktop.java:602)
at oracle.apps.fnd.security.AdminDesktop.createDBC(AdminDesktop.java:450)
at oracle.apps.fnd.security.AdminDesktop.execute(AdminDesktop.java:279)
at oracle.apps.fnd.security.AdminDesktop.main(AdminDesktop.java:1111)
Rolling back changes

Changes

No changes made. The command is run from command line

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms