Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Oracle Apps Technical Training" is no longer available

No Reviews Yet

Velacheri, Chennai

Course ID: 21402

Velacheri, Chennai

Jagadeesh picture
No Reviews Yet

About the Course

Good to have prior knowledge of SQL, PL/ SQL, Oracle Forms and Oracle Reports

Topics Covered

Overview of Oracle products used and Oracle Applications Architecture
? Client/Server architecture
? Explain Oracle product with Oracle with Developer/2000. – This point understands
? people why and how Oracle Application works, useful and developed initially form based and web based.
? 3 tier architecture (for ERP) Database--Application-Client
? Preview of Oracle Applications:
? Why Business needs
? Who needs it
? How they can use
? What best business can achieve with this
? Explain different parts in Oracle Applications with modules in each area and flow and
? Connectivity between modules with diagram.
? Financials
? Manufacturing
? Supply Chain Introduction to ERP ? Definition of ERP, Overview of popular ERP'S ? Comparison of Oracle Apps with other ERP'S ? Over view of Oracle E-Business suite ( EBS) ? Types of Roles ? Types of Projects ? AIM documentation standards ? Oracle Application Architecture. ? Database structure of OA ? Using TOAD ? Business Requirements Gathering ? GAP Analysis ? Setup Process ? Deliverable Process Architecture: ? Architecture of Oracle Application Package ? Product Directory Structures ? Users ? Responsibilities ? File Objects in Oracle Applications ? Database objects in Oracle Applications ? Profile Options
System Administration and Application Object Library (AOL) ? Defining an Applications User and Assigning the Responsibilities. ? Understanding AOL and its Components ? Creating a Custom Application Module. ? Using AD_DD Package to register Database Component in AOL. ? Registering Custom Concurrent Programs based on Reports, Sql scripts, PL/SQL Stored Procedures. ? Registering a Custom Reports in Oracle Application with or without parameters. ? Profile Option in Oracle Applications. ? Define User, Responsibilities , Define, Request Group ,Request set ? Profiles, System , Personal ? Application, Register ,Form, Function ? Menu , Menu creation ? Define Value Sets ? Flex fields, Key and Descriptive ? Define Currency, Concurrent Program ? Understanding Customization ? Customizing form with custom pll/ Forms Personalization Reports registration ? Report development ? Report registration ? Parametric report registration ? Reports with repeating frames
Flex Fields
? Types of Flex Fields
? Descriptive Flex Fields
? Key Flex Fields
? Flex field’s tables and relations
Value sets
? Overview of value sets
? Options in value sets
? Types of value sets
? Creation of value set
? Overview of value set tables
Multi Org Concepts
? What is Multi Org and Operating unit why we need.
? Multi Org Tables.
? Multi Org Views.
Introduction to Interfaces
? Inbound Interfaces
? Using SQL * Loader tool
? SQL * Loader Concepts
? Data File.
? Control File.
? Bad File.
? Discard File.
? Log File.
? Commands in Sql * Loader
? Registration Of control File in Oracle Apps.
? Working with staging table script
? Developing validations package
? Introduction to interface tables in all modules
? Usage of Standard Import Programs
? GL Interface
? Outbound Interfaces
? Using UTL_FILE package
? Overview on Conversions
? Difference between Interfaces and conversions
? Working with Staging Table Script
? Developing Validations Package
? Standards to be followed in Conversions
XML Publisher
? Introduction to XML Publisher
? Generating XML file using reports
? Creating Templates
? Creating Data Definitions
? Bursting report in XML
? Introduction to Discoverer tool
? Discoverer Administrator
? Creating EUL
? Creating Business Areas
? Discoverer Desktop
? Creating work books

Who should attend




What you need to bring


Key Takeaways


Date and Time

Not decided yet.

About the Trainer

Jagadeesh picture

Avg Rating






trainer created through tv 360


No reviews currently


Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more