Concurrent Managers Fail To Start After New Install of Release 12

		Concurrent Managers Fail To Start After New Install of Release 12

---

Applies to:

Oracle Applications Technology Stack - Version 12.0 and later
Information in this document applies to any platform.
Checked for relevance on 03-Oct-2011

Symptoms

On 12.0.0, after fresh install from Rapidwiz, when attempting to start the concurrent managers the following error occurs:

ERROR
APP-FND-01564: ORACLE error 12899 in insert_icm_record

Cause: insert_icm_record failed due to ORA-12899: value too large for column
"APPLSYS"."FND_CONCURRENT_PROCESSES"."NODE_NAME" (actual: 31, maximum: 30)

Cause

The Host name / machine name is greater than 30 characters

On UNIX use the following command to identify the host machine name
uname -a
Linux . 2.6.9-42.0.3.ELsmp #1 SMP Mon Sep 25
17:28:02 EDT 2006 i686 i686 i386 GNU/Linux

If the Host name is more than 30 characters then this issue will occur.

Solution

To implement the solution, please execute the following steps:

1. The Hostname / Domain name must be less than 30 characters

The limitation is on the table - FND_CONCURRENT_PROCESSES with the column - NODE_NAME VARCHAR2(30)