Course Duration in Hours
120
120
1) R12.1 Oracle E-Business Essentials for Implementers: Overview
Objectives
Course purpose
Navigating in R12.1 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 records
Accessing Online Help
Running reports and programs
Introduction to R12.1 Oracle Applications
Introduction to R12.1 Footprint
Benefits of R12.1 Footprint
R12.1 E-Business Suite Architecture
Fundamentals of System Administration
Application Security Overview
Function Security
Data Security
Profile Options
Standard request submission (SRS)
Fundamentals of Flexfields
Basics of Flexfields
Define Value sets
Define Key Flexfields
Define Descriptive Flexfields
Planning Decisions
Flexfield Enhancements
Shared Entities and Integration
Shared entities and non-key shared entities
Overview of E-Business Suite business flows and integration
Fundamentals of Multiple-Organization and Multiple-Organization Access Control (MOAC)
Introduction to Multiple-Organization and Multiple- Organization Access control (MOAC)
Types of organizations supported in the Multi-Org model
Multiple-Organization Access Control Setup and Process
2) R12.x Oracle Financial Applications Overview
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
How Oracle General Ledger Integrates with Other Oracle eBusiness Applications
The Accounting to Financial Accounting Business Flow
Understanding the Procure to Pay Business Flow
Key Areas in the Procure to Pay Process
How the Procure to Pay Process Fits Into the Oracle eBusiness Suite of Applications
Understanding Suppliers
Setting up New Suppliers
Identifying Supplier-related Implementation Considerations
Understanding the Order to Cash Flow Business Flow
The Order to Cash and Click to Cash Process Flows
Key Areas in the Order to Cash Cycle
How the Order to Cash Process Fits into the Oracle eBusiness Suite
Understanding Customers
The Party Model
Setting up New Customers
Customer-related Implementation Considerations
3) R12.x Oracle General Ledger Management Fundamentals
Oracle General Ledger Process
Understanding the General Ledger Functions and Features
Analyzing the General Ledger Accounting Cycle
Reviewing General Ledger Integration Points
Generating Standard Reports and Listings
Ledger
Describing the Elements Required to Define Ledgers
Identifying Attributes, Options and Settings to Define the Accounting Flexfield
Defining an Accounting Calendar
Using Accounting Setup Manager
Creating Accounting Setups
Creating Accounting Setup Structures
Completing Accounting Options
Analyzing Reporting Currencies
Basic Journal Entries
Describing how Journal Entries are Positioned in the Accounting Cycle
Identifying Attributes, Options and Settings to Define the Accounting Flexfield
Defining an Accounting Calendar
Creating Manual Journal Entries
Posting Journal Entries
Performing Accounting Inquiries
Performing Drilldowns to Oracle Sub-ledger applications
Creating Reversing Entries
Summary Accounts
Understanding how Summary Accounts are used in General Ledger
Defining Rollup Groups for Creating Summary Accounts
Assigning Parent Values to Rollup Groups
Entering Summary Account Templates
Discussing Implementation Considerations
Advanced Journal Entries
Understanding Recurring Journals
Understanding Mass Allocation Journals
Understanding Journal Approval
Advanced Security
Describing Data Access Security for Legal Entities and Ledgers
Understanding Management Reporting and Security
Financial Budgeting
Understanding Anatomy of a Budget
Completing the Budget Accounting Cycle
Discussing Budget Entry Methods
Uploading Budget Amounts
Transferring Budget Amounts
Freezing and Unfreezing Budget Amounts
Multi-Currency
Defining Foreign Currencies
Entering Foreign Currency Journals
Revaluing Foreign Currency Balances
Translating Balances Into Foreign Currency
Period Close
Understanding the Accounting Cycle
Understanding Steps in the Close Process
Performing Journal Import of Sub-ledger Balances
Generating Revaluation
Understanding the Closing Period
Consolidating Account Balances
4) R12.x Oracle Payables Management Fundamentals
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
Suppliers
Understanding the Procure to Pay Lifecycle
Defining Supplier and Supplier Sites
Identifying the Key Reports
Understanding Setup Options
Analyzing Implementation Considerations
Invoices
Entering Invoices and Invoice Distributions
Matching Invoices to Purchase Orders
Validating Invoices
Applying and Releasing Holds
Generating Key Reports
Analyzing Setup Options
Analyzing Implementation Considerations
Payments
Describing the Payments Process
Setting Up Banks and Bank Accounts
Entering Single Payments
Processing Multiple Payments
Understanding how to Review Payments
Understanding how to Adjust Payments
Creating, Applying, and Releasing Holds on Prepayments
Period Close
Describing the Period Closing Process in Payables
Describing the Period Closing Process in Purchasing
Reconciling Payables Transactions for the Period
Identifying Key Programs and Reports
Understanding Setup Options
Understanding Implementation Considerations
1099 Reporting
Describing How to Enable 1099 Suppliers
Entering Invoices for 1099 Suppliers
Updating the 1099 Information
Understanding the 1099 Setup Options
Understanding Implementation Considerations
Transaction Taxes in Payables
Describing how Transaction Taxes are Calculated
Inserting Manual Tax Lines
Updating Transaction Tax Lines
Viewing Tax Summary and Details
Identifying Key Reports
Understanding Setup Options
Withholding Tax
Identifying the Withholding Tax Process
Using Withholding Tax Options
Processing Manual Withholding Tax Invoices
Creating Withholding Tax Invoices
Processing Automatic Withholding Tax Invoices
Analyzing Standard Key Reports
5) R12.x Oracle Asset Management Fundamentals
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
Location Key Flexfield
Creating Key Flexfield Combinations
Specifying System Controls
Setting Up Asset Calendars
Maintaining an Audit Trail
Asset Books
Asset Books Regions
Calendar Region
Accounting Rules Region
Organizations and Security by Book
Security by Book Setup Steps
Troubleshooting Security by Book
Implementation Considerations for Security by Book
Asset Categories
Asset Categories Positioning
Asset Categories Regions
Asset Categories Setup
Manual Asset Additions
Asset Life Cycle
Adding Assets Manually
Detailed Asset Additions
Asset Cost Terminology
Accumulated Depreciation Considerations
Manual Asset Additions Journal Entries
Mass Asset Additions
Mass Asset Additions Process
Using the Mass Additions Interface Table
Tracking Expensed Items in Oracle Assets
Changing Asset Information
Accounting for Cost Adjustments
CIP Asset Additions
Adding and Capitalizing a CIP Asset
Acquire and Build CIP Assets
Modifying the Cost of CIP Assets
Recording a CIP Asset Addition
Capitalizing a CIP Asset
Reversing a Capitalized Asset
Asset Adjustments and Maintenance
Single Asset Reclassification
Mass Reclassification
Inheriting Depreciation Rules
Choosing to Expense or Amortize Depreciation Adjustments
Amortizing Adjustments Using a Retroactive Start Date
Asset Revaluation
Depreciation
Elements of Depreciation
Depreciation Setup Areas
Basic Depreciation Calculation
Depreciation Methods
Entering Production Information
Prorate Conventions
Run Depreciation Process
Depreciation Forecasts
Asset Retirements
Tracking Asset Retirements
Overview of Retiring an Asset
Restrictions on Retirements and Reinstatements
Reinstating Retired Assets
Retirement Processing Flow
Recording Retirements
Retirement Reports
Calculating Gains and Losses
Asset Accounting
Setting Up Asset Accounting
Oracle Subledger Accounting
Assets Journal Entries Flow
Reconciling Data in Oracle Assets
Generating Reports to Reconcile to the General Ledger
Reconciling Asset Cost Accounts
Reconciling Mass Additions
Asset Inquiry and Reporting
Viewing Asset Information Online
Types of Asset Inquiries
Oracle Assets Reporting
6) R12.x Oracle Receivables Management Fundamentals
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 to Cash Life Cycle
Describing the overall Receivables Process
Discussing the key areas in the Receivables Process
Manage Parties and Customer Accounts
Defining the Features to Enter and Maintain Party and Customer Account Information
Creating and Maintaining Party and Customer Account Information
Enabling Customer Account Relationships
Defining TCA Party Paying Relationships
Viewing Party and Customer Account Information
Process Invoices Using Auto-Invoice
Describing the Auto-Invoice Process
Using Auto-Invoice
Correcting Errors Using Auto-Invoice Exception Handling
Process Invoices
Describing How Processing Invoices Fits into the Receivables Process
Entering and Completing Invoices
Correcting Invoices
Demonstrating Promised Commitment Accounts
Receipts
Describing the Receipt Process
Applying Receipts Using Different Methods
Creating Charge-backs, Adjustments, and Claims
Implement Receipts
Entering Setup Information for Receipts
Discussing the Implementation Considerations
Tax Processing
Understanding the Tax Accounting Process
Understanding Oracle E-Business Tax Setups for Receivables
Managing Tax Accounts and Tax Adjustments
Period Closing
Understanding Sub-ledger Accounting Related to Period Closing
Defining Various Actions Required to Close a Period in the Order to Cash E-Business Flow
Describing Available Reports Assisting in the Closing Process
Explaining How to Run the Revenue Recognition Program and the General Ledger Interface Program
7) R12.x Oracle Cash Management Fundamentals
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 Management
Describing how to set up Oracle General Ledger
Describing how to set up related applications
Describing how to set up Oracle Cash Management
Creating Bank Accounts
Defining banks
Defining bank branches
Creating bank accounts
Defining bank transactions codes
Defining bank account signing authorities
Bank Transfers
Describing how to set up bank transfers
Creating a bank transfer
Settling a bank transfer
Creating a bank account transfer template
Reconciling Bank Statements
Reconciling bank statements manually
Clearing and unclearing transactions
Transferring bank reconciliation transactions to your general ledger
Cash Forecasting
Defining a cash forecast template
Generating a cash forecast
Modifying a cash forecast
Exporting a cash forecast to your spreadsheet application
Identifying implementation considerations
Using cash forecasting reports
Accounting Events
Describing the accounting flow in Oracle Cash Management
Describing the key concepts of Oracle Subledger Accounting
Describing how to set up Oracle Subledger Accounting for Cash Management
Creating manual journal entries
any
Three Spear, BTM Ist Stage (Bangalore),Bangalore,IN