|
|
| Oracle Apps |
PROGRAMS |
PRE
REQUISITES |
MODULE WISE DETAILS |
COURSE
DURATION |
ORACLE 11i
APPS
DEVELOPER |
UG / PG / Diploma /BE/ Btech / ME / Mtech in any stream with/without Programming
Knowledge |
OCA Developer |
4 Days |
18 Days
|
a. SQL with Dumps |
2 Days |
b. PLSQL with Dumps |
2 Days |
Forms & Reports |
3 Days |
Oracle Apps Basic Concepts |
3 Days |
Oracle Apps Advanced Concepts |
2 Day |
UNIX Shell Scripting - Basics |
1 Day |
Projects , Real time scenarios,
Case Studies and Mock Interviews |
1 Day |
Course Content
Introduction
- Notes on Course Content
- Preparation
- Exercise: Creating Basic Oracle Forms Applications
Mouse and Key Triggers
- Mouse and Key Triggers
- Cursor Styles
- Key Triggers
- Exercise: Implementing Mouse and Key Triggers
Timers
- Use of Timers
- Creating and Handling Timers
- Timer Triggers and Built-ins
- Exercise: Creating a Clock Timer
Record Groups
- LOVs and Record Groups
- Record Group Types
- Creating Run-time Record Groups
- Built-in Procedures and Functions
- Record Groups and Lists
- Exercise: Using Run-time Record Groups
Data Block Relationships
- Relation Object Properties
- Creating Relationships Manually
- Procedures and Triggers for Coordination
- Modifying Default Functionality
- Exercise: Creating and Modifying a Relation Object
Multi-Form Applications
- Calling Other Forms
- The OPEN_FORM Procedure
- The CALL_FORM Procedure
- The NEW_FORM Procedure
- Related Built-ins
- Passing Data between Forms
- Creating Parameters and Parameter Lists
- Exercise: Calling Oracle Forms and Passing Parameters
Creating Custom Menus
- Menu Modules, SubMenus and Menu Items
- The Menu Editor
- Menu and Menu Item Properties
- PL/SQL in Menu Modules
- Menu Item Built-ins
- Menu Security
- Popup Menus
- Exercise: Generating a Custom Menu
Handling Database Objects
- Object Support and Object Types
- Object Tables
- Column Objects
- Handling REF Columns
- Exercise: Handling Objects with an Oracle Form
Using Other Data Sources
- Data Source Types
- Using a FROM Clause Query
- Using Procedures which return REF Cursors
- Using Procedures which return PL/SQL Index-By Tables
- Implementing DML using Packaged Procedures
- Exercise: Defining and using FROM Clause Query
- Exercise: Defining and using a Packaged Procedure
Using Oracle Database Features
- Database Functionality
- Handling PL/SQL Code
- Handling Database Server Errors
- Using the FORMS_DDL Package
- DDL Functionality
- Exercise: Using the FORMS_DDL Package
Reusable Components
- Reusable Component Definition
- Oracle-Supplied Components
- Using Oracle's Calendar Class Component
- Notes on Active X Controls
- JavaBeans and PJCs
- Exercise: Implementing the Calendar Component
- Exercise: Implementing Pluggable Java Components
Including Reports
- Oracle Reports Overview
• Form Like
• Tabular
• Group Above
• Group Left
• Matrix
• Matrix Group
• Label
• Letter
- Running an Oracle Report
- Integrating Oracle Reports with Oracle Forms
- Viewing an Oracle Report
- Exercise: Interfacing with an Oracle Report
Including Charts
Oracle Charts Overview
Running an Oracle Chart
Integrating Oracle Charts with other components
Viewing an Oracle Charts
Oracle application R12 Basic concepts
Application object library
Registration
- Users
- Responsibility
- Menu
- Form
- Request Group
- Current Programs
Value sets
- Independent
- Dependent
- Table
- Pair
- None
- Segment
- Translatable Independent
- Translatable Dependent
Flex fields
- KFF
- DFF
System profiles
Customizations
- Standard Oracle Reports
- Standard Oracle Forms
SQL Reports
Forms
- Template.fmb
Interfaces
- SQL Loader
- PL/SQL
Oracle Standard interfaces/Conversions
- Invoices
- Customers
- Suppliers
- Lockbox process (Receipts)
- Payments
Oracle Foundation Tables
Tuning/Performance
Summary
Evaluation
Overview of differences between 11i & R12 (Functional/Technical) |
|
|
|
|
