Oracle apps Interview Preparation

Greetings

An employer receives daily no of resumes, but how they filter the resume. In many cases applicant didn’t read Job description.

Employer receives the resumes in the below format usually       

Having 3+ years of Total Experience in Oracle Applications as Technical consultant.

• Involved in implementations and supporting project of Oracle Applications R12/R11i. Modules PO, INV, OM, AP, AR, GL, PA Modules. • Proficient in Oracle Technologies like SQL, PL/SQL and Developer Reports 10g/6i.AIM methodology, Discoverer Reports,TARs,OAF,

Employer will think that applicant have capability above technologies 

If applicant has good knowledge on above technologies he/she must be strong at sql/plsql

If the JD is demanding interface skills (he can expect the questions error handling, global variables, and pragma exceptions)

Suppose Applicant is familiar with item, invoice (accounts payable) interfaces he/she should know the basic setup to run these interfaces
.Mainly interviewer will ask what is the autonomous transaction to check how he/she handled errors while he/she executing the interface

Suppose if the applicant is familiar with 11i/R12 he/she can expects questions on "new additions" in particular module

Mainly they will ask on SLA concepts as account entries will hit first SLA tables the post into GL(General Ledger)

New tables are introduced in R12.Need to know why these  tables are introduced. What are the benefits got in terms of functionality?

Reports: Need to know the triggers, flex mode, confine mode, user exits, printing on stationary .page breaks.
If somebody customized the report you have to justify why client needs the customization

Normally AIM is belongs to 11.5.10.2 Now Oracle introduced OUM(Oracle Unified Methodology).Why Oracle introduced this you have know that .

If you mentioned OAF you have to know what the MVC architecture
How OAF is following MVC if you are working on OAF you have to know oops concepts of JAVA, collections.

In next series I will explain for each topic say interface what needs to be focus while facing interview

Happy reading…All the best   

                                             
                    *Read*Explore*Succeed*

Share on Google Plus

About Sekhar Byna

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.