Posted by
satish on
May 01, 2023; 3:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-EBS-R12-1-3-to-R12-2-Package-FND-CONCURRENT-has-errors-tp11831.html
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.htmlHere 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