Protected by Copyscape Web Copyright Protection Software

Search This Blog

Sunday, May 26, 2013

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