Upgrade Oracle Applications to 12.0.4

on Friday, 10 August 2012

Upgrade Oracle Applications to 12.0.4 Oracle Applications Release 12 update 4 (12.0.4) is available now.  This post covers top level steps for upgrading Oracle Applications R12 (12.0.0, 12.0.1, 12.0.2, 12.0.3) to latest patchset i.e. 12.0.4 Key Points for Upgrade to 12.0.4 1. You can upgrade to 12.0.4 directly from following releases 11.5.8, 11.5.9 (Base, Update1 and Update2), 11.5.10 (Base, Update1 and Upadte2), R 12 (Base, 12.0.1, 12.0.2, 12.0.3) 2. Patch Number for 12.0.4 is 6435000  (Apply this patch if you are upgrading from R12 i.e. 12.0.0, 12.0.1, 12.0.2 or 12.0.3) 3. If you are upgrading from R12 (12.0.1, 12.0.2, 12.0.3), first apply R12.AD.A.DELTA.4 (6510214). 4. After applying 12.0.4 patch (6435000)...

R12 Instance Home Overview

on Friday, 10 August 2012

R12 Instance Home Overview Oracle Applications/E-Business Suite Release 12 introduces a new concept of a top-level directory for an Applications Instance which is known as Instance Home and is denoted the environment variable $INST_TOP.            Instance Home contains all the config files, log files, SSL certificates etc. Advantages of new INSTANCE HOME The additional Instance Home makes the middle tier more easy to manage and organised since the data is kept separate from the config files. The Instance Home also has the ability to share the Applications and Technology stack code across multiple instances. Another advantage of the Instance Home is that the...

Upgrade Oracle Apps 11i to R12/12i (12.0.4) – Key Points

on Friday, 10 August 2012

Upgrade Oracle Apps 11i to R12/12i (12.0.4) – Key Points This post covers overview/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).    This post is useful to understand...

Difference between Oracle Apps 11i and R12 (Technical)

on Friday, 10 August 2012

Difference between Oracle Apps 11i and R12 (Technical) Database: Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2) Application Tier: Tech Stack in Application Tier consist of iAS(1.0.2.2.2)...

How to troubleshoot Concurrent Manager in 11i/R12 – Apps Listener

on Tuesday, 7 August 2012

How to troubleshoot Concurrent Manager in 11i/R12 – Apps Listener How to check if Concurrent Manager is Up and running ? Login as user with System Administrator responsibility. Under Concurrent : Manager click on Administer (Actual should be...

Concurrent manager Phase and Status Codes meaning in Oracle E-Business Suite

on Tuesday, 7 August 2012

Concurrent manager Phase and Status Codes meaning in Oracle E-Business Suite You can find meanining of  Concurrent Manager status codes meaning. Here is the lists PHASE CODE: I = Inactive P = Pending R = Running C = Completed STATUS CODE: U = Disabled W = Paused X = Terminated Z = Waiting M = No Manager Q = Standby R = Normal S = Suspended T = Terminating D = Cancelled E = Error F = Scheduled G = Warning H = On Hold I =  Normal A = Waiting B = Resuming C = Normal You can find in-detail about the Phase and status of the Concurrent managers in the previous post  ie : Concurrent Request Phase and Status If you like this post please comment ......

Post Clone Checks,Procedures for 11i / R12

on Tuesday, 7 August 2012

Post Clone Checks,Procedures for 11i / R12 Clone Procedures are outlined in : Clone-ie-Refresh-Oracle-Applications-11i-R12 Cloning-from-Multinode-to-Single-Node-Merge-APPL_TOP Post Clone checks and steps can differ . Listed are some of the common Post clone activities : (Here DEV is the target and PROD is the source) CHECKS =========== THE CHECKS/STEPS LISTED HERE SHOULD BE PERFORMED AFTER DATABASE CLONE BEFORE APPLICATIONS CLONE 1 Check the Target - If its in ARCHIVELOG / NOARCHIVELOG MODE as desired. 2 Create the Temp datafiles , using the commands taken from the control file , if the temporary tablespace tempfiles is not existing. ALTER TABLESPACE TEMP ADD TEMPFILE __________ Verify dba_temp_files, for all...

Concurrent Request Phase and Status

on Tuesday, 7 August 2012

Concurrent Request Phase and Status Phase Status Description PENDING Normal Request is waiting for the next available manager.   Standby Program to run request is incompatible with other program(s) currently running.   Scheduled Request is scheduled to start at a future time or date.   Waiting A child request is waiting for its Parent request to mark it ready to run. For example, a request in a request set that runs sequentially must wait for a prior request to complete. RUNNING Normal Request is running normally.   Paused Parent request pauses for all its child requests to finish running. For example, a request...

Concurrent manager issues - 11i / R12

on Tuesday, 7 August 2012

Concurrent manager issues - 11i / R12Inactive/No managerA concurrent request has a life cycle consisting of the following phases: Pending, Running, and Completed. During each phase, a request has a specific status. Listed below are the possible statuses for each phase:•Pending Phase - Normal, Standby, Scheduled, Waiting•Running Phase - Normal, Paused, Resuming, Terminating•Completed Phase - Normal, Error, Warning, Cancelled, Terminated•Inactive Phase - Disabled, On Hold, No ManagerIf a concurrent request is on hold or unable to run when there are no active manager processes that can run the request, the request is placed in an Inactive phase. Review the following points when the concurrent request is in Inactive phase...

Concurrent Managers in Oracle Apps 11i

on Tuesday, 7 August 2012

 Concurrent Managers in Oracle Apps 11i  1Q. What is a Concurrent Manager ? Ans:A Concurrent Manager is a background process which manages the concurrent requests in Oracle Apps 11i. 2Q. How many type of Concurrent Managers there are...

Concurrent manager in Oracle Apps

on Tuesday, 7 August 2012

Concurrent manager in Oracle Apps Lets discuss the very basics of Concurrent Managers, again the very basics for the beginners that read  :/http://appstier.blogspot.in/ Two things are obvious:- 1. Concurrent Manager is related to Concurrent  Programs 2. Concurrent manager manages the concurrent(oops I mean parallel) execution of concurrent programs. So what's left to explain?.....Well nothing much, but I gave a commitment to one of my readers that I shall write something about concurrent managers today. And now when I begin to write, I realize it is worth writing something in plain English on this topic. Lets explain this with some Q&A Q : How to run a concurrent program? Ans: In oracle apps you have...