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

All about FNDLOAD command and WFLOAD command

INTRODUCTION TO FNDLOAD The loader is a general-purpose utility that moves structured data between a text file and a database. Structures supported by the loader include master-detail relationships, and foreign key reference relationships, including arbitrary chains of said relationships. The loader operates in one of three modes: download, upload, or upload_partial. In the download mode, data is downloaded from the database to a text file; … Continue reading All about FNDLOAD command and WFLOAD command »

Top Questions about JAVA/JRE in Oracle Apps

Last updated on April 1st, 2017 at 08:06 am  1) What is the JDK and the JRE? JDK(SDK): Java (Standard) Developer Kit. JRE: Java Runtime Environment This is the full suite of Java products necessary for development in Java.    Designates the set of tool necessary for developing in Java. It includes its own JRE, development libraries, JAVA compiler (javac)… It is a scaled down … Continue reading Top Questions about JAVA/JRE in Oracle Apps »

Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.6 Release Update Pack)

Last updated on April 14th, 2017 at 02:35 pmR12.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 , 2,3 in previous Post … Continue reading Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.6 Release Update Pack) »

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

Last updated on April 14th, 2017 at 02:32 pmR12.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 … Continue reading Step by step upgrade process to R12.2 Upgrade part -3 »

Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)

Last updated on April 14th, 2017 at 02:30 pmR12.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 in previous Post We are … Continue reading Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0) »

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

Last updated on April 14th, 2017 at 02:21 pmR12.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. Step by … 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

Last updated on November 27th, 2016 at 08:38 am 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 … Continue reading Useful Unix command for Oracle DBA »