Introduction to Oracle 10g Level 1 Training
Oracle 10g Level1 Training Overview
In this database administration course students gain the skills necessary for basic day-to-day administration of an Oracle10g database. This Oracle training class is the starting points for Oracle database administrators and also sets the foundation for advanced administrator training and certification.
The class target audience is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.
Oracle 10g Level1 Training Class Goals
- Learn to install Oracle software and create new databases.
- Explore the database architecture, including memory, process and data structures, and the management of those structures.
- Learn to manage database files.
- Learn to manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
- Learn to use advanced self-tuning and self-management capabilities, including Oracle-Managed Files, database Advisors and other components of the Management Framework.
- Learn to monitor performance, troubleshoot problems, and resolve lock and conflict issues.
- Learn to use the Oracle Enterprise Manager and SQL interfaces for administration tasks.
- Learn to control database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
- Learn about basic backup and recovery structures and strategies.
- Explore operating system-specific considerations for Unix, Linux and MS Windows.
Oracle 10g L1 Courseware
- Installing Oracle 10G Database Software
- Identify Database System Requirements
- The Optimal Flexible Architecture (OFA)
- Configure the Installation Environment
- Installation Using the Universal Installer
- More About Enterprise Manager
- Exploring the Oracle Database Architecture
- General Database Architecture
- Database Instance Memory Architecture
- Database Instance Process Architecture
- About the Instance Process Architecture
- Instance Background Processes
- Sql Execution Processes
- Creating an Oracle Database
- Create a Database
- Configure & Drop a Database
- Manage DBCA Templates
- Manually Creating a Database
- Controlling the Database Environment
- Starting & Stopping Database Control
- Starting & Stopping Isql*Plus
- Starting & Stopping the Database Listener
- Starting & Stopping the Database
- More About the Database Files
- Handling Parameter Files & Parameter Settings
- Storage Structures: Tablespaces
- About Tablespaces
- Tablespace Management
- Storage Structures: Data Files & Temp Files
- Managing Data Files
- Managing Temp Files
- About Oracle-Managed Files (OMF)
- Undo Management
- About Undo Space Management
- Configure Undo Management
- Guarantee Undo Retention
- Monitor Undo Space
- Use the Undo Advisor
- Database Security
- Database System Privileges
- Database Object Privileges
- Audit Database Activity
- Register For Security Updates
- Administering Users
- Create & Manage Database Accounts
- Grant & Revoke Database Privileges
- Resource Limits Via Profiles
- Password Management Via Profiles
- About Role-Based Security
- Managing Data: Loading Data With Sql Loader
- About the Database Utilities
- Using the Loader
- Understanding the Loader Process
- Control File Options
- Direct Path Loads
- Managing Data: Exporting & Importing Data
- Create Directory Objects
- EXPDP
- IMPDP
- Oracle Net Services
- What Is Oracle Net Services?
- Oracle Net Manager
- Listener Configuration
- Listener Administration
- Lsnrctl Commands
- Configuring Client Parameters
- Isolating the Problem
- Oracle Trace Assistant
- Network Troubleshooting Utilities
- Monitoring & Resolving Lock Conflicts
- About Latches & Locks
- More About Latches
- More About Locks
- Backup & Recovery Concepts
- About Database Backup & Recovery
- About Redo Data
- Redo Log File Maintenance
- Managing the Archive Options
- More About the Control File
- Storage Structures: Advanced Tablespaces (if time allows)
- More About Temporary Tablespaces
- About Temporary Tablespace Groups
- More About Permanent Tablespaces
- More About Bigfile Tablespaces
- More About the SYSAUX Tablespace
- Oracle Shared Servers (if time allows)
- Shared Servers Architecture
- Configuration Of Shared Server Mode
Module I [SQL]
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
Module II [Oracle 11g: PL/SQL Fundamentals]
- Introduction to PL/SQL
- Explain the need for PL/SQL
- Explain the benefits of PL/SQL
- Identify the different types of PL/SQL block
- Output messages in PL/SQL
- Declaring PL/SQL Variables
- Recognize valid and invalid identifiers
- List the uses of variables, declare and initialize variables, use bind variables
- List and describe various data types using the %TYPE attribute
- Writing Executable Statements
- Identify lexical units in a PL/SQL block
- Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
- Describe when implicit conversions take place and when explicit conversions have to be dealt with
- Write nested blocks and qualify variables with labels
- Write readable code with appropriate indentation
- Interacting with the Oracle Database Server
- Create PL/SQL executable blocks using DML and transaction control statements
- Make use of the INTO clause to hold the values returned by a SQL statement
- Writing Control Structures
- Identify the uses and types of control structures (IF, CASE statements and expressions)
- Construct and identify loop statements
- Apply guidelines when using conditional control structures
- Working with Composite Data Types
- Create user-defined PL/SQL records
- Create a record with the %ROWTYPE attribute
- Create an INDEX BY table and INDEX BY table of records
- Describe the differences among records, tables, and tables of records
- Using Explicit Cursors
- Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
- Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
- Declare and use cursors with parameters
- Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
- Handling Exceptions
- Define PL/SQL exceptions
- Recognize unhandled exceptions
- Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
- Propagate exceptions in nested blocks and call applications
- Creating Stored Procedures and Functions
- Differentiate between anonymous blocks and subprograms
- Create a simple procedure and invoke it from an anonymous block
- Create a simple function
- Create a simple function that accepts a parameter
- Differentiate between procedures and functions
Module III [Oracle 11g: Forms & Reports]
- Introduction to Oracle Forms Developer and Oracle Forms Services
- Running a Forms Developer Application
- Creating LOVs and Editors
- Creating Additional Input Item
- Creating Noninput Items
- Creating Windows and Content Canvases
- Working with Other Canvas Types
- Introduction to Triggers
- Working in the Forms Developer Environment
- Creating a Basic Form Module
- Working with Data Blocks and Frames
- Working with Text Items
- Producing Triggers
- Debugging Triggers
- Adding Functionality to Items
- Run Time Messages and Alerts
- Query Triggers
- Validation
- Navigation
- Transaction Processing
- Writing Flexible Code
- Sharing Objects and Code
- Introducing Multiple Form Applications
- Creating a Menu Module
- Managing Menu Modules
- Programming Function Keys
- Building Multiple Form Applications
- Defining Data Sources
- Working with Record Groups
- Using Database Objects in Forms Applications
Oracle Finance on E-Business Suite R12
Duration: 50 Hours
Pre Requisite: Basic Knowledge Finance
Training Type: In-Class / Online
R12 E-Business Suite Essentials for Implementers
- Overview of Essentials for Implementers
- Navigating in R12 Oracle Applications
- Introduction to R12 Oracle Applications
- Shared Entities and Integration
- Fundamentals of System Administration
- Standard request submission (SRS)
- Fundamentals of Multiple-Organization and
- Multiple-Organization Access Control
- (MOAC)
- Fundamentals of Oracle Work-flow & Alerts
- Fundamentals of Daily Business Intelligence
- and Oracle Fusion Business Intelligence
R12 Oracle General Ledger Management Fundamentals
- Oracle General Ledger Process
- Accounting Setup Manager
- Ledger
- Basic Journal Entries
- Using Accounting Setup Manager
- Summary Accounts
- Advanced Journal Entries
- Advanced Security
- Financial Budgeting
- Consolidations
- Period Close
- Financial Reporting
R12 Oracle Payables Management Fundamentals
- Procure to Pay Overview
- Payables Overview
- Suppliers
- Invoices
- Payments
- Expense Reports and Credit Cards
- Period Close
- 1099 Reporting
- Transaction Taxes in Payables
- Withholding Tax
- Advances and Progressive Contract
- Financing
R12 Oracle Receivables Management Fundamentals
- Order to Cash Lifecycle Overview
- Overview of Oracle Receivables Process
- Manage Parties and Customer Accounts
- Process Invoices Using Auto-Invoice
- Process Invoices
- Bill Presentment Architecture
- Credit Management
- Implement Customer Invoicing
- Receipts
- Implement Receipts
- Tax Processing
- Period Closing
R12 Oracle Cash Management Fundamentals
- Oracle Cash Management Overview
- Cash Management Security
- Setting Up Oracle Cash Management
- Creating Bank Accounts
- Bank Transfers
- Managing Bank Statements
- Reconciling Bank Statements
- Cash Pools
- Cash Positioning
- Cash Forecasting
- Accounting Events
- Balances and Interest
R12 Oracle Asset Management
Fundamentals
- Overview of Oracle Asset Management
- Asset Controls Setup
- Asset Books
- Asset Categories
- Mass Asset Additions
- CIP Asset Additions
- Asset Adjustments and Maintenance
- Depreciation
- Asset Retirements
- Asset Accounting
- Asset Inquiry and Reporting
- Tax Accounting
Introduction to Oracle Apps Functional HRMS
Core HR:
Core HR System Administration
- Responsibility
- User Management
- Menu
- Functions
- Flex fields
- SIT and EIT
- Security
- Lookups
- Value sets
- Working with Custom responsibility
Core HR Setups
- Person Types
- Assignment Status
- Work Structure
- Locations
- Business Group
- Organizations
- Organization Hierarchy
- Jobs
- Position
- Grades
1. Direct Grades
2. Indirect Grades
- Recruitment
- Workforce management ( Hiring – Transfer / Promotion / Terminating )
- Performance management ( Competence management / Appraisal )
Payroll:
- Earning and Deduction Elements
- Salary Basis
- Payment Methods
- Consolidation Set
- Payroll
- Payroll run with the entry values
- Payroll run using the Input values
- Payroll run with the Data base items
- Using Global values
- Proration
- Retro Pay
- Advanced Pay
- Rollback
- Rollback Run
- Retry Run
- Fast Formulas
SSHR:
Oracle applications Functional HRMS
- What is Self Service HR
- Different Users in SSHR
- Key Features
- Approvals in SSHR
- Functions of SSHR
- Working with Employee and Manager Self Services
- Configuration and Security in SSHR
iRecruitment:
Benefits of iRecruitment
Process Flow of iRecruitment
Vacancies & Job Posting
- Learning about Vacancies
- Default Job Posting Descriptions
- Creating Vacancies
- Posting Vacancies to multiple Recruiting Sites
- Managing Vacancies
Site Visitors & Registered Users
- Using Site Visitor Functionality
- Searching for Jobs
- Registering in iRecruitment
- Creating User Account details include a resume online
- Applying & monitoring jobs applications
Candidate Processing
- Learn about different search options
- Searching the Prospect Pool, Resumes, and Individuals
- Processing candidates and using different options
- Inviting applicant to apply for job
Working with Applicants
- Viewing Applicants details
- Progressing Applicants
- Creating Offers for applicants
- Managing Offers
- Hiring Applicants
OLM:
- Different OLM Users
- Configuration and Security in OLM
- Menus and Responsibilities
- Profile Options
- Enrollment Status
- Delivery Mode
- Administration and Organization
- Define Location
- Define Training Organization
- Catalog Management
- Define Catalog Hierarchical Structure
Oracle applications Functional HRMS
- Delivery Modes
- Session
- Sub Sessions
- Define Learning Path
- Resource Management
- Define Training Resource Key Flex-Field
- Define Resources
- Booking Resources
1. Business Process Identification
There are different business flows as well as module clusters that a student intends to learn. The combinations are as follows.
- Oracle Supply Chain or Distributions :
- Oracle Inventory (Mandatory)
- Oracle Purchasing (Mandatory)
- Oracle Order Management (Mandatory)
- Oracle Internet Procurement (Optional)
- Oracle Internet Supplier (Optional)
- Oracle Sourcing (Optional)
- Oracle Manufacturing or Discreet Manufacturing :
- Oracle Inventory (Mandatory)
- Oracle Purchasing (Mandatory)
- Oracle WIP (Mandatory)
- Oracle BOM (Mandatory)
- Oracle Engineering (Mandatory)
- Oracle Procure-To-Pay Cycle
- Oracle Inventory (Mandatory)
- Oracle Purchasing (Mandatory)
- Oracle Accounts Payables (Mandatory, with purchasing essentials)
- Oracle Internet Procurement (Optional)
- Oracle Internet Supplier (Optional)
- Oracle Sourcing (Optional)
- Oracle Order-To-Cash
- Oracle Inventory (Mandatory)
- Oracle Purchasing (Mandatory)
- Oracle Order Management (Mandatory)
- Oracle Accounts Receivables (Mandatory)
Note: We will be able to take up all the modules except detailed Accounts payables and Accounts Receivables
Oracle Applications DBA Workshop On Oracle E-Business Suite R 12
Course Pre-requisite: Oracle 10g or 11g DBA Knowledge Duration: 1 Month
Software Requirement: Oracle EBS R12, Oracle Enterprise Linux 5.5
Activities:
Day 1:
Understanding the Concept of Enterprise Resource Planning The Famous Three Tier Architecture
Understanding the Applications Components
Introduction to Database Server, Apache Web Server, Form Server, Report Server, Concurrent Manager Serer and other Server
Day 2:
Preparing the Environment of EBS R12 Installation Understanding the software and hardware requirements Installation of Oracle Enterprise of Linux 5.5 for EBS R12 Demonstration of downloading EBS software
Staging the software System Setup for Installation Performing the Installation
Day 3:
Finishing the Installation
Verifying the Oracle Applications Installation
For OCA and OCP
Module 1: Introduction to Oracle 11g SQL Chap 1: Introduction to Oracle 11g and SQL
Uniqueness of Oracle Database Suite
Time line of Oracle database and versions
Structure Query Language Overview (On Demand)
Fundamental of DBMS (On Demand)
Use of SQL
Format and Types of SQL and Other SQL
Oracle and SQL Relevance
SQL vs. SQL* Plus vs. SQL Developer
Chap 2: Writing Basic SQL Commands:
List of capabilities of SQL Select Statements Writing First SELECT statement
Selecting all or specific columns in Oracle Tables
Sorting Table Data from SELECT Statement using ORDER BY clause Selecting specific rows using SELECT command using WHERE BY clause Using ampersand (&) substitution variable in SELECT commands
Chap 3: Single Row SQL Functions:
Oracle Inventory
11i Receipt to Issue Overview |
[ ] |
Describe the Receipt to Issue process |
[ ] |
Explain the various ways of receiving Inventory and the types of Inventory receipts |
[ ] |
Transfer and issue inventory |
[ ] |
Explain the key integration points between inventory and other Oracle Applications |
Duration: 1 hour
11i Defining Inventory Organizations |
[ ] |
Describe the multi-organization structure in Oracle Applications |
[ ] |
Describe a sample organizational structure |
[ ] |
Describe the structure of an inventory organization |
[ ] |
Use organizations to model an enterprise |
Duration: 1 hour
11i Defining and Maintaining Items |
[ ] |
Explain and define items |
[ ] |
Explain organization assignments |
[ ] |
Define Units of Measure |
[ ] |
Explain and define item attributes and status codes |
Duration: 1.5 hour
11i Defining and Maintaining Items |
[ ] |
Define Item Master Organization |
[ ] |
Define items and templates using your own part-numbering scheme |
[ ] |
Enable attributes in item templates |
[ ] |
Define item deletion constraints |
[ ] |
Identify the setup options and implementation considerations |
11i Inventory Controls |
[ ] |
Create Subinventories |
[ ] |
Explain the subinventory-locator relationship |
[ ] |
Define revision control |
[ ] |
Define lot control |
[ ] |
Generate serial numbers |
[ ] |
Describe Implementation Considerations |
[ ] |
Explain Locator flexfield structure |
Duration: 1 hour
11i Transaction Concepts |
[ ] |
Define Transactions |
[ ] |
Explain how transactions integrate with Oracle Applications |
[ ] |
Explain the Oracle Inventory transaction flow |
[ ] |
Define key transactions concepts |
[ ] |
Explain Mobile Transactions |
Duration: 1 hour
11i Transaction Setup |
[ ] |
Define Transaction Managers, Transaction Types, and Transaction Reasons |
[ ] |
Define a customized transaction |
[ ] |
Explain Shipping Methods and Inter-organization shipping network |
[ ] |
Define Movement Statistics and parameters |
[ ] |
Define Inventory Account Aliases |
[ ] |
Set Up Move Orders |
[ ] |
Use Alerts, Notifications and Reports |
[ ] |
Set up transaction Profile Options |
[ ] |
Define implementation considerations for transactions |
Duration: 2 hour
11i Issue and Transfer of Material |
[ ] |
Explain Transaction Flows and Inventory Transactions |
[ ] |
Define transaction options and restrictions |
[ ] |
Perform Subinventory transfer |
[ ] |
Perform a Miscellaneous transaction |
[ ] |
Perform Inter-organization transfers |
[ ] |
Enter and manage Receipts |
[ ] |
Explain Receiving reports |
[ ] |
Explain the Move order process flow |
[ ] |
Perform Move orders |
[ ] |
Perform transactions using a mobile device |
[ ] |
Manage Shipments |
Duration: 2 hour
11i Replenishment Concepts |
[ ] |
Describe Inventory and Order planning |
[ ] |
Describe Inventory Forecasting |
[ ] |
Describe Oracle Inventory replenishment |
[ ] |
Explain how mobile devices can be used for replenishment |
Duration: 1 hour
11i Replenishment |
[ ] |
Explain the various methods of Forecasting |
[ ] |
Explain the steps for Reorder-point planning |
[ ] |
Explain the Min-max planning process flow |
[ ] |
Perform replenishment counting |
[ ] |
Generate kanban cards |
[ ] |
Set up available to promise (ATP) |
[ ] |
Perform ATP checks |
[ ] |
Set up inventory planning and forecasting profile options |
[ ] |
Identify Implementation Considerations |
Duration: 1 hour
11i Inventory Accuracy Concepts |
[ ] |
Define ABC Analysis |
[ ] |
Define Cycle Counting |
[ ] |
Define Physical Inventory |
[ ] |
Use Mobile Devices for inventory accuracy |
Duration: 1 hour
11i Inventory Accuracy |
[ ] |
Perform ABC Analysis |
[ ] |
Create and run an ABC compile |
[ ] |
Describe cycle count approval tolerance |
[ ] |
Perform Cycle Count |
[ ] |
Enter and approve cycle count |
[ ] |
Perform Count Adjustments and Approvals |
Duration: 1 hour
|
Total Duration 13 -14 Hours.
Oracle Purchasing
Procure to Pay Lifecycle Overview |
[ ] |
Describe the key areas in the procure to pay process |
[ ] |
Describe how the procure to pay process fits into the Oracle eBusiness suite of applications |
Duration: 1 hour
Oracle Purchasing Process |
[ ] |
Describe how the Procurement process fits into the Procure to Pay lifecycle |
[ ] |
Describe the orerding process |
[ ] |
Describe the key areas in the Procurement process |
[ ] |
Identify Purchasing integration points |
[ ] |
Identify Purchasing open interfaces and APIs |
Duration: 1 hour
Enterprise Structure – Locations, Organizations, and Items |
[ ] |
Describe the Oracle Applications Enterprise Structure |
[ ] |
Define Inventory Organizations and Locations |
[ ] |
Define Units of Measure |
[ ] |
Define Item Categories and Catalogs |
[ ] |
Describe Item Definition, Item Attributes and Attribute Controls |
[ ] |
Define Items |
[ ] |
Create Item Templates |
Duration: 1 hour (Only if Inv is covered) otherwise 2 Hours
Suppliers |
[ ] |
Define suppliers |
[ ] |
Explain the Purchasing use of Suppliers and the flow of default values |
[ ] |
Define supplier sites |
[ ] |
Manage suppliers |
[ ] |
Identify key reports |
[ ] |
Describe Financials setup options and Profile options |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
RFQs and Quotations |
[ ] |
Create RFQs |
[ ] |
Create quotations |
[ ] |
Identify key reports |
[ ] |
Describe Purchasing setup options and Profile Options |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
Approved Supplier Lists and Sourcing Rules |
[ ] |
Explain the role of Sourcing in Purchasing and define supplier statuses |
[ ] |
Set up and use an approved supplier list |
[ ] |
Set up and use sourcing rules |
[ ] |
Describe how sourcing information defaults to requisitions and purchase orders |
[ ] |
Set up Sourcing Profile Options |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
Requisitions |
[ ] |
Explain the Requisition Lifecycle |
[ ] |
Create purchase requisitions |
[ ] |
Describe the various requisition actions that can be performed |
[ ] |
Explain the Internal Requisition Process |
[ ] |
Create Internal Requisition |
[ ] |
Describe the Requisitions Open Interface |
[ ] |
Indentify key reports |
[ ] |
Describe setup options |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
Purchase Orders |
[ ] |
Describe Purchase Orders and Purchase Order types |
[ ] |
Create Standard Purchase Orders |
[ ] |
Create Blanket Purchase Agreements and releases |
[ ] |
Create Contract Purchase Agreements |
[ ] |
Create Planned Purchase Orders |
[ ] |
Describe purchasing document interfaces |
[ ] |
Maintain purchase orders |
[ ] |
Identify key reports |
[ ] |
Describe setup options |
[ ] |
Identify additional implementation considerations |
Duration: 2 hour
Automating Document Creation |
[ ] |
Use the AutoCreate window to automate the creation of purchase documents |
[ ] |
Describe the benefits of AutoCreate |
[ ] |
Use the Create Releases program to generate blankd purchase agreement releases |
[ ] |
Describe how the PO Create Documents workflow can automatically create purchase documents without buyer intervention |
[ ] |
Set up Profile Options |
[ ] |
Identify additional implmentation considerations |
Duration: 1 hour
Receiving |
[ ] |
Describe the process of receiving goods |
[ ] |
Describe receipt routing |
[ ] |
Describe receipt processing methods |
[ ] |
Create standard, express, and cascade receipts |
[ ] |
Describe substitute receipts, unordered receipts, returns and corrections |
[ ] |
Describe pay on receipt |
[ ] |
Describe Receiving open Interface |
[ ] |
Identify key reports |
[ ] |
Set up Purchasing, Receiving and Profile options |
[ ] |
Identify additional implmentation considerations |
Duration: 1 hour (Not required if Inv is covered)
Document Security, Routing and Approval |
[ ] |
Define your document security and access levels |
[ ] |
Define your document approval and routing process |
[ ] |
Create and assign approval groups |
[ ] |
Identify key reports |
[ ] |
Describe setup options |
[ ] |
Identify additional implementation considerations |
Duration: 1 hour
Purchasing Accounting |
[ ] |
Describe the period closing process in Purchasing |
[ ] |
Describe key accounts |
[ ] |
Use foreign currency |
[ ] |
Identify key reports |
[ ] |
Describe setup options |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
Purchasing Administration |
[ ] |
Identify Purchasing administration tasks |
[ ] |
Describe Purchasing database maintenance |
[ ] |
Identify important concurrent processes |
[ ] |
Describe additional implementation considerations |
Duration: 1 hour
Purchasing Setup Steps |
[ ] |
Identify the key Purchasing setup steps |
[ ] |
Describe key reports |
[ ] |
Describe setup options and additional implementation considerations |
Duration: 2 hour
|
Total Duration -14 Hours.
Oracle Order Management
Order to Cash Lifecycle |
[ ] |
Explain the order to cash process from order entry through Bank reconciliation |
[ ] |
Describe the order lifecycle |
[ ] |
Describe application integration for order management |
Duration: 1 hour
Oracle Order Management Process |
[ ] |
Explain the positioning of Order Management in the Order to Cash lifecycle |
[ ] |
Explain the Ship-to-Stock fulfillment model in Order Management |
[ ] |
Explain the Internal orders fulfillment model in Order Management |
[ ] |
Explain the Configure-to-order, ATO, and PTO fulfillment models in Order Management |
[ ] |
Explain the Back-to-Back orders fulfillment model in Order Management |
[ ] |
Explain the Drop-Ship to customers fulfillment model in Order Management |
[ ] |
Explain customer relationships in order management |
[ ] |
Describe various order entry methods |
Duration: 2 hour
Items |
[ ] |
Describe the Enterprise Structure |
[ ] |
Describe considerations for defining inventory structure |
[ ] |
Create and convert units of measure |
[ ] |
Explain use of items by different modules in Oracle Applications |
[ ] |
Describe item master organizations |
[ ] |
Create an item and explain implementation considerations |
Duration: 1 hour
Manage Parties and Customer Accounts |
[ ] |
Describe the components and relationships of the Party Model |
[ ] |
Create and manage profile classes |
[ ] |
Explain how Data Quality Management (DQM) works |
[ ] |
Import party information from external sources |
[ ] |
Explain Trading Community Architecture (TCA) |
[ ] |
Manage Party-Paying relationships using Oracle Trading Community Architecture |
[ ] |
Merge party accounts and customer accounts |
[ ] |
Set up customer profiles |
Duration: 2 hour
Enter Orders |
[ ] |
Describe the different order creation methods |
[ ] |
Explain the Negotiation phas in Order Management |
[ ] |
Explain workflow integration in the negotiation phase |
[ ] |
Create Defaulting rules |
[ ] |
Aplly sales credits |
[ ] |
Create an order header |
[ ] |
Explain line transaction types |
[ ] |
Explain line statuses for a order |
[ ] |
Search for an item using “Advanced item Search” |
[ ] |
Create an order line and add an attachment in the order line |
[ ] |
Explain Blanket sales agreements (BSA) |
[ ] |
Create a Blanket sales agreement |
[ ] |
Explain the process flow for internal requisitions |
[ ] |
Create an internal Order |
[ ] |
Explain Drop Ship across Sets of books |
[ ] |
Create a drop ship order |
[ ] |
Schedule an order line |
[ ] |
Book an order |
[ ] |
Copy an order |
[ ] |
Explain High Volume Order Processing (HVOP) |
[ ] |
Explain the required setup steps for entering orders |
[ ] |
Describe order import |
Duration: 2 hour
Manage Orders |
[ ] |
Explain Processing Constraints |
[ ] |
Update an order header and an order line |
[ ] |
Perform a mass update or orders |
[ ] |
Explain versioning and types of versioning |
[ ] |
Describe the audit trail |
[ ] |
Split an order line |
[ ] |
Explain the Approval workflow |
[ ] |
Create and apply a Hold |
[ ] |
Release Holds |
[ ] |
Explain the Credit Checking functionality |
[ ] |
Credit Check an account before entering an order |
[ ] |
Cancel an order |
[ ] |
Close an order |
[ ] |
Purge orders |
Duration: 2 hour
Order Inquiry |
[ ] |
Find Order and order lines using the Order Organize Form |
[ ] |
Maintain orders using the Summary Form |
[ ] |
Search for orders using the Navigator Tree Funtionality |
[ ] |
Use the Order Information Portal |
Duration: 1 hour
Pricing Concepts |
[ ] |
Explain Pricing in the Order to Cash Process |
[ ] |
Explain how the Pricing Engine works |
[ ] |
Explain Price Lists |
[ ] |
Explain Pricing Agreements |
[ ] |
Compare features of Basic Pricing with Oracle Advanced Pricing |
Duration: 1 hour
Oracle Shipping Execution Concepts |
[ ] |
Explain Shipping in the Order to Cash Life Cycle |
[ ] |
Explain Trips |
[ ] |
Explain Delivery |
[ ] |
Explain Stops |
[ ] |
Use Query Manager |
[ ] |
Explain the Shipping Transaction Form |
[ ] |
Explain Quick Ship |
[ ] |
Describe Shipping Exceptions |
Duration: 1 hour
Oracle Shipping Execution |
[ ] |
Explain Delivery Line |
[ ] |
Explain LPN |
[ ] |
Explain the Pick release process |
[ ] |
Describe the Ship Confirm Process Flow |
[ ] |
Explain One Step Shipping |
[ ] |
Create Shipping Exceptions |
[ ] |
Release Sales Orders |
[ ] |
Describe On-Line, SRS and concurrent methods for pick release |
[ ] |
Configure the pick release process |
[ ] |
Explain auto-creation of deliveries |
[ ] |
Ship Confirm Deliveries |
[ ] |
Define shipping Document Sets |
[ ] |
Describe packing into LPN containers |
[ ] |
Explain the setup required for Shipping Execution |
[ ] |
View shipping exceptions |
[ ] |
Define Pick Slip grouping rules |
[ ] |
Define Release sequence rules |
[ ] |
Define Freight Carriers |
[ ] |
Define Freight Costs Types |
[ ] |
Define Roles and Grant access to roles |
Duration: 3 hour
|
Total Duration 15 Hours.
- See more at: https://infoschool.in/oracle-inventory-training-and-placements-in-bangalore/#sthash.7SFq3mZS.dpuf
Content 10