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.
sajjad said
nice!! need some questions nd answers for latests version R12. plz
Mahmoud Maher said
http://allinterview.com/showanswers/57621.html
2010 in review « Oracle Application Financial said
[…] Oracle Financials Interview Questions – Answers Included December 2009 2 comments 5 […]
Muhammad Irfan Shah said
exellent work………..
please also share questions of payable, recievable also.
thanx for sharing such important information..
nagendra roayl said
good!! need some questions nd answers for latests version R12.
madanmohanrao said
very good i need some oracle R12 finance course questions and answera
khalil_parast@yahoo.com said
i want to get information about oracle financials with full details and sources
such as questions and answers .
mr.rajesh pathak said
nice!! need some questions nd answers for latests version R12.
abhi said
hi
jagadish said
tanx plz shere AP&AR also
sudershan said
nice!! need some questions nd answers for latests version R12..
suresh said
Very good ..
give more interview question an d ans..
thank u so much
Ahmad Yahya said
is this questions are during job interview?
suleman said
give more important questions and answers
thank you
pathan said
excellent work u r doing just keep it up.its worth
swamy said
good job dude
financial leasing said
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!
budget money said
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
house budget said
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?
😛 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?
home staging services said
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
immigration visa services said
I read this post completely about the difference of newest and previous
technologies, it’s awesome article.
The Colony locksmith service said
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!
get rid of shin splints said
This piece of writing will help the internet viewers
for setting up new weblog or even a weblog from start to end.
Nithya said
I NEED STILL MORE DETAILS
Lillian said
I like looking through an article that will make men and women think.
Also, thank you for allowing for me to comment!
lines said
What’s up, afterr reading this remarkable piece of writing i am too happy to share my experience here
with mates.
pandu said
Hi friends I completed MBA finance in 2013, I haven’t been doing any job till now. The question is I want to learn oracle finance Course, please give me your valuable suggisions, rand best coaching center details in ameerpet area
N.sandhya rani said
Hiii friends am don my oracle finance functional course in winners technology at mytrrevanam they were provied good knowledge about the course and good teaching……. friends i want a resume plzz how to get the resume plzz give me idea ore informacation