Special Offer - Enroll Now and Get 2 Course at ₹25000/- Only Explore Now!

All Courses
Oracle Apps Financial Interview Questions And Answers

Oracle Apps Financial Interview Questions And Answers

March 5th, 2019

In case you’re searching for Oracle Apps Financial Interview Questions and answers for Experienced or Freshers, you are at the correct place. GangBoard offers Advanced Oracle Apps Financial Interview Questions and answers that assist you in splitting your Oracle Apps Financial interview and procure dream vocation as Oracle Apps Financial Developer.

Q1) What number of key flexfields are there in oracle financials?

General Ledger

  • Accounting flexfield


  • Asset Key flexfield
  • Location flexfield
  • Category flexfield


  • Service Item flexfield


  •  Territory flexfield
  •  Sales Tax Location flexfield


  • Item Categories
  • System Items
  • Sales Orders
  • Item Catalogs

Q2) What is the report used to distinguish copy providers?

So as to discover copy provider, SUPPLIER AUDIT REPORT is runned

Q3) What are the advantages of flexfields?

  • Configure applications to help your very own bookkeeping, item and different codes.
  • Enable the development of wise keys.
  • Configure application to catch extra information.
  • Use the application to approve esteems and esteem mixes entered by the client.
  • Support different flexfield structures relying upon information setting.

Q4) What are the kinds of flexfields?

  • Key flexfield
  • Descriptive flexfield

Q5) What is a key flexfield qualifier?

A qualifier is a mark connected to a specific key flexfield section so it tends to be situated by the application requiring its data. It  can be of two  types:

  • Flexfield qualifiers recognize a fragment in a flexfield.
  • Segment qualifiers recognize an esteem set in a fragment.

Q6) What are the kinds of Flexfield Qualifier

Common Account
Each Accounting Flexfield structure must contain just a single characteristic record portion. When setting up the qualities, you will demonstrate the sort of record as Asset, Liability, Owner’s Equity, Revenue, or Expense.

Adjusting Account
Each Structure must contain just a single adjusting section. Oracle GL guarantees that all diaries balance for each adjusting fragment.
Cost Center
This fragment is required for Oracle Assets. The Cost focus fragment is utilized in numerous Oracle Assets reports and by Oracle Workflow to produce account numbers. Furthermore, Oracle applications preparing Bangalore Projects and Oracle Purchasing likewise use the cost focus section.
GL naturally utilizes the intercompany portion in the record code mix to follow intercompany exchanges inside a solitary arrangement of books. This portion has a similar esteem set and indistinguishable qualities from the adjusting fragment.
Fragment Qualifiers
Record TYPE: Asset, Liability, Owner’s Equity, Revenue, Expense, Budgetary Dr, and Budgetary Cr.
Spending passage allowed           (Yes/No)
Posting allowed                (Yes/No)
Control Account Reconciliation Flag Available for explicit nations

Q7) What is the ramifications of dynamic embed?

Dynamic Insertion is a component which controls whether the client can enter new record code blends from any shape/window. On the off chance that this element is incapacitated, the client can’t include new record code blends from any window/frame.
Oracle applications utilize a specific frame (called a Combination shape) for straightforwardly entering the new code blends. Clients can enter new record code mixes just through this frame if Dynamic Insertion is crippled.

Q8) What are Cross Validating Values

For key flexfields with various portions, we can characterize standards to cross check esteem blends entered with in the key flexfield fragments. This choice is alluded as Cross Validation rules.
Esteem Set List Types
Rundown of values         (10 to 200)
Extensive rundown of values     (> 200)
Poplist  (> 10)
Esteem Set Security Type

  • No Security: All security is handicapped for this esteem set.
  • Hierarchical Security: With Hierarchical security, the highlights of the esteem security and esteem chains of importance are consolidated. With this element any security that applies to a parent esteem additionally applies to its tyke esteems.
  • Non-Hierarchical Security: Security is empowered, however the guidelines of the various leveled security don’t make a difference. That is, a security decide that applies to a parent esteem does not “course down” to its youngster esteems.

Q9) What are the sorts of Value Sets

  • Special: This specific esteem set gives another flexfield as an esteem set for a solitary fragment.
  • Dependent: A needy esteem set is related with an autonomous esteem set. Subordinate esteem sets guarantee that all needy esteem are related with an incentive in the related free esteem set.
  • None: An esteem set of the sort None has no rundown of endorsed esteems related with it. A None esteem set performs just insignificant checking of, for instance, information type and length.
  • Independent: Independent sort esteem sets perform fundamental checking yet in addition check an esteem entered against the rundown of affirmed esteems you characterize.
  • Table: Table esteem sets acquire their arrangements of affirmed esteems from existing applications tables. When characterizing your table esteem set, you determine a SQL inquiry to recover all the affirmed esteems from the table.
  • Pair: This particular esteem set gives a range flexfield as an esteem set for a couple of portions.
  • Translated Independent: This works like Independent sort. Nonetheless, a Translated Independent esteem set can contain show esteems that are converted into various dialects.
  • Translated Dependent: This works like Dependent sort. In any case, a Translated Dependent esteem set can contain show esteems that are converted into various dialects.

Q10) What number of fragments are there in the key flexfield(s) in oracle general record?

Oracle GL Key flexfield can have 15 sections each speaking to a portion. Be that as it may, the fragments type can be:

  • Cost Center portion
  • Balancing portion
  • Account portion
  • Intercompany portion

Q11) On which element is a security rule pertinent?

It’s a component of Key flexfield, pertinent on Value Sets.

Q12) On which substance is the cross-approval rule pertinent?

It’s a component of Key flexfield, material on Value Sets.
Shorthand nom de plume.
An Alias is a mark for a specific blend of key flexfield fragment esteem. This enables clients to enter information quicker and all the more effectively in light of the fact that the client needs to simply enter the shorthand moniker, and the flexfield consequently populates the qualities for the fragment.

Q13)What is a period in oracle gl?

A Period relates to a period range inside which exchanges are entered preceding finishing, generally called as close of the period.

Q14) What are the period types?

Predefined period types in Oracle GL are:

  • Month
  • Quarter
  • Year

If necessary, period kinds of our own can be characterized notwithstanding the standard time frames.
Distinctive statuses of a bookkeeping period.
Never Opened – Cannot enter or post diaries.
Future Enterable – Enter diary, however can’t post. The quantity of future enterable periods is a settled number characterized in the arrangement of books window. The quantity of future enterable period can be changed whenever.
Open – Enter and port diaries to any open period. A boundless number of periods can be open, yet doing as such may moderate the posting procedure and can confound clients entering diaries.
Closed – Cannot post diaries in a shut period. Must revive shut periods previously posting diaries. Should physically close periods subsequent to completing month/quarter/year-end preparing.
Permanently Closed – Permanently shut periods can’t be revived. This status is required to Archive and Purge information.

Q15) What is an altering period and its suggestions?

Ordinarily, the most recent day of the financial year is utilized to perform modifying and shutting diaries passages. This period is alluded to as Adjusting Period.
Picking whether to incorporate an altering period or not in a timetable is an essential choice. There can be boundless number of altering periods. When the bookkeeping logbook is utilized, changes to its structure to evacuate or include a modifying period is impossible.

Q16) What number of kinds of change rates are there in oracle gl?

There are 5 essential kinds of change rate types predefined in Oracle GL:
Detect: A swapping scale dependent on the rate for a particular date. It applies to the prompt conveyance of a money.
Corporate: A swapping scale that institutionalize rates for your organization. This rate is commonly a standard market rate controlled by senior money related administration for use all through the association.
Client: A conversion scale that you enter amid outside cash diary section.
Emu Fixed: A conversion scale that is utilized by nations joining the EU amid the progress time frame to the Euro cash.
Client Defined: A rate type characterized by your organization to address explicit issues.

Q17) What kind of transformation rate is required to be characterized for all value-based purposes?

Spot (Not certain).

Q18) what are the three fundamental parts of a gl set of book?

Diagram of Accounts
Your diagram of records is the record structure you characterize to fit the particular needs of your association.
You can pick the quantity of record fragments just as the length, name, and request of each seg15 ment.
Bookkeeping Calendar
A bookkeeping date-book characterizes a bookkeeping year and the periods it contains.
You can characterize various timetables and relegate an alternate schedule to each arrangement of books.
Monetary standards
You select the useful cash for your arrangement of books just as different monetary standards that you use to execute business and report in.
GL changes over money related sums entered in an outside cash to utilitarian cash reciprocals utilizing provided rates.

Q19) What is the ramifications of ‘things to come period” field in the arrangement of book definition frame?

The esteem referenced in the Future Period field speaks to the quantity of future enterable periods that clients can use to include diary sections (gave those future periods are opened). Notwithstanding, thought must be given to limit the quantity of future enterable periods to keep clients from unintentionally entering diary passages in an erroneous period.

Q20) What number of selected areas are there in the arrangement of book definition frame? What are the names of these selected locales?

There are 5 selected areas in the arrangement of books definition shape.

  • Closing
  • Journaling
  • Average Balances
  • Budgetary Control
  • Multiple Reporting Currencies

Q21) What is held income account?

GL posts the net equalization of all pay and costs accounts from the earlier year to this record when you open the main time of a financial year.

Q22) What is the motivation behind the interpretation alteration account?

On the off chance that you interpret your useful money adjusts into another cash for revealing, or in the event that you revalue outside cash overwhelmed balances, you should indicate an interpretation modification account.

  • Parent  Do no empower
  • Budget Yes
  • Posting Yes
  • Record Type Ownership/Stock

Q23) What is the motivation behind/novel element of the net gain account?

GL utilizes this record to catch the net movement of all income and cost accounts while figuring the normal equalization for held profit.

Q24) What is the motivation behind the exchange logbook?

Exchange logbook is characterized to enable normal equalization preparing. Exchange logbook is made alternatively with legitimate business days referenced.
So as to permit unbalances diary posting what activity is required at set of book definition level/23. what is a tension record and its motivation?
On the off chance that you permit posting of out-of-balance/uneven diary sections, GL naturally presents the distinction on Suspense Account. In any case, the Suspense Account check box ought to be checked and an Account # to be accommodated this component to work amid the formation of set of books.
On the off chance that you have different organizations or adjusting elements inside a lot of books, GL consequently makes an anticipation represent each adjusting substance.

Q25) What is an esteem set?

An esteem set characterizes the limits for the ascribes that you dole out to a key or illustrative flexfield fragment. Esteem sets control what sorts of qualities can be utilized as Accounting Flexfield section esteems. Esteem sets decide the properties of your sections, for example, length, zero-fill, and right legitimize, alphanumeric, and esteem security. Esteem sets additionally control how approval is performed.
Inorder to permit intercompany diaries what activity is required at set of book definition level?
One of the bookkeeping key flexfield sections ought to be of the sort Intercompany. This portion would have a similar esteem set and indistinguishable qualities from the adjusting section.
Additionally, empower Balance Intercompany Journals highlight. This enables clients to post out-of-balance intercompany diary passages and consequently balance those diary sections against a predetermined intercompany account

Q26) What is Account Hierarchy Manager

Record pecking order director is a component given by Oracle Application which permits to:

  • Graphically make, keep up, and audit account structure orders.
  • Define new parent and kid fragment esteems, just as change parent/kid conditions.
  • Create new move up gatherings from the record chain of importance director and have your progressions reflected naturally in both key portion esteems and rollup bunches window.

Likewise gives an alternative to control elements, for example,

  • Read-as it were
  • Read/compose security
  • Segment Value Security: An oracle applications include that gives you a chance to bar a portion esteem or scopes of fragment esteems for a particular client duty. Fragment Value Security is reached out to the Account Hierarchy Manager.
  • Chart of Accounts Security

Q27) What does adjust type “a” show?

Not Sure. May be ACTUAL.

Q28) What number of catches are there on the manual diary passage frame? What are they?

As a matter of course, there are 3 catches on the manual diary passage shape:

  • More Details
  • Change Currency
  • More Actions

Q29) What number of catches are there under the “more activities” catch? What are they?

When we tap on the “More Actions” catch, another window shows up with 4 catches:

  • Reverse Journal
  • Post
  • Change Period

Q30) What is the status of a recently entered diary?

  • Unposted
  • Posting statuses
  • Unposted
  • Pending
  • Processing
  • Selected for posting
  • Posted
  • Error

Q31) When a journal is created, which all gl tables are impacted?


Q32) What is the name of the concurrent to populate the gl tables from the interface table?

Journal Import.

Q33) What is the mechanism to rectify a posted journal?

Reverse the Journal.

Q34) What is the purpose of stat journal?

You can connect factual sums with financial sums by utilizing factual units of measure.
This empowers you to enter both fiscal and measurable sums in a solitary diary section line.

Q35) For creation of periodically repititive journals what is the gl tool?

Recurring Journal.

Q36) What is massallocations?

A solitary diary passage recipe that apportions incomes and costs over a gathering of cost focuses, offices, or divisions.

Q37) What is the formula for creation of allocation journals?

An is the Cost Pool that will be distributed. It tends to be sum or record balance.
B is the numerator of the factor (a number or measurable record) that duplicates the cost pool for the designation.
C is the denominator of the factor (a number or measurable record) that isolates the cost pool for the distribution.
Note: Parent esteems can be utilized in at least one portions.

Q38) Record segment types for massallocation.

  • Circling
  • Summing
  • Consistent

Q39) What is the pre-requisite for conversion?

  • Characterize new monetary forms
  • Empower seeded monetary forms
  • Characterize rate types
  • Enter day by day rates

Q40) For revaluation, what rate types are available?

  • Day by day rates
  • Authentic rates
  • Revaluation rate is the reverse of period end rate.

Q41) The revaluation journals are created in which currency?

Functional money

Q42) Which rate types are used for translation?

  • Period-End
  • Period-Average
  • Notable
  • GL Account Type
  • Period-End
  • Period-Average
  • Notable

Q43) So as to effect translation, what setup is required to set of book definition level?

Cumulative Translation Adjustment (CTA) record ought to be determined in the SOB widows to guarantee that your books stay in parity.

Q44) What must be common between the primary and the reporting books?

To utilize MRC, the essential and the detailing SOBs should all have a similar logbook and diagram of record structures.

Q45) On which event in the primary book, the manual journals are transferred to the reporting book?

When diaries are posted in the essential SOBs.

Q46) Union tools

Fiscal report Generator (FSG): Use FSG to solidify money related data for organizations utilizing a solitary SOBs or organizations utilizing diverse SOBs that share a similar schedule and diagram of records.
Worldwide Consolidation System (GSC): Use GCS to unite monetary data for various SOBs, assorted budgetary frameworks, and geographic areas, including both Oracle and non-Oracle applications.


If we utilize Global Consolidation System, there is no such prerequisite. Be that as it may, it might be that the Period to be same.

Q48) Gcs features and benefits.

  • A workbench to see the combination status of your auxiliaries.
  • Complex combination mapping standards to delineate and indicate exchange rules from the auxiliary to the parent.
  • A shading coded combination screen that guides you through the union advances.
  • A solidification order watcher to graphically show your combination structure.
  • The Interface Data Transfer makes bringing in information from outside feeder framework less demanding.
  • Programmed age of taking out sections.
  • Staggered drilldown capacities to auxiliary adjusts and sub-records.
  • Incredible report distributing capacities utilizing FSG and ADI.
  • Incorporated multi-dimensional examination utilizing Oracle Financial Analyzer.
  • Can be utilized if the organization chooses to change the Accounting Calendar.
  • Taxi be utilized if the organization chooses to change the Chart of Accounts.

Q49) Interface data transformer (IDT).

The IDT is an easy to use instrument that makes bringing in of information from outer feeder frameworks into Oracle GL or Oracle GCS a lot less demanding and less tedious. Advantages of IDT are:
Programmed information transformation that changes over dissimilar information positions into an Oracle organize.
Reapplication of similar standards each time you exchange.
Programmed information approval on imported information give more noteworthy adaptability.
Conditions enable you to control when Transformation tenets to be applies.

Q50) Combination workbench

The combination workbench gives an essential issue of control for solidifying a boundless number of backups to your parent. This window gives criticism on the condition of the union procedure, keeping you educated about every backup’s solidification status. The workbench additionally screens backup account adjusts for any progressions that happen after the auxiliary information has been exchanged to your parent SOBs.
Solidification Sets: You can even make combination sets which dispatch various unions in a solitary advance for by and large streamlining of the union procedure.
Solidification Hierarchies: You can make combination orders, or staggered chains of importance, and view your unions orders utilizing a graphical Consolidation Hierarchy Viewer.
State Controller: From the union workbench, you can get to the State Controller, which is a shading coded route instrument to direct through the solidification procedure.

Q51) Union mapping and mapping rules

A union mapping is a lot of guidelines for mapping records or whole record portions from an auxiliary SOBs to the parent SOBs. We can characterize section rules, account rules or a mix of both. Record rules supersede section rules.

Q52) Solidification set and its purpose

Mapping sets are made to exchange information for numerous auxiliaries at the same time. After the mapping set is made the outcome can be seen in the Consolidation Hierarchy Viewer.

Q53) What number of buttons are there on the manual journal entry form? What are they?

By default, there are 3 catches on the manual diary passage shape:

  • More Details
  • Change Currency
  • More Actions

Q54) Posting statuses

  • Unposted
  • Pending
  • Preparing
  • Chosen for posting
  • Posted
  • Mistake

Q55) What number of buttons are there under the “more actions” button? What are they?

When we tap on the “More Actions” catch, another window shows up with 4 catches:

  • Turn around Journal
  • Post
  • Change Period
  • Drop

Q56) What is Oracle Financial Applications?

Oracle Financial Applications are a subset of the Oracle E-Business Suite. It’s also the products family developed to analyze and capture your financial information across the globe.

Q57) What is Oracle E-Business Suite?

The Oracle E-Business Suite is an entire business application set that allows organizations to track the complete business transaction data efficiently. With the help of a system built on unique information architecture, it turns into decision making information.

Q58) What is the use of Oracle Financial Applications?

The Oracle Apps Financial has been used to manage the business towards the target that is announced to investors in a better way.

Q59) What are the key areas that meet the obligations of the Oracle Financial Application?

Financial Control, Cost Containment, Compliance, Regulatory Reporting, and Risk Management.

Q60) What are the benefits of Oracle Financial Applications?

  • Think universally to make the correct decisions
  • Work universally to act competitively.
  • Manage universally to increase performance and lower cost.

Q61) What are the key attributes of the Oracle E-Business Suite?

  • Reduced Number of Instances
  • Database Integration
  • Common Data Model
  • Integrated Applications

Q62) Are there any subfamilies included in the Oracle Financials Suite of Applications?

Yes, there are subfamilies and they are arranged by standard business flow to support the financial process of your firm. Some of them include Corporate Performance Management, Credit-to-cash, Asset, Lease Management, and Real Estate, Travel & Expense Management, Reporting & Financial Control, Corporate Governance, Procure-to-pay, and Treasury & Cash Management.

Q63) What are the system entities included in the Oracle E-Business Suite?

  • GRLE (Government Reporting Legal Entity)
  • Ledgers
  • Inventory Organization
  • Business Group and Departments
  • Legal Entity
  • Operating Unit
  • Human Resources Organization.

Q64) What do you mean by Ledger?

It’s one of the basic concepts of Oracle Financial Applications. Ledger indicates a representation of accounts for a corporation that is accountable in a self-contained way. The ledger owner can be a legal entity, a substantial operation within a legal entity but incorporated with the attributed of a legal entity, a group of organizations in a common legal environment, or a foreign branch.

Q65) What are reports and their types?

Oracle Apps Financial offers a collection of reporting ability as presented in sections like Shared reports, Filling with the Authorities, Reconciliation, and control, Cross-reference and Drill-down, Product-specific reports and generating reports.

Q66) Mention some of the Reporting tools?

XML Publisher, Desktop Integrators, and RXI Report Administration Tools.

Q67) What is XML Publisher?

Oracle XML Publisher is one of the important reporting tools of Release 12. It enables the user to make formatting templated in Microsoft Word, Microsoft Excel, and other desktop products so that non-information technology and non-technical people can do it. Apart from this, it also helps to pair the templates automatically with the extracts to make use of the ideal report.

Q68) What is the use of XML Publisher?

Oracle XML Publisher is used to save reports to many various file types which include PDF, Excel, XML, RTF, etc. Its also used to publish the report by sending in an email, printing, or posting to portals or websites.

Q69) What are the types of Mandatory Segments in a Chart of Accountants?

Natural Account, Balancing Segment, and Cost Center.

Q70) What do you mean by Subledger accounting in Oracle Financials?

Oracle Subledger is an accounting service that is in accordance with rules of accounting which you produce in line with the requirements of your compliances. It also offers a standard means of posting a sub-ledger to a general ledger. It’s a flexible and open service that defines and generates transaction accounts captured by the transaction processing system present in the Oracle E-Business Suite.

Q71) Mention some of the important features included in Oracle Subledger Accounting?

Flexible Journal Entry Setup, Multiple Accounting Representations using two important methods namely Same Ledger, and Primary & Secondary Ledger, Common Subledger Operations, and Inquires reporting and, drill-down.

Q72) What is the advanced consolidation functionality included in the Oracle Financial Consolidation Hub?

Automated Processing, Sub-consolidations, Simulations, Drill-downs and Audit entries for every consolidation stage, and partial ownership.

Q73) What are the requirements for Financial Compliance?

Holistic, good, compliance, and governance require that the management have better visibility of the enterprise, operate efficiently and also have effective internal controls.

Q74) What are the four layers of technology stack?

Process/Risk Management, Training Management, Content and Records Management, Security and Identity Management, Performance Management and Reporting, E-Business Suite.

Q75) What is the feature of the Product Management Business Process in Oracle Financials?

CAD Viewing, UCCnet Trading Connector, Product Lifecycle Management, Product Information Management Hub, and Product Intelligence.

Q76) What are the areas that Oracle Applications offer improved industry support for corporations?

Asset Intensive: Improved fleet asset management, Enhanced forecasting and budget, Support for 21 CFR Part 11, and Common asset repository.
Public Services: Improved Shared services, Configured and centralized accounting and budgetary control.
Manufacturing: Title 21 Code of Federal Regulations Part 11 (21 CFR Part 11) and Regulatory compliance for clinical trials.
Service: Oracle Financial Services Accounting Hub, and Oracle Retek Merchandising & Oracle Financial System.

Q77) What is Flex Field?

Flex Field helps in capturing your corporation’s entire information.

Q78) Difference between DFF and KFF?

DFF: It’s used for capturing extra information and this is stored in the attribute column.
KFF: It’s a unique identifier and this is stored in a segment column.

Q79) How many KFF are there in GI.Ap, AR?

GL Accounting FF, AR Sales Tax Location FF, Module KFF, AP No KFF, and Territory FlexField.

Q80) What is the KFF Structure in the accounting Flexfields?

Cost center, product, company, account, and future use.

Q81) What is the symbol of DFF in the forms?

Square Bracket [ ].

Q82) How many segments are present in AFF?

AFF contains a minimum of two and a maximum of thirty segments.

Q83) What do you mean by Flex field Qualifiers?

Flex field Qualifiers are used for recognizing the segments in a clear way.

Q84) What are the different types of Flex field Qualifiers?

Cost center segment qualifier, Intercompany segment qualifier, balancing segment qualifier, and Natural account segment qualifier.

Q85) What is profile and their types?

A profile is one of the options that can be changed; this affects the way of how your applications run. Two types of the profile include User-defined and System defined profiles.