oracle app’s r12 technical

Oracle App’s R12 Technical Training Syllabus

General Introduction

• Know How Of ERP
• Version Of Oracle Apps 11i
• Comparison of 11i and R 12
• Module Of Oracle Application
• Profile Of ERP Consultant
• Frond end And Back end Of Apps
• Introduction to Tnsnames.ora and Host Files
• Oracle Application Architecture
• Oracle Application File System

AOL(Application Object Library)

• Navigation Path
• How to Create User In ERP
• How To Assign Responsibility To the User
• How to attached buyer to user
• How to disable user
• How to add an remove responsibility assign to user
• Name of table in which user stored

Responsibility

• Navigation Path
• What is responsibility
• What are the three main components of responsibility
• How to exclude menu and function from responsibility
• How to disable responsibility
• Name of the table in which responsibility stored
• Difference between FND_RESPONSIBILITY and FND_RESPONSIBILITY_TL

Table Registration

• How to Register custom table & Column
• How to check to register table in front end
• Importance of WHO column

User Exists Form

• Overview Template
• Overview Appstand
• Implementing LOV
• Implementing ROW LOV
• Implementing Master Details
• Implementing Query Find

Application Developer

• Create Menu
• Create Function
• How to attached a form in menu
• Form Registration

Concurrent Program

• Requests
• Define request Group
• Value Set
• Reports
• Difference between D2k Reports and apps reports
• Register the PL/SQL Procedure in apps
• Define Request Sets

SQL LOADER

• Developed DFF form
• Enable DFF in the form

KFF(GL)

• Introduction
• Chart of account
• Calendar
• Currency Define Conversion Rates
• Set Of Books
• Periods
• Journals, advance journal entries & posting

Interface (GL)

• Inbound Interface
• Outbound Interface
• Prepared MD200 Documents
• Profile Options
• Oracle alerts
• multi org setup
• Concept FTP
• Unix Commands
• Forms Personalization
• XML/BL Publisher Overview
• Workflow Builder Overview
• Discoverer Tool Overview