Oracle Apps 11i Technical Interview Question and Answers

1)   How to know if a specific patch is installed or not?
    SELECT * FROM AD_BUGS WHERE BUG_NUMBER=x;
Here substitute x with patch number, and if the query returns a value means the patch is already applied.

2)   What is US directory in $AD_TOP or under various product TOP’s. US directory is defauly language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for Arabic, simplifies Chinese or Spanish.

3)   What are main concurrent Manager Types?
ICM - Internal Concurrent Manager which manages concurrent Managers
Standard Managers - Which Manage processesing of requests.
CRM - Conflict Resolution Managers , resolve conflicts in case of incompatibility.

4)   What is difference between ICM, Standard Managers & CRM in Concurrent Manager?
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.
CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.

5)   Where is Concurrent Manager log file location.
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well

6)   What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database; Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System.
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.
CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.

7)   Where is Concurrent Manager log file location.
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well

8)   What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database; Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System.

9)   What is .dbc file, where its stored, what use of .dbc file?
dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE

10)  How to determine Oracle Apps 11i Version?
Select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
———————–
11.5.9 or 11.5.10.2

11)  Whats is TWO_TASK in Oracle Database?
TWO_TASK mocks your tns alias which you are going to use to connect to database. Lets assume you have database client with tns alias defined as PROD to connect to Database PROD on machine teachmeoracle.com listening on port 1521. Then usual way to connect is sqlplus username/passwd@PROD ; now if you don’t want to use @PROD then you set TWO_TASK=PROD and then can simply use sqlplus username/passwd then sql will check that it has to connect to tnsalias define by value PROD i.e. TWO_TASK


12)  What is GWYUID?
GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB
Where GWYUID defined & what is its used in Oracle Applications?
GWYUID is defined in dbc i.e. Database Connect Descriptor file. It is used to connect to database by think clients

13)  How to check number of forms users at any time?
Forms Connections initiate f60webmx connections so you can use
ps -ef grep f60webmx wc –l

14)  What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD?
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.
‘Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

15)  If your system has more than one Jinitiator, how will the system know, which one to pick. ?
When client makes a forms connection in Oracle Applications, forms client session uses configuration file defined by environment variable FORMS60_WEB_CONFIG_FILE also called as appsweb config file. These days this file is of format appsweb_$CONTEXT.cfg The initiator version number defined by parameter jinit_ver_name in this file will be used.

16)  What are .ldt & .lct files which you see in apps patch or with FNDLOAD?
ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

17)  What is dev60cgi & ifcgi60?
cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access forms server . Usually Form Server access directly viahttp://hostname:port/dev60cgi/ifcgi60

18)  What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms?
Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file. This confuses version control and build tools (CVS, Subversion, make, scons); they believe you’ve made significant changes to the source. COMPILE_ALL=SPECIAL does not do this.

19)  What is ps -ef or ps command in Unix ?
ps is unix/linux utility or executable to find status of process. Used mainly to find if services/process is running or not.





WHAT VERSION OF TOAD SHOULD WE USE?


We don’t get this particular question per se as often as one would expect, but we do see enough user problems where this fundamental issue becomes the underlying question to answer for problem resolution. Below is a chart for the release dates for both Toad and Oracle. The “blue highlighted” dates are when Oracle first releases a major new version, such as Oracle 10g in January of 2004. But it’s the “red highlighted” dates that are more significant – as these are what Oracle calls the “terminal release” for a database version, such as 10.2.0.4. That’s the version Oracle treats as the mainstream one that it expects its users to standardize upon – especially for support purposes. In fact an Oracle tech support call where you’re not on the terminal release probably has an above average likelihood of ending with the advice to upgrade to see if that fixes it. Thus look again below, there are four key Oracle versions of which one should be the version that your database server is on. Also note that both Oracle 8i and 9i are essentially unsupported products at this time for most people (unless you have a specific and special extended support agreement with Oracle – and these are neither cheap nor common, so don’t just say yeah we have that).

So what version of Toad should you be using? That’s easy – one that came out around the time (and preferably after) your database terminal release version. So that’s why I’ve highlighted four Toad versions in red boxes below. If you’re trying to use Toad 7.6 with and Oracle 9i, 10g or 11g database – then you’re just asking for problems. Stay current on your maintenance and Toad upgrades are free. Don’t live dangerously – Toad 9.6 or 9.7 should be your standard for most cases these days. Happy Toad’ing to you all …..








For more Details Please visit http://www.orafaq.com/wiki/TOAD_Product_Review



How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...