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
COMMENTS