ORA-00604: error occurred at recursive SQL level 1 ORA-20099

Apply on:-

Oracle EBSR12.2.4 /11gr2

Cause:-

Here cause of error is export wrong file system.

First check file system..Here my file system is Patch file system.

[appl@sujeet ~]$ cd /u02/apps/fs2/EBSapps/appl/

[appl@sujeet appl]$ . APPSPREPROD_sujeet.env

[appl@sujeet appl]$ echo $FILE_EDITION
patch
[applchintels@chintels appl]$ sqlplus
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jun 6 15:53:17 2016
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter user-name: apps
Enter password:****
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: E-Business Suite Patch Edition does not exist.

ORA-06512: at line 29

Solution:- 

In EBS12.2.4 is a RUN filesystem, and a PATCH filesystem - make sure you have not exported the wrong filesystem’s env file in your environment  - I did - After I changed from fs2 to fs1, the error was resolved From the below you can see it only fails using the fs2 env variable, and not the fs1 env variable file:-

[appl@sujeet ~]$ cd /u02/apps/fs1/EBSapps/appl/

[appl@sujeet appl]$ . APPSPREPROD_sujeet.env

[appl@sujeet appl]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jun 6 16:18:02 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

[appl@sujeet appl]$ echo $FILE_EDITION
run

[appl@sujeet appl]$ echo $TWO_TASK

PREPROD

I hope Issue resolved..