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

Output post Processor(OPP)

The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and … Continue reading Output post Processor(OPP) »

Top 10 Useful oracle apps queries for DBA

Oracle apps DBA has to often trouble shoot various issues. I am giving here Top 10 Useful oracle apps queries for DBA To find forms sesssion in database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column unix_process format a7 heading “UNIX|Process” column user_name format a15 trunc heading … Continue reading Top 10 Useful oracle apps queries for DBA »

How to use Patch wizard in Oracle EBS environment

How to use Patch wizard  You can submit a specific patch analysis request through the Patch wizard to determine the impact of a patch on your system. Patch Wizard Impact Analysis provides reports on: • The total number of files in the patch • The number of files the patch will install • The products that will have updated files • The files that will … Continue reading How to use Patch wizard in Oracle EBS environment »

New Optimizer Feature with 11g and 12c

New Optimizer Feature with 11g 1) Invisible indexes With 11g release,index can be made invisible. They will be maintained all the time and can be made visible any time alter index K invisible; Optimizer will not use the index if it is invisible alter index K visible If want one query to use invisible index,we can set this parameter in the session optimizer_use_invisible_index=true Then the … Continue reading New Optimizer Feature with 11g and 12c »

Basic elements(Application,Forms,functions,menu) of Oracle EBS Application

Here in this post,I am trying to explain the Basic elements(Application,Forms,functions,menu) of Oracle EBS Application Application -An Application is a collection of Forms,Reports and PL/SQL objects to meet a particular business objectives -Oracle Applications like 11.0,11i,R12 is a collection of predefined inter linked applications -A custom application can be designed and integrated with Oracle Applications -Any custom application has to be registered with Oracle Applications … Continue reading Basic elements(Application,Forms,functions,menu) of Oracle EBS Application »

Guest User password in 11i/R12

Here in this post,I am decoding all the facts about Guest User password in 11i/R12 –GUest user password is very important for the functioning of Application SSWA. Self service login used this password to verify the user password.Selfservice will not come up if this password is incorrect.Direct form login will still work if the password is incorrect -It is stored in following places in 11i $FND_TOP/secure/ … Continue reading Guest User password in 11i/R12 »

Important Oracle Forms Architecture Features in R12

We are explaining here Oracle Forms Architecture Features in R12/R12.2 Features of Forms in R12 -forms are deployed as a one One OC4J instance of 10.1.3 Oracle home -It uses the utlity from 10.1.2 Oracle home/bin -Forms.EAR 10.1.2 is deployed to the OC4J container in Application Server 10.1.3 -Run time form executabale f60webmx has been replaced by frmweb -Forms Servlet is default deployment / communication … Continue reading Important Oracle Forms Architecture Features in R12 »

How to rebuild WF_DEFERRED_TABLE_M Queue

Last updated on December 17th, 2017 at 05:31 pmSome times we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. First take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lst select object_name, object_type, status, owner from dba_objects where object_name like ‘%WF_DEFERRED_TABLE_M%’; spool off 2) Now we … Continue reading How to rebuild WF_DEFERRED_TABLE_M Queue »

What is current view APPL_TOP snapshots

What is APPL_TOP snapshots? 1) It is record the current set of files and file versions in your APPL_TOP 2) Current view snapshots are created once and updated when appropriate to maintain a consistent view of the APPL_TOP content 3) Snapshots are current views of your system: they are created once, and then updated when appropriate to maintain a consistent view. There are two types of … Continue reading What is current view APPL_TOP snapshots »

How To Check Environment Variables for a Running Process

This post we will talking about one of the useful things which administrator often has to use. The topic is How To Check Environment Variables for a Running Process . Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavor of Unix systtem What is environment Variable An environment variable is a dynamic-named … Continue reading How To Check Environment Variables for a Running Process »

Step by Step resolution for the problem oacore not coming up in R12

Last updated on September 21st, 2017 at 05:20 pmI would be presenting some solutions for oacore not coming up  in R12 EBS  version. First let me give brief idea about oacore mechanism in R12 In R12 we have 3 groups of OC4J’s. oacore OC4J – Supports framework based applications forms OC4J – Supports forms based applications oafm OC4J – expands to Oracle Application Fusion Middleware … Continue reading Step by Step resolution for the problem oacore not coming up in R12 »

Awesome 24 Concurrent Manager Interview questions

Here are awesome 24 Concurrent Manager Interview questions asked in most interview to test concurrent Manager working skills   Question 1: What are different types of concurrent manager? Answer There are several types of concurrent manager. Important ones: Internal Manager Standard Manager. Conflict Resolution Manager Internal monitors Service Manager Transaction Manager Custom Manager Defined Read more on below link Oracle Concurrent Manager Question 2: What is … Continue reading Awesome 24 Concurrent Manager Interview questions »