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.
Stored in segment Column
Is used to capture additional information
Stored in attribute Column
Qns: How many KFF are in GL. AP , AR.
GL Accounting FF
AP No KFF
AR Sales tax Location FF
Qns: What is symbol of DFF in the Forms?
Ans: Square Bracket [ ].
Qns: What is structure of KFF in the Accounting Flexfields.
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.
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
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
Qns: What are different types of Currency.
Ans: Functional Currency
Qns: What are different types of Calendars .
Ans: Different types of Calendars are listed below
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)
Qns: Write Name of some Profile options.
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.
Qns: In which table Supplier informationâ€™s is stored.
Ans: Supplier information can be found in following tables
Qns: What is difference org_id and Organization_id.
Ans: Org_id is for operating unit and organization_id is for inventory organization.