Post date: Jan 08, 2014 6:39:20 AM
Case: Oracle EBS 12.0.6
--Pre SLA Modification
--1
Select *
from dba_objects
where status = 'INVALID'
--2
select *
from ad_bugs
where bug_number='8846459' --bug SLA
--3
/* Formatted on 2014/01/07 17:48 (Formatter Plus v4.8.8) */
SELECT *
FROM ad_bugs
WHERE bug_number IN
('8649286', '7717658', '8522278', '8691650', '7677948', '7320079',
'6941347', '8469298')
--Prereg
/*
8691650:R12.XLA.A
7677948:R12.XLA.A
7320079:R12.XLA.A
6941347:R12.XLA.A
8469298:R12.XLA.A
*/
--XLA Dependency Analysis (ID.833986.1)
/*
XLA Patching Dependency Analysis For 12.0 customers
For 12.0 customers, if applying any of the file versions or greater
xla java/trialbalance/server TbReportDefnsAMImpl.java 120.9.12000000.3
xla patch/115/import/US xla120cp.ldt 120.109.12000000.20
xla patch/115/sql xlaappub.pkb 120.18.12000000.7
xla patch/115/sql xlaaptrn.pkb 120.61.12000000.17
xla patch/115/sql xlarpmpb.pkb 120.8.12000000.4
xla patch/115/sql xlatbbal.pkb 120.4.12000000.9
xla patch/115/sql xlatbdmg.pkb 120.21.12000000.23
xla patch/115/sql xlatbdmg.pkh 120.7.12000000.3
*/
--EOF
Do Patch 8846459
General Ledger Journal Summarization Group By GL Date or Period (Accounting Setup Manager)
Result from patch as follow:
************* Start of AutoPatch session *************
AutoPatch version: 12.0.0
AutoPatch started at: Tue Jan 07 2014 16:20:57
APPL_TOP is set to /u03/DEV1/apps/apps_st/appl
NLS_LANG value from the environment is : American_America.US7ASCII
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.US7ASCII
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? No
Please enter the batchsize [1000] : 1000
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [DEV1] : DEV1 *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [jazz] : jazz *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'DEV1'
using ORACLE executables in '/u03/DEV1/apps/tech_st/10.1.2'.
Is this the correct database [Yes] ? Yes
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: *****
Connecting to SYSTEM......Connected successfully.
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : *****
AutoPatch is verifying your username/password.
Connecting to APPLSYS......Connected successfully.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
Identifier for the current session is 17871
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
AutoPatch warning:
Product Data File
/u03/DEV1/apps/apps_st/appl/admin/zfaprod.txt
does not exist for product "zfa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/u03/DEV1/apps/apps_st/appl/admin/zsaprod.txt
does not exist for product "zsa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/u03/DEV1/apps/apps_st/appl/admin/jtsprod.txt
does not exist for product "jts".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
Connecting to SYSTEM......Connected successfully.
Reading database for information about how products depend on each other.
Connecting to APPLSYS......Connected successfully.
Reading topfile.txt ...
Saving product information.
Connecting to SYSTEM......Connected successfully.
Connecting to APPLSYS......Connected successfully.
AD code level : [A.6]
STRT_TASK: [AutoPatch startup after aimini] [] [Tue Jan 07 2014 16:21:10]
Connecting to APPS......Connected successfully.
STRT_TASK: [Validate schema passwords] [] [Tue Jan 07 2014 16:21:10]
Connecting to APPLSYS......Connected successfully.
Connecting to APPS......Connected successfully.
STOP_TASK: [Validate schema passwords] [] [Tue Jan 07 2014 16:21:10]
STRT_TASK: [Upload Patch History information from filesystem] [] [Tue Jan 07 2014 16:21:10]
Trying to obtain a lock...
About to attempt instantiating the current-view snapshot: Tue Jan 07 2014 16:21:12
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
Done attempting to instantiate the current-view snapshot: Tue Jan 07 2014 16:21:12
**************** S T A R T O F U P L O A D ****************
Start date: Tue Jan 07 2014 16:21:12
0 "left over" javaupdates.txt files uploaded to DB: Tue Jan 07 2014 16:21:12
0 patches uploaded from the ADPSV format patch history files: Tue Jan 07 2014 16:21:12
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Tue Jan 07 2014 16:21:12
****************** E N D O F U P L O A D ******************
End date: Tue Jan 07 2014 16:21:12
STOP_TASK: [Upload Patch History information from filesystem] [] [Tue Jan 07 2014 16:21:12]
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/u03/DEV1/patch/8846459] : /u03/DEV1/patch/8846459
STOP_TASK: [AutoPatch startup after aimini] [] [Tue Jan 07 2014 16:21:16]
Please enter the name of your AutoPatch driver file : u8846459.drv
STRT_TASK: [Run a single patch driver file] [] [Tue Jan 07 2014 16:21:22]
STRT_TASK: [Steps before copy portion] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Initial driver processing steps] [] [Tue Jan 07 2014 16:21:23]
Start time for driver file is: Tue Jan 07 2014 16:21:23
STOP_TASK: [Initial driver processing steps] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Get Oracle Applications Release and read driver file] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Get Oracle Applications Release] [] [Tue Jan 07 2014 16:21:23]
Getting Oracle Applications Release...
Connecting to APPLSYS......Connected successfully.
Current installed release is 12.0.6
Connecting to APPS......Connected successfully.
STOP_TASK: [Get Oracle Applications Release] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Process patch driver file] [] [Tue Jan 07 2014 16:21:23]
Reading patch driver file...
Connecting to SYSTEM......Connected successfully.
STRT_TASK: [Parse and load patch driver file] [] [Tue Jan 07 2014 16:21:23]
Connecting to APPS......Connected successfully.
Parsing and loading patch driver file...
7629 lines processed.
STOP_TASK: [Parse and load patch driver file] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Check patch integrity] [] [Tue Jan 07 2014 16:21:23]
Not checking patch integrity as integrity checking flag is turned off.
STOP_TASK: [Check patch integrity] [] [Tue Jan 07 2014 16:21:23]
Successfully read patch driver file.
STOP_TASK: [Process patch driver file] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Other driver and release-related logic] [] [Tue Jan 07 2014 16:21:23]
Determining target release...
Current target release is 12.0.6
STOP_TASK: [Other driver and release-related logic] [] [Tue Jan 07 2014 16:21:23]
STOP_TASK: [Get Oracle Applications Release and read driver file] [] [Tue Jan 07 2014 16:21:23]
STRT_TASK: [Prereq checking logic] [] [Tue Jan 07 2014 16:21:23]
For the Current View:
l_appl_top_id .............. 192
l_eav_patch_release_name ... 12.0.0
According to the Current View, patch 8846459 is NOT_APPLIED
Setting already_applied to FALSE
already_applied == FALSE
is_patch_tobe_appld_on_entty == FALSE
entities_htable != NULL
STOP_TASK: [Prereq checking logic] [] [Tue Jan 07 2014 16:21:24]
STRT_TASK: [Ask translated patch question] [] [Tue Jan 07 2014 16:21:24]
STOP_TASK: [Ask translated patch question] [] [Tue Jan 07 2014 16:21:24]
STRT_TASK: [Determine bugs to apply] [] [Tue Jan 07 2014 16:21:24]
Determining which bug fixes to apply...
Turning off bug fixes for products not installed or shared in the database...
Resetting bug actions for bug fixes we will not apply...
Processing files for Oracle Government Applications...
Done determining which bug fixes to apply.
Log and Info File sync point:
Tue Jan 07 2014 16:21:24
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Tue Jan 07 2014 16:21:24
End of unrecognized products checking.
STOP_TASK: [Determine bugs to apply] [] [Tue Jan 07 2014 16:21:24]
STRT_TASK: [Process action options] [] [Tue Jan 07 2014 16:21:24]
STOP_TASK: [Process action options] [] [Tue Jan 07 2014 16:21:24]
STRT_TASK: [Modify actions for bootstrap mode] [] [Tue Jan 07 2014 16:21:24]
STOP_TASK: [Modify actions for bootstrap mode] [] [Tue Jan 07 2014 16:21:24]
STRT_TASK: [Ask for number of parallel workers] [] [Tue Jan 07 2014 16:21:24]
Connecting to SYSTEM......Connected successfully.
Connecting to APPS......Connected successfully.
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 82 workers.
Oracle recommends that you use between 16 and 32 workers.
Enter the number of parallel workers [16] : 20
STOP_TASK: [Ask for number of parallel workers] [] [Tue Jan 07 2014 16:21:29]
AutoPatch will run in parallel mode.
STOP_TASK: [Steps before copy portion] [] [Tue Jan 07 2014 16:21:29]
STRT_TASK: [Copy portion steps] [] [Tue Jan 07 2014 16:21:29]
STRT_TASK: [apply new applterr.txt] [] [Tue Jan 07 2014 16:21:29]
Did not need to apply new applterr.txt.
STOP_TASK: [apply new applterr.txt] [] [Tue Jan 07 2014 16:21:29]
STRT_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Tue Jan 07 2014 16:21:29]
Applying new applprod.txt (if any)...
Did not need to apply new applprod.txt.
STOP_TASK: [AutoSplice applprod.txt and applUS.txt] [] [Tue Jan 07 2014 16:21:29]
STRT_TASK: [Version checking for driver files] [] [Tue Jan 07 2014 16:21:29]
Performing version checking for driver files...
STOP_TASK: [Version checking for driver files] [] [Tue Jan 07 2014 16:21:30]
STRT_TASK: [Copy driver files] [] [Tue Jan 07 2014 16:21:30]
Copying driver files into installation area...
No driver files were selected for copying.
STOP_TASK: [Copy driver files] [] [Tue Jan 07 2014 16:21:30]
STRT_TASK: [Forcecopy driver files] [] [Tue Jan 07 2014 16:21:30]
Skipping...
ForceCopy driver files into installation area for Specified driver
since no such action is present for this driver file
STOP_TASK: [Forcecopy driver files] [] [Tue Jan 07 2014 16:21:30]
STRT_TASK: [Screen out files not valid for this configuration] [] [Tue Jan 07 2014 16:21:30]
Screening out files not valid for this installation...
STOP_TASK: [Screen out files not valid for this configuration] [] [Tue Jan 07 2014 16:21:30]
STRT_TASK: [Read file driver files to get list of valid files] [] [Tue Jan 07 2014 16:21:30]
Determining valid on-site files...
Setting JAVA_TOP to '/u03/DEV1/apps/apps_st/comn/java/classes'
STOP_TASK: [Read file driver files to get list of valid files] [] [Tue Jan 07 2014 16:21:51]
STRT_TASK: [Perform libout actions] [] [Tue Jan 07 2014 16:21:51]
Extracting object modules from product libraries...
Done extracting object modules from product libraries.
STOP_TASK: [Perform libout actions] [] [Tue Jan 07 2014 16:21:57]
STRT_TASK: [Perform version checking] [] [Tue Jan 07 2014 16:21:57]
Performing version checking...
Log and Info File sync point:
Tue Jan 07 2014 16:21:58
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
STOP_TASK: [Perform version checking] [] [Tue Jan 07 2014 16:22:09]
STRT_TASK: [Determine directories to create] [] [Tue Jan 07 2014 16:22:09]
Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine directories to create] [] [Tue Jan 07 2014 16:22:09]
STRT_TASK: [Determine executables to link] [] [Tue Jan 07 2014 16:22:09]
Determining what executables to link...
STOP_TASK: [Determine executables to link] [] [Tue Jan 07 2014 16:22:10]
STRT_TASK: [Determine forms executable files to generate] [] [Tue Jan 07 2014 16:22:10]
Determining what Oracle Forms files to generate...
STOP_TASK: [Determine forms executable files to generate] [] [Tue Jan 07 2014 16:22:10]
STRT_TASK: [Determine Reports PL/SQL library files to generate] [] [Tue Jan 07 2014 16:22:10]
Skipping...
Determine Oracle Reports libraries to generate for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine Reports PL/SQL library files to generate] [] [Tue Jan 07 2014 16:22:10]
STRT_TASK: [Determine Reports files to generate] [] [Tue Jan 07 2014 16:22:10]
Determining what Oracle Reports files to generate...
STOP_TASK: [Determine Reports files to generate] [] [Tue Jan 07 2014 16:22:11]
STRT_TASK: [Determine message files to generate] [] [Tue Jan 07 2014 16:22:11]
Skipping...
Determine if need to generate message files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Determine message files to generate] [] [Tue Jan 07 2014 16:22:11]
STRT_TASK: [Find bugs with no active actions] [] [Tue Jan 07 2014 16:22:11]
Looking for active bug fixes with no active actions...
About to turn off duplicate actions: Tue Jan 07 2014 16:22:11
Start of adptod(): Tue Jan 07 2014 16:22:11
Actions scanned: 1601
Duplicate actions: 0
End of adptod(): Tue Jan 07 2014 16:22:11
Done turning off duplicate actions: Tue Jan 07 2014 16:22:11
About to turn off bugs with no active actions: Tue Jan 07 2014 16:22:11
Start of adpunb(): Tue Jan 07 2014 16:22:11
Active bugs at start: 512
Bugs turned off: 511
Outer loop iterations: 512
Actions scanned: 1
End of adpunb(): Tue Jan 07 2014 16:22:11
Done turning off bugs with no active actions: Tue Jan 07 2014 16:22:11
About to save release list to filesystem: Tue Jan 07 2014 16:22:11
Done saving release list to filesystem: Tue Jan 07 2014 16:22:11
STOP_TASK: [Find bugs with no active actions] [] [Tue Jan 07 2014 16:22:11]
STRT_TASK: [Display customized files] [] [Tue Jan 07 2014 16:22:11]
Reading customized files list (if any)...
Did not find customized files registration file
"/u03/DEV1/apps/apps_st/appl/admin/applcust.txt"
The file may have been uploaded to the database.
This patch replaces the following customized files:
No customized files are replaced by this patch.
STOP_TASK: [Display customized files] [] [Tue Jan 07 2014 16:22:11]
STRT_TASK: [Copy files] [] [Tue Jan 07 2014 16:22:11]
Copying files into installation area...
**********************************************************
You are running admvcode
Header information is:
$Header: aiopatch.lc 120.4.12000000.4 2007/12/03 08:26:56 nissubra ship $
Start of admvcode session
Date/Time is Tue Jan 07 2014 16:22:12
Filelist file is: /u03/DEV1/apps/apps_st/appl/admin/DEV1/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: US7ASCII
Log and Info File sync point:
Tue Jan 07 2014 16:22:12
Information about files copied to the APPL_TOP would be written to the
informational message file.
No character set conversion is required.
Copying files to APPL_TOP...
0 directories created.
1 files copied without character set conversion.
0 files copied with successful character set conversion.
1 files copied successfully.
0 files had fatal errors.
admvcode is exiting with status 0
End of admvcode session
Date/time is Tue Jan 07 2014 16:22:12
**********************************************************
Done copying files into installation area.
STOP_TASK: [Copy files] [] [Tue Jan 07 2014 16:22:12]
STRT_TASK: [Forcecopy files] [] [Tue Jan 07 2014 16:22:12]
Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file
STOP_TASK: [Forcecopy files] [] [Tue Jan 07 2014 16:22:12]
STRT_TASK: [Perform libin actions] [] [Tue Jan 07 2014 16:22:12]
Archiving object modules into product libraries...
No object modules were selected for archiving.
STOP_TASK: [Perform libin actions] [] [Tue Jan 07 2014 16:22:12]
STRT_TASK: [Create directories] [] [Tue Jan 07 2014 16:22:12]
Skipping...
Create Directories for Specified driver
since no such action is present for this driver file
STOP_TASK: [Create directories] [] [Tue Jan 07 2014 16:22:12]
STRT_TASK: [Relink executables] [] [Tue Jan 07 2014 16:22:12]
Relinking executables...
Done relinking executables.
STOP_TASK: [Relink executables] [] [Tue Jan 07 2014 16:22:40]
STRT_TASK: [Copy files in patch to destinations] [] [Tue Jan 07 2014 16:22:40]
Performing second half of mirrored copies...
No mirrored copies were executed in this patch.
STOP_TASK: [Copy files in patch to destinations] [] [Tue Jan 07 2014 16:22:41]
STRT_TASK: [Maintain Oracle Applications Java files] [] [Tue Jan 07 2014 16:22:41]
Updating Oracle Applications Java files if necessary...
STRT_TASK: [Perform jcopy actions] [] [Tue Jan 07 2014 16:22:41]
** Backing up $JAVA_TOP/META-INF/JRIMETA.DAT...
Copying JRIMETA.DAT to JRIMETA.DAT.BackedupByAdpatch ...
Copied JRIMETA.DAT to JRIMETA.DAT.BackedupByAdpatch.
** Successfully backed up JRIMETA.DAT.
STRT_TASK: [Run adjcopy.class] [] [Tue Jan 07 2014 16:22:42]
Running adjcopy.class:
adjava -mx512m -nojit oracle.apps.ad.jri.adjcopy @/u03/DEV1/apps/apps_st/appl/admin/DEV1/out/apps.cmd
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java
Version 12.0.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH to:
"/u03/DEV1/apps/apps_st/appl/ad/12.0.0/java/adjava.zip:/u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u03/DEV1/apps/apps_st/comn/java/lib/appsborg.zip:/u03/DEV1/apps/tech_st/10.1.2/forms/java:/u03/DEV1/apps/tech_st/10.1.2/forms/java/frmall.jar:/u03/DEV1/apps/tech_st/10.1.2/jlib/ewt3.jar:/u03/DEV1/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u03/DEV1/apps/apps_st/comn/java/classes"
Calling /u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
About to Load metadata from master archive : Tue Jan 07 2014 16:22:44
Loading metadata from archive /u03/DEV1/apps/apps_st/comn/java/classes
Done Loading metadata from master archive : Tue Jan 07 2014 16:23:10
------------------------------------------------------------------------------
About to Merge meta data of delta archive 1 and master archive : Tue Jan 07 2014 16:23:10
Loading metadata from archive /u03/DEV1/patch/8846459/j8846459_xla.zip
This delta archive does not add to or supersede any elements of the master archive
Done Merging meta data of delta archive 1 and master archive : Tue Jan 07 2014 16:23:10
------------------------------------------------------------------------------
Writing change indicator file /u03/DEV1/apps/apps_st/appl/admin/DEV1/out/changeindicator.txt
*** This patch does not affect the master archive
Successfully created touch file.
All processing successful; exiting with status 0
Successfully ran adjcopy.class
Removed touch file.
STOP_TASK: [Run adjcopy.class] [] [Tue Jan 07 2014 16:23:11]
Removed apps.cmd.
** Successfully performed jcopy actions.
STOP_TASK: [Perform jcopy actions] [] [Tue Jan 07 2014 16:23:11]
Checking to see if any files possibly included in the product JAR files
were copied by this patch...
No files possibly included in the product JAR files
were copied by this patch.
STRT_TASK: [Run AutoConfig to instantiate special templates] [] [Tue Jan 07 2014 16:23:11]
Skipping ...
Running AutoConfig to instantiate templates which affect
the generation of JAR files since none of these templates
were patched during this run of adpatch.
STOP_TASK: [Run AutoConfig to instantiate special templates] [] [Tue Jan 07 2014 16:23:11]
No product JAR files need to be re-generated.
STRT_TASK: [Generate appsborg.zip] [] [Tue Jan 07 2014 16:23:11]
Checking to see if adjborg.txt or any files included in
adjborg.txt were copied by this patch...
Neither adjborg.txt nor any file included in
adjborg.txt was copied by this patch.
STOP_TASK: [Generate appsborg.zip] [] [Tue Jan 07 2014 16:23:11]
STRT_TASK: [Generate appsborg2.zip] [] [Tue Jan 07 2014 16:23:11]
Checking to see if adjborg2.txt or any files included in
adjborg2.txt were copied by this patch...
Neither adjborg2.txt nor any file included in
adjborg2.txt was copied by this patch.
STOP_TASK: [Generate appsborg2.zip] [] [Tue Jan 07 2014 16:23:11]
About to turn off bugs with no active actions: Tue Jan 07 2014 16:23:11
Start of adpunb(): Tue Jan 07 2014 16:23:11
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 512
Actions scanned: 1
End of adpunb(): Tue Jan 07 2014 16:23:11
Done turning off bugs with no active actions: Tue Jan 07 2014 16:23:11
About to save release list to filesystem: Tue Jan 07 2014 16:23:11
Done saving release list to filesystem: Tue Jan 07 2014 16:23:11
STOP_TASK: [Maintain Oracle Applications Java files] [] [Tue Jan 07 2014 16:23:11]
STRT_TASK: [Compile JSP files] [] [Tue Jan 07 2014 16:23:11]
Compiling JSP files...
Not compiling JSPs: no JSPs in patch.
No JSP files were compiled.
STOP_TASK: [Compile JSP files] [] [Tue Jan 07 2014 16:23:11]
STOP_TASK: [Copy portion steps] [] [Tue Jan 07 2014 16:23:11]
STRT_TASK: [Database portion steps] [] [Tue Jan 07 2014 16:23:11]
STRT_TASK: [Get initial list of invalid objects in DB] [] [Tue Jan 07 2014 16:23:11]
Number of invalid objects: 34
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/u03/DEV1/apps/apps_st/appl/admin/DEV1/log/17871_preenv.*
STOP_TASK: [Get initial list of invalid objects in DB] [] [Tue Jan 07 2014 16:23:15]
STRT_TASK: [Run SQL scripts and EXEC commands] [] [Tue Jan 07 2014 16:23:15]
Running SQL scripts and EXEC commands...
STRT_TASK: [Determine which SQL and EXEC commands to run] [] [Tue Jan 07 2014 16:23:15]
Determining which SQL and EXEC commands to run...
Validating PL/SQL direct execute exceptions file ...
Initializing PL/SQL direct execute exceptions hash table ...
Done initializing PL/SQL direct execute exceptions hash table.
Uploading PL/SQL direct execute exceptions from file ...
Done uploading PL/SQL direct execute exceptions from file.
Done validating PL/SQL direct execute exceptions file.
Net8 name-value connect string is:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jazz.pasi.co.id)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV1)(INSTANCE_NAME=DEV1)(CID=(PROGRAM= )(HOST=jazz)(USER=oradev))))
DB Address is:
(ADDRESS=(PROTOCOL=tcp)(HOST=jazz.pasi.co.id)(PORT=1522))
CONNECT_DATA is:
(CONNECT_DATA=(SERVICE_NAME=DEV1)(INSTANCE_NAME=DEV1)(CID=(PROGRAM= )(HOST=jazz)(USER=oradev)))
SERVICE_NAME/INSTANCE_NAME : [DEV1]
connect_string : [(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jazz.pasi.co.id)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV1)))]
Done determining which SQL and EXEC commands to run.
STOP_TASK: [Determine which SQL and EXEC commands to run] [] [Tue Jan 07 2014 16:23:18]
STRT_TASK: [Running database update commands] [] [Tue Jan 07 2014 16:23:18]
STRT_TASK: [Running SQL and EXEC commands in parallel] [] [Tue Jan 07 2014 16:23:18]
Running SQL and EXEC commands in parallel...
STRT_TASK: [Running parallel SQL and EXEC commands] [] [Tue Jan 07 2014 16:23:18]
Connecting to APPLSYS......Connected successfully.
Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
DROP TABLE AD_UTIL_PARAMS
CREATE TABLE ad_util_params( worker_id number not null,
utility_name varchar2(100) not null, task
varchar2(30) not null, status varchar2(100) not null,
arguments varchar2(2000) not null, rowid1
varchar2(2000), utility_status number not null, symbolic_arguments
varchar2(2560) not null)
Creating FND_INSTALL_PROCESSES table...
Running adtasktim.sql ..
Connected.
PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE
APPS_TS_TX_DATA initrans 255
INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
'FND_INSTALL_PROCESSES', 'AutoPatch', sysdate from dual where not exists
(select 'x' from ad_timestamps where type = 'FND_INSTALL_PROCESSES' and
attribute = 'AutoPatch')
CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPS_TS_TX_IDX
storage(initial 4K next 4K)
GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION
GRANT ALL ON ad_util_params TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPS_TS_TX_DATA
initrans 100 storage(initial 4K next 4K)
CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE
APPS_TS_TX_IDX storage(initial 4K next 4K)
GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (9, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (10, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (11, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (12, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (13, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (14, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (15, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (16, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (17, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (18, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (19, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (20, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
Connecting to APPS......Connected successfully.
Writing dependencies of jobs to run to appldep.txt file...
There are now 3 jobs remaining (current phase=A0):
0 running, 1 ready to run and 2 waiting.
Reading completed jobs from restart file (if any).
There are now 3 jobs remaining (current phase=A0):
0 running, 1 ready to run and 2 waiting.
Determining which java executables are supported by adJavaWorker...
Calling /u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 started.
Worker process 5 started.
Worker process 6 started.
Worker process 7 started.
Worker process 8 started.
Worker process 9 started.
Worker process 10 started.
Worker process 11 started.
Worker process 12 started.
Worker process 13 started.
Worker process 14 started.
Worker process 15 started.
Worker process 16 started.
Worker process 17 started.
Worker process 18 started.
Worker process 19 started.
Worker process 20 started.
Checking if all jobs have their actual and symbolic arguments in sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Connecting to APPLSYS......Connected successfully.
Starting phase 0 (A0): plb
Connecting to APPS......Connected successfully.
There are now 3 jobs remaining (current phase=A0):
0 running, 1 ready to run and 2 waiting.
Assigned: file xlaaptrn.pkb on worker 1 for product xla username XLA.
Time is: Tue Jan 07 2014 16:23:24
Completed: file xlaaptrn.pkb on worker 1 for product xla username XLA.
Time is: Tue Jan 07 2014 16:23:29
Connecting to APPLSYS......Connected successfully.
Starting phase 1 (A1): dat
Connecting to APPS......Connected successfully.
There are now 2 jobs remaining (current phase=A1):
0 running, 1 ready to run and 1 waiting.
Assigned: file apimportaad.sql on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:23:29
Completed: file apimportaad.sql on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:23:35
Connecting to APPLSYS......Connected successfully.
Starting phase 2 (A2): upg+70
Connecting to APPS......Connected successfully.
There are now 1 jobs remaining (current phase=A2):
0 running, 1 ready to run and 0 waiting.
Assigned: file appostimportaad.sql on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:23:36
Completed: file appostimportaad.sql on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:23:37
Telling workers to quit...
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
DROP TABLE fnd_install_processes
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS
AD_DEFERRED_JOBS table dropped.
Connecting to APPS......Connected successfully.
STOP_TASK: [Running parallel SQL and EXEC commands] [] [Tue Jan 07 2014 16:23:41]
Done running SQL and EXEC commands in parallel.
STOP_TASK: [Running SQL and EXEC commands in parallel] [] [Tue Jan 07 2014 16:23:41]
Updating the checkfile repository if necessary...
Processing the last batch...: Tue Jan 07 2014 16:23:41
Done updating the checkfile repository...
STOP_TASK: [Running database update commands] [] [Tue Jan 07 2014 16:23:43]
About to turn off bugs with no active actions: Tue Jan 07 2014 16:23:43
Start of adpunb(): Tue Jan 07 2014 16:23:43
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 512
Actions scanned: 1
End of adpunb(): Tue Jan 07 2014 16:23:43
Done turning off bugs with no active actions: Tue Jan 07 2014 16:23:43
Done running SQL scripts and EXEC commands.
STOP_TASK: [Run SQL scripts and EXEC commands] [] [Tue Jan 07 2014 16:23:43]
STRT_TASK: [Compile invalid objects in DB] [] [Tue Jan 07 2014 16:23:43]
Compiling invalid objects...
STRT_TASK: [Run ST parallel compile (APPS)] [] [Tue Jan 07 2014 16:23:43]
sqlplus -s APPS/***** @/u03/DEV1/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 20 0 NONE FALSE
Arguments are:
AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 20, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
Connected.
Running utl_recomp.recomp_parallel(20), if it exists
OWNER NUM_INVALID
------------------------------ -----------
SYS 1
ORDSYS 2
APPS 34
Elapsed: 00:00:00.31
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.06
STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...
PL/SQL procedure successfully completed.
Elapsed: 00:00:25.42
STATUS_MESSAGE
------------------------------------------------------------------------------
Successfully ran UTL_RECOMP.RECOMP_PARALLEL
OWNER NUM_INVALID
------------------------------ -----------
APPS 4
Elapsed: 00:00:00.23
Done running utl_recomp.recomp_parallel
Commit complete.
Elapsed: 00:00:00.00
STOP_TASK: [Run ST parallel compile (APPS)] [] [Tue Jan 07 2014 16:24:09]
STRT_TASK: [Run ST parallel compile (APPS) second pass] [] [Tue Jan 07 2014 16:24:09]
sqlplus -s APPS/***** @/u03/DEV1/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 20 0 NONE FALSE
Arguments are:
AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 20, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
Connected.
Running utl_recomp.recomp_parallel(20), if it exists
OWNER NUM_INVALID
------------------------------ -----------
APPS 4
Elapsed: 00:00:00.23
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...
PL/SQL procedure successfully completed.
Elapsed: 00:00:02.19
STATUS_MESSAGE
------------------------------------------------------------------------------
Successfully ran UTL_RECOMP.RECOMP_PARALLEL
OWNER NUM_INVALID
------------------------------ -----------
APPS 4
Elapsed: 00:00:00.22
Done running utl_recomp.recomp_parallel
Commit complete.
Elapsed: 00:00:00.00
STOP_TASK: [Run ST parallel compile (APPS) second pass] [] [Tue Jan 07 2014 16:24:12]
STOP_TASK: [Compile invalid objects in DB] [] [Tue Jan 07 2014 16:24:12]
STRT_TASK: [Get final list of invalid objects in DB] [] [Tue Jan 07 2014 16:24:12]
Number of invalid objects: 4
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/u03/DEV1/apps/apps_st/appl/admin/DEV1/log/17871_postenv.*
STOP_TASK: [Get final list of invalid objects in DB] [] [Tue Jan 07 2014 16:24:15]
STOP_TASK: [Database portion steps] [] [Tue Jan 07 2014 16:24:15]
STRT_TASK: [Generate portion steps] [] [Tue Jan 07 2014 16:24:15]
STRT_TASK: [Generate forms PL/SQL library files] [] [Tue Jan 07 2014 16:24:15]
Generating forms library files...
LDR_CNTRL is not previously defined
Connecting to APPLSYS......Connected successfully.
Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
DROP TABLE AD_UTIL_PARAMS
CREATE TABLE ad_util_params( worker_id number not null,
utility_name varchar2(100) not null, task
varchar2(30) not null, status varchar2(100) not null,
arguments varchar2(2000) not null, rowid1
varchar2(2000), utility_status number not null, symbolic_arguments
varchar2(2560) not null)
Creating FND_INSTALL_PROCESSES table...
Running adtasktim.sql ..
Connected.
PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE
APPS_TS_TX_DATA initrans 255
INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
'FND_INSTALL_PROCESSES', 'AutoPatch', sysdate from dual where not exists
(select 'x' from ad_timestamps where type = 'FND_INSTALL_PROCESSES' and
attribute = 'AutoPatch')
CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPS_TS_TX_IDX
storage(initial 4K next 4K)
GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION
GRANT ALL ON ad_util_params TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPS_TS_TX_DATA
initrans 100 storage(initial 4K next 4K)
CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE
APPS_TS_TX_IDX storage(initial 4K next 4K)
GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (9, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (10, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (11, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (12, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (13, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (14, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (15, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (16, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (17, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (18, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (19, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (20, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
Connecting to APPS......Connected successfully.
Writing dependencies of jobs to run to appldep.txt file...
There are now 49 jobs remaining (current phase=A1000):
0 running, 49 ready to run and 0 waiting.
Reading completed jobs from restart file (if any).
There are now 49 jobs remaining (current phase=A1000):
0 running, 49 ready to run and 0 waiting.
Determining which java executables are supported by adJavaWorker...
Calling /u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 started.
Worker process 5 started.
Worker process 6 started.
Worker process 7 started.
Worker process 8 started.
Worker process 9 started.
Worker process 10 started.
Worker process 11 started.
Worker process 12 started.
Worker process 13 started.
Worker process 14 started.
Worker process 15 started.
Worker process 16 started.
Worker process 17 started.
Worker process 18 started.
Worker process 19 started.
Worker process 20 started.
Checking if all jobs have their actual and symbolic arguments in sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Connecting to APPLSYS......Connected successfully.
Starting phase 1000 (admin): Administration
Connecting to APPS......Connected successfully.
There are now 49 jobs remaining (current phase=A1000):
0 running, 49 ready to run and 0 waiting.
Assigned: file APPREPAY.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file APXINLIN.pll on worker 2 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file APXINWKB.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXARWIN.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXCOQIT.pll on worker 5 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRAATR.pll on worker 6 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRWAPP.pll on worker 7 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRWCOM.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRWLLC.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRWMAI.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXRWRCT.pll on worker 11 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWACC.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWADA.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWADJ.pll on worker 14 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWBAL.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWCMI.pll on worker 16 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWLIN.pll on worker 17 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWMA2.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWMAI.pll on worker 19 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
Assigned: file ARXTWUTL.pll on worker 20 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:21
There are now 49 jobs remaining (current phase=A1000):
20 running, 29 ready to run and 0 waiting.
Completed: file ARXRWCOM.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:38
Assigned: file ARXAIEXP.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:38
Completed: file ARXTWBAL.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:40
Assigned: file ARXAPPIF.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:40
Completed: file ARXRWMAI.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:43
Completed: file ARXTWMA2.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:43
Assigned: file ARXCOECC.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:43
Assigned: file ARXCOQIL.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:43
Completed: file APXINWKB.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:45
Assigned: file ARXCWAGE.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:45
Completed: file ARXAPPIF.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:46
Assigned: file ARXCWMAI.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:46
Completed: file ARXTWADA.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:48
Assigned: file ARXCWUTL.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:48
Completed: file ARXTWACC.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
Assigned: file ARXCWWIN.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
Completed: file ARXCWMAI.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
Assigned: file ARXLBHIS.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
Completed: file ARXCWAGE.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
Assigned: file ARXLBSUB.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:52
There are now 39 jobs remaining (current phase=A1000):
20 running, 19 ready to run and 0 waiting.
Completed: file ARXARWIN.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:53
Assigned: file ARXLPIM.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:53
Completed: file ARXCOQIL.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:53
Assigned: file ARXPLCOM.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:53
Completed: file ARXRWLLC.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:54
Assigned: file ARXPRGLP.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:54
Completed: file ARXCWUTL.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Assigned: file ARXRWBAT.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Completed: file ARXAIEXP.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Assigned: file ARXRWBOE.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Completed: file ARXTWADJ.pll on worker 14 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Assigned: file ARXRWQRC.pll on worker 14 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:55
Completed: file APPREPAY.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Completed: file ARXLBHIS.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Assigned: file ARXSUBAA.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Assigned: file ARXSUPST.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Completed: file ARXCOQIT.pll on worker 5 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Assigned: file ARXTWBAT.pll on worker 5 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:56
Completed: file ARXLBSUB.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:59
Completed: file ARXPRGLP.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:59
There are now 28 jobs remaining (current phase=A1000):
18 running, 10 ready to run and 0 waiting.
Assigned: file ARXTWCPY.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:59
Assigned: file ARXTWFRT.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:24:59
Completed: file ARXCWWIN.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:00
Assigned: file ARXTWINS.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:00
Completed: file ARXTWUTL.pll on worker 20 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:01
Assigned: file ARXTWMAF.pll on worker 20 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:01
Completed: file ARXRAATR.pll on worker 6 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:02
Assigned: file ARXTWSCR.pll on worker 6 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:02
Completed: file ARXSUBAA.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:02
Assigned: file ARXTWTAX.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:02
Completed: file ARXLPIM.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:03
Assigned: file ARXVACOR.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:03
Completed: file ARXSUPST.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:03
Assigned: file ARXVAMAI.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:03
Completed: file ARXTWTAX.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:08
Completed: file ARXCOECC.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:08
Assigned: file ARXVASCH.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:08
Assigned: file ARXVASUM.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:08
Completed: file ARXTWCPY.pll on worker 3 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:09
Completed: file ARXTWMAF.pll on worker 20 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:09
There are now 18 jobs remaining (current phase=Done):
18 running, 0 ready to run and 0 waiting.
Completed: file ARXTWINS.pll on worker 12 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:09
Completed: file ARXTWCMI.pll on worker 16 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:10
Completed: file ARXVACOR.pll on worker 4 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:11
Completed: file ARXVAMAI.pll on worker 15 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:12
Completed: file ARXTWLIN.pll on worker 17 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:12
Completed: file ARXTWBAT.pll on worker 5 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:12
Completed: file ARXTWSCR.pll on worker 6 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:12
Completed: file ARXVASCH.pll on worker 1 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:15
Completed: file ARXTWFRT.pll on worker 9 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:16
Completed: file ARXVASUM.pll on worker 10 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:17
Completed: file ARXPLCOM.pll on worker 18 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:17
Completed: file ARXRWBOE.pll on worker 8 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:18
Completed: file ARXRWQRC.pll on worker 14 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:23
Completed: file APXINLIN.pll on worker 2 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:23
Completed: file ARXRWBAT.pll on worker 13 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:24
Completed: file ARXRWRCT.pll on worker 11 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:31
Completed: file ARXRWAPP.pll on worker 7 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:38
Completed: file ARXTWMAI.pll on worker 19 for product au username APPLSYS.
Time is: Tue Jan 07 2014 16:25:40
Telling workers to quit...
1 worker has quit. Waiting for 19 more.
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
DROP TABLE fnd_install_processes
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS
AD_DEFERRED_JOBS table dropped.
Done generating forms library files.
Connecting to APPS......Connected successfully.
STOP_TASK: [Generate forms PL/SQL library files] [] [Tue Jan 07 2014 16:25:44]
STRT_TASK: [Generate forms menu files] [] [Tue Jan 07 2014 16:25:44]
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate forms menu files] [] [Tue Jan 07 2014 16:25:44]
STRT_TASK: [Generate forms executable files] [] [Tue Jan 07 2014 16:25:44]
Generating forms...
Connecting to APPLSYS......Connected successfully.
Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
DROP TABLE AD_UTIL_PARAMS
CREATE TABLE ad_util_params( worker_id number not null,
utility_name varchar2(100) not null, task
varchar2(30) not null, status varchar2(100) not null,
arguments varchar2(2000) not null, rowid1
varchar2(2000), utility_status number not null, symbolic_arguments
varchar2(2560) not null)
Creating FND_INSTALL_PROCESSES table...
Running adtasktim.sql ..
Connected.
PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE
APPS_TS_TX_DATA initrans 255
INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
'FND_INSTALL_PROCESSES', 'AutoPatch', sysdate from dual where not exists
(select 'x' from ad_timestamps where type = 'FND_INSTALL_PROCESSES' and
attribute = 'AutoPatch')
CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPS_TS_TX_IDX
storage(initial 4K next 4K)
GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION
GRANT ALL ON ad_util_params TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename varchar2(60) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPS_TS_TX_DATA
initrans 100 storage(initial 4K next 4K)
CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE
APPS_TS_TX_IDX storage(initial 4K next 4K)
GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION
Connecting to APPS......Connected successfully.
Connecting to APPLSYS......Connected successfully.
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (9, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (10, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (11, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (12, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (13, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (14, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (15, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (16, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (17, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (18, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (19, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (20, 'W', 'W', 'UNDEF', 'UNDEF',
'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 'UNDEF', 0, 0,
rpad('-',100,'-'),rpad('-',100,'-'),'UNDEF')
Connecting to APPS......Connected successfully.
Writing dependencies of jobs to run to appldep.txt file...
There are now 56 jobs remaining (current phase=A1002):
0 running, 56 ready to run and 0 waiting.
Reading completed jobs from restart file (if any).
There are now 56 jobs remaining (current phase=A1002):
0 running, 56 ready to run and 0 waiting.
Determining which java executables are supported by adJavaWorker...
Calling /u03/DEV1/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
Worker process 3 started.
Worker process 4 started.
Worker process 5 started.
Worker process 6 started.
Worker process 7 started.
Worker process 8 started.
Worker process 9 started.
Worker process 10 started.
Worker process 11 started.
Worker process 12 started.
Worker process 13 started.
Worker process 14 started.
Worker process 15 started.
Worker process 16 started.
Worker process 17 started.
Worker process 18 started.
Worker process 19 started.
Worker process 20 started.
Checking if all jobs have their actual and symbolic arguments in sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Connecting to APPLSYS......Connected successfully.
Starting phase 1002 (admin+2): Administration
Connecting to APPS......Connected successfully.
There are now 56 jobs remaining (current phase=A1002):
0 running, 56 ready to run and 0 waiting.
Assigned: file APXHOLDS.fmx on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXINWKB.fmx on worker 2 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXIWALL.fmx on worker 3 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXPAWKB.fmx on worker 4 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXPMTCH.fmx on worker 5 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXPWALL.fmx on worker 6 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXRICAD.fmx on worker 7 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXSUMDS.fmx on worker 8 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file APXSUMPS.fmx on worker 9 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file ARBRREMI.fmx on worker 10 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file ARXLOBOX.fmx on worker 11 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file ARXRWAPP.fmx on worker 12 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file ARXRWMAI.fmx on worker 13 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:50
Assigned: file ARXRWRCT.fmx on worker 14 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file ARXTWACC.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file ARXTWADA.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file ARXTWBAL.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file ARXTWCMI.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file ARXTWMAI.fmx on worker 19 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
Assigned: file RAXSUMSC.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:25:51
There are now 56 jobs remaining (current phase=A1002):
20 running, 36 ready to run and 0 waiting.
Completed: file APXHOLDS.fmx on worker 1 for product ap username AP.
Time is: Tue Jan 07 2014 16:25:56
Assigned: file XLAABINQ.fmx on worker 1 for product xla username XLA.
Time is: Tue Jan 07 2014 16:25:56
Completed: file APXPWALL.fmx on worker 6 for product ap username AP.
Time is: Tue Jan 07 2014 16:26:00
Assigned: file XLAABJLD.fmx on worker 6 for product xla username XLA.
Time is: Tue Jan 07 2014 16:26:01
Completed: file ARXLOBOX.fmx on worker 11 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:05
Assigned: file XLAABPAD.fmx on worker 11 for product xla username XLA.
Time is: Tue Jan 07 2014 16:26:05
Completed: file ARXTWBAL.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:08
Assigned: file ARCOMMON.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:08
Completed: file APXSUMDS.fmx on worker 8 for product ap username AP.
Time is: Tue Jan 07 2014 16:26:11
Completed: file ARXTWACC.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Completed: file ARXTWADA.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Completed: file ARCOMMON.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Completed: file RAXSUMSC.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Assigned: file ARXADLMT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Assigned: file ARXAIEXP.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Assigned: file ARXAPPRU.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Assigned: file ARXCOECC.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Assigned: file ARXCOQIL.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:11
Completed: file ARXADLMT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:23
Assigned: file ARXCOQIT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:23
There are now 46 jobs remaining (current phase=A1002):
20 running, 26 ready to run and 0 waiting.
Completed: file XLAABINQ.fmx on worker 1 for product xla username XLA.
Time is: Tue Jan 07 2014 16:26:24
Assigned: file ARXCUANM.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:24
Completed: file ARXAPPRU.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:27
Assigned: file ARXCWAGE.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:27
Completed: file ARXTWCMI.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:33
Assigned: file ARXCWMAI.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:33
Completed: file ARXCOQIL.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:36
Assigned: file ARXLBHIS.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:36
Completed: file ARXCWAGE.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:36
Assigned: file ARXLBSUB.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:36
Completed: file APXIWALL.fmx on worker 3 for product ap username AP.
Time is: Tue Jan 07 2014 16:26:37
Assigned: file ARXLPIM.fmx on worker 3 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:37
Completed: file ARXLBHIS.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:44
Assigned: file ARXPRGLP.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:45
Completed: file ARXCOQIT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:52
Assigned: file ARXRWBAT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:52
Completed: file XLAABPAD.fmx on worker 11 for product xla username XLA.
Time is: Tue Jan 07 2014 16:26:52
Completed: file ARXPRGLP.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:52
Assigned: file ARXRWBOE.fmx on worker 11 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:52
Assigned: file ARXRWQRC.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:26:52
There are now 36 jobs remaining (current phase=A1002):
20 running, 16 ready to run and 0 waiting.
Completed: file ARXCUANM.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:00
Assigned: file ARXSUBAA.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:00
Completed: file APXPMTCH.fmx on worker 5 for product ap username AP.
Time is: Tue Jan 07 2014 16:27:00
Completed: file APXSUMPS.fmx on worker 9 for product ap username AP.
Time is: Tue Jan 07 2014 16:27:00
Assigned: file ARXSUDRC.fmx on worker 5 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:00
Assigned: file ARXSUPST.fmx on worker 9 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:00
Completed: file ARXCOECC.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:01
Assigned: file ARXTWADJ.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:01
Completed: file ARXLBSUB.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:02
Assigned: file ARXTWBAT.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:02
Completed: file XLAABJLD.fmx on worker 6 for product xla username XLA.
Time is: Tue Jan 07 2014 16:27:03
Assigned: file ARXTWCPY.fmx on worker 6 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:04
Completed: file ARXLPIM.fmx on worker 3 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:04
Assigned: file ARXTWFRT.fmx on worker 3 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:04
Completed: file ARXSUBAA.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Completed: file ARXTWCPY.fmx on worker 6 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Completed: file ARXAIEXP.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Completed: file ARXTWADJ.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Completed: file ARXCWMAI.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Assigned: file ARXTWINS.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
There are now 24 jobs remaining (current phase=A1002):
16 running, 8 ready to run and 0 waiting.
Assigned: file ARXTWLIN.fmx on worker 6 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Assigned: file ARXTWSCR.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:10
Assigned: file ARXTWTAX.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:11
Assigned: file ARXVACOR.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:11
Completed: file APXRICAD.fmx on worker 7 for product ap username AP.
Time is: Tue Jan 07 2014 16:27:12
Assigned: file ARXVAMAI.fmx on worker 7 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:12
Completed: file ARXTWINS.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:18
Completed: file ARXVACOR.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:18
Assigned: file ARXVASCH.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:18
Assigned: file ARXVASUM.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:19
Completed: file ARXTWBAT.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:19
Assigned: file RAXSUTRM.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:19
Completed: file ARXSUPST.fmx on worker 9 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:19
Completed: file ARXVAMAI.fmx on worker 7 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:20
Completed: file ARXTWSCR.fmx on worker 15 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:20
Completed: file ARXTWTAX.fmx on worker 17 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:20
Completed: file ARXTWFRT.fmx on worker 3 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:21
Completed: file ARBRREMI.fmx on worker 10 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:22
Completed: file ARXRWBOE.fmx on worker 11 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:23
Completed: file ARXVASUM.fmx on worker 18 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:24
There are now 12 jobs remaining (current phase=Done):
12 running, 0 ready to run and 0 waiting.
Completed: file ARXVASCH.fmx on worker 1 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:25
Completed: file RAXSUTRM.fmx on worker 16 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:30
Completed: file ARXRWRCT.fmx on worker 14 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:33
Completed: file ARXSUDRC.fmx on worker 5 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:36
Completed: file ARXRWQRC.fmx on worker 20 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:37
Completed: file APXPAWKB.fmx on worker 4 for product ap username AP.
Time is: Tue Jan 07 2014 16:27:39
Completed: file ARXRWBAT.fmx on worker 8 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:42
Completed: file ARXRWAPP.fmx on worker 12 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:46
Completed: file ARXRWMAI.fmx on worker 13 for product ar username AR.
Time is: Tue Jan 07 2014 16:27:52
Completed: file ARXTWLIN.fmx on worker 6 for product ar username AR.
Time is: Tue Jan 07 2014 16:28:00
Completed: file ARXTWMAI.fmx on worker 19 for product ar username AR.
Time is: Tue Jan 07 2014 16:28:35
Completed: file APXINWKB.fmx on worker 2 for product ap username AP.
Time is: Tue Jan 07 2014 16:29:26
Telling workers to quit...
4 workers have quit. Waiting for 16 more.
5 workers have quit. Waiting for 15 more.
6 workers have quit. Waiting for 14 more.
7 workers have quit. Waiting for 13 more.
9 workers have quit. Waiting for 11 more.
10 workers have quit. Waiting for 10 more.
11 workers have quit. Waiting for 9 more.
12 workers have quit. Waiting for 8 more.
17 workers have quit. Waiting for 3 more.
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
Connecting to APPLSYS......Connected successfully.
DROP TABLE fnd_install_processes
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS
AD_DEFERRED_JOBS table dropped.
Done generating forms.
Connecting to APPS......Connected successfully.
STOP_TASK: [Generate forms executable files] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Generate reports PL/SQL library files] [] [Tue Jan 07 2014 16:29:45]
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate reports PL/SQL library files] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Generate reports files] [] [Tue Jan 07 2014 16:29:45]
Generating reports...
No reports were selected for generation.
STOP_TASK: [Generate reports files] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Generate message files] [] [Tue Jan 07 2014 16:29:45]
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate message files] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Generate Workflow resource files] [] [Tue Jan 07 2014 16:29:45]
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
STOP_TASK: [Generate Workflow resource files] [] [Tue Jan 07 2014 16:29:45]
STOP_TASK: [Generate portion steps] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [AutoConfig steps] [] [Tue Jan 07 2014 16:29:45]
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
STOP_TASK: [AutoConfig steps] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Steps after generate portion] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Save Patch History] [] [Tue Jan 07 2014 16:29:45]
STRT_TASK: [Save Patch History to database] [] [Tue Jan 07 2014 16:29:45]
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 222 action history records for this bug (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 512 bug history records for this patch (total).
>>>>> Inserted 222 action history records for this bug (total).
About to update the current-view snapshot: Tue Jan 07 2014 16:29:59
Updating the current-view snapshot...
Done updating the current-view snapshot: Tue Jan 07 2014 16:30:33
Uploading Java objects to patch history tables...
About to update the current-view snapshot: Tue Jan 07 2014 16:30:34
Updating the current-view snapshot...
Done updating the current-view snapshot: Tue Jan 07 2014 16:30:44
Completed uploading Java objects to patch history tables.
STOP_TASK: [Save Patch History to database] [] [Tue Jan 07 2014 16:30:44]
Done saving Patch History information.
STOP_TASK: [Save Patch History] [] [Tue Jan 07 2014 16:30:44]
STRT_TASK: [IREP steps] [] [Tue Jan 07 2014 16:30:45]
About to do IREP processing...
Attempting to process IREP files ...
Successfully processed IREP files.
Done IREP processing.
STOP_TASK: [IREP steps] [] [Tue Jan 07 2014 16:30:46]
Freeing includes hash table
Freeing fixes hash table
Freeing basedons hash table
Freeing entities hash table
STOP_TASK: [Steps after generate portion] [] [Tue Jan 07 2014 16:30:46]
STOP_TASK: [Run a single patch driver file] [] [Tue Jan 07 2014 16:30:46]
STRT_TASK: [AutoPatch post-driver logic] [] [Tue Jan 07 2014 16:30:46]
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/DEV1/applterr.txt to admin/applterr.txt.
STOP_TASK: [AutoPatch post-driver logic] [] [Tue Jan 07 2014 16:30:46]
Log and Info File sync point:
Tue Jan 07 2014 16:30:46
AutoPatch is exiting successfully.
sqlplus -s APPS/***** @/u03/DEV1/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 17871 adt17871
Spooling to adt17871.lst
Spooling to adt17871.csv
A job timing report has been generated for the current session.
You should check the file
/u03/DEV1/apps/apps_st/appl/admin/DEV1/out/adt17871.lst
for details.
Purging timing information for prior sessions.
sqlplus -s APPS/***** @/u03/DEV1/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/u03/DEV1/apps/apps_st/appl/admin/DEV1/log/u8846459.lgi
Errors and warnings are listed in the log file
/u03/DEV1/apps/apps_st/appl/admin/DEV1/log/u8846459.log
and in other log files in the same directory.