11i Manufacturing Functional Foundation

Total time

11i Manufacturing Functional Foundation

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This course covers some primary functionality of the core manufacturing application modules (see list below) and the subsequent flow of data through the major database tables. Given the course audience, Information System Professionals, this course is more functional than technical in nature. It includes functional coverage of much of the material also included in the application technical reference manuals. This course provides a summary of the applications tables in functional order, allowing the technical student to become more efficient at resolving user requirements such as forms customization, data conversion, or extensive reporting requirements.

A typical scenario for this course is a…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Manufacturing, Oracle 11i, Software / System Engineering, Retail (Management), and Project Management.

This course covers some primary functionality of the core manufacturing application modules (see list below) and the subsequent flow of data through the major database tables. Given the course audience, Information System Professionals, this course is more functional than technical in nature. It includes functional coverage of much of the material also included in the application technical reference manuals. This course provides a summary of the applications tables in functional order, allowing the technical student to become more efficient at resolving user requirements such as forms customization, data conversion, or extensive reporting requirements.

A typical scenario for this course is as follows: the instructor will demonstrate and describe a manufacturing function such as entering a bill of material (Oracle Engineering functionality). This is followed by a detailed discussion of an entity relationship diagram depicting the database table relationships involved in bills of material entry. Finally, the student is asked to demonstrate their understanding by executing a SQL script to locate a particular bill of material, and answer specific questions, related to the database tables, with regard to that bill of material entry. The functionality of the following modules are covered: Oracle Inventory, Oracle Bills of Material and Engineering, Oracle Cost Management, Oracle Order Management, Oracle Work in Process, Oracle Material Requirements Planning, Oracle Quality, and Oracle Purchasing, with 50 entity relationship diagrams presented and discussed.

Learn to:
  • Understand the major features and process flows in Oracle Manufacturing
  • Identify the major tables used in Oracle Manufacturing
  • Read Oracle Manufacturing entity relationship diagrams (ERDs)
  • Discuss the Manufacturing open interfaces and APIs

Audience
  • Technical Consultant

Course Topics Understanding Application Basics
  • Using Application Basic Tools
  • Describing the Applications Security Model
  • Discussing Concurrent Processing
  • Describing Flexfields
  • Describing Alerts
  • Describing Workflow
Understanding Entity Relationship Diagrams and Tables
  • Reading ERDs
  • Understanding Custom Programs in Oracle
  • Setting Up Responsibilities and Users
  • Using Folders and Attachments
  • Defining Flexfields
Understanding Open Interfaces and APIs
  • Describing the Open Interface Model
  • Managing Open Interface Processing
  • Discussing Standards for Using Open Interfaces
Understanding Oracle Inventory
  • Discussing Inventory Structure
  • Describing Inventory Major Features and Functions
  • Identifying Major Tables Used in Oracle Inventory
  • Reading Oracle Inventory ERDs
  • Discussing Open Interfaces and APIs for Oracle Inventory
Understanding Oracle Bills of Material and Engineering
  • Discussing Bill of Material Structures, Resources, Departments, and Routings
  • Understanding Engineering Change Control
  • Identifying the Major Tables Used in Oracle Bills of Material and Engineering
  • Reading Oracle Bills of Material and Engineering ERDs
  • Discussing Open Interfaces and APIs for Oracle Bills of Material and Engineering
Understanding Oracle Cost Management
  • Discussing Costing Methods Supported in Oracle Cost Management
  • Identifying the Major Tables Used in Oracle Cost Management
  • Reading Oracle Cost Management ERDs
  • Discussing Open Interfaces and APIs for Oracle Cost Management
Understanding Oracle Order Management
  • Describing the Order Management Process Flow
  • Identifying the Major Tables Used in Oracle Order Management
  • Reading Oracle Order Management ERDs
  • Discussing Open Interfaces and APIs for Oracle Order Management
Understanding Oracle Work in Process
  • Discussing the Flow of Inventory through a Factory
  • Identifying the Major Tables Used in Oracle Work in Process
  • Reading Oracle Work in Process ERDs
  • Discussing Open Interfaces and APIs for Oracle Work in Process
Understanding Oracle Material Requirements Planning
  • Discussing the Planning Process
  • Identifying the Major Tables Used in Oracle Material Requirements Planning
  • Reading Oracle Material Requirements Planning ERDs
  • Discussing Open Interfaces and APIs for Oracle Material Requirements Planning
Understanding Oracle Quality
  • Understanding the Major Features and Process Flows in Oracle Quality
  • Identifying the Major Tables Used in Oracle Quality
  • Reading Oracle Quality ERDs
  • Discussing Open Interfaces and APIs for Oracle Quality
Understanding Oracle Purchasing
  • Discussing Purchasing Activities from Requisitions to Receipt of Goods
  • Identifying the Major Tables Used in Oracle Purchasing
  • Reading Oracle Purchasing ERDs
  • Discussing Open Interfaces and APIs for Oracle Purchasing

Course Objectives
  • Work with Oracle application basics
  • Understand Oracle Inventory's major features and processes
  • Understand Bills of Material and Engineering’s major features and processes
  • Understand Cost Management's major features and processes
  • Understand Order Management's major features and processes
  • Understand Material Requirements Planning's major features and processes
  • Understand Work in Process' major features and processes
  • Understand Quality's major features and processes
  • Understand Purchasing major features and processes
  • Read and explain Oracle Manufacturing entity relationship diagrams
  • Use Oracle Manufacturing open interfaces and APIs

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.