[go: up one dir, main page]
Scribd
Upload
2K views6 pages

Oracle Financials Interview Questions

This document provides answers to common interview questions about Oracle Financials. It includes questions about flexfields, code combinations, sets of books, journals, and more. Key points covered are: - Flexfields allow capturing additional organization information and come in key (KFF) and descriptive (DFF) types. Accounting flexfield structure includes company, cost center, account, product. - Code combinations store flexfield segment values and concatenated codes. Journals are created in tables like JE_BATCHES and JE_LINES then posted to GL_BALANCES. - Sets of books combine chart of accounts, currency, and calendar. They are attached to responsibilities through profiles. Other profiles control options like

Uploaded by

aren12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2K views6 pages

Oracle Financials Interview Questions

This document provides answers to common interview questions about Oracle Financials. It includes questions about flexfields, code combinations, sets of books, journals, and more. Key points covered are: - Flexfields allow capturing additional organization information and come in key (KFF) and descriptive (DFF) types. Accounting flexfield structure includes company, cost center, account, product. - Code combinations store flexfield segment values and concatenated codes. Journals are created in tables like JE_BATCHES and JE_LINES then posted to GL_BALANCES. - Sets of books combine chart of accounts, currency, and calendar. They are attached to responsibilities through profiles. Other profiles control options like

Uploaded by

aren12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Oracle Financials Interview Questions Answers Included

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.
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 words1. Open the period
2. Create Journal Enteries
3. Post the Journals.
Qns: In Which tables Journal entries created.
Ans: Important tables are1. 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.

Read more: http://prasanthapps.blogspot.com/2011/08/oracle-financials-interviewquestions.html#ixzz1mR5BeOA9

You might also like