Following are few Important questions that are asked in almost every financials technical interview panel.
Qns: What is Flex field? What are different types of Flex field?
Ans: Flex field is used to capture information of your Organisations.
Difference between KFF and DFF.
KFF : Unique identifier and Stored in segment Column
DFF : Is used to capture additional information and Stored in attribute Column
Qns: How many KFF are used frequently in GL, AP , AR.
Ans:
GL: Accounting FF
AP: No KFF
AR: Sales tax Location FF, Territory Flexfield.
Qns: How do you identify a DFF in the Forms?
Ans: Square Bracket [ ].
Qns: What is the structure of KFF in the Accounting Flexfields.
Ans: Company
Cost center
Account
Product
Future use.
Qns: How many segments are used in DFF.
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 Cs.
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 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: Following are the Profiles Level available in oracle apps
1. Site(Lowest level)
2. Application
3. Responsibility
4. User.
Qns: What are the important profile option used in Oracle Financials?
Ans:
1. GL Sets of Books Name
2. GL sets of Books id
3. MO:Operating unit (multi org).
4. HR:User type.
Qns: Describe the GL cycle ?
Ans: In simple words-
1. Open the period
2. Create Journal Enteries
3. Post the Journals.
Qns: Which tables stores information when Journal entries are 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 the 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: Which table contains Supplier information.
Ans: Supplier information can be found in following tables
1. PO_VENDORS
2. PO_VENDOR_SITES_ALL
3. PO_VENDOR_CONTACTS
Qns: What is the difference between org_id and Organization_id.
Ans: Org_id is for operating unit and organization_id is for inventory organization.
Most Useful Oracle Apps Articles:
- Types Of Tables In Oracle Applications
- Oracle Applications Technical Questions And Answers
- Oracle Apps AOL and Sysadmin Interview Questions And Answers
- Oracle Apps AR Module Interview Questions And Answers
- Oracle Purchasing Interview Questions And Answers
- Oracle R12 Tables and Views Changes
- Purpose of MO_GLOBAL.SET_POLICY_CONTEXT
I did course on Oracle Financial in kbs training institute.Now im searching for interview question for preparing interview above given information is very helpful to prepare for interview thanks for given such useful information for job seekers
ReplyDelete