AdminDesktop Utility Fails With Errors ORA-06502 - ORA-06512: at "APPS.FND_APP_SERVER_PKG" (Doc ID 1545153.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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

Symptoms

When running AdminDesktop utility to register the external node it fails with the following errors:

java oracle.apps.fnd.security.AdminDesktop APPS/APPS CREATE NODE_NAME=<host name>.<domain name> IP_ADDRESS=XX.XXX.XXX.XX
DBC=/opt/.../appl/fnd/12.0.0/secure/<SID>.dbc
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 691
ORA-06512: at line 1
raised error performing CREATE
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 691
ORA-06512: at line 1

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
       at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
       at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
       at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
       at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
       at oracle.apps.fnd.security.AdminDesktop.addSvrToDB(AdminDesktop.java:621)
       at oracle.apps.fnd.security.AdminDesktop.createDBC(AdminDesktop.java:452)
       at oracle.apps.fnd.security.AdminDesktop.execute(AdminDesktop.java:280)
       at oracle.apps.fnd.security.AdminDesktop.main(AdminDesktop.java:1143)
Rolling back changes

Changes

 

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