Signup as a Tutor

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

Oracle Apps Technical Training

No Reviews Yet

Velacheri, Chennai

Course ID: 21402

Velacheri, Chennai

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

About Jagadeesh

trainer created through tv 360
No reviews currently Be the First to Review

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



No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now


Submit your enquiry for Oracle Apps Technical Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Tarun Tarun

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer