Overview:
This course is designed for a Functional DBA and/or an Applications DBA. It covers all aspects of Oracle Forms, Reports, Front-End development and Application development (using PL/SQL, and SQL).

Course Outline:

Oracle Financial Applications: Financial Management Release 11.x
Oracle Applications: Navigate
• The aim of this course is to enable students to navigate within any of the Oracle Applications Release 11 forms, regardless of the Application module.
Oracle General Ledger: Transactions
• Oracle General Ledger allows companies to manage and streamline their accounting processes. In this course, students will learn to create a chart of accounts and set of books. Additionally, they will learn to create, approve, and import basic journal entries, and to create recurring and formula journals and utilize Journal Wizard in Oracle General Ledger.
Oracle General Ledger: Budgeting and Reporting
• In this course, students learn the budgeting and accounting cycle associated with Oracle General Ledger. The course introduces the advanced account structure, including balancing accounts, summary accounts and financial controls. Participants learn to use the reporting and analysis tools, standard reports, Financial Statement Generator (FSG) reports, Report Wizard, and Oracle Financial Analyzer within General Ledger.
Oracle General Ledger: Consolidations
• This course is designed for those who work with Oracle General Ledger applications. In this course, students will learn about the powerful features related to foreign and multiple currency, consolidations usage, and considerations for setup in Oracle General Ledger.
Oracle Assets: Setup
• Oracle Assets can help enterprises lower administrative costs by streamlining data management. In this course, students will learn to configure Oracle Fixed Assets for asset accounting information, asset categories, correction of historical data, depreciation, and system controls. Students also will learn to set up additional options in Oracle Assets, including distribution sets, leases, payment schedules, financial options, warranties, descriptive flexfields, suppliers, and employers.
Oracle Assets: Manage Assets
• In this course, students use Oracle Assets to add assets, adjust assets, transfer assets, use unplanned depreciation and revaluation, depreciate assets, fully or partially retire assets, and perform online inquiries about assets information.
Oracle Cash Management: Reconciliation and Forecasting
• Oracle Cash Management can help companies effectively manage and control their cash assets. In this course, students will learn to set up and use Oracle Cash Management to perform bank reconciliation and cash forecasting.

Oracle Financial Applications: Applied Technology Release 11.x
Oracle Applications: System Administration
• This course discusses how to perform administrative tasks in an Oracle Applications systems environment.
Oracle Applications: Workflow
• In this course, participants will learn how to use Oracle Workflow to design and automate business processes. A workflow business process contains a series of activities and inter-activity dependencies. Each activity can represent work performed by a human, a PL/SQL function that the Workflow Engine automatically executes, or a subprocess of other activities. Hands-on exercises help the participants plan and implement these activities in Oracle Workflow Builder. This course gives an overview of the set of public Workflow Engine API's that can be called to fully workflow-enable a business process.
Oracle Applications: Flexfields
• Key and descriptive flexfields give end users and technical personnel the ability to customize an Oracle Application to meet business requirements without programming. Key flexfields enable multi-segment, intelligent keys and allow segment validation and security. Descriptive flexfields provide custom expansion space on forms. This course gives participants a general overview of both types of flexfields. Hands-on exercises will give them practice in planning, defining, setting up and maintaining flexfields for a variety of business applications.
Oracle Financials: Implementation Vol. 1
• This course presents the essential steps and processes in the implementation of core Oracle Financial applications. Students gain an understanding of the technical and functional issues involved in managing an Oracle Applications implementation. Additionally, students learn about the decisions related to implementing the primary Oracle Financial applications. This class is a high-level, theoretical course and should be followed up with appropriate product classes.
Oracle Financials: Implementation Vol. 2
• This course presents the essential steps and processes in the implementation of core Oracle Financial applications. Students gain an understanding of the technical and functional issues involved in managing an Oracle Applications implementation. Additionally, students learn about the decisions related to implementing the primary Oracle Financial applications. This class is a high-level, theoretical course and should be followed up with appropriate product classes.

Oracle Financial Applications: Procurement Release 11.x
Oracle Purchasing: Suppliers, Items and Requisitions
• This course covers key functions of the Oracle Purchasing application. Students learn to create supplier information, evaluate supplier performance, and perform supplier queries. Additionally, students will define locations, organizations, and items. Finally, the course introduces the concepts of creating purchasing and internal requisitions and performing requisition inquiries.
Oracle Purchasing: Receiving
• This course covers key functions of the Oracle Purchasing application. In this course, students learn to enter the detail information of receiving, to correct and return receiving transactions, and to inquiry receiving reports.
Oracle Purchasing: RFQ's and Purchase Orders
• This course covers key functions of the Oracle Purchasing application. Students learn to create requests for quotation (RFQ's) and purchase orders. Additionally, the students learn to create an approved supplier list and sourcing rules.
Oracle Payables: Suppliers and Invoicing
• Oracle Payables provides a company the information needed to make effective payment decisions and improves the efficiency of invoice processing with its workflow orientation. This course will teach you to use Oracle Payables to setup, review, and merge suppliers. The class also covers how to enter invoices, process invoices, apply and release holds to invoices, approve invoices, and cancel invoices.
Oracle Payables: Payments, Taxes and Freight
• This course is for students who want to learn to use Oracle Payables to enter and process manual and computer-generated payments, perform tax-setup requirements, prorate taxes and freight, set up payments, accounting, and auditing options, and submit reports.

Oracle Financial Applications: Order Fulfillment Release 11.x
Oracle Receivables: Receipts and Reporting
• Oracle Receivables can help a company lower its costs by streamlining its billing and collections processes. This course is designed for those who want to learn to set up and use Oracle Receivables to manage and track customer receivables.
Oracle Receivables: Customers and Transactions
• Oracle Receivables can help a company lower its costs by streamlining its billing and collections processes. In this course, participants will learn how to set up and use Oracle Receivables to create and generate customer invoices and manage and track customer receivables.
Oracle Order Entry: Orders, Returns and Setup
• In this course, students learn how to setup and implement Oracle Order Entry/Shipping. Students also learn to process internal, drop ship, and return orders; to transfer orders to Oracle Receivables for invoicing; and to close completed orders. Hands-on exercises give students an opportunity to experience working through each function.
Oracle Order Entry: Customers and Order Processing
• In this course, students learn to use Oracle Order Entry/Shipping to manage customer information and process an order. Hands-on exercises give students an opportunity to experience working through each component of customer management and order processing.