Oracle Apps Details Information For Technical Consultant :

AOL SYLLABUS:

PREREQUISITE

SQL

PL/SQL

D2K

GENERAL INTRODUCTION

KNOW HOW OF ERP

Version of Oracle Apps 11i

Comparison of 10.7/11.0.3/11i Version

Modules of Oracle applications

Cycle of Oracle Financials

Profiles of ERP Consultants

Front End and Back End of Apps 11i

Introduction to Tnsnames.ora files.

AOL:

1. User Creation

·         Navigation Path

·         How to Create User in ERP

·         How to assign responsibility to the User

·         How to attached Buyer to the User

·         How to disable User

·         How to add and remove responsibility assign to User

·         Name of  table in which User Stored

2. Responsibility

·         Navigation Path

·         What is responsibility

·         What are the three Main Component of Responsibility

·         How to Exclude Menu and Function from responsibility

·         How to disable responsibility

·         Name of  table in which Responsibility Stored

·         Difference between FND_RESPONSIBILITY and FND_RESPONSIBILITY_TL

3. Data Group

·         Navigation Path

·         Overview of Data Group

·         Importance of Data Group

·         How to attach custom Application with Data Group

·         How to Create Custom data group

·         How to register new Schema.

4. WHO COLUMN
5. Applications and table Name
6. Schema Registrations
7. Responsibility
8. Menu Customizations
9. Request Group
10. How to Register Custom Application
11. Request Set (How to Create Request Set).
1. How to Share Paramater in Request Set
2. Stages of Request Set
12. SRS WINDOW
13. Value Set
14. Lookups
15. How to Get Name of table From Front End
16. How to Register Custom tables in Oracle Applications
17. Directory Structure of Oracle Apps
18. How to Attach Reports in Apps
1. Default Type in Reports
2. Token in Reports
3.  How to call reports through APIs
19. How to Attach Forms in Apps
20. Executable
21. Concurrent Programs
22. Incompatibility in Concurrent Programs
23. Flex fields (Key and Descriptive Flex Fields)
24. How to Enable DFF in the Forms
25. Profile options
26. User Exit
27. Importance of P_CONC_REQUEST_ID Parameter in reports
28. Difference between D2k Reports and APPS reports
29. How to Register PL/SQL Procedure in apps
30. How to Register SQL*LOADER in Oracle Applications.
31. Telnet
32. VI Editor
33.  FTP
34. Concurrent Manager
35.  Unix Command
36. AIM Standard for Documentations (MD50 , MD70)