קורס מיישמי אורקל של חברת One1up

קורס מיישמי אורקל - פיננסי

הקורסים המוצעים על ידנו מאופינים בהתאמת החומר התיאורטי לעבודה בשטח. בקורס נלמדים הנושאים התיאורטיים המקיפים על מנת לבנות את בסיס הידע בתחום ולאחר מכן נלמדים נושאים מיוחדים הרלוונטיים לחיי היישום בארץ ובעולם.

הקורסים מועברים ע"י מיישמים מנוסים החיים את הפרויקטים ואת העשייה היומיומית המסוגלים להעביר לסטודנטים את דרך התנהלות הפרויקטים ועולם היישום.

בנוסף לנושאי הקורס הסטנדרטיים יקבלו הסטודנטים העשרה בנושאים כגון:

•           מבוא למערכות מידע

•           פרסונליזציות

•           מבוא ל SQL & PL/SQL

 

הנושאים שיועברו בקורס:

1. Introduction to Information System

2. Navigation& Essentials in Oracle Application

2.1 Introduction to R12 Oracle Applications

•           R12 E-Business Suite Architecture

•           Basic Technical Architecture

2.2 Shared Entities and Integration

•           Shared entities and Non-key shared entities

•           Overview of E-Business Suite business flows and Integration

2.3 Fundamentals of System Administration

•           Application Security Overview

•           Function Security

•           Data Security

•           Profile Options

•           Standard request submission (SRS)

2.4 Fundamentals of Flexfields

•           Basics of Flexfields

•           Define Value sets

•           Define Key Flexfields

•           Define Descriptive Flexfields

•           Flex field enhancements in R12

2.5 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

•           Reporting across entities

•           Key Implementation consideration

 

3. R12 Oracle General Ledger Management Fundamentals

3.1 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

3.2 Accounting Setup Manager

•           Understanding the required Accounting Setups

•           Describing Reporting Currencies

•           Describing Accounting Setup Considerations

3.3 Ledger

•           Describing the Elements Required to Define Ledgers

•           Identifying Attributes, Options and Settings to Define the Accounting Flexfield

•           Defining an Accounting Calendar

3.4 Basic Journal Entries

•           Describing how Journal Entries are Positioned in the Accounting Cycle

•           Identifying the Types of Journal Entries

•           Creating Manual Journal Entries

•           Posting Journal Entries

•           Performing Accounting Inquiries

•           Performing Drilldowns to Oracle Sub-ledger applications

•           Creating Reversing Entries

3.5 Using Accounting Setup Manager

•           Creating Accounting Setups

•           Creating Accounting Setup Structures

•           Completing Accounting Options

•           Analyzing Reporting Currencies

3.6 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

3.7 Advanced Journal Entries

•           Understanding Advanced Journal Entries Functions

•           Understanding the Business Benefits of Advanced Journal Entries

•           Understanding Recurring Journals

•           Understanding Mass Allocation Journals

•           Understanding Auto-Allocations

•           Understanding Journal Scheduling

•           Understanding Journal Approval

3.8 Advanced Security

•           Describing Data Access Security for Legal Entities and Ledgers

•           Understanding Management Reporting and Security

3.9 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

3.10 Multi Currency

•           Defining Foreign Currencies

•           Entering Foreign Currency Journals

•           Revaluing Foreign Currency Balances

•           Translating Balances Into Foreign Currency

3.11 Consolidations

•           Identifying Consolidations Across the General Ledger Business Process

•           Understanding Key Implementation Issues Across Consolidations

•           Understanding the Global Consolidation System

•           Defining the Elements of the Consolidation Workbench

3.12 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

3.13 Financial Reporting

•           Identifying Financial Reporting Across the General Ledger Business Process

•           Understanding Basic Report Building Concepts

•           Understanding the Financial Statement Generator

•           Generating Financial Reports using the Standard Request Submission Form

3.14 Intercompany and Intracompany

•           Understanding the differences between Intercompany and Intracompany transactions

•           Understanding the setups required to perform intercompany and intracompany transactions.

•           Creating manual Intercompany and Intracompany transactions.

4. R12 Oracle Payables Management Fundamentals

4.1 Procure to Pay Overview

•           Describing the Procure to Pay Process Flow

•           Describing how the Procure to Pay Process Fits Across the eBusiness Suite Applications

4.2 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

4.3 Suppliers

•           Understanding the Procure to Pay Lifecycle

•           Defining Supplier and Supplier Sites

•           Identifying the Key Reports

•           Understanding Setup Options

•           Analyzing Implementation Considerations

4.4 Invoices

•           Importing and Entering Invoices and Invoice Distributions

•           Matching Invoices to Purchase Orders

•           Validating Invoices

•           Applying and Releasing Holds

•           Understanding the Invoice Approval Workflow

•           Generating Key Reports

•           Analyzing Setup Options

•           Analyzing Implementation Considerations

4.5 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

•           Analyze Setting up and Creating Bills Payable

•           Creating, Applying, and Releasing Holds on Prepayments

4.6 Expense Reports and Credit Cards

•           Describing the Expense Reports Process

•           Understanding how to Enter Expense Report Templates

•           Entering Expense Reports

•           Understanding how to Apply Advances

•           Identifying the Key Expense Reports

•           Understanding how to Set Up Credit Card Programs

4.7 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

4.8 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

4.9 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

4.10 Advances and Progressive Contract Financing

•           Understanding the Purpose of Complex Service Contracts

•           Identifying Advances, Contract Financing, and Progress Payment Invoices

•           Calculating Retainage

•           Recouping Prepaid Amounts for Complex Service Contract

 

 

5.  R12 Oracle Receivables Management Fundamentals

5.1 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

5.2 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

5.3 Manage Parties and Customer Accounts

•           Defining the Features to Enter and Maintain Party and Customer Account Information

•           Defining the Features to Enter and Maintain Party and Customer Account Information

•           Creating Profile Classes and Assigning hem to Customer Accounts

•           Creating and Maintaining Party and Customer Account Information

•           Enabling Customer Account Relationships

•           Defining TCA Party Paying Relationships

•           Merging Parties and Customer Accounts

•           Viewing Party and Customer Account Information

5.4 Process Invoices Using Auto-Invoice

•           Describing the Auto-Invoice Process

•           Using Auto-Invoice

•           Correcting Errors Using Auto-Invoice Exception Handling

5.5 Process Invoices

•           Describing How Processing Invoices Fits into the Receivables Process

•           Entering and Completing Invoices

•           Correcting Invoices

•           Printing Transactions and Statements

•           Using Event-Based Management

•           Demonstrating Promised Commitment Accounts

5.6 Bill Presentment Architecture

•           Explaining the Bill Presentment Architecture Processes

•           Registering Data Sources

•           Creating Templates to Present Bills

•           Defining Rules to Assign Templates to Customers

•           Printing BPA Invoices

5.7 Credit Management

•           Understanding Setup Steps for Credit Management

•           Demonstrating Credit Profile Changes

•           Identifying Credit Management Processing

•           Using Workflow and Lookups

•           Reviewing Credit Management Performance

•           Applying Credit Hierarchy

5.8 Implement Customer Invoicing

•           Entering Setup Information related to Invoicing

•           Understanding Key Implementation Considerations in Customer Invoicing

5.9 Receipts

•           Describing the Receipt Process

•           Applying Receipts Using Different Methods

•           Creating Charge-backs, Adjustments, and Claims

•           Using Balancing Segments

•           Applying Non-Manual Receipts

5.10 Implement Receipts

•           Entering Setup Information for Receipts

•           Discussing the Implementation Considerations

5.11 Tax Processing

•           Understanding the Tax Accounting Process

•           Understanding Oracle E-Business Tax Setups for Receivables

•           Managing Tax Accounts and Tax Adjustments

5.12 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

6. Introduction To SQL/PL/SQL

7. Personalization

 

 

•           יתכנו שינויים, הורדות או הוספות של נושאים עפ"י שיקול דעת המדריך

•           תכנים אלו יועברו ב - 30 מפגשים, בעלי 3 שעות כל אחד

 

 

פרטים נוספים:

One1up Oracle Academy

academic@one1up.com

www.one1up.com

077-5551521