Course Overview
About Course
Oracle Forms & Reports Training offers a robust, 40‑hour immersion into Oracle’s classic RAD platform—used extensively for mission-critical enterprise applications. Developed over foundational PL/SQL and SQL, the course transitions rapidly into the Oracle Forms Builder environment. Learners design data-entry screens using forms components—blocks, canvases, windows—with controls defined in the Layout Editor and properties refined in the Property Palette
Hands-on trigger labs teach building dynamic, data-validated user interactions using triggers like Pre-Query, Validate-Item, and Pre-Commit. Navigating complex master-detail relationships, including record groups, LOVs, and visual attributes, further refines form functionality The training also covers menu construction, alerts, and toolbar functionality to give forms a user-friendly navigation system
The Reports Developer section delves into data models—including query and parameter setup, triggers, and bursting logic—with formats like HTML, PDF, and Excel. Students learn seamless integration of reports within forms, deploying applications via Oracle Forms Services and Reports Server
Advanced modules cover performance tuning, dynamic SQL, multi-language capabilities, and debugging—utilizing logs, formsweb.cfg configurations, and troubleshooting techniques to ensure maintainable, optimized applications Students also explore deployment best practices and configuration management to move applications from development to production smoothly.
Throughout, instruction is enriched with real-world use cases like user permissions, data dependencies, and cross-module communication, making the training both practical and comprehensive. The course prepares learners for the Oracle Certified Professional Forms Developer certification (1Z0‑151)
The capstone project consolidates learning by delivering a complete Form plus integrated Reports application—covering screen design, business logic, data validation, reporting, and deployment. Learners polish and present their applications, receiving feedback to simulate real-world review processes. Graduates finish as capable Oracle Forms & Reports Developers—ready to build, debug, and deploy enterprise-grade applications with confidence and certification-ready knowledge.
Course Syllabus
- Module 1: Introduction & Environment Setup (3 hrs)
- Oracle Forms & Reports history, architecture, IDE overview
- Install/configure Oracle Developer Suite (Forms/Reports), run environment
- Module 2: SQL & PL/SQL Refresher (4 hrs)
- SQL fundamentals, DDL/DML/joins/subqueries
- PL/SQL blocks, procedures, functions, packages, triggers
- Module 3: Forms Development Basics (5 hrs)
- Building forms: blocks, canvases, windows, items
- Layout Editor, Property Palette, compiling/running Forms
- Module 4: Triggers & Program Units (4 hrs)
- Key triggers (Pre-Query, When-Validate-Item, Pre-Insert, Pre-Commit)
- Program units, PL/SQL libraries, parameter maps
- Module 5: LOVs, Record Groups & Validations (3 hrs)
- Query/non-query record groups, LOV wizard
- Validations and dynamic content
- Module 6: Master–Detail Forms & Navigation (3 hrs)
- Creating master–detail forms and navigating between blocks
- Module 7: Menus, Alerts & Visual Attributes (3 hrs)
- Custom menus/forms, alerts, toolbar functions, visual attributes
- Module 8: Oracle Reports Developer (5 hrs)
- Report components: Data Model, Layout, triggers
- Report parameterization, bursting, output formats
- Module 9: Reports Integration & Publishing (4 hrs)
- Linking Reports to Forms, Reports Server setup, deployment
- Module 10: Advanced Features & Performance (4 hrs)
- Dynamic queries, multi-language support, performance tuning, error handling
- Module 11: Troubleshooting & Deployment (3 hrs)
- Debugging techniques, config files (formsweb.cfg), logs, version management
- Module 12: Capstone Project & Review (2 hrs)
- Build a complete application: Forms + integrated Reports
- Presentation, peer feedback, best-practice discussion
-
Key Features
Hands‑on labs: ~80% practice — screen design, triggers, PL/SQL code, Reports
Real-world scenarios: Use of LOVs, Master–Detail forms, dynamic validations, and Alerts
Reports expertise: Learn to design, run, and deploy reports; integrate with Forms
Modern integration: Connection between Forms and Reports across Java EE/WebLogic/Oracle Forms Services
Debugging skills: Log analysis, troubleshooting, config management, deployment strategies
Certification readiness: Material aligns with Oracle Certified Professional Forms Developer (exam 1Z0-151)
Capstone Integration: A polished Forms + Reports application, ready for portfolio/demo
Our Upcoming Batches
At Topskill.ai, we understand that today’s professionals navigate demanding schedules.
To support your continuous learning, we offer fully flexible session timings across all our trainings.
Below is the schedule for our Training. If these time slots don’t align with your availability, simply let us know—we’ll be happy to design a customized timetable that works for you.
Training Timetable
| Batches Online/Offline | Batch Start Date | Session Days | Time Slot (IST) | Fees |
|---|---|---|---|---|
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 11:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 5:00 PM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 PM (Class 1-1.30 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 7:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 10:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 11:00 AM (Class 3 Hrs) | View Fees |
For any adjustments or bespoke scheduling requests, reach out to our admissions team at
support@topskill.ai or call +91-8431222743.
We’re committed to ensuring your training fits seamlessly into your professional life.
Note: Clicking “View Fees” will direct you to detailed fee structures, instalment options, and available discounts.
Don’t see a batch that fits your schedule? Click here to Request a Batch to design a bespoke training timetable.
Corporate Training
“Looking to give your employees the experience of the latest trending technologies? We’re here to make it happen!”
