My Oracle Support Banner

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 NOVEMBER 08, 2022

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.
ORA-06512; AHM
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

Steps to reproduce the issue

1. Log into general ledger

2. Navigate to Setup-Accounts-Manager


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.