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

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

Some 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 will proceed with the steps to rebuild the … 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 »

How to create DMZ for EBS R12

This post I will explaining my experience with setting up DMZ for EBS R12. We will first go through some of the important terms DMZ The DMZ, which stands for Demilitarized Zone consists of the portions of a corporate network that are between the corporate intranet and the Internet. The DMZ can be a simple one segment LAN or it can be broken down into … Continue reading How to create DMZ for EBS R12 »

Top FAQ about Oracle E-Business Suite on Oracle Cloud

Oracle E-Business Suite on Oracle Cloud is the simply using the IAAS  and PAAS model with the Oracle Cloud. You are basically transferring your very own EBS instance on Oracle cloud Infrastructure.This is different from ERP /SCM SAAS  model  provided by the Oracle Here are some important Faq to clear your confusion surrounding EBS on Oracle cloud 1. What is Oracle E-Business Suite on Oracle … Continue reading Top FAQ about Oracle E-Business Suite on Oracle Cloud »

All about FNDLOAD command and WFLOAD command

INTRODUCTION TO FNDLOAD The loader is a general-purpose utility that moves structured data between a text file and a database. Structures supported by the loader include master-detail relationships, and foreign key reference relationships, including arbitrary chains of said relationships. The loader operates in one of three modes: download, upload, or upload_partial. In the download mode, data is downloaded from the database to a text file; … Continue reading All about FNDLOAD command and WFLOAD command »