Interview Questions.

Question 1. How Is Apps Schema Is Different From Another Schemas ?

Answer :

Apps schema is the only that comprises of best synonyms and there may be no possibility of making tables in it. Other schema contains of tables and items in it and permits the creation of tables as well as for presenting offers to tables.

Question 2. What Is Diagnostics In Oracle Apps?

Answer :

The Oracle Diagnostic Tool is supplied by way of Oracle to accumulate and examine records from eBusiness suite to diagnose an present information problem, transactional problem or setup mistakes via a entire set up obligation “Application Diagnostics”.

PL/SQL Interview Questions
Question three. What Is The Difference Between Fields And Flexfields?

Answer :

A area is a position on a form that one uses to enter, view, update, or delete data. A subject set off describes each field via telling what form of facts seems within the discipline, or instead, what kind of records should be entered inside the subject.

A flexfield is an Oracle Applications field made from segments. Each phase has an assigned call and a fixed of legitimate values. Oracle Applications makes use of flexfields to capture facts about your enterprise. There are  varieties of flexfields: key flexfields and descriptive flexfields.

Question 4. Distinguish Between Key Flexfield And Descriptive Flexfield?

Answer :

Key FlexField is used for growing precise identifiers or constraints. It is the building block which defines the shape of gadgets. Key flexfields are bendy sufficient to let any business enterprise use the code scheme they need, with out programming. With the help of Key Fields an organisation can outline regulations to specify which section values may be combined to make a valid complete code (additionally known as a mixture).

Descriptive FlexField is used to create new fields on screen and seize other data. Also gives customizable “growth space” to your paperwork. Descriptive flexfields may be context sensitive, wherein the statistics your software stores depends on different values that customers enter in other components of the form.

Key flexfields presentations like text item however Descriptive FlexField presentations like arrays. Key flexfields offers the result after easy access of facts and Descriptive FlexField is person dependent whic manner while person need to get output.

OBIEE Tutorial
Question five. Where Does The Concurrent Request Log Files And Output Files Go ? Where Are They Stored In Database?

Answer :

Out positioned file and Log file are bodily stored in server, you could locate the bodily route of log and output document of a concurrent request in FND_CONCURRENT_REQUESTS table.

Column LOGFILE_NAME stores Log document call in conjunction with the bodily  course

Column OUTFILE_NAME sores Out report in conjunction with the physical route

OBIEE Interview Questions
Question 6. Which Api Used To Get The Current Application User Id ?

Answer :

fnd_profile.Fee(‘USER_ID’)

or

fnd_global.USER_ID

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

Answer :

_ALL  Table holds all of the records approximately special operating units in a Multi-Org surroundings. You can also set the client_info to precise running unit to look the records particular to that operating unit handiest.

Oracle apps Interview Questions
Question 8. What Is The Significance Of “priority” Field In Concurrent Program Definition?

Answer :

Oracle definition for Priority:  Priority is used to signify the priority that the concurrent request may be assigned when it's far submitted. If you do not assign a priority, the user’s profile alternative Concurrent:Priority units the request’s precedence at submission.

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

Answer :

Token is used for shifting values in the direction of document builder. Tokens are generally not case – sensitive.

Oracle Apps ERP Interview Questions
Question 10. What Is The Difference Between Fnd_global And Fnd_profile??

Answer :

Though FND_GLOBAL and FND_PROFILE gives us same result however they work in a distinctive style FND_GLOBAL is a server-aspect package deal which returns the values of device globals, which includes the login/signon or “consultation” sort of values. Where as FND_PROFILE  makes use of consumer profile routines to manipulate the option values saved in client and server user profile caches.

From this we can take into account that FND_GLOBAL works on server aspect and FND_PROFILE works on customer aspect.

On the customer, a unmarried user profile cache is shared via a couple of form periods. Thus, when Form A and Form B are each going for walks on a single patron, any adjustments Form A makes to the consumer’s consumer profile cache affect Form B’s run-time environment, and vice versa.

On the server, every form consultation has its own person profile cache. Thus, even supposing Form A and Form B are going for walks on the equal purchaser, they've separate server profile caches. Server profile values changed from Form A’s session do no longer have an effect on Form B’s consultation, and vice versa.

That is the reason in bureaucracy we use FND_GLOBAL.

Question eleven. What Is Job Scheduling And How To Do It?

Answer :

The Scheduler allows database directors to complete fill commercial enterprise responsibilities in an organized and managed fashion.

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

Below are the essential this a Scheduler can do:

Schedule process execution based totally on time or events
Schedule activity processing in a manner that fashions your commercial enterprise requirements
Manage and screen jobs
Execute and control jobs in a clustered surroundings
Oracle ADF Interview Questions
Question 12. What Is Autonomous Transaction?

Answer :

Autonomous Transaction is a kind of transaction that is independent of another transaction. This sort of transaction permits you in suspending the principle transaction and allows in performing SQL operations, rolling again of operations and additionally committing them. The self reliant transactions do not help sources, locks or any type of commit dependencies which can be part of most important transaction.

PL/SQL Interview Questions
Question 13. What Is Application Top ? What Are The Different Types Of Application Tops?

Answer :

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

We have two one-of-a-kind styles of Application Tops

Product Top
Custom Top
Product Top: Product top is the default top constructed with the aid of the manufacturer. This is generally called as APPL_TOP which shops all components supplied via the Oracle.

Custom Top: Custom top can be described as the consumer top that's created completely for customers. According to the requirement of the patron many number of purchaser tops may be made. Custom pinnacle is made used for the purpose of storing additives, which are developed as well as customized. At the time while the oracle enterprise applies patches, every module aside from custom pinnacle are overridden.

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

Answer :

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

You can define a concurrent software to be globally incompatible with another program — that is, the two programs cannot be run simultaneously in any respect; or you may outline a concurrent software to be incompatible with every other program in a Conflict Domain. Conflict domains are abstract representations of corporations of information. They can correspond to other institution identifiers, together with sets of books, or they may be arbitrary.

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

Answer :

FlexRpt: The execution file is wrnitten the use of the FlexReport API.

FlexSql: The execution record is written the usage of the FlexSql API.

Host: The execution file is a bunch script.

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

PL/SQL Stored Procedure: The execution document is a saved technique.

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

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

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

Immediate: The execution record is a program written to run as a subroutine of the concurrent supervisor. We advocate against defining new immediate concurrent applications, and advocate you operate either a PL/SQL Stored Procedure or a Spawned C Program rather.

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

Oracle DBA Troubleshooting Interview Questions
Question sixteen. What Are Different Types Of Value Sets?

Answer :

There are 8 extraordinary styles of Value Set Validations.

None: this is the indication of minimal validation.
Independent: Input have to be there within the listing of – values which are described formerly.
Dependent: According to the previous value, enter is in comparison with a subset of values.
Table: Input is checked on the basis of values that exist within the application table.
Special: These are the values that employ flex discipline.
Pair: A pair may be defined because the set of values that employ flex fields.
Translated Independent: This is a type of cost that may be made used best if there's any life for the enter within the list this is defined previously.
Translatable dependent: In this kind of validation policies that evaluate the input with the subset of values associated with the formerly defined list.
Question 17. Is There A Limit For Number Of Parameters Of A Concurrent Program??

Answer :

one hundred is the limit for the number of parameters for a concurrent software

OBIEE 11g Interview Questions
Question 18. How To Submit A Concurrent Request Directly From The Operating System(unix)?

Answer :

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

Example

sqlplus -s  apps/apps @XX_SUBMIT_CP.Square

OBIEE Interview Questions
Question 19. How To Generate A Trace File For A Pl/square Based Concurrent Program?

Answer :

Step1: Enable Trace on the Report Definition.

Go to System Administrator -> Concurrent Programs -> Define , Query the document and test the ‘Enable hint‘ take a look at field  Navigate to:

Profile->gadget
Query on the Profile Option: “Concurrent: Allow Debugging”
  This should be set to ‘yes’ at ‘Site’ degree.
If it isn’t set, then set it, then logout and soar the APPS offerings.
The ‘Debug Options’ button at the concurrent software will now be enabled. )

Step2: Run the file for Step 1. Above

Step3: Get the request id from beneath question. I.E. Request identification = 11111111

SELECT fcr.Request_id “Request ID”
  –, fcr.Oracle_process_id “Trace ID”
  ,
  p1.Cost’/’
  lower(p2.Costcall                  =’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 will be brought on to enter the request_id;

Step4: trace document directory the usage of an sq. Query

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

Step5: Go to directory in Step 4. Above.

Step6: Find out the hint file using GREP command

eg:- grep ‘11111111’ *.Trc

Step7: Run TKPROF to get a dependent statistics from trace report.

Syntax of the command:

$ tkprof <RAW TRACE> <output> explain=apps_uname/apps_pwd sys=no  sort=prsela,exeela,fchela

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

Answer :

We can discover Custom Application top physical route from Application Developer responsibility:

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

name. The cost within the discipline Basepath, is the OS device variable that shops the actual directory data.

Oracle Apps Functional Interview Questions
Question 21. How To Ensure That Only One Instance Of A Concurrent Program Runs At A Time?

Answer :

‘Run Alone‘ test container need to be enabled in Concurrent program definition to make it run one request at a factor of time.

Question 22. How To “write” To The Concurrent Request Log And Output?

Answer :

Syntax for log:

 FND_FILE.PUT(FND_FILE.LOG, <Text>);        

Syntax for Output:

 FND_FILE.PUT(FND_FILE.OUTPUT, <Text>);

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

Answer :

We can use $FLEX$.<Value set name> within the in which circumstance of the target valueset to restriction LOV values bases on figure price set.

Oracle Apps DBA Interview Questions
Question 24. What Is The Significance Of Us Folder In Application Top?

Answer :

US folder is nothing but a language particular folder. Oracle Apps makes use of american language by way of default and so is america folder.

Oracle apps Interview Questions
Question 25. Can We Give File Extensions In Executable File Name?

Answer :

No! As according to Oracle widespread method, the application will no longer allow file extensions. It may even now not permit any special characters and areas.

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

Answer :

relink the precise module eg :if FNDLOAD is lacking then relink FND module

Oracle Core Dba Interview Questions
Question 27. How Do I Find The Version Of An Installed Product?

Answer :

One of the very best approaches is to run the product if you can. Running Reports designer will come up with the Reports model, going for walks SQL*Plus will give you its version and many others. 

Another smooth way is to launch the Oracle Installer and appearance within the set up merchandise at the right aspect. It will list all the goods set up with their variations. 

Another manner is to look at the .Rgs record. This file is located in $ORACLE_HOME/orainst 

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

This report will list all the goods set up and their versions. Note although that this report is not continually correct. For instance, patching Reports from 2.Five.5.4 to 2.Five.Five.8 will no longer display up on this document as the new version. Running Reports Designer is the high-quality way of having an appropriate version. 

Also, on UNIX there may be an executable called 'inspdver'. It is placed in $ORACLE_HOME/orainst. 

Running it's going to produce a display of all of the installed products. It simply pulls the records from unix.Rgs, so it may show the incorrect statistics as properly.

Oracle Apps ERP Interview Questions
Question 28. How Do I Open A Form In Query-handiest Mode?

Answer :

visit applcation developer responsibilitynavigation->Application/function.Query the characteristic name then goto shape tab then goto parameters area then write the following code in that fieldQUERY_YES= YES shop the changes and then see the bureaucracy get affected in question best mode.

Question 29. Why Does Help->tools->take a look at Ask For A Password?

Answer :

Navigate to the Update System Profile Screen. 

( navigate profile system)

Select Level: Site 
Query up Utilities:Diagnostics inside the User Profile Options Zone. 
If the profile alternative Utilities:Diagnostics is about to NO, human beings with access to the Utilities Menu have to enter the password for the ORACLE ID of the cutting-edge duty to use Examine. If set to Yes, a password will no longer be required.

Question 30. How Do I Cancel A Running Concurrent Request?

Answer :

Navigate to the Concurrent Request Summary shape 

Select a request 
In character, do a Quickpick on the Status column 
You can choose Cancel or Hold 
In GUI, use the Cancel or Hold buttons 
The Sysadmin responsibility can cancel or maintain any jogging request
Question 31. How Do I Submit A Concurrent Request From Pl/square?

Answer :

FND_REQUEST.SUBMIT_REQUEST ( ' Parameters');

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

Answer :

It may be generated thru submission of Concurrent Program from Application Developer duty.

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

Answer :

Use: oerr ora XXXX 

or: oerr tns XXXX 

where XXXX is the error range 

(This also helps a number of other errors sorts. Use the three-letter errors prefix in area of 'ora')

Oracle ADF Interview Questions
Question 34. How Do I Find The Name Of A Form?

Answer :

GUI: Use Help->About Oracle Applications 

Scroll down to discover the form name 

Character: Use Help->Version

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

Answer :

We also can discover through Help > About Oracle Applications
SELECT release_name FROM fnd_product_groups
Question 36. How Do I Check If Multi-org Is Installed?

Answer :

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 set to 'N' Then its unmarried Org.

Oracle DBA Troubleshooting Interview Questions
Question 37. What Are The Logfile And Output File Naming Conventions?

Answer :

Log file get following name by using default: lRequest_id.Req

and Output report get following name by using default :

oRequest_id.Out
Output files are stored at $APPLCSF/$APPLOUT
and Log documents are saved at $APPLCSF/log

These paths might also range depending at the setups that sys admins perform at the time of Oracle Apps set up

Question 38. Where Do Concurrent Request Log Files And Output Files Go?

Answer :

The concurrent manager first appears for the surroundings variable $APPLCSF 

If that is set, it creates a path the usage of two different surroundings variables: 

$APPLLOG and $APPLOUT 

It places log files in $APPLCSF/$APPLLOG 

Output files go in $APPLCSF/$APPLOUT 

So for instance, if you have this environment set: 

$APPLCSF = /u01/appl/not unusual 
$APPLLOG = log 
$APPLOUT = out 

The concurrent manager will area log files in /u01/appl/not unusual/log, and output files in /u01/appl/not unusual/out 

Note that $APPLCSF have to be a full, absolute direction, and the opposite two are  directory names. 

If $APPLCSF isn't always set, it locations the files below the product top of the application associated with the request. So for example, a PO document could cross beneath $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT 

Logfiles go to: /u01/appl/po/9.0/log 
Output documents to: /u01/appl/po/nine.0/out 

Of course, these kind of directories need to exist and have an appropriate permissions. 

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

Answer :

We can also get better via the subsequent steps:

Go to gadget administrator responsibility > Security > Responsibility > Define > Give the particular responsibility call question on it after which see the effective dates to area. If any date is there then that repsonsibility will expire on that date and if it's miles null then it will no longer expire on any date.

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

Answer :

You can do this with Custom.Pll and if ur the use of apps version greater that eleven.Five.9 then you can do that with form personlization too

OBIEE 11g Interview Questions
Question forty one. Where Would I Find The .Rf9 Files What Actualy It Dose?

Answer :

rf9 documents are created even as making use of patches generally in $APPL_TOP/admin/SID/restart listing

Question forty two. 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?

Answer :

Use adctrl utility to screen and restart adworkers after solving your locking trouble. Check advert workers log record that display you which of them desk has problem and blunders message.

Oracle Apps Functional Interview Questions
Question 43. 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?

Answer :

Give it a few more time. Did you make certain which you had run right now checked when you submitted the record/request? If it became accidentally scheduled for a later date/time the best aspect you can do is to submit it once more with accurate parameters.

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

Answer :

FTP the Custom.Pll from $AU_TOP/useful resource 
Open the Custom.Pll in Forms6i 
Include the following code to your Form common sense :

start
Form_Name varchar2(50) : name_in('gadget.Current_form');
If Form_Name 'YOUR CUSTOM FORM then
begin
include your good judgment
quit;
cease;

Once adjustments over using the subsequent 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/aid
Question 45. How Can I Implement And Manage The Custom Schema?

Answer :

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

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

Answer :

$Flex$ is used when we need to go back the Flex price contained through any AOL Vlauset or AOL item . 

For Ex . $Flex$. Could return the cost held by using that valueset.

$profiles$. Are used to get the values of surroundings variables like org_id or mfg_Organization_id and many others which are associated with the modern-day apps surroundings.

Ex. $profiles$.Org_id might return the working unit that is active at that time for the user.

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

Answer :

Quick Code or Lookup Code are brief names given to some discipline values. An example is  letter codes given to Country names.

Question forty eight. What Is The Difference Between Organization Id And Master Organization Id?

Answer :

In easy wordsOrg_id referes the running unit and and corporation identification refers the InventoryOrganizationRegardsKarthikeyan

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

Answer :

This comes into image while security rule comes into picture.

For example Say Maintanance is the one of the accounts in that we've cleansing painting expenses whilst we aren't accesssible to most important a/c (i.E maintanance) we can't use sub a/c i.E cleaning and portray while you choose Hierarchicalsecurity while it's miles non-Hierarchical we will use sub a/c i.E painting cleaning and so on... 

Question 50. How Do I Submit A Series Of Requests From Pl/square?

Answer :

May be your query about collection of requests is from PL/SQL. For this it isn't feasible to publish series of requests at a time their is simplest one option to post request from backend is fnd_request.Sumbint_request(Paramenters)