Financial Technical Interview questions and answers in Oracle Apps

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.