Oracle Apps Fresher Interview Questions and Answers

Hi friends i faced these questions in a telephonic interview of a company.

 

1. Which modules you trained in oracle apps?

A: Financial modules : AP,AR,GL

         SCM Modules : PO,OM,INV

2.Which reports you've done? 

i. Stack Summary Report

ii.Return to Vendor Reprot

iii.Goods Receipt Note (GRN)

iv.Approved Requisition Report

v.Back Order Report

vi.GL Report

vii.Sales OrderReport.

viii.Vendorwise PO Approved Report

ix.AR Receipt Information Report.

3.Which Interfaces have you done?

AP Interface

PO Interface

GL Interface

4.What is Interface?

Interface is the process of transferring data from one system to another system.

5.what is the use of Inbound Interface?

It is used to transfer the data from legacy system to oracle applications.

6.Explain about AP Interface?

Client give us data file

Then we have design 2  temporary staging tables one for invoices and another one for invoices lines.

Then we dump the data from data/f lat file to staging tables through SQL *loader.

Then we will create one Package with 2 procedures, In that we create 2 cursors one for invoices and another one for invoices lines.

Take 2 variables and validate mandatory columns and send data into variables.

Then insert the data into  Interface tables.

Run Standard Concurrent Program "Payables Open Interface Import " through SRS window.

Then finally we will see data in base tables.

7.What are mandatory columns in AP Interface?

Invoice Header level.

Operating Unit, Vendor, Invoice Number, Vendor Site, Invoice type, Invoice amount, Invoice Date, Invoice Source

Invoice Line Level.

Invoice line Type, Account, Line Number, Line Amount.

8.Which tables did you used in AP Interface?

Interface Tables :

AP_INVOICES_INTERFACE

AP_INVOICE_LINES_INTERFACE

AP_INTERFACE_REJECTIONS

Base Tables :

AP_INVOICES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

9.Difference between Conversion and Interface?

Interface                                                                                                             Conversion

To transfer daily transactions from Legacy system to Oracle Apps	To transfer old data from Legacy  system to oracle Apps or Lower Version to Higher version (11i -->R12)
It is on demand process/scheduled process	It is one time process
It is applicable in After Implementation	It is applicable in Conversion Projects and Up gradation Projects.
We don't know data volume	We know the data volume

10.When will we use conversion?

11.How to display vendor details in GL Report and what is the link?

We will display vendor details in GL Report by taking AP tables.

link is PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID

Then

AP_AE_LINES.GL_SL_LINK_ID=GL_JE_LINES.GL_SL_LINK_ID

12.What is Procedure?

 is a named pl/sql block to perform a specific task.

    ----    A procedure may have DML statements.

    ----    It may or may not return a value.

    ----    Procedure can return more than one value.

13.What is Function? When will we use it?

is a named pl/sql block to perform a specific task, is mainly used for calculation purpose.

   ---- A function is called as part of an exception.

   ---- Every function should return a value

If u want to do any calculations then we will use Function.

14.XML Registration steps?

1.                   Register the E-business suite report as a Data Definition in the Template Manager.

                                       Create a Data definition in the Template Manager for E-business Suite reports that

                                       We wish to customize using XML Publisher. When you create the Data Definition

                                       Code must match the E-Business Suite report short name.

2.                   Design our template

                  Our template files can be either in Rich Text Format (RTF) or Portable Document.

                  RTF is a specification used by many word processing applications, such as

                  Microsoft word. We design the template using our desktop word processing

                  Application and save the file as an RTF file type (.rtf extension). Insert basic

                  Markup tags to the document to prepare it for merging with the XML data. XML

                  Recognizes the formatting features that we apply and converts them to XSL-FO.

                  Use Adobe Acrobat to apply markup tags to your custom-designed or

                  Downloaded PDF template

3.                   Register out template in the Template Manager

                  When we create the Template Manager, we register and upload our RTF

                  Or PDF template files. The template must be assigned to the Data definition

                  Code of the E-Business Suite report with which it will be merged.

4.                   Add desired translations of your RTF template

                  XML Publisher’s translation utility allows us to extract the translatable strings

                  From your template into an XLIFF file. Translate the strings in this file and re-

                  upload to the Template Manager to make translation available at runtime.

Run Time: -

1.        Set the concurrent program to generate XML.

2.        Run the concurrent program using standard request submission to obtain the XML

Output.

3.        Run the XML Publisher Concurrent Request .

The XML Publisher Concurrent Request will prompt us to enter the Request ID from the previous step, and t select a template, template locale, and output type. Available templates are those associated to the report Data Definition in the Template Manager. XML Publisher merges our design template with the XML data to generate your customized output.

15.PO Process?

16.RDF Registration steps?

17.What is Form Personalization? Which pages you personalize?

18.Which triggers you use in Form Personalization?

19.What is exception? How many types?

20. Difference between Predefined exceptions and User defined exceptions?

21.If we write any exception after when others then what will be the error?

22.Can we create Package Body without specification?

23.Can we create Package Specification without Body?

24.Form Customization steps? When will we give form name in Registration?

25.What is Profile? How many levels?

26.Whar are Site level Profiles?

27.Which profile in GL?

28.Which Profile added in R12?

29.What is Sql*loader? Which command used in Sql*loader to load data?

30.What is TCA? What are the changes made in TCA in R12?

31. What are PO Tables?

31. What are Inventory Tables?

33.What are Sub ledger Accounting Tables?

                                                         

 If you know any answer of the above Question please type in comment box by giving Question no.

or send an mail to me to kommarajashekarreddy@gmail.com