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.

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

          I--INSTALLED,

          B--BASE,

          D--DISABLE

            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?

         No.

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               

1) P_CONC_REQUEST_ID

2) P_FLEXDATA

3) P_STRUCT_NUM

13) Types of User Exits?

FND SRWINIT, FND SRWEXIT, FND FLEXSQL,FND FLEXIDVAL.

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?

By using FND_FILE.PUT_LINE(FND_FILE.OUT, 'MESSAGE') for outfile

                       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?

It is in SEGMENT1 in MTL_SYSTEM_ITEMS_B

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?

        rcv_shipment_headers

        rcv_shipment_lines

        rcv_transactions

        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.

         While concurrent Program means To Which Responsibility we can attach this Program.

You May Like:

Oracle Reports Interview Questions and Answers

Oracle Forms Interview Questions and Answers  

Concurrent Program Questions and Answers

SQL interview questions and answers

Oracle Interview Questions and Answers - FAQs   

Oracle PL/SQL interview questions and answers