The most commonly asked Oracle Fusion Financials interview questions cover the enterprise structure (ledgers, legal entities, business units), the AP and AR transaction cycles, Subledger Accounting (SLA), period close, and data loads with FBDI. Below are clear, interview-ready answers to each.
Oracle Fusion Financials interviews tend to move quickly from definitions to real transaction flows and period-close scenarios. The questions below are the ones consistently asked of functional consultants, grouped by area, with answers phrased the way a confident, hands-on candidate should respond.
Enterprise Structure & General Ledger
What are the four C's that define a ledger in Oracle Fusion?
A ledger is defined by the Chart of Accounts, the accounting Calendar, the Currency, and the accounting Convention (the subledger accounting method). Together these four components determine exactly how financial data is recorded and reported.
What is the difference between a Legal Entity and a Business Unit?
A Legal Entity is a registered company used for statutory and tax reporting, while a Business Unit is an operational division that performs functions such as Payables, Receivables and Procurement. A Business Unit is always linked to a primary ledger.
What is the difference between a primary and a secondary ledger?
The primary ledger is the main book of accounts for a legal entity. A secondary ledger maintains a separate accounting representation — for example one ledger under IFRS and another under local GAAP — and can differ in chart of accounts, currency, calendar or accounting method.
What is a Data Access Set?
A Data Access Set controls which ledgers and which balancing segment values a user can access in General Ledger. It is the primary way read/write security is applied to financial data in GL.
What is the difference between revaluation and translation in GL?
Revaluation restates foreign-currency balances at period-end exchange rates and posts the unrealised gain or loss. Translation converts entire ledger balances into a reporting currency using defined rate types, and is typically run for consolidation.
What is a cross-validation rule?
A cross-validation rule prevents users from creating invalid combinations of chart-of-accounts segment values — for example blocking a balance-sheet account from being used with a specific cost centre — so only meaningful account combinations can be created.
Accounts Payable (AP)
What is a 3-way match in Accounts Payable?
A 3-way match validates an invoice against the purchase order and the receipt — quantity and amount must agree within defined tolerances before the invoice can be validated and paid. A 2-way match checks only PO to invoice, and a 4-way match adds inspection.
What types of invoices can you enter in AP?
Common invoice types include Standard, PO-matched, Prepayment, Credit Memo, Debit Memo and Recurring invoices, plus withholding-tax and interest invoices that the system can generate automatically.
What is a Payment Process Request (PPR)?
A PPR is the batch payment flow in AP: you select invoices that meet defined criteria, the process builds and formats the payments, and after review you confirm them. It is the standard way to pay many invoices together rather than one by one.
What is a prepayment and how is it settled?
A prepayment is an advance paid to a supplier before the goods or services are invoiced. When the standard invoice arrives you apply the prepayment against it, which reduces the amount payable and clears the prepayment balance.
Accounts Receivable (AR)
What is AutoInvoice in Oracle Fusion Receivables?
AutoInvoice is the interface process that imports transactions — invoices, credit memos and debit memos — from other systems or from Order Management into Receivables, validating them against setup before creating the AR transactions.
What is AutoAccounting in AR?
AutoAccounting is the rule set that derives the default General Ledger accounts (revenue, receivable, tax, freight) for Receivables transactions, based on sources such as transaction type, salesperson or the item.
What is a miscellaneous receipt?
A miscellaneous receipt records cash that is not related to a customer invoice — such as interest income or refunds — and posts directly to the account you specify rather than being applied to a transaction.
Assets, Cash Management, Tax & Period Close
What are Mass Additions in Fixed Assets?
Mass Additions is the process that brings capitalisable invoice lines from Payables into Fixed Assets, so that assets purchased through AP can be created and depreciated in FA without re-keying.
What is the difference between a corporate and a tax book in Fixed Assets?
A corporate book holds assets for financial reporting with your primary depreciation rules, while a tax book maintains a parallel set of depreciation rules purely for tax purposes, drawing from the same assets.
How does bank reconciliation work in Cash Management?
Cash Management imports the bank statement and matches statement lines to system transactions — automatically using reconciliation rules and tolerances, or manually for exceptions — so the bank balance can be reconciled to the GL cash balance.
What is Subledger Accounting (SLA)?
SLA is a centralised rules engine that converts subledger transactions from Payables, Receivables and Assets into General Ledger journals. Because it is rules-driven, a single business transaction can generate multiple accounting representations.
What is the correct period-close sequence in Financials?
You close the subledgers first — Payables, Receivables, Fixed Assets and Cash Management — transfer their accounting to GL, then reconcile and close the General Ledger period. Closing GL before the subledgers would leave unposted subledger entries.
What is FBDI and when do you use it?
File-Based Data Import (FBDI) uses Oracle-provided spreadsheet templates that you populate and convert to CSV, then load through an ESS job. It is the standard tool for high-volume data conversion and loads such as opening balances, suppliers, customers and invoices.
If you can answer these confidently and back each one with an example from your own practice, you will handle most Oracle Fusion Financials functional interviews well. At LearnwithCR, our Oracle Fusion Financials training walks through every one of these areas live with real-time business scenarios and daily assignments.
Ready to become an Oracle Fusion expert?
Join LearnwithCR for live, hands-on Oracle Fusion training with certification guidance and placement assistance.