Interview Questions.

Q1. How Is Apps Schema Is Different From Another Schemas ?

Apps schema is the only that accommodates of best synonyms and there may be no possibility of creating tables in it. Other schema accommodates of tables and objects in it and allows the advent of tables as well as for offering offers to tables.

Q2. What Is Application Top ? What Are The Different Types Of Application Tops?

Application Top is a bodily folder on server which holds all of the executable, UI and assist files.

We have  one of a kind kinds of Application Tops

Product Top

Custom Top

Product Top: Product top is the default top constructed by way of the manufacturer. This is usually referred to as as APPL_TOP which shops all additives furnished by using the Oracle.

Custom Top: Custom pinnacle can be defined as the customer pinnacle that's created completely for clients. According to the requirement of the patron many quantity of customer tops may be made. Custom pinnacle is made used for the reason of storing additives, that are developed in addition to custom designed. At the time when the oracle company applies patches, every module other than custom pinnacle are overridden.

Q3. What So You Mean By Hierarchical And Non Hierarchical Security Type In Value Set?

This comes into photograph when safety rule comes into picture.

For instance Say Maintanance is the one of the money owed in that we have cleaning portray fees while we are not accesssible to predominant a/c (i.E maintanance) we cannot use sub a/c i.E cleaning and portray while you select Hierarchicalsecurity whilst it's miles non-Hierarchical we are able to use sub a/c i.E painting cleansing and so on... 

Q4. What Is The Significance Of _all Suffix In Oracle Tables?

_ALL  Table holds all of the data about extraordinary running gadgets in a Multi-Org surroundings. You can also set the client_info to unique operating unit to see the records precise to that working unit most effective.

Q5. Where Does The Concurrent Request Log Files And Output Files Go ? Where Are They Stored In Database?

Out put document and Log document are physically stored in server, you may discover the bodily direction of log and output record of a concurrent request in FND_CONCURRENT_REQUESTS desk.

Column LOGFILE_NAME shops Log document name together with the bodily  path

Column OUTFILE_NAME sores Out document together with the physical route

Q6. What Is The Difference Between Organization Id And Master Organization Id?

In easy wordsOrg_id referes the operating unit and and agency id refers the InventoryOrganizationRegardsKarthikeyan

Q7. How Do I Submit A Concurrent Request From Pl/sq.?

FND_REQUEST.SUBMIT_REQUEST ( ' Parameters');

Q8. How Do You Create A Table Validated Value Set Dependent On Another Value Set?

We can use $FLEX$.<Value set name> within the wherein condition of the goal valueset to restrict LOV values bases on determine fee set.

Q9. How To Generate A Trace File For A Pl/square Based Concurrent Program?

Step1: Enable Trace at the Report Definition.

Go to System Administrator -> Concurrent Programs -> Define , Query the document and check the ‘Enable trace‘ take a look at box  Navigate to:

Profile->system

Query at the Profile Option: “Concurrent: Allow Debugging”

  This have to be set to ‘sure’ at ‘Site’ level.

If it isn’t set, then set it, then logout and jump the APPS offerings.

The ‘Debug Options’ button at the concurrent application will now be enabled. )

Step2: Run the file for Step @above

Step3: Get the request identification from under question. I.E. Request identity = 11111111

SELECT fcr.Request_id “Request ID”

  –, fcr.Oracle_process_id “Trace ID”

  ,

  p1.Valuedecrease(p2.Pricename                  =’user_dump_dest’

AND p2.Name                    =’db_name’

AND fcr.Concurrent_program_id  = fcp.Concurrent_program_id

AND fcr.Program_application_id = fcp.Application_id

AND fcp.Application_id         = fe.Application_id

AND fcp.Executable_id          =fe.Executable_id

AND ((fcr.Request_id           =

  &request_id

OR fcr.Actual_completion_date > TRUNC(sysdate)))

ORDER BY DECODE(fcr.Request_id,

  &request_id, 1, 2),

  fcr.Actual_completion_date DESC;

–you may be triggered to enter the request_id;

Step4: hint record listing the use of an sq. Question

SELECT fee FROM v$parameter WHERE name = ‘user_dump_dest’;

Step5: Go to directory in Step @above.

Step6: Find out the hint file the usage of GREP command

eg:- grep ‘11111111’ *.Trc

Step7: Run TKPROF to get a established data from hint document.

Syntax of the command:

$ tkprof <RAW TRACE> <output> provide an explanation for=apps_uname/apps_pwd sys=no  sort=prsela,exeela,fchela

Q10. How To Submit A Concurrent Request Directly From The Operating System(unix)?

Write a PL/SQL script to submit concurrent request using FND_REQUEST.Submit() API in a file and execute that document in shell script the use of SQLPLUS

Example

sqlplus -s  apps/apps @XX_SUBMIT_CP.Sq.

Q11. How Do I Find The Name Of A Form?

GUI: Use Help->About Oracle Applications 

Scroll all the way down to find the form name 

Character: Use Help->Version

Q12. What Is '$flex$ And '$profile$, What Is The Use Of '$flex$'?

$Flex$ is used while we want to go back the Flex value contained with the aid of any AOL Vlauset or AOL object . 

For Ex . $Flex$. Might go back the cost held with the aid of that valueset.

$profiles$. Are used to get the values of surroundings variables like org_id or mfg_Organization_id and so forth which can be associated with the cutting-edge apps environment.

Ex. $profiles$.Org_id might return the operating unit that is active at that time for the person.

Q13. Is There A Limit For Number Of Parameters Of A Concurrent Program??

A hundred is the restriction for the quantity of parameters for a concurrent program

Q14. How Do I Submit A Series Of Requests From Pl/sq.?

May be your question about collection of requests is from PL/SQL. For this it isn't viable to put up series of requests at a time their is only one choice to publish request from backend is fnd_request.Sumbint_request(Paramenters)

Q15. How To Find Out Base Path Of A Custom Application Top Only From Front End ?

We can discover Custom Application pinnacle bodily direction from Application Developer responsibility:

navigate to Application Developer  –> Application –> Register. Query for the custom utility 

call. The cost in the subject Basepath, is the OS system variable that stores the actual listing information.

Q16. I Have Run A Request But It Is Not Completed. His Status Is (jogging Normal) And Those Requests Are Giving After This He Will Be Completed. So, Now What Steps I Have To Follow For The Running Request?

Give it a few more time. Did you make sure that you had run without delay checked whilst you submitted the file/request? If it become by accident scheduled for a later date/time the fine thing you could do is to put up it again with accurate parameters.

Q17. How Can I Change In Custom.Pll? After Changes How Can I Send On The Server And What's Effect In This Condition?

FTP the Custom.Pll from $AU_TOP/aid 

Open the Custom.Pll in Forms6i 

Include the subsequent code on your Form good judgment :

begin

Form_Name varchar2(50) : name_in('machine.Current_form');

If Form_Name 'YOUR CUSTOM FORM then

start

include your good judgment

cease;

give up;

Once changes over the usage of the following command to generate the CUSTOM.Plx f60gen module CUSTOM.Pll userid apps/apps@mfgdev module_type LIBRARY to generate the today's CUSTOM.Plx and move this CUSTOM.Plx to $AU_TOP/resource

Q18. What Is The Purpose Of Token In Concurrent Program Definition Form?

Token is used for trferring values closer to file builder. Tokens are typically not case – touchy.

Q19. How Do I Check If Multi-org Is Installed?

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS

If MULTI_ORG_FLAG is set to 'Y' Then its Multi Org.

If MULTI_ORG_FLAG is about to 'N' Then its unmarried Org.

Q20. What Are Different Types Of Value Sets?

There are eight special kinds of Value Set Validations.

None: that is the indication of minimum validation.

Independent: Input must be there in the list of – values which might be described previously.

Dependent: According to the previous value, input is in comparison with a subset of values.

Table: Input is checked on the premise of values that exist in the software desk.

Special: These are the values that employ flex subject.

Pair: A pair can be defined because the set of values that make use of flex fields.

Trlated Independent: This is a kind of cost that may be made used best if there's any existence for the input within the list that is described formerly.

Trlatable dependent: In this sort of validation regulations that evaluate the input with the subset of values related to the formerly described listing.

Q21. What Are The Different Types Of Incompatibilities In Concurrent Program Window?

There are  styles of application incompatibilities, “Global” incompatibilities, and “Domain-precise” incompatibilities.

You can outline a concurrent program to be globally incompatible with every other application — that is, the two packages can't be run concurrently at all; or you can define a concurrent software to be incompatible with another software in a Conflict Domain. Conflict domain names are summary representations of businesses of facts. They can correspond to different institution identifiers, which includes units of books, or they may be arbitrary.

Q22. I Have Applied A Patch. At The Time Of Applying He Update A Table And Suddenly He Gives The Error That Table Is Lock. Now What I Do?

Use adctrl software to reveal and restart adworkers after fixing your locking trouble. Take a look at advert workers log file that show you which of them table has problem and mistakes message.

Q23. Where Would I Find The .Rf9 Files What Actualy It Dose?

Rf9 files are created even as making use of patches generally in $APPL_TOP/admin/SID/restart directory

Q24. How Do I Find Out What The Currently Installed Release Of Applications Is?

We also can discover through Help > About Oracle Applications

SELECT release_name FROM fnd_product_groups

Q25. What Should I Do If I Am Missing An Executable From My Appl_top?

Relink the unique module eg :if FNDLOAD is lacking then relink FND module

Q26. What Is The Significance Of Us Folder In Application Top?

US folder is not anything but a language specific folder. Oracle Apps uses american language by way of default and so is america folder.

Q27. What Is Job Scheduling And How To Do It?

The Scheduler allows database administrators to complete fill enterprise responsibilities in an organized and controlled fashion.

To gain process scheduling Oracle offers a collection of features and methods in the DBMS_SCHEDULER package deal.

Below are the fundamental this a Scheduler can do:

Schedule task execution primarily based on time or occasions

Schedule job processing in a way that models your enterprise requirements

Manage and screen jobs

Execute and manage jobs in a clustered environment

Q28. What Is The Difference Between Fields And Flexfields?

A field is a role on a shape that one makes use of to go into, view, replace, or delete data. A field prompt describes every field by way of telling what form of information seems in the subject, or alternatively, what form of statistics have to be entered in the subject.

A flexfield is an Oracle Applications field made of segments. Each phase has an assigned name and a set of legitimate values. Oracle Applications uses flexfields to seize records about your employer. There are two types of flexfields: key flexfields and descriptive flexfields.

Q29. How Do I Recover The Responsibility In Apps If It Is Disabled?

We can also get better thru the subsequent steps:

Go to gadget administrator duty > Security > Responsibility > Define > Give the unique obligation call question on it and then see the powerful dates to area. If any date is there then that repsonsibility will expire on that date and if it's far null then it'll no longer expire on any date.

Q30. What Are The Logfile And Output File Naming Conventions?

Log report get following name through default: lRequest_id.Req

and Output record get following name by way of default :

oRequest_id.Out

Output documents are saved at $APPLCSF/$APPLOUT

and Log documents are stored at $APPLCSF/log

These paths can also vary depending on the setups that sys admins perform on the time of Oracle Apps set up

Q31. How Do I Open A Form In Query-handiest Mode?

Go to applcation developer responsibilitynavigation->Application/characteristic.Query the feature name then goto form tab then goto parameters field then write the subsequent code in that fieldQUERY_YES= YES save the modifications after which see the bureaucracy get affected in question best mode.

Q32. How Do I Generate A Message File (usaeng.Msb)?

It can be generated through submission of Concurrent Program from Application Developer duty.

Q33. Distinguish Between Key Flexfield And Descriptive Flexfield?

Key FlexField is used for developing unique identifiers or constraints. It is the constructing block which defines the shape of items. Key flexfields are bendy sufficient to allow any business enterprise use the code scheme they want, without programming. With the assist of Key Fields an organisation can define rules to specify which segment values may be combined to make a valid complete code (also called a mixture).

Descriptive FlexField is used to create new fields on screen and seize other statistics. Also affords customizable “expion area” in your bureaucracy. Descriptive flexfields may be context sensitive, in which the records your software shops depends on different values that customers input in different elements of the shape.

Key flexfields presentations like textual content item but Descriptive FlexField displays like arrays. Key flexfields offers the result after easy access of information and Descriptive FlexField is consumer dependent whic me whilst consumer want to get output.

Q34. What Is The Difference Between Fnd_global And Fnd_profile??

Though FND_GLOBAL and FND_PROFILE offers us identical result however they paintings in a one-of-a-kind style FND_GLOBAL is a server-facet package which returns the values of system globals, such as the login/signon or “session” type of values. Where as FND_PROFILE  uses person profile workouts to govern the option values stored in patron and server person profile caches.

From this we are able to remember the fact that FND_GLOBAL works on server aspect and FND_PROFILE works on customer facet.

On the consumer, a unmarried consumer profile cache is shared via more than one shape classes. Thus, whilst Form A and Form B are each walking on a unmarried purchaser, any changes Form A makes to the customer’s consumer profile cache have an effect on Form B’s run-time environment, and vice versa.

On the server, every form consultation has its very own user profile cache. Thus, although Form A and Form B are running on the identical customer, they have separate server profile caches. Server profile values changed from Form A’s consultation do now not have an effect on Form B’s session, and vice versa.

That is the purpose in bureaucracy we use FND_GLOBAL.

Q35. What Is Autonomous Traction?

Autonomous Traction is a kind of traction that is impartial of some other traction. This type of traction allows you in postponing the primary traction and helps in acting SQL operations, rolling lower back of operations and additionally committing them. The self reliant tractions do not support resources, locks or any type of commit dependencies which are part of predominant traction.

Q36. How To Ensure That Only One Instance Of A Concurrent Program Runs At A Time?

‘Run Alone‘ check box should be enabled in Concurrent software definition to make it run one request at a factor of time.

Q37. How Do I Lookup Ora Errors? (and Tns Errors)

Use: oerr ora XXXX 

or: oerr tns XXXX 

wherein XXXX is the mistake range 

(This additionally helps some of other blunders types. Use the 3-letter mistakes prefix in place of 'ora')

Q38. How Do I Cancel A Running Concurrent Request?

Navigate to the Concurrent Request Summary shape 

Select a request 

In character, do a Quickpick at the Status column 

You can pick Cancel or Hold 

In GUI, use the Cancel or Hold buttons 

The Sysadmin duty can cancel or maintain any walking request

Q39. Where Do Concurrent Request Log Files And Output Files Go?

The concurrent manager first appears for the environment variable $APPLCSF 

If this is set, it creates a route the use of  different environment variables: 

$APPLLOG and $APPLOUT 

It places log files in $APPLCSF/$APPLLOG 

Output files pass in $APPLCSF/$APPLOUT 

So as an instance, when you have this environment set: 

$APPLCSF = /u01/appl/common 

$APPLLOG = log 

$APPLOUT = out 

The concurrent manager will location log documents in /u01/appl/commonplace/log, and output files in /u01/appl/common/out 

Note that $APPLCSF need to be a full, absolute direction, and the alternative  are  directory names. 

If $APPLCSF isn't set, it places the files below the product pinnacle of the software related to the request. So as an instance, a PO file would move underneath $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT 

Logfiles visit: /u01/appl/po/nine.0/log 

Output files to: /u01/appl/po/nine.Zero/out 

Of path, a majority of these directories should exist and feature the perfect permissions. 

Q40. How Can I Disabled And Enabled The Standard Button's In Apps Window?

You can do that with Custom.Pll and if ur the usage of apps version greater that 11.5.Nine then you may do that with form personlization too

Q41. What Are The 10 Different Types Of Executables In Oracle Apps?

FlexRpt: The execution file is wrnitten using the FlexReport API.

FlexSql: The execution document is written using the FlexSql API.

Host: The execution record is a number script.

Oracle Reports: The execution file is an Oracle Reports record.

PL/SQL Stored Procedure: The execution file is a saved process.

SQL*Loader: The execution report is a SQL script.

SQL*Plus: The execution report is a SQL*Plus script.

Spawned; The execution report is a C or Pro*C program.

Immediate: The execution document is a application written to run as a subroutine of the concurrent manager. We propose in opposition to defining new immediately concurrent applications, and recommend you use both a PL/SQL Stored Procedure or a Spawned C Program as an alternative.

Request Set Stage Function: PL/SQL Stored Function that can be u.S. To calculate the crowning glory statuses of request set ranges.

Q42. How Can I Implement And Manage The Custom Schema?

Basically a schema is series of items(tables perspectives indexes sequences) belonging to specific person right here in case of Oracle apps every module is applied as a consumer for instance Order Management is carried out as a user ONT with the intention to create a custom schema we need to create a user and sign up the consumer with AOL.Check this link for little by little method to create a custom module(Application) and register with oracle AOL.

Q43. Can We Give File Extensions In Executable File Name?

No! As according to Oracle widespread system, the software will not permit record extensions. It may also not permit any unique characters and areas.

Q44. How Do I Find The Version Of An Installed Product?

One of the easiest methods is to run the product if you could. Running Reports dressmaker will come up with the Reports version, walking SQL*Plus will come up with its version and so on. 

Another easy way is to launch the Oracle Installer and appearance inside the mounted products at the proper facet. It will list all the goods set up with their variations. 

Another way is to have a look at the .Rgs record. This file is positioned in $ORACLE_HOME/orainst 

On UNIX, it'll be called unix.Rgs. On the PC, it is going to be known as Windows.Rgs. 

This file will listing all the goods mounted and their versions. Note though that this document is not continually correct. For example, patching Reports from 2.5.Five.Four to 2.Five.Five.8 will not show up on this file as the new version. Running Reports Designer is the quality way of having the appropriate version. 

Also, on UNIX there may be an executable known as 'inspdver'. It is positioned in $ORACLE_HOME/orainst. 

Running it'll produce a display of all the set up products. It just pulls the data from unix.Rgs, so it could show the incorrect records as nicely.

Q45. What Is Quick Code? Why Is It Called A Quick Code?What Is Steps Of Defining A Quick Code?

Quick Code or Lookup Code are quick names given to some area values. An instance is  letter codes given to Country names.

Q46. Why Does Help->gear->study Ask For A Password?

Navigate to the Update System Profile Screen. 

( navigate profile device)

Select Level: Site 

Query up Utilities:Diagnostics in the User Profile Options Zone. 

If the profile choice Utilities:Diagnostics is about to NO, people with get admission to to the Utilities Menu have to input the password for the ORACLE ID of the present day obligation to apply Examine. If set to Yes, a password will no longer be required.

Q47. Which Api Used To Get The Current Application User Id ?

Fnd_profile.Fee(‘USER_ID’)

or

fnd_global.USER_ID

Q48. What Is Diagnostics In Oracle Apps?

The Oracle Diagnostic Tool is supplied by way of Oracle to accumulate and analyze records from eBusiness suite to diagnose an existing data problem, tractional trouble or setup error via a whole set up obligation “Application Diagnostics”.