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

How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2

We often need to find out what all patches are applied to the EBS instance. Now this vary as per the EBS instance version. We have different queries for R12.1 and R12.2. For R12.0/R12.1 ad_bugs tables contains the information for all the patches applied to the system. we can used below query to find out the patch application in the instance sqlplus apps/<APPS PASSWORD> SELECT DISTINCT RPAD(a.bug_number, … Continue reading How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2 »

Useful Unix/Linux command for Oracle DBA

Last updated on June 21st, 2018 at 07:03 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/Linux command for Oracle DBA »

EBS 12.2.5 and Higher: Login Page Button Misalignment

The Login page in Oracle E-Business Suite 12.2.5 and later may display button misalignment Correct Login Page Incorrect One Reason and Fix Oracle E-Business Suite 12 is not certified with IE11 using either ‘Enterprise Mode’ or ‘Compatibility View’. Enterprise Mode: Internet Explorer 11 includes an ‘Enterprise mode’ which can be used to emulate Internet Explorer 8 behavior and provide compatibility for earlier browser standards. This … Continue reading EBS 12.2.5 and Higher: Login Page Button Misalignment »

Enterprise Manager 11g FMW Control in R12.2

R12.2 comes with Enterprise Manager 11g FMW Control to manage FMW components What is Enterprise Manager 11g FMW Control Enterprise Manager 11g FMW Control is  aWeb application used to monitor and administer a farm A farm is a collection of components managed by Fusion Middleware Control. it Contains Oracle WebLogic Server domains, one Administration Server, one or more Managed Servers, clusters, and one or more Oracle … Continue reading Enterprise Manager 11g FMW Control in R12.2 »

Distributed AD

1)Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems. 2)AD has always utilized a Parallel Jobs System, where multiple AD workers start and are assigned jobs. Information for the Jobs System is stored in the database, and workers receive their assignments by monitoring certain tables in the database. 3) … Continue reading Distributed AD »

How to delete Virtual Machine from VirtualBox

Power off the Virtual Machine which you want to delete from the Virtual box 2) Select the VM to be deleted and then Click Machine on the top machine and choose remove from drop down menu 3) Below screen will come up Use delete all files option to remove the file which contains the virtual machine hard disk. This will free up all the space … Continue reading How to delete Virtual Machine from VirtualBox »

Step by Step R12.2.6 EBS installation on Virtual Box Part -2

Last updated on August 9th, 2018 at 06:58 amWe have already performed the installation of VirtualBox and download the VM appliance in the last post Now lets continue with the installation of 12.2.6 VM template in the Virtual box 1)  Check if the Hardware Virtualization is enabled in the Desktop of Laptop where you have installed the Virtualbox 2) Now Open the Virtual box  and … Continue reading Step by Step R12.2.6 EBS installation on Virtual Box Part -2 »

Step by Step R12.2.6 EBS installation on Virtual Box

Last updated on August 9th, 2018 at 06:59 amOracle recently release VM template for R12.2.6 on Software delivery cloud. In this blogpost , we would be checking step by step how to build R12.2.6  with Virtual box on the Desktop or Laptop 1)  First install VirtualBox on the Desktop or Laptop. Check below post on how to do the installation Step by Step instructions for … Continue reading Step by Step R12.2.6 EBS installation on Virtual Box »

How FNDFS (Oracle Report Review agent) works in EBS environment

Explaining how FNDFS working 1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ 2) The file name and nodename are selected from the database. Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes WHERE concurrent_process_id = :process_id; The client takes the nodename that was returned and … Continue reading How FNDFS (Oracle Report Review agent) works in EBS environment »

oracle apps dba training Part 4

Last updated on July 22nd, 2018 at 05:11 pmoracle apps dba training This is in continuation of the Online oracle apps dba training Course  Series Training Course Part 1 Training Course Part 2 Training Course Part 3 Here  is  Online oracle apps dba training Course Part 4 . I will be discussing Ad utlities, Concurrent Manager ,Online patching Concepts, patching concepts Lets get started Autopatch and … Continue reading oracle apps dba training Part 4 »

APPLSYSPUB schema

APPLSYSPUB  is the database schema. it is the first schema which is used in any connection in Oracle apps. Oracle forms, oacore  all connects to it first The APPLSYSPUB account should have only these grants – INSERT ON FND_UNSUCCESSFUL_LOGINS INSERT ON FND_SESSIONS EXECUTE ON FND_DISCONNECTED EXECUTE ON FND_MESSAGE EXECUTE ON FND_PUB_MESSAGE EXECUTE ON FND_SECURITY_PKG EXECUTE ON FND_SIGNON EXECUTE ON FND_WEBFILEPUB SELECT ON FND_APPLICATION SELECT ON … Continue reading APPLSYSPUB schema »

Online Oracle Apps DBA Training Course Part 2

Last updated on July 24th, 2018 at 04:06 amoracle apps online training This is in continuation of the Online Oracle Apps DBA Training Course  Series Training Course Part 1 Here  is  Online Oracle Apps DBA Training  Course Part 2 . I will be discussing Oracle Applications Technology LayerThe Oracle Applications technology layer lies between the Oracle Applications technology stack and the Oracle Applications product-specific modules. … Continue reading Online Oracle Apps DBA Training Course Part 2 »