ERPs available in market
· SAP
· Oracle Applications
o People Soft
o Siebel
o JD Edwards
Oracle applications are used to capture Business functionality information of the organization.
· Instances
o Development – Development
§ Development Stage 1
§ Development Stage 2
o Production – Client Testing
Roles involved in Oracle Applications and their responsibilities in brief
1. DBA- Database administrator
a) Installation of Oracle Applications
b) Applying patches
c) Maintaining Multiple Instances
2. Functional Consultant
a) Interaction with client
b) Gathering the requirement for development/customization
c) About Oracle applications what available and what wasn’t available.
d) Example invoice form – fields – Or develop an invoice form from scratch
e) Preparation of FDD (Functional Design Document)
3. Technical Consultant – Input FDD
a) Go through the FDD
b) Prepare TDD ( Technical Design Document) – Logic, Tables, Procedures, Forms, Menus, Packages – approval
c) Development of Component
d) Test the Component
e) Deliver to the client
All these sessions will go through the below mentioned Components
R I C E – Components for development 70%
· R - Reports - Reports 6i
· I - Interfaces - Programs, SQL,PL/SQL
· C - Conversions - Programs, SQL,PL/SQL
· E - Extensions - Forms6i
Functions Knowledge 30%
· Purchase Order Module
· Accounts Payable Module
Inventory Module
Inventory Module
· Order Management Module