Oracle E-Business Fundamentals
E-Business Suite
- Benefits of E-Business Suite
- Business architecture of E-Business Suite and the design principles on which it is based
- Technical architecture, including the components involved in communications between the desktop tier, Application tier and the database tier
Shared Entities and Integration
- Shared entities
- Individual shared entities owned by various modules
- Key business flows in E-Business Suite (e.g.: Order to Cash, Procure to Pay) and the modules involved
- Integration points between modules related to the business flow
Fundamentals of Multi-Org
- Multi-Org and identify the modules that have Multi-Org capabilities
- Identify the business needs which can be addressed with multi-org enhancement
- components of a multi-org organizational model
- balanced entities and explain when they should be used.
- Explain data security in multi-org
- different levels of cross-organizational reporting
- Identify the benefits of cross-functional reporting
- Enable Multi-org and add to the organization structure
Fundamentals of Flexfields
- Flexfields
- Explain the benefits of flexfields
- Classify types of flexfields
- Compare features of key and descriptive flexfields
- Explain coponents of key and descriptive flexfields
- validation of input using value sets
- types of value set
- Define and enter values in a value set
- Plan and define key flexfields
- Plan and define descriptive flexfields
Fundamentals of System Administration
- E-Business Suite security model
- Define new application users
- a responsibility and its components
- Define a new responsibility using menu exclusions
- Discuss securing and exclusion attributes
- Define a menu structure
- profile hierarchy types
- Set profile options
Fundamentals of Workflow & Alerts
- Discuss the advantages of a workflow-driven business process
- Explain the components that make up workflow architecture
- Explain the Business event system functions
- Explain the Business event system architecture
- Monitor a workflow-based business process
- key implementation considerations for workflow
- classify alerts
- Explain the difference between Alerts and Workflows
Daily Business Intelligence (DBI)
- features of Daily Business Intelligence
- Explain the relationship of Daily Business Intelligence to the E-Business Suite
- components of a DBI report
Oracle General Ledger
Oracle General Ledger Process
- Oracle General Ledger Overview
- General Ledger integrates with other Oracle eBusiness applications
- Implementation considerations for setting up and using Oracle General Ledger and the Oracle eBusiness Suite
- Functions and Features of Oracle General Ledger
Set of Books
- Elements required to create a set of books within Oracle General Ledger
- Creating a Set of Books
- Attributes, options and settings required to define the Accounting Flexfield
- Define an accounting calendar and enable predefined currencies
- Create a set of books in Oracle General Ledger
- Utilize the Account Hierarchy Editor feature of Applications Desktop Integrator to view and maintain Accounting Flexfield values
Basic Journal Entries
- how journal entries are positioned in the accounting cycle
- Identify the types of journal entries
- Create manual journal entries
- Post journal entries using various posting options
- Perform account inquiries
- Perform drilldowns to Oracle subledger applications
- Create reversing entries
- Use ADI to create journal entries
- Import journal entry information using the GL_INTERFACE
- setup options available to process journal entries
- Identify reports, listings and inquiry options available for journal entries
- Identify the profile options necessary to process journal entries
- Identify the key implementation issues regarding journal entries and General Ledger
- Identify the key elements of Applications Desktop Integrator (ADI)
- Setup ADI security
- Setup database connections
- Setup the ADI toolbar, general ledger and language options
- Identify ADI profile options
- Perform ADI diagnostic system checks
Summary Accounts
- summary accounts and how they are used in General Ledger
- difference between Summary accounts and Parent values
- Define rollup groups for summary account creation and assign parent values to rollup groups
- Determine the number of summary accounts created by a template using a specific formula
- Enter summary account templates to create summary accounts
- Maintain summary accounts
- key implementation considerations in planning summary accounts
Advanced Journal Entries
- Create and generate the three types of recurring Journals
- Enumerate the steps to define Mass allocations and define mass allocation journals
- Features of AutoAllocations
- AutoScheduling and Journal Scheduling
- Features and process of Journal Approval
- Identify the key issues and considerations when implementing the Auto Allocation workbench and Journal Entry Automation
Intercompany
- Solutions to account for intercompany transactions
- Set up steps for Intercompany Accounting
- Enter Intercompany Transactions
Global Intercompany System
- GIS (Global Intercompany System)
- Set up GIS Subsidiaries
- Create GIS Transaction Types
- Define GIS Clearing Accounts
- Define Autoaccounting Rules
- Enter and report on GIS Transactions
Financial Budgeting
- Explain the anatomy of a budget
- Enumerate the budget accounting cycle
- Define a budget and budget organization
- Enumerate the budget entry methods
- Apply budget rules and enter budget journals
- Perform transfer of budgets
- Freeze and unfreeze budgets and Review and correct budgets
- Translate budget balances
- Perform budget inquiry
- Review balances in Master/Detail budgets
- Create a budget worksheet in Budget Wizard
- Upload budgets from Budget Wizard and external sources
- budget reporting methods
- List standard budget reports
- Plan budget implementation requirements
Multi-Currency
- foreign currency concepts
- Explain Multiple Currency Accounting
- List the steps that need to be completed before entering foreign currency transactions
- Enter foreign currency journals and explain conversion
- Revalue foreign currency balances
- Explain MRC Revaluation against Primary Currency Description
- Currency rates manager
- Translate functional balances into foreign currency
- Set up and Secondary tracking segment
- Foreign currency Listings and reports and MRC profile options
Consolidations
- Explain Consolidations and Consolidation tools
- Identify the key implementation issues regarding consolidations
- Identify the features and functionality of Global Consolidation System (GCS)
- Interface data Transformer with examples
- elements of the Consolidation Workbench
- Define consolidation mapping
- List the steps to be done before transferring balances from subsidiary set of books
- Create eliminating entries
- Identify reports and inquiry options available for consolidations
Period Close
- Explain the accounting cycle
- Identify steps in the close process
- Perform journal import of subledger balances
- Reconcile to the subledger: P2P Period Close and reports
- Reconcile to the subledger: O2C Period Close and reports
- Reconcile to the subledger: Projects Period Close
- Run revaluation
- Close the period
- Consolidate account balances
- Inquire and run reports on final balances
Financial Reporting
- Explain Online Enquiry and Standard Reports and Listings
- Identify the basic report building concepts
- Explain the elements of the Financial Statement Generator (FSG necessary to create financial reports
- Create basic FSG report definitions
- Identify listing reports available for FSG report definitions
- Identify profile option settings required to implement financial reporting
- Utilize the Report Wizard of ADI to create FSG report definitions
- Utilize the ADI Request Center to submit and publish financial reports
- Utilize the ADI Analysis Wizard to view account balance and detail information
- Explain other reporting tools (Discoverer, OFA, E-Business Intelligence, Rxi reports)
- XBRL Reporting language
- Identify the key implementation issues regarding Oracle General Ledger financial reporting
Oracle Payables
Procure to Pay Lifecycle Overview
- key areas in the procure to pay process
- how the procure to pay process fits into the Oracle eBusiness suite of applications
Payables Overview
- key areas in the Payables process
- Identify Payables integration points
- Explain Payables open interfaces
Suppliers
- Set up and Define suppliers
- Set up and Define supplier sites
- Adjust supplier details
- key reports
- Explain and setup Financials Options
- Explain and setup Payable Options
- Setup Lookup codes and Profile options
- Explain additional implementation considerations
Invoices
- Import/Enter invoices
- Create Invoice Batches and enter Invoice Header and Distributions and enter Recurring Invoices
- Apply prepayments and advances
- Match to purchase orders
- Apply and release holds
- Explain invoice approval workflow
- Validate invoices for payment
- types of accounting flows
- Explain key reports
- Identify and set up Profile Options, and Financials, Purchasing and Payables options specific to Invoices
- Explain additional implementation considerations
Quick Invoices
- and use Quick Invoices
- Enter invoice records
- Enter purchase order matched invoice records
- Enter price corrections
- Find and modify invoice records
- Add invoice records to an existing Quick Invoices Batch
- Create invoices from quick invoice records
Payments
- process of issuing payments
- Payment workbench, and identify the Payment methods and disbursement types
- Set up bank accounts
- Create and Process Manual and Quick Payments and process refunds
- Process payment batches
- Process stop and void payments
- Identify key reports
- Identify and set up Financials and Payables options specific to Payments
- Explain additional implementation considerations
- Explain Internal Controls for Payment processing and Integration Partners for check printing
Expense Reports and Credit Cards
- Expense report process
- Enter expense report templates
- Enter expense reports and apply holds
- Apply advances, modify, review and Pay expense reports
- Run Expense Report Import program and purge Expense Reports
- Identify key expense related reports
- Procurement Cards Process flow
- Set up credit card programs
Period Close
- period closing process in Payables and Purchasing
- Identify the activities in the period close process
- Reconcile accounts payable transactions for the period and close the PO period
- Identify Key accounts and accrual accounting for Period end
- Identify key reports
- Setup Financials, Purchasing and Payables options relevant to Period close
- Explain additional implementation considerations
Invoice Tax
- Set up supplier tax information
- supplier and supplier sites regions relevant to Taxes
- Identify tax validations
- Enter tax types tax codes, and tax groups including Offset, VAT and use taxes
- Submit invoice validations
- Use tax control methods
- Identify tax code defaults and deriving tax from a natural account
- Identify 1099 reportable suppliers and related reports
- Identify key standard reports
Withholding Tax
- Define Withholding tax
- Setup withholding tax options and define withholding tax codes and groups
- Process manual withholding tax invoices and create withholding tax invoices
- Process automatic withholding tax invoices
- Identify standard key reports
Oracle Receivables
Order to Cash Lifecycle
- key areas in the Order to Cash Life Cycle
- integration between the applications
- Order Receivables Process
- Receivables Process and its key areas
Manage Parties and Customer Accounts
- Create profile classes and assign them to customer accounts
- Create and maintain party and customer account information
- Define TCA party paying relationships
- Merge parties and/or customer accounts
- View party and customer account information
- Define setup options
Process Invoices Using AutoInvoice
- AutoInvoice process
- Implement AutoInvoice
- Correct errors by using AutoInvoice Exception Handling
- Match to purchase orders
Process Invoices
- Indicate where the processing of Invoices fits into the receivables process
- Enter and complete invoices
- Create Invoice Batches and View Currency details
- Enter and complete invoices
- Create Invoices with rules and run Revenue Recognition Program
- Correct Invoices: debit memo, credit memo, make adjustments and on-account credits, create refunds, void transactions
- Define Transaction types
- Print Transactions and Consolidated Billing
- Use event-based revenue management
- Identify XML receivables documents
- promised commitment accounts
Bill Presentment Architecture
- Explain bill presentment architecture processes
- Register data sources
- Create templates to present bills
- Define rules to assign templates to customers
- Print BPA invoices
Credit Management
- Setup for credit management
- Define Customer Profile Class
- Process Credit Reviews
- Use workflow and lookups
- Review credit management performance
- Define and identify Credit hierarchy
Implement Customer Invoicing
- Enter set up information relating to invoicing
- Set up optional set ups for transactions
- major implementation considerations in customer invoicing
Receipts
- Receipt Process
- Create receipts and receipt batches
- Apply receipts using different methods
- Create Chargebacks, Adjustments and Claims
- Use balance segments
- Create and use Autolockbox
Implement Receipts
- Enter setup information relating to receipts
- Enter setup information relating to cross currency receipts and set up System and Profile Options
- Receipts implementation considerations
- Set up Lockbox Integration and Function Security
Tax Accounting Process
- Explain the Tax Accounting Process
- Define General Tax Setup Steps
- Enter Tax Adjustments
- Explain Tax Reporting Ledger
Period Closing Process
- Define the various actions required to close a period in the Order to Cash eBusiness flow
- Reconcile transactions and available reports to assist in the closing process
- Run in the Revenue Recognition program and the General Ledger interface program
Bank Reconciliation
- Explain reconciliation and the key concepts of reconciliation integration
- Set up for bank reconciliation
- Bank Statement Open Interface
- Enter bank statements manually
- Archive and purge bank statements
- Reconcile transactions automatically
- Clear and unclear transactions manually
- Record exceptions
- Explain Value Date
- bank reconciliation reports