Oracle e-Business Financial

Mahmoud Elemam – blog

Oracle Financials Interview Questions – Answers Included

Posted by Mahmoud Elemam on December 12, 2009


Below is a list of 25 Important questions that is asked in almost every financials technical interview question. I have also included some of the functional questions that are asked.Answers are included.

Qns: What is Flex field? What are different types of Flex field?

Ans: Flex field is used to capture information of your Organisations.

Qns: Difference between KFF and DFF.

KFF

Unique identifier

Stored in segment Column

DFF

Is used to capture additional information

Stored in attribute Column

Qns: How many KFF are in GL. AP , AR.

Ans:

Module KFF

GL Accounting FF

AP No KFF

AR Sales tax Location FF

Territory Flexfield.

Qns: What is symbol of DFF in the Forms?

Ans: Square Bracket [ ].

Qns: What is structure of KFF in the Accounting Flexfields.

Ans: Company

Cost center

Account

Product

Future use.

Qns: How many segments are in AFF.

Ans: max 30 segments and min two.

Qns: What are flexfield Qualifiers.

Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:

a) Balancing Segment Qualifier.

b) Cost Center segment Qualifier.

c) Natural Account Segment Qualifier.

d) Intercompany Segment Qualifier.

Qns: What is Dynamic Insertions?

Ans: u can create Code Combinations at run time.

Qns: In which table Code Cominations id is stored.

Ans: GL_CODE_COMBINATIONS.

Qns: In which table flex values are stored.

Ans: 1. fnd_ flex_Values

2. fnd_ flex_Values_tl

Qns: What is set of Books and in which table set of book is stored.

Ans : Set of Books is a Financial Reporting entity which Consist of three C.

a) Chart Of Accounts

b) Currency

c) Calendar.

Set of Books is stored in GL_SETS_OF_BOOKS

Qns: In which table Currency and Period Type Name are stored.

Currency – FND_CURRENCIES

Period – GL_PERIOD_STATUSES

Qns: In which table Segment Values are stored and concatenated values are stored.

Ans: 1. GL_CODE_COMBINATIONS

2. GL_CODE_COMBINATIONS_KFV.

Qns: What are different types of Currency.

Ans: Functional Currency

Foreign currency.

Qns: What are different types of Calendars .

Ans: Different types of Calendars are listed below

a) Fiscal

b) Accounting

Qns: How will you attach set of Books to the Responsibility?

Ans: through Profile. GL SETS OF Books Name.

Qns: What is Profile and what are different types of Profiles.

Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profile.

1. System defined

2. User defined

Qns: What are different Profiles Level available in oracle apps.

Ans: Below are the Profiles Level available in oracle apps

1. Site(Lowest level)

2. Application

3. Responsibility

4. User.

Qns: Write Name of some Profile options.

Ans:

1. GL Sets of Books Name

2. GL sets of Books id

3. MO:Operating unit (multi org).

4. HR:User type.

Qns: What is cycle of GL.?

Ans: In simple and layman words-

1. Open the period

2. Create Journal Enteries

3. Post the Journals.

Qns: In Which tables Journal entries created.

Ans: Important tables are-

1. Batch: GL_JE_BATCHES

2. Header: GL_JE_HEADERS

3. Lines : GL_JE_LINES

Qns: After Posting data goes in which tables.

Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).

Qns: What are Important tables in GL.

Ans:

1. GL_JE_BATCHES

2. GL_JE_HEADERS

3. GL_JE_LINES

4. GL_BALANCES

5. GL_SETS_OF_BOOKS

6. GL_CODE_COMBINATIONS

7. GL_PERIOD_STATUES

8. GL_INTERFACE

Qns: In which table Supplier information’s is stored.

Ans: Supplier information can be found in following tables

1. PO_VENDORS

2. PO_VENDOR_SITES_ALL

3. PO_VENDOR_CONTACTS

Qns: What is difference org_id and Organization_id.

Ans: Org_id is for operating unit and organization_id is for inventory organization.

About these ads

26 Responses to “Oracle Financials Interview Questions – Answers Included”

  1. sajjad said

    nice!! need some questions nd answers for latests version R12. plz

  2. […] Oracle Financials Interview Questions – Answers Included December 2009 2 comments 5 […]

  3. Muhammad Irfan Shah said

    exellent work………..
    please also share questions of payable, recievable also.

    thanx for sharing such important information..

  4. nagendra roayl said

    good!! need some questions nd answers for latests version R12.

  5. madanmohanrao said

    very good i need some oracle R12 finance course questions and answera

  6. i want to get information about oracle financials with full details and sources
    such as questions and answers .

  7. mr.rajesh pathak said

    nice!! need some questions nd answers for latests version R12.

  8. abhi said

    hi

  9. jagadish said

    tanx plz shere AP&AR also

  10. sudershan said

    nice!! need some questions nd answers for latests version R12..

  11. suresh said

    Very good ..

    give more interview question an d ans..

    thank u so much

  12. Ahmad Yahya said

    is this questions are during job interview?

  13. suleman said

    give more important questions and answers
    thank you

  14. pathan said

    excellent work u r doing just keep it up.its worth

  15. swamy said

    good job dude

  16. Woah! I’m really enjoying the template/theme of this blog. It’s simple, yet effective.
    A lot of times it’s very difficult to get that “perfect balance” between user friendliness and visual appeal. I must say you’ve done a superb
    job with this. Additionally, the blog loads extremely fast for me on Internet
    explorer. Exceptional Blog!

  17. Good day! This is kind of off topic but I
    need some advice from an established blog. Is it difficult to set up your own blog?

    I’m not very techincal but I can figure things out pretty fast. I’m thinking about
    setting up my own but I’m not sure where to begin. Do you have any ideas or suggestions? Thank you

  18. I tend not to drop many responses, but i
    did some searching and wound up here Oracle Financials Interview Questions – Answers Included « Oracle Application Financial.

    And I actually do have a couple of questions for you
    if you tend not to mind. Is it simply me or does it give the impression like some of these remarks
    come across as if they are left by brain dead individuals? :-P And, if you are posting at additional social sites, I would like to follow everything new you have to
    post. Could you list of the complete urls of your public pages like
    your Facebook page, twitter feed, or linkedin profile?

  19. Undeniably consider that that you said. Your favorite reason seemed to be on the web the simplest thing to bear in
    mind of. I say to you, I definitely get annoyed even as other folks think about concerns that they plainly don’t understand
    about. You managed to hit the nail upon the highest and outlined out the entire thing with no need side effect ,
    other folks can take a signal. Will probably be again to get more.
    Thanks

  20. I read this post completely about the difference of newest and previous
    technologies, it’s awesome article.

  21. Good day! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me.
    Nonetheless, I’m definitely delighted I found it and I’ll be bookmarking and checking back
    frequently!

  22. This piece of writing will help the internet viewers
    for setting up new weblog or even a weblog from start to end.

  23. Nithya said

    I NEED STILL MORE DETAILS

  24. Lillian said

    I like looking through an article that will make men and women think.
    Also, thank you for allowing for me to comment!

  25. lines said

    What’s up, afterr reading this remarkable piece of writing i am too happy to share my experience here
    with mates.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 340 other followers

%d bloggers like this: