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

Top queries to find Patch applied in Oracle apps

Last updated on August 24th, 2016 at 06:46 pmWe often get the task to check patch applied in oracle apps environment. Here are the Top queries to find Patch applied in ERP How to find if the bug number or patch is applied to Apps ERP select substr(APPLICATION_SHORT_NAME,1,10) Product,substr(BUG_NUMBER,1,10),Version,last_update_date applied_date from ad_bugs where BUG_NUMBER= to_char(‘&bug_no’); How to find the patch level of particular application select pi.patch_level, … Continue reading Top queries to find Patch applied in Oracle apps »

Oracle Concurrent Manager Secrets Part -I

Last updated on August 25th, 2016 at 04:34 amDescription about important Concurrent Manager tables FND_CONCURRENT_QUEUES TARGET_NODE -Used to indicate where additional processes should be started -Used by managers to determine if they should shut themselves down for migration -Managers compare parameter value passed on startup to this value -Used by UI to indicate where processes exist (not entirely accurate in migrating case) -Assigned by ICM … Continue reading Oracle Concurrent Manager Secrets Part -I »

R12 includes Oracle’s Containers for J2EE ( R12 OC4J)

Last updated on August 31st, 2016 at 08:16 amR12 includes Oracle’s Containers for J2EE (R12 OC4J) -Through R12 OC4J you can execute Servlets, Java Server Pages (JSP), Enterprise Java Beans (EJB) -OC4J replaces the older JServ implementation for running servlets on the web server -Oracle Application Server 10gR3 (10.1.3) is the latest production version -OC4J is based on J2EE standards:Specific directory structure,File requirements (content & naming conventions),XML file … Continue reading R12 includes Oracle’s Containers for J2EE ( R12 OC4J) »

Important Profiles for OA Framework

Last updated on August 31st, 2016 at 05:40 pmI am listing here important Profiles for OA Framework Oracle Applications Look and Feel / APPS_LOOK_AND_FEEL Specifies the look and feel for all OA Framework based pages. This value can be set at any of the Site, Application, Responsibility or User levels. -Valid seeded values include: blaf – Oracle’s corporate Browser Look-and-Feel [ OTN Version of BLAF guidelines … Continue reading Important Profiles for OA Framework »

OA Framework Basics

Last updated on November 14th, 2015 at 02:49 pmOA Framework Basics Key JSP Application Components A typical JSP application involves the following components: a browser for client access, a database for enterprise data and a web application server (“middle tier”) where the application objects live. -The browser communicates with the middle tier using HTTP (Hyper Text Transfer Protocol) which involves sending a request message to … Continue reading OA Framework Basics »

INST_TOP (Oracle R12 INSTANCE_HOME ) decoded

Last updated on September 30th, 2016 at 06:09 pmWith R12 ,Oracle has introduced a new Top call INST_TOP. Features on this R12 INST_TOP -All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top – All configuration files have been moved to INST_TOP like DBc file All the http related config files appsweb.cfg All the start or stop scripts all the OC4J related … Continue reading INST_TOP (Oracle R12 INSTANCE_HOME ) decoded »

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/java.sh` -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 »