Technical Interview Questions – Oracle
Financials Consultant
Structured from the following three
dimensions – Technology, People and Processes
Technology
General Ledger
- Explain the organisational concepts of business group, set of books, legal entity, operating unit and inventory organization and the hierarchical structure relating to these.
- What are the three C’s in relation to a set of books?
- Explain the difference between a key flexfield and descriptive flexfield
- What is the difference between a cross validation rule and a security rule?
- What is a value set and what are the different types of value sets that you will find within Oracle?
Accounts Payable
- Describe the Key Configuration decisions you would need to undertake when implementing the Accounts Payable module.
- Briefly describe the Supplier Invoice to Payment process within Oracle.
Accounts Receivable
- Describe the Key Configuration decisions you would need to undertake when implementing the Accounts Receivable module.
- Briefly describe/draw the Customer Invoice to Cash process within Oracle
- Describe the Key difference in setting up accounting for Accounts Receivable and Accounts Payable
- What happens when you have a receipt in Oracle that can't be applied to an invoice?
Fixed Assets
- Describe the key configuration decisions you would need to undertake when implementing the fixed assets module.
- Briefly describe/draw the asset additions process within Oracle.
Cash Management
- Describe the key configuration decisions you would need to undertake when implementing the cash management module.
- Outline the Statement to Reconciliation process within Oracle with particular reference to the different options you might want to consider when reconciling.
All Modules
People
- Draw a typical structure relating to project implementation and describe the role each person would play within a project.
- Describe how to implement an effective training strategy within an implementation – include the timing of training relative to the project lifecycle.
- Within an implementation describe a Change Management strategy that you would put in place.
Process
- Describe/draw the main phases of an implementation lifecycle and the key milestones and deliverables within each of these phases.
- Describe the key differences between a process and work instruction
- Within a project describe the different test phases that you might go through and what level of testing would be undertaken.
- Describe a typical process you would implement for managing Change Requests and Bug requests within your organization.
