AHM: The Application was Unable to Establish a Connection with the TCF Socket Server and ORA-06502, 06512 Errors When Launching Account Hierarchy Manager(AHM) For Users Upgraded From 11i to R12
(Doc ID 1233623.1)
Last updated on JUNE 07, 2021
Applies to:Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.
Account hierarchy Manager
On 12.0.6, when attempting to launch Account Hierarchy Manager the following error occurs.
The application was unable to establish a connection with the TCF SocketServer running at<TCF:Host>.
Please contact your system administrator.
Do you want to see the error details ?
Select Yes - Get a blank screen
The issue only occurs for users upgraded from 11i to R12.
New users created directly in R12 do not face the issue
The errors in FND Log file are as follows:
Exception in procedure gl_jahe_pkg.getCOAClause: ORA-06502: PL/SQL: numeric
or value error: character string buffer too small
ORA-06512: at "APPS.GL_JAHE_PKG", line 404
ORA-06512: at line 1
Upgrade from 11i to R12.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document