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
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.
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
The issue can be reproduced at will with the following steps:
1. Log in to General Ledger Responsibility
2. Navigate to Setup > Account > Manager
Upgraded from 11i to R12
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