EBS Technical
Edit Content
SQL
- Basic Database Concept and SQL
- Restricting and Sorting Data
- Single-Row Functions
- JOINS
- Multi-row Functions
- Sub-queries
- Reporting data using interface commands
- Data Manipulation Language DML and Transaction Control Language TCL
- Data Definition Language - DDL
- Constraints
- Views
- Other Database Objects
- DCL Commands
- Dictionary Tables
- SET Operators
- Advanced Date-time Functions
- Advanced GROUP BY Clause
- Advanced Subqueries
- Hierarchical Retrieval
- Multi-table Insert
- Data Loader
- Analytic Functions
- Backup
Edit Content
PL/SQL
Pre- request set
SQL Knowledge is needed and is a must!!!
Description
Learn to become a PL/SQL developer in just 4 weeks.
This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.
PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements.
In the PL/SQL program, the SQL statements are used to access sets of data stored in a database,
while the procedural statements are used to process individual piece of data and control the program flow.
- PL/SQL Basics
- Processing Data Via PLSQL
- PL/SQL Blocks
- Exceptions
- Packages
- Working with Records
- Cursors
- Collections
- Triggers
Edit Content
REPORTS
- Introduction
- Data Model
- Layout
- Parameters
- Triggers
- Program units
- Report registration in EBS
Edit Content
BI/XML Publisher
- Introduction
- Types of Data Sources
- Data Definition
- Template Defintion
- RTF Template
- Excel Template
- Report registration in EBS
- XML Bursting
Edit Content
Forms
- Introduction
- Creating Data Block and Simple form and run forms on web and using FSAL (12C)
- Triggers,Alerts and Editors
- LOV and Record Group
- Master Details
- Menus
- Visual Attribute and Property Class
- Program Units
- Pl/Sql Liabrary
- Paramters
Edit Content
Workflow
- Introduction and workflow component
- Item Attributes
- Lookups
- Activity Types
- Function Activity
- Notfication Activity
- Process Activity
- Process
- Messages and Notification
- Workflow APIs
- Workflow Access Level
- Document type attribute
- Businessevents and subscriptions