Monday, June 12, 2017

How to Continue the Failed Patch Session in R12.1.3 ERP Application

sqlplus applsys/apps

create table fnd_Install_processes_bkp as select * from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;

create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS;
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;

3. Backup the .rf9 files located in $APPL_TOP/admin/restart directory. At this point, the
adpatch session should have ended and the cursor should be back at the UNIX prompt.
cd $APPL_TOP/admin/
mv restart restart_back
mkdir restart

4. Drop the FND_INSTALL_PROCESSES table and the AD_DEFFERED_JOBS table.
sqlplus applsys/apps
drop table FND_INSTALL_PROCESSES;
drop table AD_DEFERRED_JOBS;

Now apply the pre-requirement patch and then restore the above mentioned tables, files . Finally continue the patch session


No comments:

Post a Comment