Sunday, September 5, 2010

Orace Apps Financials Functional Interview Questions (6 Years Experience)

1) Tell about your Oracle experiences?

2) Elabore for me what are the phases of the Implementation project?

3) For how many implementation were you part of End-To-End Implementation?

4) How would you rate yourself in oracle financial modules on a scale of 5?

5) Can you walk me through the Procure to Pay accounting entries?

6) At the receive system creates accounting entries. Are those entries created in Purchasing or Inventory module. What is the program that you run to transfer accounting entries from purchasing to GL?

7) Have you worked on R12? What are the major changes in R12?

8) How many C's are there while defining COA? What the 4 C's?

9) What are the mandatory segments while defining Chart of Accounts?

10) Explain Secondary Tracking Segments.

11) What is the additional qualifier in R12 while defing COA?

12) What the steps involved in consolidation?

13) What is the difference between Revaluation and Translation?

14) Can you translate the balances of SOB in GBP currencies into multiple currencies or only in one different currency?

15) I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done?

15a) When we run the translation we can give only one rate type, then how can we run it for two different exchange rates?

16) What is the difference between realized gain/loss and unrealized gain /loss?

17) I have requirement where the Invoice given by supplier is in USD, but the payment can be done in GBP. Is it possible in AP?

17a) If there is any work-around, explain me the work around.

18) In IExpenses, there are two kind of approval/types approvals, what are they?

19) There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

20) Have you used AME for IExpense? What is AME?

21) What is the significance of Iprocurement? Why is it important?

22) Can I Depreciate CIP ? Can I Retire CIP Asset? Can I Revalue CIP Asset?

23) What is Auto-Accounting in AR?

24) If the client is totally dependent on manual on Manual transactions then Is the auto-accounting rules Mandatory?

25) What is the significance of Line Ordering and Line Grouping? Explain.

26) In cash management, when I do reconciliation, the accounting entries are generated. Where are these accounting entries created?

27) Can you walk me through Order to Cash Cycle.

28) Explain the various entries in O2C

29) What is the value/Amount Oracle takes for COGS Account (while shipment is done)? What is the value the Oracle taken when the revenue account is created during AR Invoice creation?

30) What is the difference between Unidentified and Unapplied Receipts?

31) In Purchasing and Inventory there are two type of Items - Inventory and Expense Item. Expense item can further divided into two - what are they?

32) For expense items I want the accounting to flow in the same way as Inventory item. What set-up needs to be done to achieve this?

33) What are the pre-requisites for an AP Invoice line to move to FA module?

34) Why do you define the pro-rate calendar in FA?

35) Out of your experience, how many years of your experience in client facing i.e. not offshore?


  1. Hi

    Tks very much for post:

    I like it and hope that you continue posting.

    Let me show other source that may be good for community.

    Source: Purchasing interview questions

    Best rgs

  2. where are the answers? Please let me have answers for above questions

  3. this is very nice article and very good information for Oracle ADF Learners. our Cubtraining also provide all Oracle Courses

  4. Tks very much for your post.

    Avoid surprises — interviews need preparation. Some questions come up time and time again — usually about you, your experience and the job itself. We've gathered together the most common questions so you can get your preparation off to a flying start.

    You also find all interview questions at link at the end of this post.

    Source: Interview Questions & Answers:

    Best rgs

  5. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  6. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Technical Financials , kindly contact us
    MaxMunus Offer World Class Virtual Instructor led training on Oracle Technical Financials . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023