price quote with tax calculation - global academy eg

25
ORACLE UNIVERSITY Oracle E-Business Suite - Financial Track # Course Title Hours Location 1 R12.2 Oracle E-Business Suite Fundamentals 176 Cairo-Egypt 2 R12 Oracle General Ledger Management Fundamentals 3 R12 Oracle Payables Management Fundamentals 4 R12 Oracle Subledger Accounting Fundamentals 5 R12 Oracle Receivables Management Fundamentals 6 R12 Oracle Asset Management Fundamentals 7 R12 Oracle Cash Management Fundamentals 8 R12 Oracle E-Business Tax Fundamentals Pricing Offers: For 1 trainee: 6500 EGP instead of 8000 EGP FORM 2 TO 5 Trainees: 5200 EGP instead of 6500 EGP FROM 6 TO 9 TRAINEES: 5200 EGP instead of 6500 EGP AND ONE I TRAINEE FOR FREE This price valid till 30 June 2021

Upload: others

Post on 05-Oct-2021

3 views

Category:

Documents


0 download

TRANSCRIPT

ORACLE UNIVERSITY

Oracle E-Business Suite - Financial Track

# Course Title Hours Location

1 R12.2 Oracle E-Business Suite Fundamentals

176

Cairo-Egypt

2 R12 Oracle General Ledger Management Fundamentals

3 R12 Oracle Payables Management Fundamentals

4 R12 Oracle Subledger Accounting Fundamentals

5 R12 Oracle Receivables Management Fundamentals

6 R12 Oracle Asset Management Fundamentals

7 R12 Oracle Cash Management Fundamentals

8 R12 Oracle E-Business Tax Fundamentals

Pricing Offers:

For 1 trainee: 6500 EGP instead of 8000 EGP

FORM 2 TO 5 Trainees: 5200 EGP instead of 6500 EGP

FROM 6 TO 9 TRAINEES: 5200 EGP instead of 6500 EGP AND ONE I TRAINEE FOR FREE

This price valid till 30 June 2021

1- R12.2 Oracle E-Business Suite Fundamentals

R12.2 Oracle E-Business Suite Fundamentals Ed 1 training helps you build a functional

foundation for any E-Business Suite Fundamentals course. It's ideal for those who have

implemented Oracle E-Business Suite Release 12, 12.1 or 12.2

Learn To:

Access and navigate within Oracle Applications using the user interface.

Understand major architectural components in E-Business Suite.

Identify and describe the benefits of R12.2 footprint.

Explain the basic concepts of System Administration.

Define key and descriptive Flexfields.

Recognize the different entities shared between multiple applications.

Identify features of Multiple Organizations and Multiple Organization Access

Control (MOAC).

Benefits to You

Get a sound understanding of Oracle E-Business Suite, including navigation, key business

flows, functionality, and integration points between products. Smoothly implement and

start using the applications, so that your organization can quickly realize the full value of

Oracle E-Business Suite.

Features & Benefits of Oracle Workflow

Use the Workflow Monitor to monitor a Workflow to completion.

Describe Alerts and test a Periodic Alert.

Describe the features of Oracle Business Intelligence (OBI) Applications.

Audience

End User

Implementer

Objectives

Navigate within Oracle E-Business Suite

Understand conceptually the major architectural components of E-Business Suite

Describe basic concepts of System Administration

Define key and descriptive Flexfields

Identify shared entities across E-Business Suite

Describe features and benefits of Multiple Organization Access Control (MOAC)

Create Oracle Alerts and test a Periodic Alert

Learn the key features and benefits of Workflow

Understand basic features of Oracle Business Intelligence (OBI) Applications

Topics

Oracle E-Business Essentials for Implementers: Overview

o Objectives

o Course purpose

o More help about documentation and other resources

o OU courses

o Summary

Navigating in Oracle Applications

o Logging into and logging off from Oracle Applications

o Accessing Responsibilities

o Using forms & menus

o Data Flow Across Oracle Applications

o Entering data using forms

o Retrieving, Editing and Deleting records

o Accessing Online Help

o Running reports and programs

Introduction to Oracle Applications

o Introduction to R12.1 Footprint

o Benefits of R12.1 Footprint

o R12.1 E-Business Suite Architecture

o Basic Technical Architecture

o Overview of Oracle file system and directories

o Brief Overview/Introduction about Oracle E-Business Suite Integrated SOA

Gateway

Fundamentals of System Administration

o Application Security Overview

o Function Security

o Data Security

o Profile Options

o Standard request submission (SRS)

Fundamentals of Flexfields

o Basics of Flexfields

o Define Value sets

o Define Key Flexfields

o Define Descriptive Flexfields

o Planning Decisions

o Flexfield Enhancements

Shared Entities and Integration

o Shared entities and non-key shared entities

o Overview of E-Business Suite business flows and integration

Fundamentals of Multiple-Organization and Multiple-Organization Access Control

(MOAC)

o Introduction to Multiple-Organization and Multiple- Organization Access

control (MOAC)

o Types of organizations supported in the Multi-Org model

o Multiple-Organization Access Control Setup and Process

o Reporting across entities

o Key Implementation considerations

Fundamentals of Oracle Workflow & Alerts

o Overview of Workflow

o Oracle Workflow Home Pages

o Worklist WebPages

o Workflow Monitor WebPages

o Overview of Alerts

o Difference between Workflow & Alerts

Oracle Business Intelligence (OBI) Applications: Overview

o Oracle BI Applications: Overview

o Oracle BI Applications: Multisource Analytics

o Application Integration: Security

o Application Integration: Action Links

o Guided Navigation

o Deployment Options

2- R12.2 Oracle General Ledger Management Fundamentals

This R12.2 Oracle General Ledger Management Fundamentals will help you maximize

accounting process efficiency across the enterprise, while still achieving a high level of

information and setup security. It will teach you how Oracle General Ledger integrates

with the eBusiness Suite of applications.

Learn To:

Understand the steps for completing the full accounting cycle, as well as the

ledger concept.

Describe the various implementation considerations.

Use the capabilities of securing data within Oracle General Ledger.

Perform simultaneous accounting for multiple reporting requirements.

Access and process data for multiple ledgers and legal entities at the same time

using the power of ledger sets.

Understand how Oracle General Ledger integrates with the eBusiness Suite of

applications

Understand the steps for completing the full accounting cycle

Benefits to You

Ensure a smooth, rapid implementation of Oracle General Ledger.

Better understand the steps for completing the full accounting cycle, how Oracle

General Ledger integrates with other E-Business Suite applications, as well as set-up

considerations, so that you can make improved decisions during your

implementation.

Optimize the set-up of Oracle General Ledger to help your organization

standardize accounting policies and processes while complying with global

regulatory requirements and trains end users to fully utilize all the features of

Oracle's General Ledger.

Prerequisites

Suggested Prerequisite

Understand how to navigate Oracle Applications

Have accounting knowledge

Audience

End User

Implementer

Manager

Objectives

Describe the implementation considerations

Explain how Oracle General Ledger integrates with the eBusiness Suite of

applications

Identify the steps required to complete the accounting cycle

Topics

Oracle General Ledger Process

o Understanding the General Ledger Functions and Features

o Analyzing the General Ledger Accounting Cycle

o Reviewing General Ledger Integration Points

o Generating Standard Reports and Listings

Ledger - Part 1

o Describing the Elements Required to Define Ledgers

o Identifying Attributes, Options and Settings to Define the Accounting

Flexfield

o DefininIdentify the attributes, options and settings required to define the

Accounting Flexfield

o Define an Accounting Calendar

o Enable Predefined Currencies

o Create Accounting Setuos

o Explain Reporting Currencies

o Define Accounting Options

Ledger - Part 2

o Describe Segment Value Inheritance

o Define Flexfield and Cross Validation Security Rules

o Define Shorthand Aliases

o Utilize the Account Hierarchy Manager

Advanced Security

o Describe Data Access Set Security

o Describe Management Reporting and Security

Basic Journal Entries

o Describe How Journal Entries are Positioned in the Accounting Cycle

o Identify the Types of Journal Entries

o Create Manual Journal Entries

o Post Journal Entries using Various Posting Options

o Perform Account Inquiries

o Identify the Key Elements of Web Applications Desktop Integrator (Web ADI)

o Run the Create Accounting Program

o Describe Importing Journal Entries

Summary Accounts

o Discuss Summary Accounts and How They are used in General Ledger

o Define Rollup Groups for Summary Account Creation

o Assign Parent Values to Rollup Groups

o Determine the number of Summary Accounts Created by a Template using

a Specific Formula

o Enter Summary Account Templates to Create Summary Accounts

o Maintain Summary Accounts

o Discuss Key Implementation Considerations in Planning Summary Accounts

Advanced Journal Entries

o Describe Advanced Journal Entries

o Identify the Key Issues and Considerations when Implementing the

Advanced Journal Entry functions of Oracle General Ledger

o Explain the Business Benefits Derived from utilizing Oracle General Ledger's

Advanced Journal Entries Functions

Financial Budgeting

o Understanding Anatomy of a Budget

o Completing the Budget Accounting Cycle

o Discussing Budget Entry Methods

o Uploading Budget Amounts

o Transferring Budget Amounts

o Freezing and Unfreezing Budget Amounts

Multi-Currency

o Defining Foreign Currencies

o Entering Foreign Currency Journals

o Revaluing Foreign Currency Balances

o Translating Balances Into Foreign Currency

Consolidations

o Identifying Consolidations Across the General Ledger Business Process

o Understanding Key Implementation Issues Across Consolidations

o Understanding the Global Consolidation System

o Defining the Elements of the Consolidation Workbench

Period Close

o Understanding the Accounting Cycle

o Understanding Steps in the Close Process

o Performing Journal Import of Sub-ledger Balances

o Generating Revaluation

o Understanding the Closing Period

o Consolidating Account Balances

Financial Reporting

o Identifying Financial Reporting Across the General Ledger Business Process

o Understanding Basic Report Building Concepts

o Understanding the Financial Statement Generator

o Generating Financial Reports using the Standard Request Submission Form

3- R12.2 Oracle Payables Management Fundamentals

This R12.2 Oracle Payables Management Fundamentals training teaches you how to set

up and use Oracle Payables to manage the accounts payable process. You'll learn how

to create and manage suppliers and supplier bank accounts, process individual and

recurring invoices, match invoices to purchase orders or receipts and more.

Learn To:

Manage suppliers.

Process invoices and payments.

Generate key payables reports.

Import and approve invoices and expense reports for payment.

Process, stop, and void payments.

Set up bank accounts.

Benefits to You

Customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business

Suite 12.1 or R12.2 will walk away with a deep understanding of how Payables integrates

with other Oracle Applications. Develop the knowledge and skills to use multiple

distribution methods and process various types of payments.

Prerequisites

R12.2 Oracle E-Business Suite Fundamentals Ed 1

Audience

End User

Implementer

Manager

Objectives

Understanding how to Process Invoices and Payments

Generating Key Payables Reports

Approving Invoices for Payment

Process, Stop, and Void Payments

Setting Up Bank Accounts

Understanding Managing Suppliers

Processing Pay Runs

Closing Payables Periods

View Accounting

Topics

Procure to Pay Overview

o Describing the Procure to Pay Process Flow

o Describing how the Procure to Pay Process Fits Across the eBusiness Suite

Applications

Payables Overview

o Overview of Payables Processes

o Understanding Supplier Entry

o Understanding Invoice Entry

o Understanding Payments

o Analyzing Payables Integration Points

o Using Payables Open Interfaces to Import Data

Suppliers

o Understanding the Procure to Pay Lifecycle

o Defining Supplier and Supplier Sites

o Identifying the Key Reports

o Understanding Setup Options

o Analyzing Implementation Considerations

Invoices

o Importing and Entering Invoices and Invoice Distributions

o Matching Invoices to Purchase Orders

o Validating Invoices

o Applying and Releasing Holds

o Understanding the Invoice Approval Workflow

o Generating Key Reports

o Analyzing Setup Options

o Analyzing Implementation Considerations

Payments

o Describing the Payments Process

o Setting Up Banks and Bank Accounts

o Entering Single Payments

o Processing Multiple Payments

o Understanding how to Review Payments

o Understanding how to Adjust Payments

o Analyze Setting up and Creating Bills Payable

o Creating, Applying, and Releasing Holds on Prepayments

Expense Reports and Credit Cards

o Describing the Expense Reports Process

o Understanding how to Enter Expense Report Templates

o Entering Expense Reports

o Understanding how to Apply Advances

o Identifying the Key Expense Reports

o Understanding how to Set Up Credit Card Programs

Period Close

o Describing the Period Closing Process in Payables

o Describing the Period Closing Process in Purchasing

o Reconciling Payables Transactions for the Period

o Identifying Key Programs and Reports

o Understanding Setup Options

o Understanding Implementation Considerations

1099 Reporting

o Describing How to Enable 1099 Suppliers

o Entering Invoices for 1099 Suppliers

o Updating the 1099 Information

o Understanding the 1099 Setup Options

o Understanding Implementation Considerations

Transaction Taxes in Payables

o Describing how Transaction Taxes are Calculated

o Inserting Manual Tax Lines

o Updating Transaction Tax Lines

o Viewing Tax Summary and Details

o Identifying Key Reports

o Understanding Setup Options

Withholding Tax

o Identifying the Withholding Tax Process

o Using Withholding Tax Options

o Processing Manual Withholding Tax Invoices

o Creating Withholding Tax Invoices

o Processing Automatic Withholding Tax Invoices

o Analyzing Standard Key Reports

Advances and Progressive Contract Financing

o Understanding the Purpose of Complex Service Contracts

o Identifying Advances, Contract Financing, and Progress Payment Invoices

o Calculating Retainage

o Recouping Prepaid Amounts for Complex Service Contract

4- R12.2 Oracle Subledger Accounting Fundamentals

This course will be applicable for customers who have implemented Oracle E-Business

Suite Release 12, 12.1 or R12.2

This R12.2 Oracle Subledger Accounting Fundamentals Ed 1 training teaches you about

the rule-based accounting engine, toolset and repository that supports Oracle E-Business

Suite modules. Expert Oracle University instructors will begin with with an overview of

Subledger Accounting key concepts and terminology.

Learn To:

Create and modify the setup for subledger journal entries and application

accounting definitions for Oracle subledger applications.

Create journal entries and transfer them to General Ledger.

Inquire and report on subledger journal entries.

Understand how Oracle Subledger Accounting integrates with the Oracle

eBusiness Suite applications.

Understand the major features of Oracle Subledger Accounting.

Use Accounting Methods Builder (AMB) to create and modify subledger journal line

setups and application accounting definitions.

Benefits to You

By taking this course, you'll get a chance to deep dive into implementation

considerations for setting up and using Oracle Subledger Accounting. You'll walk away

with the knowledge to use the Create Accounting program and the Transfer Journal

Entries to General Ledger program to create and transfer journal entries to the general

ledger.

Create Subledger Accounting Entries

Furthermore, taking this course will also help you develop an understanding of how to

create subledger accounting entries. You'll learn how to compare subledger journal entry

information and view subledger journal entry headers and lines.

Inquire & Report on Subledger Journal Entries

You'll learn to inquire and report on subledger journal entries, accounting events and

general ledger balances. Spend time drilling down to the underlying transactions, while

learning to generate the Journal Entries report.

Advanced Options

The course also touches on some of the more advanced options, like custom sources,

business flows, multiperiod accounting, sequences and the diagnostic framework.

Prerequisites

Suggested Prerequisite

Knowledge of fundamental accounting principles

Required Prerequisite

R12.x Oracle Payables Management Fundamentals Ed 1

Working knowledge of Oracle Payables

Objectives

Define journal line types and definitions

Understand the process for building application accounting definitions

Define account derivation rules

Create copies of seeded definitions and customize them

Create and transfer journal entries by using the Create Accounting program

Transfer eligible journal entries to General Ledger by using the Transfer Journal

Entries to General Ledger program

Create subledger journal entries

Use the Transaction and Accounting chart of accounts

Define supporting references and perform inquiries on supporting reference

balance

Perform inquiries on General Ledger account balances, accounting events, journal

entries, and journal entry lines based on multiple selection criteria

View error information about accounting events and journal entries

Set up and copy business flows

Understand multiple accounting representations for reporting currencies and

secondary ledgers

Use the diagnostic framework to review the journal entries created by the

Subledger Accounting program

Define subledger accounting methods

Understand the integration of Oracle Subledger Accounting with other Oracle

eBusiness applications

Topics

Overview of Subledger Accounting

o What Is Subledger Accounting?

o Introduction to Subledger Accounting

o What Is a Subledger?

Create Accounting and Transfer Journal Entries to General Ledger

o Create Accounting Program Overview

o Draft Accounting and Online Accounting

o Straight-Through Accounting

o Transfer Journal Entries to GL Program Overview

o Transfer Journal Entries to General Ledger Program

Inquiries

o Accounting Events Inquiry Process

o Viewing Subledger Journal Entry Lines

o Subledger Journal Entry Lines Inquiry Process

o Drilldown from GL

Accounting Methods Builder (AMB)

o Accounting Methods Builder (AMB) Overview

o AMB Process

o Copy and Modify Functionality

o Transaction Chart of Accounts

o Accounting Chart of Accounts

o Application Accounting Definition

Reports

o Subledger Accounting Reports Overview

o Custom Parameters

o Journal Entries Report

o Subledger Period Close Exceptions Report

Creating Manual Subledger Journal Entries

o Subledger Journal Entries Overview

o Creating Subledger Journal Entries

o Reviewing and Completing Subledger Journal Entries

o Duplicating Subledger Journal Entries

Advanced Options

o Custom Sources

o Business Flows

o Multiperiod Accounting

o Accrual Reversals

o Diagnostic Framework Overview

o Journal Entry Sequencing

5- R12.2 Oracle Receivables Management Fundamentals

This R12.2 Oracle Receivables Management Fundamentals Ed 1 training is ideal for

customers who have implemented Oracle E-Business Suite Release 12, 12.1 or R12.2.

Expert Oracle University instructors will teach you how to set up and use Oracle

Receivables to manage receivables processing.

Learn To:

Understand the Order to Cash Lifecycle.

Understand the Oracle Receivables process.

Manage parties and customer accounts.

Process invoices using Auto-Invoice.

Utilize the bill presentment architecture processes.

Set up credit management, the receipt process, tax processing and period closing.

Benefits to You

By taking this course, you'll walk away with the skills to manage parties and customer

accounts. You'll have a better understanding of how the Receivables application fits into

Oracle’s e-Business Suite of applications. You'll experience a combination of interactive

instruction and hands-on exercises that you can apply to your daily job.

Prerequisites

Thorough knowledge of the overall Oracle Receivables Process

Ability to navigate Oracle applications

Objectives

Understand the overall order to cash process from Order Entry through Bank

Reconciliation

Understand key areas in the Order to Cash Life Cycle

Explain how the Receivables processing is positioned within the Order to Cash Life

Cycle

Describe the overall Receivables process

Manage parties and customer accounts

Describe the Auto-Invoice process

Explain bill presentment architecture processes

Understand Credit Management

Identify credit management processing

Understand setup information related to invoicing

Describing the receipt process

Understand setup information related to receipts

Understand the tax accounting process

Understand Sub-ledger Accounting as it relates to period closing

Topics

Order to Cash Lifecycle Overview

o Describing the overall Order to Cash Process from Order Entry through Bank

Reconciliation

o Discussing the key areas in the Order to Cash Life Cycle

o Describing the integration between the applications

Overview of Oracle Receivables Process

o Explaining where the Receivables processing is positioned within the Order

to Cash Life Cycle

o Describing the overall Receivables Process

o Discussing the key areas in the Receivables Process

Manage Parties and Customer Accounts

o Defining the Features to Enter and Maintain Party and Customer Account

Information

o Defining the Features to Enter and Maintain Party and Customer Account

Information

o Creating Profile Classes and Assigning them to Customer Accounts

o Creating and Maintaining Party and Customer Account Information

o Enabling Customer Account Relationships

o Defining TCA Party Paying Relationships

o Merging Parties and Customer Accounts

o Viewing Party and Customer Account Information

Process Invoices Using Auto-Invoice

o Describing the Auto-Invoice Process

o Using Auto-Invoice

o Correcting Errors Using Auto-Invoice Exception Handling

Process Invoices

o Describing How Processing Invoices Fits into the Receivables Process

o Entering and Completing Invoices

o Correcting Invoices

o Printing Transactions and Statements

o Using Event-Based Management

o Demonstrating Promised Commitment Accounts

Bill Presentment Architecture

o Explaining the Bill Presentment Architecture Processes

o Registering Data Sources

o Creating Templates to Present Bills

o Defining Rules to Assign Templates to Customers

o Printing BPA Invoices

Credit Management

o Understanding Setup Steps for Credit Management

o Demonstrating Credit Profile Changes

o Identifying Credit Management Processing

o Using Workflow and Lookups

o Reviewing Credit Management Performance

o Applying Credit Hierarchy

Implement Customer Invoicing

o Entering Setup Information related to Invoicing

o Understanding Key Implementation Considerations in Customer Invoicing

Receipts

o Describing the Receipt Process

o Applying Receipts Using Different Methods

o Creating Charge-backs, Adjustments, and Claims

o Using Balancing Segments

o Applying Non-Manual Receipts

Implement Receipts

o Entering Setup Information for Receipts

o Discussing the Implementation Considerations

Tax Processing

o Understanding the Tax Accounting Process

o Understanding Oracle E-Business Tax Setups for Receivables

o Managing Tax Accounts and Tax Adjustments

Period Closing

o Understanding Sub-ledger Accounting Related to Period Closing

o Defining Various Actions Required to Close a Period in the Order to Cash E-

Business Flow

o Describing Available Reports Assisting in the Closing Process

o Explaining How to Run the Revenue Recognition Program and the General

Ledger Interface Program

Appendix A: Bank Reconciliation

o Reconciliation Overview

o Reconciliation Integration

o Reconciliation: Oracle Receivables and Oracle Payables

o Reconciliation of Oracle Payroll EFT Payments

o AutoReconciliation Overview

o Clearing and Reconciling Transactions in Oracle Payables

o Clearing and Reconciling Transactions in Oracle Receivables

o Cash Application Work Queue

6- R12.2 Oracle Asset Management Fundamentals

This R12.2 Oracle Asset Management Fundamentals training is designed for customers

who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Expert Oracle University instructors will help you explore fundamental concepts and

implementation considerations of Oracle Asset Management.

Learn To:

Implement Oracle Assets.

Set up asset books.

Explain the asset management process.

Plan an asset management implementation.

Set up mass asset additions.

Set up depreciation and tax accounting.

Benefits to You

By taking this course, you'll walk away with the ability to leverage Oracle Assets to help

your enterprise lower administrative costs by streamlining data management. You'll be

able to explain the asset management process from Asset Data Flow to the General

Ledger, plan an asset management implementation and implement Oracle Assets, as

described above.

Learn Through Hands-On Exercises

You'll develop deeper expertise through a series of hands-on tutorials, demonstrations and

practices. Interactive, guided demonstrations will supplement your learning.

Prerequisites

R12.2 Oracle E-Business Suite Fundamentals Ed 1

Objectives

Describe adjustment transactions and how to use the physical inventory feature

Describe the Oracle Assets depreciation process

Explain asset retirements and the proper recording of accounting transactions,

including running the Calculate Gains and Losses program and reinstatements of

retired assets

Describe the asset financial information and transaction history inquiry process

Describe the key asset management reports and explain the use of the different

reporting tools, including Web ADI and XML Publisher

Describe the tax accounting process, including creating a tax book, adding assets

to the tax book using Initial Mass Copy and Periodic Mass Copy, and adding assets

manually

Identify the key implementation issues regarding Oracle Asset Management

fundamental topics

Describe the overall Asset Management process from setup through asset data

flow to the General Ledger

Describe the Oracle Assets setup steps

Describe the three types of asset books - corporate, tax and budget; the setup

options; and the use and process flow of the Security by Book feature

Explain the Oracle Assets accounting process

Identify the key functional areas that are part of Oracle Asset Management

Explain how to define asset categories

Discuss the requirements for adding assets manually, including the required fields,

descriptive details, depreciation rules, and assignments

Explain the mass additions process

Explain how to add CIP assets manually, via mass additions and through Capital

Projects

Topics

Overview of Oracle Asset Management

o E-Business Suite Integration

o Implementation Considerations for Oracle Financials

o Oracle Assets Setup Steps

o Implementing Oracle Assets

o Adding Assets Manually

o Mass Asset Additions

o Acquire and Build CIP Assets

o Reconciling Data in Oracle Assets

Asset Controls Setup

o Oracle Assets Setup Steps

o Setup Steps Flow

o Setting Up Key Flexfields

o Location Key Flexfield

o Creating Key Flexfield Combinations

o Specifying System Controls

o Setting Up Asset Calendars

o Maintaining an Audit Trail

Asset Books

o Asset Books Regions

o Calendar Region

o Accounting Rules Region

o Organizations and Security by Book

o Security by Book Setup Steps

o Troubleshooting Security by Book

o Implementation Considerations for Security by Book

Asset Categories

o Asset Categories Positioning

o Asset Categories Regions

o Asset Categories Setup

Manual Asset Additions

o Asset Life Cycle

o Adding Assets Manually

o Detailed Asset Additions

o Asset Cost Terminology

o Accumulated Depreciation Considerations

o Manual Asset Additions Journal Entries

o Group Depreciation

o Set Up Group Assets

Mass Asset Additions

o Mass Asset Additions Process

o Using the Mass Additions Interface Table

o Tracking Expensed Items in Oracle Assets

o Changing Asset Information

o Accounting for Cost Adjustments

o Purge Mass Additions

o Creating Assets Using Web ADI

CIP Asset Additions

o Adding and Capitalizing a CIP Asset

o Acquire and Build CIP Assets

o Automatically Adding CIP Assets to Tax Books

o Modifying the Cost of CIP Assets

o Recording a CIP Asset Addition

o Capitalizing a CIP Asset

o Reversing a Capitalized Asset

o CIP Assets and Oracle Projects

Asset Adjustments and Maintenance

o Single Asset Reclassification

o Mass Reclassification

o Inheriting Depreciation Rules

o Choosing to Expense or Amortize Depreciation Adjustments

o Amortizing Adjustments Using a Retroactive Start Date

o Asset Revaluation

o Performing Physical Inventory

o Physical Inventory Reconciliation

Depreciation

o Elements of Depreciation

o Depreciation Setup Areas

o Basic Depreciation Calculation

o Depreciation Methods

o Entering Production Information

o Prorate Conventions

o Run Depreciation Process

o Depreciation Forecasts

Asset Retirements

o Tracking Asset Retirements

o Overview of Retiring an Asset

o Restrictions on Retirements and Reinstatements

o Reinstating Retired Assets

o Retirement Processing Flow

o Recording Retirements

o Retirement Reports

o Calculating Gains and Losses

Asset Accounting

o Setting Up Asset Accounting

o Oracle Subledger Accounting

o Assets Journal Entries Flow

o Reconciling Data in Oracle Assets

o Generating Reports to Reconcile to the General Ledger

o Reconciling Asset Cost Accounts

o Reconciling Mass Additions

Asset Inquiry and Reporting

Tax Accounting

7- R12.2 Oracle Cash Management Fundamentals

This course will be applicable for customers who have implemented Oracle E-Business

Suite Release 12 or Oracle E-Business Suite 12.1 or 12.2

In this course, participants learn how to set up Oracle Cash Management and the other

applications that integrate with it. They learn how to set up security profiles and security

grants to control access to the application and set up access controls for multiple

organizations. Participants learn how to create banks, bank branches and bank

accounts; transfer cash between bank accounts; manage and reconcile bank

statements; work with bank balances, and calculate interest. They learn how Cash

Management uses Oracle Sub ledger Accounting to generate accounting entries. They

learn how to create cash pools, generate cash positions and cash forecasts to manage

their cash cycles. This course will be applicable for customers who have implemented

Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Learn to:

Define banks

Create bank accounts

Create a bank transfer

Enter Bank Statement Information Manually

Create Bank Statement Cashflow from bank statements

Generate a Cash Forecast

Prerequisites

R12.2 Oracle Payables Management Fundamentals Ed 1

R12.2 Oracle Receivables Management Fundamentals Ed 1

R12.x Oracle E-Business Suite Essentials for Implementers TOD

Knowledge of accounting practices

Functional knowledge of R12 navigation

Objectives

Transfer funds between bank accounts

Reconcile bank statements

Describe how to work with cash pools, cash positioning, and cash forecasting

Describe the accounting events generated for bank activity

Work with bank balances and calculate interest

Set up bank statement cashflows from bank file, payments, receipts, and

miscellaneous transactions

Describe the SEPA Credit Transfer and its components

Set up security for bank account access

Explain how to set up Oracle Cash Management and related applications

Create bank accounts

Topics

Oracle Cash Management Overview

o Describing the bank account model

o Describing the key concepts of reconciling bank accounts

o Explaining the key concepts of cash pools, cash positioning, and cash

forecasting

Cash Management Security

o Explaining how security works in Oracle Cash Management

o Creating security profiles

o Creating security grants

Setting Up Oracle Cash Management

o Describing how to set up Oracle General Ledger

o Describing how to set up related applications

o Describing how to set up Oracle Cash Management

Creating Bank Accounts

o Defining banks

o Defining bank branches

o Creating bank accounts

o Defining bank transactions codes

o Defining bank account signing authorities

Bank Transfers

o Describing how to set up bank transfers

o Creating a bank transfer

o Settling a bank transfer

o Creating a bank account transfer template

o Creating bank statement cashflows

Managing Bank Statements

o Entering and importing bank statements

o Describing the Bank Statement Open Interface

o Reviewing and correcting bank statement errors

o Entering bank statements manually

Reconciling Bank Statements

o Reconciling bank statements manually and automatically

o Recording exceptions and reversals

o Reconciling corrections and adjustments to bank errors

o Clearing and unclearing transactions

o Transferring bank reconciliation transactions to your general ledger

o Explaining archiving and purging

Cash Pools

o Creating cash pools

o Viewing cash pools

o Updating cash pools

Cash Positioning

o Creating cash positioning worksheets

o Generating cash positions from worksheets

o Generating a cash leveling proposal

o Viewing cash position results

o Exporting cash position results to your spreadsheet application

o Viewing cash positions in Discoverer

Cash Forecasting

o Defining a cash forecast template

o Generating a cash forecast

o Modifying a cash forecast

o Exporting a cash forecast to your spreadsheet application

o Identifying implementation considerations

o Using cash forecasting reports

Accounting Events

o Describing the accounting flow in Oracle Cash Management

o Describing the key concepts of Oracle Subledger Accounting

o Describing how to set up Oracle Subledger Accounting for Cash

Management

o Creating manual journal entries

Balances and Interest

o Maintaining bank account balances

o Creating interest rate schedules

o Creating reports for interest calculations and account balances

8- R12.2 Oracle E-Business Tax Fundamentals

This R12.2 Oracle E-Business Tax Fundamentals training is designed for customers who have

implemented Oracle E-Business Suite Release 12.2 or Oracle E-Business Suite 12.1. You'll

learn about the new features of Oracle E-Business Tax, while setting up a tax model and

applying that tax to a transaction using the Oracle Tax Simulator and other E-Business

suite applications.

Learn To:

Set up a tax configuration using the Regime to Rate flow.

Manage party tax profiles, configuration owners and service providers.

Set up party, product, and transaction fiscal classifications and explain how these

classifications impact tax processing.

Set up and use tax rules.

Manage taxes on transactions and identify E-Business Tax reports.

Manage migrated tax data for students upgrading from Release 11i.

Objectives

Use the Oracle Tax Simulator to verify the tax configuration

Describe E-Business Tax reports

Describe how E-Business Tax integrates with other Oracle E-Business Applications

Describe how the E-Business Tax rules engine calculates taxes on transactions

Set up tax exemptions

Set up tax rules using the Guided Rule Entry and Expert Rule Entry

Set up the basic tax configuration using the Regime to Rate flow

Translate tax regulations into a set of tax rules for tax determination

Understand E-Business Tax and third-party tax service providers

Understand E-Business Tax key concepts

Understand configuration owners

Understand how Release 11i tax data migrates to E-Business Tax

Understand tax handling on transactions

Understand tax recovery processing

Understand the use and content of party tax profiles

Understand the use of fiscal classifications in tax rules

Topics

1. Oracle E-Business Tax Overview

2. Oracle E-Business Tax Basic Tax Configuration

3. Setting Up Tax Rules

4. Configuration Owners and Event Class Settings

5. Managing Party Tax Profiles

6. Configuration Owners and Service Providers

7. Fiscal Classifications

8. Example: Determining Tax Rule Components Based on Tax Regulations

9. Tax Recovery, Self-Assessment, and Offset Taxes

10. Managing Taxes on Transactions

11. Self-Assessment and Offset Taxes

12. Tax Reporting Ledger

13. Appendix A: Managing Migrated Tax Data

Terms and Conditions for Public Group:

1. Training Kits: The prices include the Oracle training kits from Oracle.

2. Number of attendees: Group Max 10 attendees

3. Certificates: After completion of course, students will receive a (Certificate of

Completion) from Global academy – Oracle Approved Education Partner.

4. Prices: The prices showed in proposal are in (EGP).

5. Payment: 100% two weeks prior the course start date.

6. Cancelation:

Global academy reserves the right to cancel or reschedule any course with

prior notice due to circumstances beyond its control without any liability on

its part.

Customers will be refunded for cancelled courses which they have already

prepaid upon request.

Cancellation requests must be sent by email at least 4 weeks before the

course start date, otherwise they will not refund the payment.

No course cancellations will be accepted within the 4 weeks before the

course start date.

7. No Show: will be due for payment in full and no refund.

THANK YOU!