Oracle SCM Techno Functional Training

Prerequisites

• Basics in Computer Science
• Good Business Process Understanding
• Basic SQL, PL/SQL
• Fundamentals of ERP.

Target Job Roles

• Oracle Application Techno Functional Consultant.
• Oracle Application Programmer Analyst.

• Oracle Certified Professional – Oracle Applications.

Offerings

• Independent Consultants
• IT Consulting Companies.

Format

• Online (Web & Audio Conference)
• On – Site at your facility.

Overview.

Duration

Contents

• Logon and off of Oracle Applications
• Using forms menus
• Entering data using forms
• Searching forms
• Accessing Online Help

Introduction to R12 Oracle Applications

• R-12 E-Business Suite Overview
• Understanding the R-12 Architecture
• Understanding Oracle Application File System
• Understanding Rapid Install

Fundamentals of System Administration

• Application Security Overview
• Function Security
• Data Security
• Profile Options
• Standard request submission (SRS)

Fundamentals of Flexfields

• Basics of Flexfields
• Define Value sets
• Define Key Flexfields
• Define Descriptive Flexfields
• Flex field enhancements in R12
• Creating EIT and SIT (Difference Between EIT and SIT)

Overview.

Duration

Contents

• RFQ and Quotation
• Document Security, Routing and Approval
• Suppliers
• Enterprise Structure – Locations, Organizations, and Items
• Oracle Purchasing Overview
• Procure to pay Lifecycle Overview
• Requisitions
• Purchase Orders
• Automating Document Creation
• Professional Buyer’s Work Center
• Receiving
• Purchasing Accounting

Inventory Management

• Overview of Oracle Inventory
• Defining Inventory Organization
• Units of Measure
• Defining and Maintaining Item Fundamentals
• Lot and Serial Control
• Transaction Setup
• Issuing and Transferring material

• On hand and Availability
• Material Status
• Replenishment Fundamentals
• Inventory Accuracy Fundamentals
• Table Information

Oracle Order Management

• Overview of Oracle Order Management
• Oracle Inventory Setup for Oracle Order
• Order Entities and Order Flows

Introduction of Oracle I-Recruitment

• Oracle Procure to Pay Process

Overview.

Duration

Contents

• Support in R12 Installation and Media Pack delivery except shipment and HD Expenses.
• Introduction to Rice Components.
• Introduction to  SQL – PLSQL
• Introduction to Inbound and Outbound Interfaces.
• Working with Open Interfaces, Conversions.
• Designing Pre-Interfaces or Staging Tables.
• Loading Data from different flat files into Pre-Interface Tables.
• Standards to follow while writing an interface program
• Explanation of Seeded interfaces.
• Introduction of Reports and Reports Builder.
• Definition of Report Triggers.
• Working with Bind and Lexical parameters.
• Reports with multiple queries (Groups in Reports).
• Customizing Report Triggers.
• Working with Summary Columns, formula Columns, Format triggers etc.
• Registering Reports.
• Introduction to XML.
• Oracle BI Publisher.
• Introduction XML Publisher Administrator.
• Registering XML and Rtf Templates.
• Introduction to Appstand and Template.fmb
• Creating new Forms using Template.fmb
• Working with different Types of canvases.
• Creating LOV’s and attaching to form fields.
• Generating .fmx and form Registration.
• Introduction to SQL Loader.
• Different Formats of Control files.
• Different Formats of Data files.
• Using Direct load and indirect Load.
• Registering SQL Loader Scripts.
• Introduction to Oracle Alerts.
• Introduction to Oracle Forms Personalization.
• Introduction to  Oracle Application Framework (OAF) Personalization.

• Introduction to AME
  • Attributes
  • Conditions
  • Action Types
  • Approval Groups
• Practical Setup of Approval group of Purchase Orders.