Interview Questions.

Question 1. What Is Fndsm?

Answer :

FNDSM is executable & middle element in GSM (Generic Service Management Framework). You begin FNDSM offerings through APPS listener on all Nodes in Application Tier in E-Business Suite.

Question 2. What Is Ias Patch ?

Answer :

iAS Patch are patches released to repair insects associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shipped as Shell scripts & you practice iAS patches via executing Shell script.

Oracle 10g Interview Questions
Question three. Explain Architecture Of Oracle Apps 11i?

Answer :

Apps 11i is Multi Tier architecture with Desktop Tier (Client Tier), Middle Tier (Application Tier) and Database Tier.

Question four. What Are Various Components In Application/middle Tier?

Answer :

In Application Tier numerous additives are Web Server, Forms Server, Reports Server, Concurrent Manager, Admin Server & Discoverer Server.

Oracle 10g Tutorial
Question five. What Is Appl_top, Comn_top, Ora_top.....?

Answer :

XXX_TOP is top stage directory in Oracle Application 11i for respective Component.

Oracle 9i Interview Questions
Question 6. What Is Us Directory In $ad_top Or Under Various Product Top's?

Answer :

US directory is default language listing in Oracle Applications. If you've got more than one languages Installed to your Applications then you'll see other languages directories except US, that directory will incorporate reports, fmx and other code in that respective listing like FR for France, AR for Arabic.

Question 7. What Are The Main Concurrent Manager Types?

Answer :

ICM - Internal Concurrent Manager which manages concurrent managers

Standard Managers - Manages processing of requests

CRM - Conflict Resolution Managers, solve conflicts in case of incompatibility

Oracle 9i Tutorial Oracle 8i Interview Questions
Question 8. Where Is Concurrent Manager Log File Location?

Answer :

By default fashionable area is $APPLCSF/$APPLLOG, in some cases it is able to go to $FND_TOP/log as well

Question nine. Where Would I Find .Rf9 File, And What Exactly It Does?

Answer :

These documents are used all through restart of a patch in case of patch failure because of some cause.

Oracle 11g Interview Questions
Question 10. Where Is Appsweb.Cfg Or Appsweb_$context.Cfg Stored & Why Is It Used?

Answer :

This report is described via environment variable FORMS60_WEB_CONFIG_FILE. This is generally in listing $OA_HTML/bin on bureaucracy tier. This document is utilized by any forms customer session. When a consumer tries to get admission to forms, f60webmx selections up this report and primarily based in this configuration file creates a forms session to consumer/purchaser.

Oracle 8i Tutorial
Question eleven. What Is Multi Node System?

Answer :

Multi Node System in Oracle Applications 11i way you've got Applications 11i Component on more than one system. Typical instance is database, Concurrent Manager on one system and Forms Server, Web Server on 2nd machine.

Oracle apps Interview Questions
Question 12. Can You Clone From Multi Node System To Single Node System & Vice Versa?

Answer :

Yes, that is now supported through Rapid Clone, Check in case your machine has all prerequisite patches for Rapid Clone and you are on present day rapid clone patch.

Oracle 10g Interview Questions
Question thirteen. Does Rapid Clone Takes Care Of Updating Global Orainventory Or You Have To Register Manually In Global Orainventory After Clone?

Answer :

Rapid Clone robotically updates Global oraInventory all through configuration segment. You do not must do something manually for Global oraInventory.

Oracle 11g Tutorial
Question 14. What Is .Dbc File, Where Is It Stored, What Is The Use Of .Dbc File?

Answer :

DBC. As call shows is a database connect descriptor record which stores database connection information utilized by software tier to connect to database. This document is in directory $FND_TOP/at ease also known as as FND_SECURE.

Question 15. What Things You Do To Reduce Patch Timing?

Answer :

Merging patches thru admrgpch
Use numerous adpatch options like nocompiledb or nocompilejsp
Use defaults file
Staged APPL_TOP all through upgrades
Increase batch length (Might result into bad)
Oracle Apps ERP Interview Questions
Question 16. How You Put Applications 11i In Maintenance Mode?

Answer :

Use adadmin to alternate maintenance mode in EBS. If you don't need to position EBS in renovation mode you can use adpatch options=hotpatch function.

Question 17. Can You Apply Patch Without Putting Applications 11i In Maintenance Mode?

Answer :

Yes, use options=hotpatch as stated above with adpatch.

Oracle 7.Three Interview Questions
Question 18. What Are Various Options Available With Adpatch?

Answer :

Various alternatives to be had with adpatch relying in your AD version are:

autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseportion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate

Oracle 9i Interview Questions
Question 19. Adident Utility Is Used For What?

Answer :

adident application in oracle apps is used to find version of any document .

For instance:“adident Header <filename>”

Question 20. What Is Adsplice Utility?

Answer :

adsplice in oracle apps is application to add a brand new product to EBS.

Oracle ADF Interview Questions
Question 21. How Can You License A Product After Installation?

Answer :

You can use ad utility adlicmgr to license product in Oracle Apps.

Question 22. What Is Mrc? What You Do As Apps Dba For Mrc?

Answer :

MRC also called as Multiple Reporting Currency in Oracle Apps. By default you have foreign money in US Dollars but in case your agency’s working books are in different currency then you as apps DBA need to permit MRC in Apps.

Question 23. What Is Access_log In Apache, What Entries Are Recorded In Access_log? Where Is The Default Location Of This File?

Answer :

access_log in Oracle Application Server facts all users accessing oracle applications 11i. Its report place is described in httpd.Conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs.

Oracle Application Framework Interview Questions
Question 24. Where Is Jserv Configuration Files Stored?

Answer :

Jserv configuration documents are saved in $IAS_ORACLE_HOME/Apache/Jserv/and many others.

Oracle 8i Interview Questions
Question 25. Where Is Applications Start/forestall Scripts Stored?

Answer :

Applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME

Question 26. What Are Main Configuration Files In Web Server (apache)?

Answer :

Main configuration files in Oracle Apps Web Server are:

httpd.Conf, apps.Conf, oracle_apache.Conf, httpd_pls.Conf, jserv.Conf, ssp_init.Txt, jserv.Houses, area.Properties

plsql.Conf, wdbsvr.App, plsql.Conf

Oracle Apps Functional Interview Questions
Question 27. How To Check If Apps 11i System Is Autoconfig Enabled?

Answer :

Under $AD_TOP/bin check for file adcfginfo.Sh and if this exists use adcfginfo.Sh contextfile=<CONTEXT> show=enabled

If this record is not there, search for any configuration record beneath APPL_TOP if machine is Autoconfig enabled then you'll see entry like

# AutoConfig mechanically generates this record.

Oracle 11g Interview Questions
Question 28. How To Check If Oracle Apps 11i System Is Rapid Clone Enabled?

Answer :

For machine to be Rapid Clone enabled, it need to be Autoconfig enabled. You must have Rapid Clone Patches carried out.

Question 29. What Is The Difference Between Two Env Files In <context>.Env And Apps<context>.Env Under $appl_top?

Answer :

APPS<CONTEXT>.Env is principal surroundings file which in flip calls other surroundings files like <CONTEXT>.Env beneath $APPL_TOP

Oracle Workflow Interview Questions
Question 30. What Is Your Oracle Apps 11i Webserver Version And How To Find It?

Answer :

In order to find version below IAS_ORACLE_HOME/Apache/Apache/bin

Execute ./httpd -version

Question 31. What Is Plsql Database Cache?

Answer :

In order to enhance performance mod_pls (Apache element) caches a few database content material to document. This plsql cache is used to keep session facts. Plsql cache is used to save plsql cache i.E. Used by mod_pls

Question 32. Where Is Database Plsql Cache Stored?

Answer :

plsql & session cache are saved underneath $IAS_ORACLE_HOME/ Apache/modplsql/cache listing.

Question 33. How To Determine Oracle Apps 11i Version?

Answer :

select RELEASE_NAME from fnd_product_groups;

You have to see output like

RELEASE_NAME

eleven.5.Nine or 11.Five.10.2

Oracle apps Interview Questions
Question 34. What Is Content Of Dbc File & Why Is It Important?

Answer :

DBC report is pretty vital as each time Java or some other application like forms want to connect to database it makes use of dbc document. Typical entry in dbc file is

GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST
Question 35. There Are Lot Of Dbc File Under $fnd_secure, How Is It Determined That Which Dbc File To Use From $fnd_secure?

Answer :

This fee is decided from profile choice "Applications Database ID"

Question 36. What Is Rra/fndfs?

Answer :

Report Review Agent (RRA) also referred by way of executable FNDFS is default text viewer in Oracle Applications 11i for viewing output documents & log files.

Oracle Apps ERP Interview Questions
Question 37. What Is Pcp Is Oracle Applications 11i?

Answer :

PCP is acronym for Parallel Concurrent Processing. Usually you have got one Concurrent Manager executing your requests but you could configure Concurrent Manager going for walks on  machines. So for some of your requests number one CM Node is on machine1 and secondary CM node on machine2 and for some requests number one CM is on machine2 & secondary CM on machine1.

Question 38. Why I Need Two Concurrent Processing Nodes Or In What Scenarios Pcp Is Used?

Answer :

If you're walking GL month cease reports or taxation reviews annually those reports may take couple of days. Some of those requests are very resource extensive so that you will have one node going for walks lengthy running resource extensive requests while different processing your daily brief strolling requests. Another scenario is when your requests are very important and also you want excessive resilience to your Concurrent Processing Node, you may configure PCP. So if node1 is going down you still have CM node available processing your requests.

Question 39. How To Confirm If Report Server Is Up & Running?

Answer :

Report Server is started out by way of executable rwmts60 on concurrent supervisor Node & this document is below $ORACLE_HOME/bin Execute command in your server like

ps -ef forty. What Is Difference Between Icm, Standard Managers And Crm In Concurrent Manager?

Answer :

ICM stand for Internal Concurrent Manager, which controls other managers. If it finds different managers down, it exams & attempts to restart them. You can say it's miles an administrator to different concurrent managers. Standard Manager: These are ordinary managers which performs moves on the requests and does batch or unmarried request processing. CRM is acronym for Conflict Resolution Manager and is used to remedy conflicts among managers & requests. If a request is submitted whose execution is clashing or it is described now not to run even as a specific sort of request is walking then such requests are assigned to CRM for incompatibilities & war resolution.

Oracle 7.3 Interview Questions
Question 41. What Is Use Of Apps Listener?

Answer :

Apps Listener commonly run on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS & FNDSM.

Question 42. How To Start Apps Listener?

Answer :

In Oracle 11i, you've got script adalnctl.Sh so that you can begin your apps listener. You can also begin it by command lsnrctl begin APPS_$SID (Replace sid by using your Instance SID Name).

Oracle ADF Interview Questions
Question forty three. How To Confirm If Apps Listener Is Up & Running?

Answer :

lsnrctl start APPS_$SID (update SID together with your Instance Name) so if your SID is VISION then use lsnrctl repute APPS_VISION.

Question forty four. What Is Web Listener?

Answer :

Web Listener is Web Server listener that's listening for web Services (HTTP) request. This listener is started by way of adapcctl.Sh & described with the aid of directive (Listen, Port) in httpd.Conf for Web Server.

Question forty five. How Will You Find Total Number Of Invalid Objects In Database?

Answer :

SQLPLUS> select matter(*) from dba_objects wherein reputation like 'INVALID';

Question forty six. How To Compile Invalid Objects In Database?

Answer :

You can use adadmin utility to compile or you could use utlrp.Square script shipped with Oracle Database to compile Invalid Database Objects.

Question 47. How To Compile Jsp In Oracle Apps?

Answer :

You can use ojspCompile.Pl perl script shipped with Oracle apps to compile JSP documents. This script is under $JTF_TOP/admin/scripts. Sample compilation technique is

perl ojspCompile.Pl --bring together --quiet

Question forty eight. What Is Difference Between Adpatch & Opatch?

Answer :

# adpatch is software to apply oracle apps Patches while

# opatch is software to apply database patches

Question 49. Can You Use Both Adpatch & Opatch In Apps?

Answer :

Yes you need to use both in apps, for apps patches you will use opatch application and for making use of database patch in apps you will use opatch software.

Question 50. Where Will You Find Forms Configuration Details Apart From Xml File?

Answer :

Forms configuration at time of startup is in script adfrmctl.Sh and appsweb_$CONTEXT_NAME.Cfg for bureaucracy client connection used every time a user initiates bureaucracy connection.

Question 51. What Are Different Modes Of Forms In Which You Can Start Forms Server And Which One Is Default?

Answer :

You can start forms server in SOCKET or SERVLET by using default Forms are configured to begin in socket mode.

Question fifty two. How You Will Start Discoverer In Oracle Apps 11i?

Answer :

In order to start discoverer you may use script addisctl.Sh beneath $OAD_TOP/admin/scripts/$CONTEXT_NAME or startal.Sh under $ORACLE_HOME/discwb4/util (underneath Middle/Application Tier)

Question fifty three. How Many Oracle Home Are In Oracle Apps And What Is The Significance Of Each?

Answer :

There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database Tier.

# ORACLE_HOME 1: On Application Tier used to save 8.Zero.6 techstack software program. This is utilized by bureaucracy, reports & discoverer.

# ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is utilized by Web Listener & incorporates Apache.

# ORACLE_HOME three: On Database Tier utilized by Database Software generally 8i, 9i or 10g database.

Question 54. Where Is Html Cache Stored In Oracle Apps Server?

Answer :

Oracle HTML Cache is to be had at $COMMON_TOP/_pages for a few previous variations you may discover it in $OA_HTML/_pages.

Question fifty five. What Happens If You Don't Give Cache Size While Defining Concurrent Manager?

Answer :

Lets first understand what's cache size in Concurrent Manager. When Manager alternatives request from FND CONCURRENT REQUESTS Queues, it will pick up range of requests defined through cache size in one shot & will work on them before going to sleep. So in my views if you don't outline cache size whilst defining CM then it will take default cost 1, i.E. Picking up one request according to cycle.

Question fifty six. What Are Few Profile Options Which You Update After Cloning?

Answer :

Rapid clone updates profile alternatives particular to website online stage. If you have got any profile option set at other stages like server, duty, user....Degree then reset them.

Question 57. How To Retrieve Sysadmin Password?

Answer :

If forgot password link is enabled and sysadmin account is configured with mail identification user neglect password hyperlink else you may reset sysadmin password via FNDCPASS.

Question 58. If You Have Done Two Nodes Installation, First Machine: Database And Concurrent Processing Server. 2nd Machine: Form, Web. Which Machine Has Admin Server/node?

Answer :

Admin Server can be on First machine with concurrent processing server.

Question 59. What Is Two_task In Oracle Database?

Answer :

TWO_TASK mocks your TNS alias which you are going to use to connect with database. Let’s count on you've got database patron with TNS alias described as PROD to connect to Database PROD on device teachmeoracle.Com listening on port 1521. Then ordinary manner to attach is sqlplus username/passwd@PROD; now in case you do not need to use @PROD you then set TWO_TASK=PROD and then can clearly use sqlplus username/passwd then sq. Will take a look at that it has to hook up with TNS alias define with the aid of price PROD i.E. TWO_TASK

Question 60. What Is Gwyuid?

Answer :

GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

Question sixty one. Where Gwyuid Defined & Why Is It Used In Oracle Applications?

Answer :

GWYUID is described in dbc i.E. Database Connect Descriptor report. It is used to attach thin customers to database.

Question 62. What Is Difference Between Guest_user_pwd (visitor/oracle) & Gwyuid?

Answer :

GUEST_USER_PWD(Guest/Oracle) is utilized by JDBC Thin Client in which as GWYUID is utilized by Thick Clients like thru Forms Connections.

Question 63. What Is zero & Y In Fndcpass, Fndload Or Wfload?

Answer :

zero & Y are flags for FND Executable like FNDCPASS & FNDLOAD where zero is request id.  'Y' suggests the approach of invocation i.E. It's far immediately invoked from the command-line no longer from the Submit Request Form.

Question 64. In A Multi Node Installation, How Will You Find Which Node Is Running What Services?

Answer :

You can query for table FND_NODES and test for column, SUPPORT_CP (for Concurrent Manager) SUPPORT_FORMS (for forms server), SUPPPORT_WEB (Web Server), SUPPORT_ADMIN (Admin Server), and SUPPORT_DB for database tier. You also can test identical from CONTEXT File (xml document under APPL_TOP/admin).

Question sixty five. If Your System Has More Than One Jinitiator, How Will The System Know, Which One To Pick?

Answer :

When patron makes a paperwork connection in Oracle Applications, paperwork client consultation makes use of configuration file defined by means of environment variable FORMS60_WEB_CONFIG_FILE.

Question 66. While Applying Apps Patch Using Adpatch, If You Want To Hide The Apps Password, How Will That Be Possible?

Answer :

Use adpatch flags=hidepw while applying patches in apps to hide apps or gadget password being displayed on screen.

Question sixty seven. What Is The Importance Of Imap Server In Java Notification Mailer?

Answer :

IMAP stands for Internet Message Access Protocol and Java Notification mailer require IMAP server for Inbound Processing of Notification Mails.

Question 68. What Is Difference Between Socket & Servlet Mode In Apps Forms?

Answer :

When bureaucracy run in SOCKET Mode these are devoted connection among Client Machine & Form Server. When Forms run in servlet mode there can be additional JVM for Forms Request if so and also you won't begin shape thru adfrmctl.Sh.

Question 69. What Is Make Program In Unix?

Answer :

make is software in Unix/Linux to preserve , update & generate a report particularly executable.

Question 70. If By Mistake Someone Deleted Fndlibr Can This Executable Be Restored If Yes, How & If No, What Will You Do?

Answer :

Yes, you may repair FNDLIBR executables
Run adadmin on concurrent supervisor node
Select Maintain Applications Files menu
Then pick out Relink Applications programs
When activates for “Enter list of merchandise to link ('all' for all merchandise) [all]” pick out FND
When spark off for “Generate specific executables for every decided on product [No]?” pick out YES
From listing of executables select FNDLIBR this will create new FNDLIBR executables
Question 71. What Is .Pls Files Which You See With Apps?

Answer :

.PLS record stands for plsql documents. In apps patch these documents incorporate code to create bundle spec or package frame or each.

Question seventy two. What Are .Ldt And .Lct Files Which You See In Apps Patch Or With Fndload?

Answer :

.Ldt & .Lct stands for Loader statistics report & Loader configuration documents, used often in migrating customization, profile alternatives, configuration information and many others. Throughout Instances.

Question seventy three. What Are .Odf File In Apps Patch?

Answer :

odf stands for Object Description Files used to create tables & different database objects at the same time as applying a patch.

Question 74. Where To Find Form Server Log Files In Forms?

Answer :

Form Server Start up log file default location is $OAD_TOP/admin/log/$CONTEXT_NAME/f60svrm.Txt

Forms Run Time Diagnostics default location is $ORACLE_HOME/forms60/log/$CONTEXT_NAME

Question seventy five. How To Convert Pll To Pld File Or Pld File To Pll ?

Answer :

pll->pld f60gen module=MSCOSCW3.Pll module_type=library userid=apps/ module_access=document output_file=MSCOSCW1.Pld script=sure.

Pld -> pll f60gen module=MSCOSCW3.Pld userid=apps/ module_type=library module_access=report output_file=MSCOSCW1.Pll parse=y batch=sure compile_all=special.

Question 76. Does Apps_mrc Schema Exist For Mrc In eleven.5.10 And Higher?

Answer :

No, apps_mrc schema is dropped with 11.5.10 Upgrade & eleven.Five.10 new Install. This is replaced by greater Integrated Architecture.

Question seventy seven. If Apps Mrc Schema Is Not Used In 11.5.10 And Higher Then How Mrc Is Working?

Answer :

For merchandise like Payable, Receivables which makes use of MRC and if MRC is enabled then each transaction table in base schema related to foreign money now has an associated MRC sub tables.

Question 78. When You Apply C Driver Patch Does It Require Database To Be Up & Why?

Answer :

Yes, database & db listener must be UP while you apply any motive force patch in apps. Even if driver is not updating any database item connection is required to validate apps & different schema and to add patch history records in database tables.

Question 79. Can C Driver In Apps Patch Create Invalid Object In Database?

Answer :

No, C motive force most effective copies documents in File System. Database Object might be invalidated throughout D driving force when these items are created/dropped/changed.

Question 80. What Is Dev60cgi & F60cgi?

Answer :

cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to get admission to forms server . Usually Form Server get right of entry to at once via http://hostname:port/dev60cgi/f60cgi.

Question eighty one. Why Does A Worker Fail In Oracle Apps Patch And Few Scenarios In Which It Failed For You?

Answer :

Apps Patch employee can fail in case it does not locate predicted statistics, item, documents or some thing which motive force is attempting to update/edit/adjust. Possible symptoms may be underlying tables/objects are invalid, a prerequisite patch is lacking, login facts is inaccurate, inconsistency in seed information.

Question eighty two. What Is Difference Between Mod_osso & Mod_ose In Oracle Http Server?

Answer :

mod_osso is Oracle Single Sign-On Module where as mod_ose is module for Oracle Servlet Engine.

Question 83. What Is Difference Between Compile_all=unique And Compile=all While Compiling Forms?

Answer :

Both the options will assemble all of the PL/SQL inside the resultant .FMX, .PLX, or .MMX record but COMPILE_ALL=YES also adjustments the cached version within the source .FMB, .PLL, or .MMB record.

Question eighty four. How Will You Find The Apache, Forms, Reports Version In An Ebs Suite?

Answer :

http –v – Apache
f60gen – Forms
ar60run – Reports
Question 85. Find Jinitiator Version?

Answer :

Client side – Control panel

Server aspect – SID_hostname.Xml (s_jinit_ver_)

Question 86. List Some Ad Utilities And Their Functions?

Answer :

adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker

Question 87. List Out The Modules Related To Oracle Apps Dba?

Answer :

FND – Application Object Library, AU – Application Utilities, AD – Application DBA

Question 88. What Are The Different Types Of Oracle Patches Available?

Answer :

One-off, mini, diagnostics, cu, rup, language, assist, platform precise, OS, OPatch, Interoperability, family % and renovation p.C..

Question 89. List Out The Important Env Files?

Answer :

Appsora.Env, appsSID_hostname.Env, adovars.Env, APPSSID_hostname

Question ninety. What Are The Components In The Application Tier?

Answer :

Apache(http)
Jserver(jre)
Forms Server(f60srv)
Metric Server(d2ls)
Metric Client(d2lc)
Report Server(rwm60)
Concurrent Server(FNDLIBR)
Discoverer
Question 91. What Are Main File Systems In Oracle Apps?

Answer :

APPL_TOP, COMMON_TOP, DB_TOP,ORA_TOP 7

Question ninety two. What Is The Location Of Jinitiator In The Desktop Tier?

Answer :

c:/programfiles/oracle/Jinitiator.

Question ninety three. What Are Adadmin Utilities And Their Location?

Answer :

$AD_TOP/bin
adadmin
adpatch
adsplice
adident
adrelink
adlicmgr
Question ninety four. How Do You Start The Apps Services?

Answer :

$COMMON_TOPadminscriptsContextnameadstrtal.Sh apps/apps

Question 95. What Is Dad?

Answer :

It is a report which stores apps passwords in difficult coded format i.E. Wdbsvr

Question ninety six. How Do You Know The Package Version?

Answer :

select text from dba_source wherein call='package name' and kind='PACKAGE BODY' and rownum<10>/rdbms/admin)

Question 97. What Are Restart Files And Its Location?

Answer :

These files contain the preceding consultation information about adadmin. Location is $APPL_TOPadminsidrestart*.Rf9

Question 98. How Do You Validate Apps Schema?

Answer :

To validate synonyms, lacking synonyms and all grants use adadmin. After validating it's going to produce a document inside the location $APPL_TOPadminsidout*.Out

Question ninety nine. How To See The Version Of A Script Or Form Or Report Or Etc?

Answer :

adident Header GLXSTEA.Fmx

Question a hundred. What Is The Location Of Adadmin Log?

Answer :

$APPL_TOPadminsidlog

Question one zero one. What Are The Profile Options, What Are Various Types Of Profile Options?

Answer :

You set profile alternatives at the subsequent degrees

Site level
Application stage
Responsibility degree
User level
Question 102. What Is Apps Listener? Why Is It Used?

Answer :

Apps Listener typically run on all Oracle Applications 11i Nodes with listener alias as APPS_$SID and is specially used for listening requests for offerings like FNDFS & FNDSM.

Question 103. What Is Autoconfig?

Answer :

Autoconfig is technique of configuring Oracle Applications. All the statistics required to configure Oracle Apps 11i is saved in document referred to as Context report. So there are two context documents, one for Database Tier and Second for Application Tier. Context document is repository for configuration information stored in xml format. Its xml document and document call layout is <SID>_<HOSTNAME>.Xml so in case your gadget call is MACHINE1 and SID is VISION then context document name will be VISION_MACHINE1.Xml

Question 104. What Is Context File?

Answer :

Oracle stores all the environment particular values in an xml file saved in $APPL_TOP/admin listing, which they name an software context file. This document is created by using running adbldxml.Sh/adbldxml.Pl (Located in $AD_TOP/bin). Adbldxml.Sh in flip runs oracle.Apps.Ad.Context.GenerateContext java magnificence.

Context record is generated via plugging in environment specific values within the context report template (don’t confuse this template with the configuration record templates) $AD_TOP/admin/template/adxmlctx.Tmp. In older variations of 11i those alternative values were gotten from config.Txt report (created via rapidwiz throughout set up), however in later versions, those values are gotten from the facts, in existing configuration files and the database. Adbldxml.Sh/adbldxml.Pl (in more moderen variations of autoconfig) creates an in depth log record, detailing the supply for every context variable.

Question 105. How To Create User In Oracle Applications 11i? Can You Delete A User?

Answer :

Choose Users from the Manage menu to create a brand new person. This opens the Manage Users dialog box, wherein you pick out New to go into data for a brand new consumer.

You offer the subsequent user information:

User :Enter a call that identifies the person.

User Type : Select the type of the consumer.

Usernames :Choose Edit to get admission to the Edit User dialog field in which you can accomplice one or more user names with the person and specify whether or not the user is allowed to create shareable files.

Other:Provide information this is unique to the consumer type. For instance, for a skinny-client computing device, you enter the SHELLS directory of the factor in which you are developing the consumer and the Express Server instance to which the user's private database will be connected.

Adding a brand new person creates a user challenge and sends it to the Task Processor. If you aren't going for walks the Task Processor within the historical past, you need to run it in the foreground to manner the consumer venture.

Question 106. What Is Single Sign On? (if You Are Using Portal 3.Zero.Nine Or 10g)?

Answer :

Oracle Enterprise Single Sign-On Suite provides customers with unified signal-on and authentication throughout all their corporation resources, together with desktops, patron-server, custom and host-based totally mainframe applications. Even if users journey or share workstations, they could experience the ability of a single log-on that eliminates the need for more than one usernames and passwords and helps implement robust password and authentication regulations.

Question 107. What Happens If The Icm Goes Down?

Answer :

Since ICM is down so it cannot attain different managers & cannot shutdown them however sure if due to a few purpose Standard Manager dies & ICM is already dead Standard managers will no longer start. The ICM does the work of distributing the concurrent request to traditional managers. If ICM is going down the concurrent requests in standard managers can be strolling nice. But no new request can be assigned to the standard managers. So wait till all your concurrent requests gets finished and then bounce the concurrent managers to begin your ICM.

Question 108. Provide A High-stage Overview Of The Cloning Process And Post-clone Manual Steps?

Answer :

Rapid Cloning Steps for Windows R12Source System:

Run adpreclone.Pl in Database Node
Perl $ORACLE_HOMEappsutilscripts$CONTEX_NAMEadpreclone.Pl dbTier
Run adpreclone.Pl in Apps Node
Perl $ADMIN_SCRIPTS_HOMEadpreclone.Pl appsTier
Shut down the Applications and database
Change all services type into manual (option)
Restart the machine (alternative)
Check if any FNDLIBR programs are running or no longer
Take a chilly backup of database and packages
Target System:

Prepare your target gadget as in keeping with the supply gadget configuration

Install Windows Server 2003 service % 2 Enterprise Edition
Install Visual Studio 2005
Install Active perl
Install Cygwin Change make version from three.Eighty one into three.Eighty
Copy the Source device backup into target machine
Set perl locations by way of using present env record(It varies among DB node and Apps Node, We will set this  times)
Goto the $ORACLE_HOMEappsutilclonebin folder and the post clone scripts
Run Postclone scripts in db Tier
Perl $ORACLE_HOMEappsutilcloneBinadcfgclone.Pl dbTier
Run Postclone in Apps Tier
Perl $COMMON_TOPclonebinadcfgclone.Pl appsTier
Finishing Tasks:

Update the profile options Rapid clone will update the site degree profile alternatives handiest, we need to replace example stage profile options manually
Update the printer settings
Update the workflow configuration settings
Cloning an Oracle Applications instance will not update the host and instance particular facts used by Oracle Workflow. Review the following tables and columns to verify there may be no example precise facts in the Workflow configuration at the target gadget.

Important Notes:

While running Postclone in appsTier it prompts hostname, we have to provide like hostname.Domainname as an instance sys10.Pattern.Com
While going for walks put up clone in appsTier it prompts visual studio directory don’t include bin folder. For instance supply like c:vcVC, don’t supply like  c:vcVCbin
Question 109. Provide An Introduction To Autoconfig. How Does Autoconfig Know Which Value From The Xml File Needs To Be Put In Which File?

Answer :

AutoConfig makes use of a context document to keep key configuration files. A context document is an XML file within the $APPL_TOP/admin listing and is the centralized repository. When you run AutoConfig it reads the XML documents and creates all of the AutoConfig managed configuration documents. For every configuration document maintained via AutoConfig, there exists a template report which determines which values to pick out from the XML file.

Question one hundred ten. Can You Tell Me A Few Tests You Will Do To Troubleshoot Self-provider Login Problems? Which Profile Options And Files Will You Check?

Answer :

Check visitor consumer/password inside the DBC document, profile choice visitor consumer/password, the DB.
Check whether apache jserv is up.
Run IsItWorking, FND_WEB.PING, aoljtest, and so on.
Question 111. What Could Be Wrong If You Are Unable To View Concurrent Manager Log And Output Files?

Answer :

Most possibly the FNDFS listener is down. Look at the value of OUTFILE_NODE_NAME and LOGFILE_NODE_NAME within the FND_CONCURRENT_REQUESTS table. Look at the FND_NODES desk. Look on the FNDFS_ access in tnsnames.Ora.

Question 112. How Will You Change The Location Of Concurrent Manager Log And Output Files?

Answer :

The area of log files is decided with the aid of parameter $APPLCSF/$APPLLOG and that of output files by using $APPLCSF/$APPLOUT.

Question 113. If The User Is Experiencing Performance Issues, How Will You Go About Finding The Cause?

Answer :

Trace his consultation (with waits) and use tkprof to research the trace record.
Take a statspack report and analyze it.
O/s monitoring the use of top/iostat/sar/vmstat.
Check for any community bottleneck by way of the use of basic tests like ping results.
Question 114. How Will You Change The Apps Password?

Answer :

Use FNDCPASS to alternate APPS password.
Manually adjust wdbsvr.App/cgiCMD.Dat files.
Change any DB links pointing from different instances.
Question 115. Explain The Steps For Applying Apps Patch And Database Patch?

Answer :

Login as applmgr and set the surroundings. For the Windows surroundings also, you have got to check that CLASSPATH consists of %JAVA_TOP%, %JAVA_TOPp.Cloadjava.Zip
Create a PATCH_TOP listing inside the Base Directory (on the equal level as APPL_TOP, COMMON_TOP, and many others: this is just a recommendation) for the patches for you to be downloaded. If this listing exists, this step may be skipped. An OS surroundings variable will be created for this directory. This will be executed best one time, when the primary patch may be applied.
Download the patch you need to apply in PATCH_TOP directory and unzip the patch.
Understand the README.Txt file and complete the prerequisite or manual steps. Here, if there are any patched to use as pre-needful, in fashionable, is created a document with all the steps regarding in the patching manner and the pre-considered necessary patches could be implemented earlier than the initial patch.
Ensure that the PLATFORM variable surroundings (beneath UNIX, Linux, Solaris) is about
Shut down APPS services. The database services and the listener have to be up and jogging.
Enable Maintenance Mode.
Start AutoPatch in interactive mode. This challenge must be performed from the directory where the patch driving force is/changed into unzipped. Also, reply to the adpatch activates. If there are extra drivers to apply (there is no unified power: there will be a database (d), reproduction (c) or generate (g) driver) restart the adpatch and follow the opposite patches.
Review the log documents. By default, the place is $APPL_TOP/admin//log and the file is adpatch.Log.
Review the customizations (if any). If a customization turned into modified by way of this patch, the customization should be applied again.
Question 116. What Is .Lgi File?

Answer :

lgi documents are created with patching in conjunction with .Log files . .Lgi documents are informative log files containing records associated with patch. You can test .Lgi files to see what activities patch has performed.

Question 117. How Will You Skip Worker During Patch?

Answer :

If to your adctrl there are six alternatives shown then 7th is hidden alternative. (If there are seven options visible then eighth option is to Skip employee depending on advert version).

Question 118. Which Two Tables Are Created At Start Of Apps Patch And Drops At End Of Patch?

Answer :

FND_INSTALLED_PROCESS and AD_DEFFERED_JOBS are the tables that get updated at the same time as making use of a patch specially d or unified driver.

Question 119. How To Compile An Oracle Reports File?

Answer :

Utility adrepgen is used to collect Reports. Syntax is given beneath adrepgen userid=apps<psswd> supply = $PRODUCT_TOPsrwfilename.Rdf dest=$PRODUCT_TOPsrwfilename.Rdf stype=rdffile dtype=rdffile logfile=x.Log overwrite=sure batch=yes dunit=individual

Question a hundred and twenty. What Is Difference Between Ad_bugs And Ad_applid_patches?

Answer :

AD_BUGS holds records approximately the various Oracle Applications bugs whose fixes were implemented (i.E. Patched) within the Oracle Applications set up.

AD_APPLIED_PATCHES holds information approximately the "wonderful" Oracle Applications patches that have been implemented. If 2 patches happen to have the identical name however are one-of-a-kind in content material (e.G. "merged" patches), then they may be considered wonderful and this table will therefore hold 2 statistics.

Question 121. How You Will Troubleshoot If Concurrent Request Is Taking Long Time?

Answer :

First you will attempt to test how some distance the query has long gone (if in v$session_longops as an example, or reading a few session information) and if there is competition with some other consultation (which includes a lock as an instance) because it talks approximately a 'concurrent request'.

Method 1: Trace the consultation the usage of dbms_system.Set_sql_trace_in_session (or) if u r using 10g, using dbms_monitor and have a look at the trace record to become aware of wherein the difficulty is. You can get the give an explanation for plan and song the question.

Method 2:

Is this a brand new query (or) an present query
Look for the wait occasion associated to this query.
Based at the sq. Hash value, study the sql_text from v$square
Run an explain plan (or) use oradebug and trace the query if what bind variables are using and how the statistics distribution is.
Based on the above records, search for when data turned into accrued
Once u apprehend where the hassle is, then solutions may be defined starting from developing square profiles / stored outlines (or) including pointers to the question and carefully take a look at your modifications.

Always recollect to make one exchange and check for performance alternate. If you are making a chain of changes, it'll be very tough to isolate which has precipitated the overall performance improvement.

Question 122. What Is Shared Application Tier?

Answer :

Sharing Application Tier (along with APPL_TOP, COMN_TOP, ORA_TOP) across all Middle Tier Nodes in configuration is called as Shared Application Tier.  So I can say shared APPL_TOP is subset of shared Application Tier, to begin with shared APPL_TOP got here out & based on its benefits & reputation later COMMON_TOP & ORA_TOP documents have been additionally blanketed & whole concept is called as Shared Application Tier.

Question 123. Limitation With Shared Appl_top And Application Tier?

Answer :

If you're going for walks Apps on Windows you will be sad to listen that it’s no longer certified with Windows Operation System. More over you can percentage across same operation machine like Linux to Linux & Solaris to Solaris.

Question 124. What Are The Request Incompatibilities? How Conflict Resolution Concurrent Manager Solve Them?

Answer :

Checks if a request in queue may be run in parallel with the jogging request.

Question 125. Where And How You Update Workflow Notification Mailer Configuration Setting?

Answer :

This depends on which workflow mailer you're jogging C Mailer or Java Mailer.

Question 126. If You Want To Change Concurrent Manager Log And Out File Location, Is It Possible, If Yes, How? If No, Why Not?

Answer :

By default widespread vicinity is $APPLCSF/$APPLLOG, in a few instances it is able to visit $FND_TOP/log as nicely.

Question 127. How Frequent You Run Gather Schema Statistics Program & With What Option? Why You Need To Run It? What Is Cost Based Optimizer?

Answer :

In Oracle Database there's something known as Cost Based Optimizer (CBO) which apart from doing many stuff additionally does question optimization. That is it determines the great or premiere technique to run a query. Now when massive modifications to the data or database take region, the device overall performance can also get sluggish. DBMS_STATS is the bundle which collects statistics for Cost Based Optimizer. Collecting Statistics lets the CBO recognize about the exceptional strategies for query optimization. The facts include the Table statistics, Column statistics, Index facts and System statistics. The DBMS_STATS package includes the following methods.

          GATHER_INDEX_STATS, Index facts
          GATHER_TABLE_STATS, Table, column, and index statistics
          GATHER_SCHEMA_STATS,Statistics for all objects in a schema
          GATHER_DICTIONARY_STATS,Statistics for all dictionary items
          GATHER_DATABASE_STATS,Statistics for all objects in a database 
Of all of the above usually the most used is GATHER_SCHEMA_STATS to acquire records of all items inside a particular Schema. The Gather Schema Statistics procedure should be run on a normal foundation (weekly at a minimum) and each time huge modifications to the facts or database take location.

Question 128. If We Run Autoconfig Which Files Will Get Effected?

Answer :

In order to test listing of documents modified during autoconfig , you may run adchkcfg application so that it will generate HTML report. This document will listing all files and profile alternatives going to exchange when you run AutoConfig.

Question 129. What Is Difference Between .Xml File And Autoconfig?

Answer :

Autoconfig is Utility to configure your Oracle Application environment. Xml document is repository of all configuration from which AutoConfig alternatives configuration and populates related files.

Question a hundred thirty. How You Will Avoid Your Query From Using Indexes?

Answer :

By changing the order of the columns that are used in the index, within the Where circumstance, or by way of concatenating the columns with some consistent values.

Question 131. What Is An Outer Join?

Answer :

An OUTER JOIN returns all rows that satisfy the join situation and also returns a few or all of those rows from one desk for which no rows from the alternative fulfill the join circumstance.