Upgrade R12.1.3 to R12.2 - APPS.FND_CONCURRENT invalid

Posted by satish on Jan 02, 2023; 12:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-R12-1-3-to-R12-2-APPS-FND-CONCURRENT-invalid-tp11402.html

 Dear Erman,

We are upgrading R12.1.3 to R12.2

File system lay down using rapid install was done.
We have applied all AD/consolidated upgrade patches and finally we ran upgrade driver and it completed successfully.

Now we are about to run rapid install in configuer mode. As prerequisite step,we generated appsutil folder and copied to RDBMS home.Ran autoconfig in db.

When we run autoconfig in apps tier it errored out. Error is:
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.FND_CONCURRENT"
ORA-06512: at line 1
ORA-06512: at line 109
ORA-04063: package body
"APPS.FND_CONCURRENT" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.FND_CONCURRENT"
ORA-04063: package body
"APPS.FND_CONCURRENT" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.FND_CONCURRENT"


SQL> alter package APPS.FND_CONCURRENT compile body;
Warning: Package Body altered with compilation errors.
SQL> sho errors
Errors for PACKAGE BODY APPS.FND_CONCURRENT:
[02/01, 17:23] Sai Sandeep Ttd: LINE/COL ERROR
342/12 PLS-00323: subprogram or cursor
'SET_INTERIM_STATUS' is declared
in a package specification and must be defined in the package
body

We found note id Oracle APPS Upgrade From 12.1.3 To 12.2, After Applying The Patches
APPS.FND_CONCURRENT Is INVALID (Doc ID
2854582.1)

Applying patch 33671306 to existing fs1 using adpatch,but failed.

AutoPatch error:
Missing prerequisite codelevel for entity 'au'.
This patch requires the following codelevel or higher: 'R12.AU.2.3'.
The current on-site codelevel for the entity 'au' is : 'R12.AU.2'.
In order to apply this patch you must first apply a patch that introduces
at least the minimum required codelevel.
You may merge this patch with a patch that introduces the required codelevel.

We are stuck here. Please advice.

This patch is avaible for 12.1 and 12.2. We have downloaded for 12.2 and tried applying to fs1 using adpatch.

Thank you,
Satish