My Oracle Support Banner

After 19c Database Upgrade Concurrent Programs Fail With Error: ORA-00972: identifier is too long (Doc ID 2797871.1)

Last updated on APRIL 28, 2022

Applies to:

Oracle Applications Manager - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On: 12.2.6 version, Database for Application Technology

After upgrading the Oracle E-Business Suite (EBS) database to the 19.10 version, concurrent programs are failing, and the concurrent request logs show the following error:

SQLException:
java.sql.SQLException: ORA-20100: ORA-20100: ORA-00972: identifier is too long
ORA-06512: at "APPS.FND_FILE", line 319
ORA-06512: at "APPS.FND_FILE", line 364
ORA-06512: at "APPS.FND_FILE", line 421
ORA-06512: at "APPS.FND_OAM_COLLECTION", line 2798
ORA-06512: at line 1


The error also occurs when the following piece of PL/SQL code is executed.

STEPS TO REPRODUCE THE ISSUE
-------------------------------------------------------
The following steps show how to run the PL/SQL code that uses the fnd_file package, which is also used by Oracle EBS concurrent programs to create output and log files.

1. Connect as the APPS user

2. Get the folders where temp files can be created. Below is just an example of the output you might get, your values will be different.

    SQL> select value from v$parameter2 where name='utl_file_dir';

    VALUE
    --------------------------------------------------------------------------------
    /u01/db/temp/<PDBSID>
    /u01/db/19.3.0/appsutil/outbound/<PDBSID>_<hostname>

3. Run the following piece of code to confirm you are also getting the error: ORA-00972: identifier is too long

    a. Set DIR_TEMP with one of the above values:

        SQL> create or replace directory DIR_TEMP as '/u01/db/temp/<PDBSID>';

    b. Run the piece of PL/SQL code:

        SET SERVEROUTPUT ON
        declare
        x varchar2(20);
        Begin
        select 'test'
        into x
        from dual;
        fnd_file.put_line(FND_FILE.LOG,'In the log file');
        fnd_file.put_line(FND_FILE.OUTPUT,'In the output file');
        end;

        You should get an error such as:

        declare
        *
        ERROR at line 1:
        ORA-20100: ORA-20100: ORA-00972: identifier is too long
        ORA-06512: at "APPS.FND_FILE", line 319
        ORA-06512: at "APPS.FND_FILE", line 364
        ORA-06512: at "APPS.FND_FILE", line 421
        ORA-06512: at line 7

Changes

 Database upgrade to 19c release.

Cause

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
Symptoms
Changes
Cause
Solution
References


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