Upgrade EBS R12.1.3 to R12.2---->Package FND_CONCURRENT has errors

[satish]

Dear Erman,

This is some where related to but not clear-->http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-R12-1-3-to-R12-2-APPS-FND-CONCURRENT-invalid-td11402.html

Here we identified and updated the along with file versions. Looks like the db code for the package is at latest level but at the filesystem it is lower

We are upgrading from R12.1.3 to R12.2, Autoconfig failed after applying uprade driver and when running autoconfig on application tier.

At very high level;

1) We have ran Rapidwiz to lav out the file system.
2) Applied all patches and ran American English upgrade patch driver (Merge Driver).
3) Disabled Maintenence mode
4) Create new appsutil.zip from the fs1 filesystem.
1) Run environment file of application file system.
2) $perl <AD TOP>/bin/admkappsutil.pl
3) Copy to RDMBS_HOME (DATABASE HOME)
4) unzip -o appsutil.zip
5) unzip appsutil.zip file created in the apps tier on the dbtier
6) cd <RDBMS ORACLE HOME>/appsutil/bin/ perl adbldxml.pl
5) Autoconfig on the DB tier all nodes
6) Autoconfig on the Application
tier-================-
•-->Failed


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:
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)


Its a test instance:

Immediately after the clone:

[applCRP@ssstCRPerpdb01 ~]$ adident Header /u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls
/u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls:
$Header AFCPUTLS.pls 120.4.12000000.1 2007/01/18 13:17:23 appldev ship $
[applCRP@ssstCRPerpdb01 ~]$ adident Header /u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls
/u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls:
$Header AFCPUTLB.pls 120.12.12010000.6 2010/04/29 20:34:14 pferguso ship $


SQL> SELECT text
FROM     dba_source
WHERE  name ='FND_CONCURRENT'
AND        text LIKE '%Header:%';   2    3    4

TEXT
--------------------------------------------------------------------------------
/* $Header: AFCPUTLS.pls 120.4.12000000.1 2007/01/18 13:17:23 appldev ship $ */
/* $Header: AFCPUTLB.pls 120.12.12010000.6 2010/04/29 20:34:14 pferguso ship $ *





And after upgrade failed:


R12.1.3:
========

[applcrp@sssterpdev1 CRP]$ adident Header /u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls
/u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls:
$Header AFCPUTLS.pls 120.4.12010000.2 2015/01/30 19:15:52 tkamiya ship $
[applcrp@sssterpdev1 CRP]$

[applcrp@sssterpdev1 sql]$ adident Header /u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls
/u01/CRP/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls:
$Header AFCPUTLB.pls 120.12.12010000.9 2013/06/28 20:02:18 tkamiya ship $
[applcrp@sssterpdev1 sql]$


SQL> SELECT text
FROM     dba_source
WHERE  name ='FND_CONCURRENT'
AND        text LIKE '%Header:%';   2    3    4

TEXT
--------------------------------------------------------------------------------
/* $Header: AFCPUTLS.pls 120.4.12010000.2 2015/01/30 19:15:52 tkamiya ship $ */
/* $Header: AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $ */



R12.2:
=====

[applcrp@sssterpdev1 appl]$ adident Header /u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls
/u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls:
$Header AFCPUTLS.pls 120.4 2006/04/05 01:37:43 ktanneru ship $

[applcrp@sssterpdev1 appl]$ adident Header /u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls
/u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls:
$Header AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $
[applcrp@sssterpdev1 appl]$



SQL> SELECT text
FROM     dba_source
WHERE  name ='FND_CONCURRENT'
AND        text LIKE '%Header:%';  2    3    4

TEXT
--------------------------------------------------------------------------------
/* $Header: AFCPUTLS.pls 120.4.12010000.2 2015/01/30 19:15:52 tkamiya ship $ */
/* $Header: AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $ */


Here,looks like the db code for the package is at latest level but at the filesystem it is lower. Need your expertise.

Thanks,
Satish

[ErmanArslansOracleBlog]

So you already found a patch for that . (Patch 33671306:R12.FND.C or above)
so why don't you apply it before the failing step.

Why dont you apply it before autoconfig, and check the versions and then continue with the autoconfig?

And the error says: Spec is OK but body is not OK . In spec we have SET_INTERIM_STATUS , but in body we don't have.. Please check the db body does it have SET_INTERIM_STATUS? Also check the Package Body pls file, is there any SET_INTERIM_STATUS?  If there is did you try recreating the body using the pls and compiling the invalid afterwards?

[satish]

Dear Erman,

Looks like spec is ok but body is not.

But,it seems like package spec is having different version in file system and in database.But package body has same version in file system and in database. Please correct me.

R12.2:
=====

[applcrp@sssterpdev1 appl]$ adident Header /u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls
/u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls:
$Header AFCPUTLS.pls 120.4 2006/04/05 01:37:43 ktanneru ship $

[applcrp@sssterpdev1 appl]$ adident Header /u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls
/u01/CRP/R122/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/AFCPUTLB.pls:
$Header AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $
[applcrp@sssterpdev1 appl]$



SQL> SELECT text
FROM     dba_source
WHERE  name ='FND_CONCURRENT'
AND        text LIKE '%Header:%';  2    3    4

TEXT
--------------------------------------------------------------------------------
/* $Header: AFCPUTLS.pls 120.4.12010000.2 2015/01/30 19:15:52 tkamiya ship $ */
/* $Header: AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $ */


Thanks,
Satish

[ErmanArslansOracleBlog]

It s already seen in the error :

'SET_INTERIM_STATUS' is declared
in a package specification and must be defined in the package
body'