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 APRIL 21, 2016

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.
ORA-06512; AHM

Symptoms

On 12.0.6
When attempting to launch Account Hierarchy Manager the following error occurs.

ERROR
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


The issue can be reproduced at will with the following steps:
1. Log in to General Ledger Responsibility
2. Navigate to Setup > Account > Manager

Changes

Upgraded from 11i to R12

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