Category Archives: Oracle


Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

How to find R12 components Version

Last updated on August 25th, 2016 at 03:30 amWe are often asked How to find R12 components Version. This is includes all R12.0/R12.1 and R12.2.I will try to explain how to find out that with variours R12 version with command and reports. Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Version sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print $2}’ $ADMIN_SCRIPTS_HOME/` -version;” Jre … Continue reading How to find R12 components Version »

Introduction to R12

Last updated on September 14th, 2016 at 10:00 pmIntroduction to R12 R12.0 and R12.1 are new version of Oracle apps After 11i.  They have quite of few new things than 11i Technology Change New Versions of Mid Tier Technology • Application Server: 1.0 -> 10.1 • Servlet Container: JServ -> OC4J • Apache: 1.3.19 -> 1.3.34 • Forms & Reports: 6 -> 10 • R12 … Continue reading Introduction to R12 »

Workflow Notification Mailer Configuration in Oracle Apps R12

Last updated on September 29th, 2017 at 05:23 pmWorkflow notification mailer in Oracle apps The Workflow Notification Mailer performs email send and response processing for the Oracle Workflow Notification System. By deploying the Workflow Notification Mailer workflow users receive their notifications by email, as well as from the Worklist web pages. Java based Workflow Notification Mailer – Features Java Based Workflow Notification Mailer is indroduced … Continue reading Workflow Notification Mailer Configuration in Oracle Apps R12 »

Awesome Useful Oracle Apps script to debug it

Last updated on September 14th, 2016 at 09:10 pmYou will need many scripts while troubleshooting,extracting data from Oracle E-business suite.Here I am giving very Useful Oracle Apps  script/code.   Script to find out patches applied select orig_bug_number,to_char(max(last_update_date),’DD-MON-YYYY hh24:mi:ss’) updated from ad_patch_run_bugs where orig_bug_number in ( select distinct app_patch.patch_name from ( select substr(ap.patch_name,1,10) patch_name from ad_patch_runs pr, ad_patch_drivers dr, ad_applied_patches ap where pr.start_date between to_date(‘&&1′,’MM/DD/YYYY’) and to_date(‘&&2′,’MM/DD/YYYY’) and … Continue reading Awesome Useful Oracle Apps script to debug it »

MLS Installation in 11i/R12

Last updated on November 4th, 2015 at 06:57 pmMLS Installation in 11i/R12 Introduction to NLS/MLS NLS: National language support. Being able to run an application in 1 language. This language can be any supported language. It basically means the ability to run an Applications instance in any one of the supported languages (other than American English), including certain region/territory specific numeric and date formats. Only … Continue reading MLS Installation in 11i/R12 »

How Autoconfig in oracle apps R12

Last updated on September 30th, 2016 at 06:25 pmIntroduction to Autoconfig in oracle apps R12 -Autoconfig in oracle apps r12 is a tool that supports automated configuration of an Applications instance. -Autoconfig tool is a set of scripts to centralize and simplify E-Business Suite configuration management. -It does so by maintaining a central repository of E-Business Suite environment information in a context file(.xml) on each midtier. … Continue reading How Autoconfig in oracle apps R12 »

Oracle Concurrent Manager

Last updated on August 16th, 2015 at 03:30 amOracle Concurrent Manager is a important piece in Oracle E-Business Suite product. it helps in batch processing of many things. I am here presenting the some details about it It consists of several part. Explaining each of these in details .It gives u a glimpse of How an E-Business Suite Concurrent Manager Process Works Internal Concurrent Manager (ICM) The Internal … Continue reading Oracle Concurrent Manager »

Forms facts in 11i

Last updated on October 22nd, 2017 at 08:17 amIn this post, I have noted down all the important Forms facts Forms run time trace ‘http://:/dev60cgi/f60cgi?play=&record= collect&log=/tmp/form1.frd’ 2. When-logon-Change error comes 1 Complie invalids 2. Compile all the pll and bounce the forms server 3 Jisniter Dowload URL http://:/jinitiator/oajinit.exe 4.User-exit ere third generation languages which you can cretae and call during forms Application include variaous USER+EXIT Core … Continue reading Forms facts in 11i »

Forms Server Architecture in 11i

Last updated on October 22nd, 2017 at 08:16 amForms Server Architecture Forms Server use a three-tier architecture, consisting of the following components: • Client – A Java Applet running on the client PC that handles the UI presentation. • Middle tier – The Web Listener and the Form runtime that handles the logic. • Database tier – Data-intensive logic and data management. The Forms runtime … Continue reading Forms Server Architecture in 11i »

Oracle Forms in 11i/R12

Last updated on August 16th, 2015 at 03:49 amWe have Oracle forms 6i  in 11i Oracle E-buisness Suite  while Oracle  forms 10g in R12.0/R12.1/R12.2 Oracle E-buisness Suite. The basics remains same in all these. The executable differs between different version We are presenting here the basics of Oracle Forms in  11i/R12 Summary of Forms Definitions -The .fmb file is a Form source file. It’s a binary … Continue reading Oracle Forms in 11i/R12 »

All about Apache in 11i/R12

Last updated on September 19th, 2015 at 06:35 amApache is used in Many product and good knowledge is very important.Here in this section we will have discussion about Apache used in 11i and R12 All about Apache in 11i/R12 Important Directive in httpd.conf Listen: The Listen directive instructs Apache to listen to more than one IP address or port; by default it responds to requests … Continue reading All about Apache in 11i/R12 »

Jserv Architecture in 11i

Last updated on April 15th, 2017 at 03:42 amJserv Architecture in  11i The servlet engine is not part of the web server, but a standalone server application. When executing a servlet request, the web server acts as a client,subrequesting servlets through the network (using the Apache JServ Protocol commonly known as the AJP protocol),converting the returned data and sending it back to the requesting client. … Continue reading Jserv Architecture in 11i »