Oracle Financials Interview Questions And Answers

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:

1. Types Of Tables In Oracle Applications
2. Oracle Applications Technical Questions And Answers
3. Oracle Apps AOL and Sysadmin Interview Questions And Answers
4. Oracle Apps AR Module Interview Questions And Answers
5. Oracle Purchasing Interview Questions And Answers
6. Oracle R12 Tables and Views Changes
7. Purpose of MO_GLOBAL.SET_POLICY_CONTEXT