Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Saturday, 1 July 2017

Oracle Application Interview questions and Answers

       The following Oracle Apps Interview questions and Answers created based on my person experience, I hope it will use for you while you are facing Oracle apps interview, These are very frequently asking question and answers (FAQS) in oracle apps interview.

Oracle Application Interview questions and Answers

1) What is the Diff between APPS Schema and other Schema?

Apps schema contains only Synonyms we can't create tables in apps schema, where as other schema contains tables, & all the objects. Here only we will create the tables and giving grants on created tables. Almost all every time we will connect to apps schema only. 

2) What is meant by Custom Top and what is the Purpose?

 Custom Top is nothing but Customer Top, which is created for customer only.
 We can have multiple custom tops based on client requirement. It is used to store developed & customized components. Whenever oracle corp appling patches it will over ride on all the modules except custom top. that's why we will use custom top.

3) What is the Significance of US Folder?

It is nothing but language specification by default it is in American language.
We can have multiple languages folders based on installed languages. From backend we can get it from   FND_LANGUAGES -- COL --INSTALLED_FLAG I,B,D

            select language_code,nls_language from fnd_languages
            where installed_flag like 'B'

4) Where did you find the Application short name and basepath names?

select basepath, application_short_name from fnd_application from the backend.
     From the front end we can get it Navigation
Application Developer.-----> Application---->Register
     The application name we will get from FND_APPLICATION_TL                                                                         
5) Where can you find the release version from backend?

SELECT release_name from FND_PRODUCT_GROUPS;

6) What are the Folders we will find below the 12.2.0 Folder?

  Reports,forms,sql,lib,log,out,bin,admin,html,xml,msg,def, etc

7) Can we create Tables in the Apps Schema?

8) Can we have custom schema when it required? 

      yes, we can have custom schema, when we want to create a new table we required custom schema.

9) What is meant by concurrent Program?

 It is nothing but Instance of the execution along with parameters & Incompatibles.
     Here Incompatibles nothing but if we r submitting cc programs if anyone can be execute in those program, which programs are  not imp yet this time we will mention those programs in incompatibles tab.

10) What are the steps we will follow to register Reports as Concurrent Program?

  First develop the report & save it in local machine.
  Upload into custom_top/12.2.0/reports/us/
  Go to system administrator open executable form
  Create executable by mentioning executable method as reports, executable as report name which was created.
  Go to concurrent program form create concurrent program by attach executable name in executable section.
     Then attach this concurrent program to request group,
     Request group attached to Responsibility.
     Responsibility attached to User.

11) What is meant by Request group?

  It is nothing but collection of concurrent programs.

12) Flex Fields Reports development?

P_FLEXDATA: It is one of the lexical parameter having the default value it is a contribution of all the segment columns,
We will use this lexical parameter in the select statement to retrieve the data from database

P_STRUCT_NUM:  This is a bind variable will be used to capture KFF structure number

FND FLEX SQL:  It is one of the User Exit we will define in the before report trigger to retrieve KFF segments data

FND FLEXIDVAL:  This is another user exit will called from formula column to display the KFF data in the output

1) Call the user ext from before report trigger
          SRW.USER_EXIT (      'FND SRWINIT');
2) Call another User Exit from After Report Trigger
             SRW.USER_EXIT ('FND SRWEXIT');
3) Define the following parameters               

13) Types of User Exits?


14) How to Print request ID in the Output?

 By using to P_CONC_REQUEST_ID parameter in the report, & take one object field in the layout by specifying source for that object type is :P_conc_request_id.

15) What is meant by responsibility?

Responsibility nothing but the collection of Data Group, Request Group and Menu.

16) What are the things are mandatory at the time of creating Responsibility?

Application Name, Responsibility Key, Effective Dates, Data Group and Menu.

17) Can we delete Responsibility?

No we cannot delete Responsibility but we can disable it by using effective dates.

18) What is Errbuf and RetCode?

 This are to mandatory OUT parameters whenever you are going executable method as PL/Sql procedure
         Errbuf --- is to display the phase
         Retcode--- is to display the status of the program in the SRS window.

19) How to Write the messages into the Output file from PL/SQl Procedure?

                       FND_FILE.PUT_LINE(FND_FILE.LOG, 'MESSAGE') for logfile

20) What is Control file? Syntax?

 It is a Sql * loader program file to transfer the data from flatfile to stage tables.

21) What is the Diff between Discard file and Bad File?

It contains the rejected records which are rejected by SQL*Loader, because of bad format or data type mismatch and so on.  The extension of the bad file .bad.
        Discard:  It contains the rejected records which are rejected by control file
       if we have specified any condition in the control file if record is not satisfying the condition the complete record will be inserted in the discard file.  The extension of file is .dis.

22) How to issue the Commit in Control File?

 Along with the SQLLDR command we can also use the few commands like as bellow
LOAD – Will be used to load the first ‘N’ records
                   SQLLDER username/password@Hoststring Load=10
SKIP – TO skip the first ‘n’ records
                   SQLLDER username/password@Hoststring skip=10
ROWS – It will be used to issue the commit after insert ’N’records for every 10 records internally auto commit will happen
                   SQLLDER username/password@Hoststring rows=10
INIT.ORA file contains the default values for the commit point

23) How to insert data into multiple tables at a time?

 By using WHEN command in ctl file

24) How to pass parameter to the Control file?

like &1, &2 These are should be in sequential order we cannot skip the sequence.

25) What is Value sets? Types of Value sets?

It is a Validation Values we will use these to restrict user to enter correct data into the fields

26) How to register program from Backend?

 By using fnd_program.request API

27) How to submit Concurrent Program from Backend?

By using  fnd_request.submit_request API

28) Do we need to issue the Commit statement after calling concurrent program?

No, the apps Environment session is auto commit.

29) What are the types of PO's we have?

   We have Standard, Blanket, Planed, Contract Types.

30) What are the Match Approvals we have?

   We have 2way, 3way, 4 way match approvals.

31) Where the item Name will be stored?


32) What are the levels we have in Purchase Orders form?

 Header, Line, Shipment, Distribution

33) Where the BLANKET PO Data will be stored?

PO_headers_all in this we can retrieve the BLANKET PO data by specifying Type_lookup_code='BLANKET'

34) How to find the receipt no if we give PO number?

We have a link between these two  i.e  po_distribution_id,po_header_id in the Rcv_shipment_lines table

35) What are the receipt tables? And as well as receipt types?

        We have 3 Receipt types.  Direct Delivery, Standard Receipt, Inspection Required.

36) IN the Same table RFQ,QUOTATION,PO data will be stored then how to identify the Information whether it is RFQ data or Quotation data or PO data?

The Difference we can see in the Type_lookup_code column.

37) What is the flow of Oracle Purchasing Application?

    Requisition-->RFQ--->Quotations--->Qoute Analysis--->PO---> Receipts

38) Is Item filed is mandatory in Purchase Order form?

It is not a Yellow field so it is not mandatory, but for which Item we are creating this PO we need to mention. For that purpose that is mandatory.

39) Where Shipto and Billto Data will be stored?

 In the RA_Customer_trx_all

40) While Creation of Executable we are giving the Application Name and also at the time of creating the Concurrent Program we are giving Application Name what is the Diff between these two?

While Creation of Executable means In which TOP our developed object is reseading.

Share this article :


  1. Hello Dayakar,

    Hip Hip Hooray! I was always told that slightly slow in the head, a slow learner. Not anymore! It’s like you have my back. I can’t tell you how much I’ve learnt here and how easily! Thank you for blessing me with this effortlessly ingestible digestible content.

    An extent is a specific number of contiguous data blocks, obtained in a single allocation and used to store a specific type of information.

    Thank you very much and will look for more postings from you.

    Kind Regards,

  2. Olà,

    Grazie! Grazie! Grazie! Your blog is indeed quite interesting around I agree with you on lot of points!

    how to get the first non space character from a string in Oracle. Could you help me on this?

    Anyways great write up, your efforts are much appreciated.

    Many Thanks,

  3. In the event that conceivable and if your financial plan permits you ought to guarantee that you procure the correct programming engineer for this reason. website to app

  4. Hi Dayakar,

    I learnt so much in such little time about Oracle Application Interview questions and Answers. Even a toddler could become smart reading of your amazing articles.

    1) I know there are a lot of website to know about hierarchical query but not getting the correct output as desired.

    I am in need to use
    hierarchical query:

    I have table with values

    sub_node_pk low_term_no high_term_no

    123 1 3

    342 5 7

    I need query with level being used to get as below

    level sub_node_pk

    1 123

    2 123

    3 123

    5 342

    6 342

    7 342

    Kindly help.

    I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.


  5. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.