Oracle Applications
Copyright @ Immense Source Institutes, 2011. All rights reserved
ERP - Enterprise Resource Planning
ERP is short for enterprise resource planning. Enterprise resource planning (ERP) is business management software that allows an organization to use a system of integrated applications to manage the business.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Functional Architecture of Oracle Applications
Business
Oracle Apps
Multiple Departments
Modules (GL,AP,AR )
Processes
Forms Form
Programs PL/SQL
Reports Report
Table SQL
Tasks
Builder
Builder
Copyright @ Immense Source Institutes, 2011. All rights reserved
Modules
Different Categories of Modules Financial Modules: General Ledger (GL) Account Payables (AP)
Account Receivables (AR)
Fixed Asserts (FA) Cash Management (CA)
Project Account (PA)
Copyright @ Immense Source Institutes, 2011. All rights reserved
Modules
Distribution Modules:
Purchasing (PO)
Inventory (INV) Order Management (OM) Manufacturing Modules: Bill of Materials (BOM) Work in Process (WIP)
Copyright @ Immense Source Institutes, 2011. All rights reserved
Modules
CRM Modules:
Field Services (FS)
Service Contracts (SC) Depo Repair (DR)
Tele Services (TS)
Technical Modules System Administrator
Application Developer.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Different Roles in Apps Project
Functional Consultant : Technical Consultant : Processes and Setups. Development and Customization of RICE Components APPS DBA : Installation and Up gradation
Copyright @ Immense Source Institutes, 2011. All rights reserved
Project Process
Activity Gathering Requirements Doing Setups in Apps Identification of GAPS Functional Design Document Technical Design Document Start Development Testing UAT ( User Access Test ) Go-Live
Copyright @ Immense Source Institutes, 2011. All rights reserved
Role Functional Consultant Functional Consultant Functional Consultant Functional Consultant Technical Consultant Technical Consultant Tech/Func Consultant
Document BP 80 (Business Process ) BR100 (Business Requirement) BR150 (BR GAP Report) MD50 MD70 Code Scripts TE020, TE050
Different Types of Projects
Implementation Project
Support Project Enhancement Project Roll Outs
Copyright @ Immense Source Institutes, 2011. All rights reserved
Technical Architecture of apps
Languages SQL PL/SQL Java Unix Reports Forms Tools sql*plus, toad, sql developer sql*plus, toad, sql developer J-Developer Telnet, Putty Oracle Reports,XML,Discoverer. Oracle Forms. Objects Tables, views. Functions, Procedures Web Pages FTP, Email. Reports Forms
Workflow
Workflow Builder
Workflow
Copyright @ Immense Source Institutes, 2011. All rights reserved
Three Tier Architecture of Apps
Java Applet Application Tier Oracle AP AR GL PO SQL INV OM BOM JAVA WIP User Tier
Forms Reports Log Bin Database Tier
IN OUT
APPS AP AR GL PO INV
Apps Schema OM BOM WIP Base Schema
Copyright @ Immense Source Institutes, 2011. All rights reserved
Different Ways to Access Apps
User Tier: Click the URL User Name : Operations Password : Welcome Application Tier: Server Name ( Unique IP Address where apps is Installed )
Username/Password
Path ( Where oracle folder is stored ) Database Tier: Host Name: where exactly Database is installed
TNS Names ( Helps to connect to server )
Username/Password
Copyright @ Immense Source Institutes, 2011. All rights reserved
Application and Navigation
Application access will be controlled using Responsibility. User: The Person who can login to Oracle Application is called User. 1 User contain n number of responsibilities. Responsibility: Collection of Menu Group, Request Group, Data Group.
1 Responsibility can be connected to number of Users.
Menu Group: Combination of Group of Forms. Request Group: Combination of Programs and Reports.
Data Group: Contains group of Schemas, Where user can access.
Copyright @ Immense Source Institutes, 2011. All rights reserved
AOL ( Application Object Library )
Copyright @ Immense Source Institutes, 2011. All rights reserved
User
The Person who can login to Oracle Application is called User.
Copyright @ Immense Source Institutes, 2011. All rights reserved
User
Default User : Operation Password : Welcome Navigation to Create a User System Administrator --- Security --- User --- Define
Copyright @ Immense Source Institutes, 2011. All rights reserved
User
User : Immense Password : Source
Task : Create a new User and Add Existing Responsibilities to your User
Copyright @ Immense Source Institutes, 2011. All rights reserved
Responsibility
Collection of Menu Group, Request Group and Data Group.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Responsibility
Navigation For Responsibility Security Responsibility Define
Task : Create a New Responsibility using Existing Menu Group, Request Group, Data Group and Assign it to your User.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Menu Group
Combination of Group of Forms.
Navigation for Menus
System Administrator Application -- Menu
Task : Create a New Menu Group.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Menu Group
Menu Group Contains Sub Menus and Functions.
Sub Menu Contain Group of Functions.
Each Function is Connected to a form.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Form Functions
Attach Form to a Function.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Attach Function to Sub Menu Sub Menu to Menu
Copyright @ Immense Source Institutes, 2011. All rights reserved
Request Groups
Combination of Programs and Reports. Navigation : Security Responsibility Request
Task : Create Request Group with Programs and Reports.
Copyright @ Immense Source Institutes, 2011. All rights reserved
Request Groups
Copyright @ Immense Source Institutes, 2011. All rights reserved
Some Imp Shortcuts
F11 Enter Query CTRL + F11 Execute Query F4 Cancel the Query Mode CTRL + F4 : Closes the Form. F6 : Clear the Form. CTRL + S : Save the Form. CTRL + H : Help
Copyright @ Immense Source Institutes, 2011. All rights reserved
WHO Columns
Created_by
Creation_date
Last_updated_by
Last_update_date
Last_updated_login
Copyright @ Immense Source Institutes, 2011. All rights reserved
Concurrent Program Statuses
Copyright @ Immense Source Institutes, 2011. All rights reserved
