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

Online Oracle Apps DBA Training Course Part 1

Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications Oracle applications is the widely used EBS application in the world.Oracle’s E-Business Suite requires extensive work from Oracle Application Database Administrator(Oracle apps DBA). So Oracle Application Database Administrator is a rewarding career with great potential to scale … Continue reading Online Oracle Apps DBA Training Course Part 1 »

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 25 Useful oracle apps queries for DBA

Last updated on July 27th, 2018 at 05:05 pmOracle apps DBA has to often trouble shoot various issues. I am giving here Top 25 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 … Continue reading Top 25 Useful oracle apps queries for DBA »

How to use Patch wizard in Oracle EBS environment

Last updated on July 27th, 2018 at 05:00 pmPatch Wizard is a tool provided by Oracle on finding the impact of Apps patches on the Environment.It is very useful tools and shows all the impacted files and appropriate action can be taken based on that information. It is extremely important tool and here i will explain how to use patch wizard, how to do analysis … 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 »