Oracle Training

27 Years

Experience

33

Projects

12

Modules

Our vast experience has provided us with a broad understanding of Oracle Financials from a functional and technical perspective. Our training is unique in that you will implement a fictitious company from start to finish with your own instance to provides hands-on experience. We will do all the setup as if you are setting up a company from scratch based on business requirements as well as complete User Acceptance Testing (UAT) and finally go through a month-end close to provide you with a thorough understanding of the accounting, system integration and business processes of the Oracle Financials Modules.

This unique approach along with actual hands-on experience using your own Oracle instance will be more valuable than simply watching videos or reading training materials. You will be doing hands-on work in every step of the training process so that you will gain a deeper understanding of Oracle Financials from the perspective of an Oracle consultant implementing the product on the client site.

Upon completion of this training, a first time student should be able to participate in their first Oracle Financials implementation for a small to mid-size company with confidence in their abilities and knowledge from this training. With this training, coupled with the fact that you will have your own Oracle instance, you can always refresh your skills and examine more advanced topics as your knowledge increases.

About the Instructor

William Green

William Green

William is the founder of William Delaney Consulting. He has over 27 years of experience and has implemented Oracle Applications for over 33 companies both technical and functional. He has a degree in Accounting and is a former US Marine.

Full Implementation

During the class, you will implement a company called ACME Corporation.  Acme Corporation is a fictitious corporation located in Atlanta Georgia.  They will be implementing Oracle EBS Applications Release 12.1.3 modules General Ledger, Accounts Payable, Internet Expenses, Purchasing, Internet Procurement, Cash Management, Payments, Accounts Receivable, Fixed Assets and EB-Tax.  You are the business analyst whose responsibilities it is to gather business requirements and map them to Oracle Applications.  There will be minor data conversions for some data elements such as suppliers and customers.  There will be no data conversion of open items.  You will create custom reports.

At the end of this implementation, at a very minimum, you will have accomplished the following tasks:

  • Acquired a functional and technical knowledge of Oracle EBS R12 application in a multi-organization environment

  • Acquired a knowledge of the underlying Oracle tables, integration points and technology processes of the Oracle EBS R12 application

  • Acquired experience with low-level ad-hoc query tools (SQL Developer, SQLPlus) and a working knowledge of SQL queries

  • GL account setups for all financial modules (AR, AP, PO and FA)

  • Setup and Run GL Financial Statement Generator

  • SLA (Subledger Accounting) rules for Receivables, Payables and Costing

  • AR receipts, invoices, credit memos, debit memos and prepayment receipt application

  • Modify AP and PO approval workflows and approval hierarchy

  • AP invoices, approval hierarchy setup, price variance and setting up price variance GL accounts

  • Create accounting process for all financial modules (AR, AP, PO and FA)

  • Manual AR invoice creation, receipt creation and application

  • Payment processing and reconciliation for AR and AP

  • Setup and approval requirements and workflow modification for Internet Expenses and Internet Procurement

  • Setup Asset Corporate Books, run depreciation and retire assets

  • Convert data elements using PL/SQL, SQL Loader, DataLoader and WebADI

  • Create custom responsibilities, reports and menus

  • Setup employees, users and assign responsibilities

  • Analyze data elements and diagnose issues of the financial modules Account Receivables, General Ledger, Assets, Purchasing and cash applications

  • Month-end and year-end process and production support to clear any month end related issues

  • Create ad-hoc reports for product and/or consumer feedback as requested by cross-functional business units

  • Skill in data requirements gathering, query design, development, testing, and tuning

Course Outline

Partnership

We are partnering with Lifting the Veil IT Academy.  Founded by Bill Green in 2017, Lifting the Veil Academy has been steadfast in building professional, well trained, & career driven Developers.  LTV was actually started on a whim based on a challenge to Bill to give back and share the skills he had acquired.  Thinking he was just going to teach a few students, Bill decided to teach a class and bestow his Database Development skillset on to a few students.  Before long, he had taught hundreds of students, and the request to take the course just kept coming.  Since then LTV has taught and/or helped employ thousands of students.  

LTV primarily offers SQL Server Database Development and Business Intelligence /Oracle Financial Applications as their main disciplines however we definitely intend to offer many other disciplines in the near future (such as Salesforce, Python, AWS, etc.)  At LTV, they believe in offering you a down to earth, friendly, professional, and courteous learning environment.  We are excited about the future and we definitely look forward to speaking with you about launching your new IT career!  

​