Category Archives: Oracle Ebuisness Suite

Oracle E-business Suite also called as Oracle application is a suite of business applications made up of a large number of distinct software modules.Examples are  Oracle Supply chain, Oracle financials etc

This page contain all the administration related post for all the Oracle apps version  11i/R12/R12.1/R12.2

 

You can also view the Oracle application post in more ordered manner at below link

E-Business Suite 11i/R12/R12.1/R12.2

Step by step upgrade process to R12.2 Upgrade part -3

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 and 2 in previous Post We are publishing the step 3 in this … Continue reading Step by step upgrade process to R12.2 Upgrade part -3 »

Step by step upgrade process to R12.2 Upgrade part -2

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part in previous Post We are publishing the step 2 in this part Main upgrade … Continue reading Step by step upgrade process to R12.2 Upgrade part -2 »

Step by step upgrade process for R12.2 Upgrade Part -1

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We will be taking care of step 1 in this post.We will publish the other steps in seperate posts DOCUMENT REFERENCE … Continue reading Step by step upgrade process for R12.2 Upgrade Part -1 »

Top AWR useful queries for R12.2/R12.1 Upgrade

R12.1/R12.2 are pretty big  and time consuming upgrade. We need to find all the long running sql in order to resolve the  R12.2 upgrade performance issues. Since each iteration takes lot of time,it is important ,we tried to find out the performances issues in less iterations. Here are Top AWR useful queries to solve R12.2 upgrade performance issues If SQL is still in memory (cursor cache) the following … Continue reading Top AWR useful queries for R12.2/R12.1 Upgrade »

R12.2 RapidWiz Installed Components and System Requirements

R12.2 is the latest release of Oracle EBS. Here are R12.2 RapidWiz  Installed Components and System Requirements Technology Stack Components For a new Release 12.2 installation, Rapid Install automatically installs and configures the required technology stack components for both the database tier and the application tier. On the database tier, the technology stack includes: Oracle Database 12c Release 1 (12.1.0.2)  (  This is when we don’t … Continue reading R12.2 RapidWiz Installed Components and System Requirements »

How to change the Web Port in EBS 12.2

As we all  know,httpd.conf configuration is managed by FMW  in R12.2, the method to change the webport is quite different in R12.2 Here are the steps to change Web Port in EBS 12.2 – Launch EM Console http://<s_wls_admin_host>.<s_wls_admin_domain>:<s_wls_adminport>/em) – Login as weblogic admin user (s_wls_admin_user) – Select the webtier instance from the Web Tier drop down – Select the Oracle HTTP server component and Advanced Configuration … Continue reading How to change the Web Port in EBS 12.2 »

Solaris OS parameter required for R12.2 Upgrade

R12.2 Upgrade on Solaris Operating requires the below prerequisites to be in place before starting with any upgrade steps Operating System Supported Versions The following table lists the supported operating system versions. Operating System Name Supported Version Oracle Solaris on SPARC (64-bit) 10 (5.10) – 9/10 (Update 9) or higher 1,2,6 Oracle Solaris on SPARC (64-bit) 11 (5.11) – 11.1, SRU 7, Build 5 (11.1.7.5.0) … Continue reading Solaris OS parameter required for R12.2 Upgrade »

EBS Data Model Comparison Report

Oracle provides the  EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases •Release 12.1.3 •Release 12.2.2 •Release 12.2.3 •Release 12.2.4 •Release 12.2.5 •Release 12.2.6 Benefits of EBS Data Model Comparison Report it help users to preview the database object definition changes before upgrading their instances from one release to another we can understand the impact of … Continue reading EBS Data Model Comparison Report »

Useful Unix command for Oracle DBA

Oracle DBA need to operate on Unix/Linux/Solaris/AIX Operating system. He has to locate various file, process, kill session ,clear directories, schedule cron and various other activities. Here in this article I am trying to give some Useful Unix command for Oracle DBA  to help them in day-to-day activities.These same commands are applicable for Linux also. Hope you like it   How to kill all similar processes … Continue reading Useful Unix command for Oracle DBA »

Troubleshooting Workflow Notification Mailer issues

To Troubleshoot Workflow Notification  Mailer issues, we need to understand how outbound and inbound processing works Outbound Notification Processing – -Creation of Workflow notification raises oracle.apps.wf.notification.send event. -This event is deferred immediately and placed on the WF_DEFERRED agent. -Workflow Agent Listener on WF_DEFERRED queue process the deferred subscription. -Subscription to this event calls the Generate function (WF_XML.Generate) to generate an XML representation of the notification. … Continue reading Troubleshooting Workflow Notification Mailer issues »

Enabling TLS in R12.1

Introduction to Enabling TLS  in R12.1 The data between web browser and web server travels unencrypted in R12 application So the password and other information can be tracked by sniffer. We are avoiding this by implementing T:LS in R12. With TLS implementation, the data travels in the encrypted forms and Only web browser and web server can decrypt it. The implementation requires the SSL certificate and … Continue reading Enabling TLS in R12.1 »

Every thing You must know about Profile options in Oracle Apps

Introduction to Profile options in Oracle Apps A set of changeable options that affects the way your application runs.The profile option acts like a Global Variable in Oracle, to provide the flexibility in Oracle Applications Two type of Profile options System Profile Options :It is set by the System administrator.User cannot access it and Any change in the system profile becomes effective only when the user … Continue reading Every thing You must know about Profile options in Oracle Apps »