Oracle Forms & Reports Training

Syllabus of Oracle Forms & Reports Course

Here are the topics we are covering in this Oracle® Forms Training session.

Introducing Oracle Forms Developer and Forms Services

• Grid Computing
• Oracle 10g Products
• Oracle Application Server 10g Architecture
• Benefits and Components of Oracle Developer Suite 10g
• Running a Forms Developer Application
• Working in the Forms Developer Environment

Creating Forms Modules

• Creating a Basic Forms Module
• Creating a Master-Detail Forms Module
• Modifying the Data Block
• Modifying the Layout

Working with Data Blocks and Frames

• Using the Property Palette
• Managing Object Properties
• Creating and Using Visual Attributes
• Controlling the Behavior and Appearance of Data Blocks
• Controlling Frame Properties
• Creating Control Blocks
• Deleting Data Blocks

Working with Input Items

• Creating Text Items
• Controlling the Behavior and Appearance of Text Items
• Creating LOVs
• Defining Editors
• Creating Check Boxes
• Creating List Items
• Creating Radio Groups

Working with Non Input Items

• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating a Bean Area Item

Working with Windows and Canvases

• Overview of Windows and Canvases
• Displaying a Forms Module in Multiple Windows
• Creating a New Window
• Displaying a Forms Module on Multiple Layouts
• Creating a New Content Canvas
• Creating a New Stacked Canvas
• Creating a New Toolbar Canvas
• Creating a New Tab Canvas

Producing Triggers

• Grouping Triggers into Categories
• Defining Trigger Components: Type, Code, and Scope
• Specifying Execution Hierarchy
• Using the PL/SQL Editor
• Writing Trigger Code
• Using Variables and Built-ins
• Using the When-Button-Pressed and When-Window-Closed Triggers

Debugging Triggers

• The Debugging Process
• The Debug Console
• Setting Breakpoints
• Debugging Tips
• Running a Form in Debug Mode
• Stepping through Code

Adding Functionality to Items

• Coding Item Interaction Triggers
• Defining Functionality for Check Boxes
• Changing List Items at Run Time
• Displaying LOVs from Buttons
• Populating Image Items
• Populating and Displaying Hierarchical Trees
• Interacting with JavaBeans

Run-Time Messages and Alerts

• Built-ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Using Triggers to Intercept System Messages
• Creating and Controlling Alerts
• Handling Server Errors

Query Triggers

• SELECT Statements Issued During Query Processing
• WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time

Validation

• Validation Process
• Controlling Validation Using Properties
• Controlling Validation Using Triggers
• Performing Client-Side Validation with PJCs
• Tracking Validation Status
• Using Built-ins to Control When Validation Occurs

Navigation

• Navigation Overview
• Understanding Internal Navigation
• Using Object Properties to Control Navigation
• Writing Navigation Triggers: When-New–Instance, Pre- and Post- Triggers
• The Navigation Trap
• Using Navigation Built-ins in Triggers

Transaction Processing

• The Commit Sequence of Events
• Characteristics and Common Uses of Commit Triggers
• Testing the Results of Trigger DML
• DML Statements Issued During Commit Processing
• Overriding Default Transaction Processing
• Running Against Data Sources Other Than Oracle
• Getting and Setting the Commit Status
• Implementing Array DML

Writing Flexible Code

• What Is Flexible Code?
• Using System Variables for Flexible Coding
• Using Built-in Subprograms for Flexible Coding
• Referencing Objects by Internal ID
• Referencing Items Indirectly

Sharing Objects and Code

• Working with Object Libraries
• Working with Smart Classes
• Reusing PL/SQL
• Working with PL/SQL Libraries

Using WebUtil to Interact with the Client

• • Benefits of WebUtil
  • Integrating WebUtil into a Form
  • Interacting with the Client

Introducing Multiple Form Applications

• Multiple Form Applications Overview
• Starting Another Forms Module
• Defining Multiple Form Functionality
• Sharing Data Among Modules

Oracle Reports Training Syllabus

Here are the topics we are covering in this Oracle Reports Training session.

Basic Concepts

• Oracle Reports Builder
• Reports
• Report Styles
• Wizards
• The Object Navigator
• The Report Editor
• Data Model Objects
• Layout Objects
• Parameter Form Objects
• The Property Instructor
• Runtime Views
• Oracle Reports Components

Advanced Concepts

• Reports
• Web Reports
• Data Model Objects
• Layout Objects
• Parameter Form Objects
• PL/SQL
• Templates
• Output Formats and Capabilities
• Data Sources
• Debugging Tools

Visual Index

• Building Basic Reports
• Building Group Reports
• Building Reports w/ Special Formatting
• Building Matrix Reports
• Building Reports for Business Cases
• Building Reports w/ PL/SQL and Java
• Building Reports w/ Pluggable Data Sources

How To …

• Access Oracle Reports Documentation
• Set Properties and Preferences
• Perform Common Tasks
• Work with the Object Navigator
• Work with Reports
• Work with Web Reports
• Run and Dispatch a Report
• Work with the Data Model
• Work with the Report Layout
• Work with Report Sections
• Work with Parameters and the Parameter Form
• Define a Template
• Use PL/SQL in a Report or Template
• Debug a Report
• Integrate with Other Products
• Administer Oracle Reports Builder

Oracle Forms & Reports Training Course Highlights

1) Our Training Center batch sizes are generally very small size 3-5 members OR 1 to 1 also, so students receive direct, hands-on training from us.

2) 100% practical training only. It is not a slide show training program / theory class program. 

3) At the end of this class, definitely you will refer your colleagues / friends / relatives for our training.

4) Conducting regularly online Oracle Forms & Reports training for US peoples in all time zones (PST,CST,EST,HST,MST)

5) Installation of Softwares in your desktop / laptop will be done.

6) Will be provided self evaluation testing software, exam simulator, dumps & books with this training.

7) Continuous support is provided for any of your on-site problems. Assistance will be provided and you will be recommended to some of IT development firms.

Why Enroll with IICT for Oracle Forms & Reports Training Course ?

1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule.

2) Live Project Exposure of Fortune companies.

3) Training by Subject Matter experts from CMM Level 5 companies

4) Both Online and Classroom Training offered at Oracle Forms & Reports

5) Our basic course worth more than the advanced course of other institutes/freelancers.

6) Free Interview preparations.

7) 100% free assistance for Oracle Forms & Reports certifications.

8) Practical and Hands on Training for Oracle Forms & Reports Course .

9) 100 % guarantee in succeeding the certification at affordable fees.

10) Also provide online training to students of foreign countries.

Oracle Forms & Reports Trainer Profile

• More than 10+ Years of Experience.
• Trained more than 5000+ students in a year.
• Strong Theoretical & Practical Knowledge.
• Oracle Forms & Reports Certified Professionals with High Grade.
• Well connected with Hiring HRs in multinational companies.
• Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
• Trainers have Experienced on multiple real-time projects in their Industries.
• Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc

Oracle Forms & Reports Placement Training

• More than 5000+ students Trained
• 2000+ students Placed
• 1100+ Interviews Organaized
• Strong Theoretical & Practical Knowledge
• Oracle Forms & Reports certified Professionals

Oracle Forms & Reports Training Batch Size

Regular Batch ( Morning, Day time & Evening)

Seats Available : 6 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

Seats Available : 8 (maximum)

Fast Track batch

Seats Available : 7 (maximum)

Oracle Forms & Reports Training Duration

Regular Classes( Morning, Day time & Evening)

Duration : 6 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

Duration : 8 Weeks

Fast Track Training Program( 3+ hours classes daily)

Duration : within 4 weeks