Oracle Training: Course Outline

Section One

1)      Environment

a)       Tools

i)        Oracle Instance

ii)       SQL Navigator

iii)     Putty

iv)     WinSCP

v)       DataLoad

b)      LMS Review

2)      E-Business Suite Concepts

3)      User Interface

4)      Company Overview

5)      System Administration

a)       Setup

i)        Menus

ii)       Responsibilities

iii)     Users

iv)     Profile Options

b)      Administration Queries

6)      General Ledger

a)       Setup

i)        Chart of Accounts

(1)    Load Values (DataLoader)

ii)       Cross Validation Rules

iii)     Calendar

iv)     Currency

v)       Legal Entities

vi)     Assign Ledger

vii)   Profile Options

viii)  Open Period

ix)     Create FSG

b)      Transactions

i)        Enter Journals

ii)       Reverse Journals

iii)     Post Journals

iv)     Run Financial Report

v)       Upload Journal WebADI

c)       Diagnostics and Queries

i)        GL Schema Review

ii)       Diagnostics

iii)     Basic Queries

7)      Setup Multi-Org

a)       Setup

i)        Locations

ii)       Business Group

iii)     Organizations

iv)     Organization Relationships

v)       Responsibility Profile Options

vi)     Run Replicate Seed Data

vii)   Application Profile Options

viii)  Run Multi-Org Setup Validation Report

8)      Cash Management

a)       Setup

i)        Bank Account Maintenance and Access Security

ii)       Choose Primary Ledger (Payables)

iii)     Account for Payment (Payables Options)

iv)     Open Payables Accounting Periods

v)       Choose Primary Ledger (Receivables)

vi)     Open Receivables Accounting Periods

vii)   Receipt Class Miscellaneous Receipts

viii)  Receipt Activity Miscellaneous Transactions

ix)     Define Bank Accounts

x)       Define System Parameters

b)      Diagnostics and Queries

i)        AP Schema Review

ii)       Diagnostics

iii)     Basic Queries

9)      Payments

a)       Setup

i)        Payment Format Template

ii)       Payment Format

iii)     Payment System

iv)     Payment Template

b)      Diagnostics and Queries

i)        AP Schema Review

ii)       Diagnostics

iii)     Basic Queries

10)  E-Business Tax

a)       Setup

i)        Tax Regimes

ii)       Tax Jurisdictions

iii)     Taxes

iv)     Tax Status

v)       Tax Rates

b)      Diagnostics and Queries

i)        AP Schema Review

ii)       Diagnostics

iii)     Basic Queries

11)  Accounts Payable

a)       Setup

i)        Choose Ledger

ii)       Set Profile Options

iii)     Payables Lookups (Default)

iv)     Purchasing Lookups (Default)

v)       Payment Options

vi)     Expense Template

vii)   Suppliers

b)      Transactions

i)        Invoice

(1)    Enter Invoice

(2)    Reverse Invoice

(3)    Cancel Invoice

(4)    Invoice with Taxes

(5)    Invoice with Assets

(6)    Adjust

(7)    Validate Invoice

(a)    Individual

(b)    Program

(8)    Approve

ii)       Prepayment

(1)    Enter Prepayment

(2)    Apply Prepayment

iii)     Enter Expense Report

iv)     Recurring Invoice

(1)    Template

(2)    Create

v)       Payments

(1)    Quick Pay

(2)    Submit Payment Process Request

(3)    Cancel Payment

vi)     Create Accounting

vii)   Standard Reports

c)       Diagnostics and Queries

i)        AP Schema Review

ii)       Diagnostics

iii)     Basic Queries

12)  Accounts Receivable

a)       Setup

i)        Account Generator

ii)       System Options

iii)     Payment Terms

iv)     Open Period

v)       Define AutoAccounting

vi)     Transaction Types

vii)   Collectors

viii)  Approval Limits

ix)     Distribution Sets

x)       Receivable Activities

xi)     Receipt Classes

xii)   Receipt Methods

xiii)  Receipt Sources

xiv)  Salespersons

xv)    System Profile Options

xvi)  Customer Profile Options

xvii)            Customer Profile Classes

xviii)          Customers

xix)  Remit-to Addresses

b)      Transactions

i)        Enter Invoices

ii)       Enter Commitments

iii)     Complete Transactions

iv)     Copy Invoice

v)       Adjust Invoice

vi)     Enter Credit Memos

vii)   On-Account Credit Memos

viii)  Enter Receipts

ix)     Applying Receipts

x)       Reverse Receipt

xi)     Reapply Receipt

xii)   Create Accounting

xiii)  Standard Reports

c)       Diagnostics and Queries

i)        AR Schema Review

ii)       Diagnostics

iii)     Basic Queries

Section Two

13)  Purchasing

a)       Setup

i)        Human Resources Key Flexfield

ii)       Inventory Key Flexfields

iii)     Units of Measure

iv)     Freight Carriers

v)       Categories

vi)     Personnel

vii)   Oracle Workflow

viii)  Account Generator

ix)     Financial Options

x)       Approval Information

xi)     Lookups

xii)   Buyers

xiii)  Start Purchasing Database Administrator

xiv)  Purchasing Options

xv)    Receiving Options

xvi)  Transaction Managers

xvii)            Suppliers

xviii)          Workflow Options

xix)  Submit Workflow-Related Processes

xx)    Open Inventory and Purchasing Periods

xxi)  Additional SYSADMIN Setup

xxii)Manufacturing System and User Profiles

b)      Transactions

i)        Create Requisition Template

ii)       Enter Requisition

(1)    Cancel Requisition

(2)    Approve Requisition

iii)     Create Standard PO

(1)    Cancel Requisition

(2)    Approve Requisition

(3)    Copy PO

iv)     Create Blanket PO

(1)    Create Release

v)       Create Contract PO

vi)     Create RFQ

vii)   Create Quotation

(1)    Enter Approve

viii)  Setup Automatic Sourcing

ix)     Create Approved Supplier List

x)       AutoCreate PO

xi)     Receiving

(1)    Enter Receipts

(2)    Enter Returns

(3)    Deliver Receipts

(4)    Enter Corrections

xii)   Review Accounting

xiii)  Standard Reports

xiv)  Accounts Payable

(1)    Matching to PO in AP

(2)    Create a Quick Invoice from PO

c)       Diagnostics and Queries

14)  Fixed Assets

a)       Setup

i)        Asset Key Flexfield

ii)       Asset Category Flexfield

iii)     Location Flexfield

iv)     System Controls

v)       Fiscal Years

vi)     Calendars

vii)   Book Controls

viii)  Depreciation Methods

ix)     Prorate Conventions

x)       Retirement Conventions

xi)     Asset Categories

b)      Transactions

i)        Additions

(1)    Manually Add an Asset

(a)    Quick Additions

(b)    Detail Addition

(2)    Mass Addition

(a)    WebADI

(b)    Invoice

(c)     Review

(d)    Merge

(e)    Split

(f)      Post

(g)    Delete

ii)       Maintenance

(1)    Adjust Accounting

(2)    Asset Details

(3)    Transfer

iii)     Retirements

iv)     Depreciation

(1)    Run

(2)    Rollback

v)       Create Accounting

vi)     Reporting

c)       Diagnostics and Queries

i)        FA Schema

ii)       Diagnostics

iii)     Basic Queries

15)  Internet Procurement

a)       Setup

i)        Requisition Templates

ii)       Information Templates

iii)     Function Security

iv)     Personalization

v)       OU Purchasing News

vi)     Customize Workflows

vii)   Descriptive Flexfields

viii)  Profile Options

ix)     Load Catalog

x)       Determine Catalog Type

xi)     Create Catalog Content Zone

xii)   Suggested Buyer

xiii)  One-Time Address

xiv)  PO Grouping

xv)    Global Requester

b)      Transactions

i)        Requisitions

(1)    Create

(2)    Receive

(3)    Correct

(4)    Cancel

(5)    Approve

(6)    Copy

(7)    Cancel

ii)       Standard Reports

c)       Diagnostics and Queries

i)        iPO Schema

ii)       Diagnostics

iii)     Basic Queries

16)  Internet Expenses

a)       Setup

i)        Job

ii)       Position

iii)     Employees

iv)     Financial Options

v)       Expense Template

vi)     Expense Fields

vii)   Payable Options

viii)  Cost Center Flexfield Qualifier

ix)     Signing Limits

x)       Profile Options

b)      Transactions

i)        Expense Report

(1)    Enter

(2)    Adjust

(3)    Approve

(4)    Import

(5)    Copy

(6)    Cancel

ii)       Pay Expense

iii)     Standard Reports

c)       Diagnostics and Queries

i)        iExp Schema

ii)       Diagnostics

iii)     Basic Queries

Section Three

17)  Inventory

a)       Setup

i)        Item Flexfield

ii)       Item Categories Flexfield

iii)     Item Catalog Flexfield

iv)     Stock Locator Flexfield

v)       Account Alias Flexfield

vi)     Sales Order Flexfield

vii)   Organizations

viii)  Organization Parameters

ix)     Change Organization

x)       Intercompany Relations

xi)     Receiving Options

xii)   Unit of Measure Classes

xiii)  Subinventories

xiv)  Item Attribute Controls

xv)    Define Categories

xvi)  Define Category Sets

xvii)            Define Statuses

xviii)          Item Templates

xix)  Items

xx)    Cost Types

xxi)  Freight Carriers

xxii)Accounting Periods

xxiii)           Profile Options

xxiv)           Launch Transaction Managers

b)      Transactions

i)        Receiving

ii)       Transfer

iii)     Subinventory Transfer

iv)     Cost Update

v)       Issue from Stores

vi)     Receive into Stores

vii)   Purchase an Item

viii)  Receive an Item

ix)     View Material Transactions

x)       View Accounting Distributions

xi)     Miscellaneous Receipts

xii)   Miscellaneous Issues

xiii)  View On-Hand Quantity

xiv)  Move Orders

xv)    ABC Analysis

xvi)  Cycle Counting

xvii)            Physical Inventory

xviii)          Intercompany Transactions

xix)  Standard Reports

c)       Diagnostics and Queries

i)        INV Schema

ii)       Diagnostics

iii)     Basic Queries

18)  Order Management

a)       Setup

i)        Key and Descriptive Flexfields

ii)       Profiles

iii)     System Parameters

iv)     Invoicing Information

v)       Tax Features

vi)     Sales Representatives

vii)   Quickcodes

viii)  Header and Line Processing Flows

ix)     Document Sequences for Order Numbering

x)       Order Import Sources

xi)     Item Information

xii)   Items

xiii)  Configurations (BOM)

xiv)  Price Lists

xv)    Customer Profile Classes

xvi)  Customer Information

xvii)            Item Cross-References

xviii)          Order Management Transaction Types

xix)  Cost of Goods Sold Account Flexfield

xx)    Credit Checking Rules

xxi)  Automatic Holds

xxii)Shipping Parameters

b)      Transactions

i)        Sales Order

(1)    Enter

(2)    Update

(3)    Cancel

ii)       Import Sales Order (AR)

iii)     Standard Reports

c)       Diagnostics and Queries

i)        OM Schema

ii)       Diagnostics

iii)     Basic Queries