Course Category: Oracle

Module 1: Examining the Role of Oracle OLAP within the Oracle BI / DW Platform Module 2: Understanding the Dimensional Model Module 3: Building OLAP Cubes Module 4: Examining Cube-Organized Materialized Views (Cube MVs) Module 5: Creating Calculated Measures Module 6: Using SQL to Query Oracle OLAP Cubes Module 7:…

Module 1: Introduction Module 2: Data Warehouse Design: Overview Module 3: Data Warehouse Tuning Considerations Module 4: Partitioning Basics Module 5: Parallelism Concepts Module 6: Parallel Operations in Data Warehouses Module 7: ETL: Extraction and Transportation Module 8: ETL: Loading Module 9: ETL: Transformation Module 10: Materialized Views Module 11:…

Module 1: Introduction Module 2: Overviewing Data Mining Concepts Module 3: Understanding the Data Mining Process Module 4: Introducing Oracle Data Miner 11g Release 2 Module 5: Using Classification Models Module 6: Using Regression Models Module 7: Performing Market Basket Analysis Module 8: Using Clustering Models Module 9: Performing Anomaly…

Module 1: Administrative Tasks in Warehouse Builder Module 2: Managing Metadata Module 3: Accessing Non-Oracle Sources Module 4: Designing Mappings with the Oracle Data Integration Enterprise Edition License Module 5: Right-Time Data Warehousing with OWB Module 6: Defining Relational Models Module 7: More Relational Dimensional Modeling Module 8: Modeling Multidimensional…

Module 1: Introduction Course Objectives Suggested Course Prerequisites Suggested Course Schedule Class Sample Schemas Practice and Solutions Structure Review location of additional resources Module 2: Predictive Analytics and Data Mining Concepts What is the Predictive Analytics Introducting the Oracle Advanced Analytics (OAA) Option What is Data Mining Why use Data…

Overview of Oracle Asset Management E-Business Suite Integration Implementation Considerations for Oracle Financials Oracle Assets Setup Steps Implementing Oracle Assets Adding Assets Manually Mass Asset Additions Acquire and Build CIP Assets Reconciling Data in Oracle Assets Asset Controls Setup Oracle Assets Setup Steps Setup Steps Flow Setting Up Key Flexfields…

Oracle Cash Management Overview Describing the bank account model Describing the key concepts of reconciling bank accounts Explaining the key concepts of cash pools, cash positioning, and cash forecasting Cash Management Security Explaining how security works in Oracle Cash Management Creating security profiles Creating security grants Setting Up Oracle Cash…

Procure to Pay Overview Describing the Procure to Pay Process Flow Describing how the Procure to Pay Process Fits Across the eBusiness Suite Applications Payables Overview Overview of Payables Processes Understanding Supplier Entry Understanding Invoice Entry Understanding Payments Analyzing Payables Integration Points Using Payables Open Interfaces to Import Data Suppliers…

Order to Cash Lifecycle Overview Describing the overall Order to Cash Process from Order Entry through Bank Reconciliation Discussing the key areas in the Order to Cash Life Cycle Describing the integration between the applications Overview of Oracle Receivables Process Explaining where the Receivables processing is positioned within the Order…

Overview of Subledger Accounting What Is Subledger Accounting? Introduction to Subledger Accounting What Is a Subledger? Create Accounting and Transfer Journal Entries to General Ledger Create Accounting Program Overview Draft Accounting and Online Accounting Straight-Through Accounting Transfer Journal Entries to GL Program Overview Transfer Journal Entries to General Ledger Program…

Oracle BI 12c New Features Overview Invoking WebLogic Scripting Tool (WLST) from a Single Location Redefining the Oracle Home Location OPMN is No Longer Used in Fusion Middleware Using New Commands For Process Control Using BAR Files to Move Between Environments Singleton Data Dictionary Scaling Out and Shared Storage Upgrading…

Enhancing Presentation Services Enhancements to Analyses Enhancements to Dashboards Enhancements to Presentation Services Administration New Features in Security New Privileges New BI Desktop Tools Oracle BI Mobile and BI Mobile App Designer Enhancements to Oracle BI Mobile – Android and Apple iOS BI Mobile App Designer Creating a Mobile App…

Repository Basics Building the Physical Layer of a Repository Building the Business Model and Mapping Layer of a Repository Building the Presentation Layer of a Repository Testing and Validating a Repository Managing Logical Table Sources Adding Calculations to a Fact Working with Logical Dimensions Using Aggregates Using Partitions and Fragments…

Introduction to Oracle Business Intelligence Enterprise Edition, Working with Oracle Business Intelligence Analyses, Filtering Data for Analyses, Selecting and Grouping Data in Analyses, Adding Views to Analyses, Showing Results with Pivot Tables, Working with Additional Views in Analyses, Visualizing Data: Gauges and Maps, Scorecards and Key Performance Indicators, Measuring Results…

Overview of Oracle Order Management Overview of Oracle Order Management What is Oracle Order Management? Order Capture and Order Fulfillment Oracle Order Management Capabilities Order to Cash Lifecycle Integration with Other Products Order Entities and Order Flows Order to Cash Lifecycle with Standard Items Order to Cash Lifecycle with PTO…

Procure To Pay Lifecycle Overview Understanding Procure to Pay Lifecycle Understanding Oracle Procure to Pay Process Oracle Purchasing Overview Understanding Purchasing Process Requisition to Purchase Order Overview of the Ordering Process The Receiving Process Purchasing Integration Enterprise Structure – Locations, Organizations, and Items Understanding the Enterprise Structure Defining Locations Defining…

Overview of Oracle Inventory Receiving Inventory Transferring Inventory On-hand and Availability Issuing Inventory Inventory Accuracy Discussing Inventory Application Integration Defining Inventory Organizations Overview of Inventory Structure Setting up the Inventory Organization Structure Defining Organization Parameters Defining Subinventories and Locators Units of Measure Defining Units of Measure Defining and Maintaining Items…

Oracle Inventory New Features Defining Process Manufacturing Options on the Process Manufacturing tab (Master Item window) Material Workbench Enhancements Performing a Status Update (Under ERES Approval Status) ERES Approval: Online and Deferred Mode Using On-hand Material Status Using Global Lot Attributes Lot Genealogy Enhancements Enhanced Reservations Additional Oracle Inventory New…

Oracle E-Business Tax Overview Oracle E-Business Tax Basic Tax Configuration Setting Up Tax Rules Configuration Owners and Event Class Settings Managing Party Tax Profiles Configuration Owners and Service Providers Fiscal Classifications Example: Determining Tax Rule Components Based on Tax Regulations Tax Recovery, Self-Assessment, and Offset Taxes Managing Taxes on Transactions…

Understanding the eBusiness Suite Key Business Flows and Integration Points Between Products in the R12 eBusiness Suite Understanding the Accounting to Financial Reporting Business Flow Steps to Complete the Accounting Cycle Using Oracle General Ledger How Oracle General Ledger Integrates with Other Oracle eBusiness Applications The Accounting to Financial Accounting…

Workflow Processes Planning a Workflow Process Diagramming a Workflow Process Defining Item Type Attributes and Lookup Types Defining Messages and Notification Activities Defining Function Activities Post-Notification Functions Defining Event Activities Monitoring Workflow Processes Testing Workflow Processes Reviewing the Status of Workflow Processes Specialized Workflow Monitoring Workflow Notifications Viewing and Responding…

Oracle E-Business Suite Overview, Preparing For Your Installation, Performing an Installation, Finishing Your Installation, Oracle E-Business Suite Components,Environment Files, Control Scripts, and Languages, Oracle E-Business Suite File System, Oracle E-Business Suite Database, Advanced Configuration Options, Using the AD Utilities, AD Administration: Generate Applications Files Tasks, AD Administration: Maintain Applications Files…

Oracle E-Business Suite System Administrative Responsibilities System Administrative Responsibilities System Administration Responsibility System Administrator Responsibility Functional Administrator and Functional Developer Responsibility Integrated SOA Gateway Responsibility Oracle E-Business Suite Security Successive Layers of Access Control Function Security Data Security Role Based Access Control (RBAC) Delegated Administration Simplified User Management Function Security…

Oracle E-Business Essentials for Implementers: Overview  Objectives Course purpose More help about documentation and other resources OU courses Summary Navigating in Oracle Applications Logging into and logging off from Oracle Applications Accessing Responsibilities Using forms & menus Data Flow Across Oracle Applications Entering data using forms Retrieving, Editing and Deleting…