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

Last updated on JULY 29, 2023

Applies to:

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:

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

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