Oracle ERP DBA

Yesterday, I was analysing CPU patches for a 11.5.9 instance. That is when I found out that 11.5.9 is desupported as far as CPU patches are concerned since July 2008. Below is the extract from the July 2008 CPU advisory for EBS (Note 605117.1). Oracle E-Business Suite Release 11.5.9 has been desupported as of 01-July-2008. Hence, there would not be any further CPUs released by Oracle for 11.5.9. To verify this, I checked the Oct 2008 CPU advisory for EBS (note 738921.1), which expectedly did NOT contain any CPUs for 11.5.9.

Many a time, DBAs are entrusted with the task of "convert to Multi-org" as soon as an Apps instance is installed. Though, the DBAs perform this task blindly, there is a lot (according to me) of setup work that needs to be completed, before "Convert to Multi-org" can succeed. I have tried, in this blog entry, to list out these tasks. Please go through the references mentioned below for explanation about the different terms/terminology like Legal Entity, Operating Unit etc. Step I - Define Work Location Set the profile option HR:User Type for a given responsibility (that we are going to use to define the work location say Global HRMS Manager) to HR User. Global HRMS Manager (responsibility) --> Work Structures --> Location Provide: 1. Location Name 2. Location Address Step II - Define Business group Set the profile option HR:User Type for a given responsibility (that we are going to use to define the work location say Global HRMS Manager) to HR User. Global HRMS

It has been a long time since I blogged (almost 2 months, to be precise), more due to paucity of time than anything else. In the meantime, I have been busy configuring the Linksys Wireless Router and my new HTC smartphone. I had to struggle a lot to configure the Linksys router WRT54GC to work with the BSNL (ISP) provided modem SmartAX MT882. So, I have prepared a list of steps that can be used to configure the Linksys router with BSNL (though the navigation is specific to SmartAX MT882, I believe the solution can be transposed on any other type of modem too). Click here for the step by step configuration guide.