1) DBA ( Database Administrator )
2) Functional Consultant
3) Technical Consultant
The ratio between Functional
Consultant and Technical Consultant is 1 : 4
Role
of Data Base Administrator
1) Installing the oracle Application
2) Define the securities
3) Provide the user access to the front
end and back end of the application
4) Database Support/ cleaning / back ups
5) Applying patches ( Scripts )
Scripts are
provided by the Oracle Corporation
Eg: bug fixing,
additional support. ( www.metalinks.oracle.com
is a contact site to fix the bugs )
6) Define multiple instances (
Development, Testing, Quality, Production ( client test ) )
Role of Functional consultant
1) Interaction with the client
2) Gathering specs from the client for
development / customization
3) Should explain about the product to
the client
Ex: Financial, Manufacturing, CRM, HRMS.
As is document à
present feature of the product
To be document à the
features, which will be implemented in
the future
4) Testing of the product
Functional
consultant is the real tester for the ERP applications
Should not be tested by using
automation tools. It is a purely manual testing.
5) Define the setups
Ex: report
generation ( inr à India
6) Preparation of Functional Design
Document
While interacting with the client,
if task is
concerned to DBA, then he should introduce the DBA to the client,
if task is
concerned to Technical Consultant, then he should introduce the Technical
Consultant to the client,
Function consultant must have
following skills
a) Expertise in Domino knowledge ( field working )
b) High communication skills
c) Presentation skills
d) Documentation skills
e) Leader ship quality
f) Interaction with new people
Role of Technical Consultant
1) Receives the document ( FDD ) form
the Functional consultant
2) Should go through the document thoroughly
3) Analyze the FDD
4) Prepare the Technical Design Document
( TDD )
Ex : Tables,
procedures, Forms, Reports, SQL Queries, PL/SQL Coding, Logic and functionality
of particular module
These document are :
1) Procedure / Function level, 2) From Level, 3) Report Level, 4) Unit Level
5) Module Level 5) Project level.
5) Development of Components / Objects
6) Testing the Components / Objects
7) Deliver the object to Testing
Department
8) Support the testers
9) Interaction with DBA, Functional
Consultant and some times with client.
Types of Objects used in the Oracle Apps
The objects/components, which are
involved in Oracle apps are
1) RICE Components and 2) Functional Components
RICE Components are
R à Reports === Reports 6i
I à Interfaces === SQL, PL/SQL and
other Programs
C à Conversions
= SQL, PL/SQL and other Programs
E à
Extensions = Forms 6i
During an Implementation development of RICE components involves:
1. Creation of Reports that are not
available as standard reports in the oracle apps modules.
2. Creation of the Interfaces to
external systems.
3. Creation of Conversion programs to
transfer data from a legacy system to the new system.
4. Enhancements (or extensions) to
the existing system to add additional functionality to existing system without
disturbing the core software functionality of the system.
Functional Components are
1) P – 2 – P Cycle
2)
O – 2 – C Cycle
P – 2 – P Cycle == PO à AP à CM à GL
INV
O
– 2 – C Cycle == OM
à
AR à
CM à
GL
Product : it
is for the public usage eg: O/S, ERPs,
and packages.
Project : it
is for the specific client
Types of Project :
1) Implementation
Project :
Data migration from Legacy system to Oracle
Application
Legacy
à it is other than
Oracle Apps such as BANN, Main Frame, Java and etc
Newly development projects are also called as
Implementation Project
2) Support
Project :
Providing
support to already implementing project
Resolving
Functional issues and Technical issues
3) Migration
Project :
It
is a moving data from Older version Oracle Apps to New Version of Oracle Apps
4) Up
Gradation Project :
Adding
new modules to existing Oracle application to obtain new features
Project Process:
1)
Requirement
Gathering à Sr. F.C
2)
Preparing the
Setup documents à How the client is going to use different modules such PO , AP, AR, GL and etc
à Sr. F.C
3)
GAP Analysis à Analyzing gap between existing Oracle ERP and Client
requirement, Use of RICE Object
By
the Solution Architect
4)
Preparing
Functional Requirement Documents ( MD050)
à by Jr. F.C
This will be sent to client for approval
5)
Preparing
Technical Requirement Document ( MD070) à by the T.C and
it will be sent Technical Lead ( T.L ) for review After review by the T.L it
will be sent client.
6)
Creating
Development Instance and Providing Access
to Developers by the DBA
7)
Code
development à by the Jr. and Cr. T.C s
8)
Creating Test
Instance and Providing Access to Testers
by the DBA
9)
Testing à testing the functionality of the application. By the
F.C and T.C
10) Creating Production Instance and Providing Access to Testers by the DBA
11) System Integration Test à Integration of different Modules by the both F.C and
T.C
12) Creating Quality Instance and Providing Access to Testers by the DBA
13) Performance Testing
14) User Acceptance à at On site
15) GO – LIVE
16) Supporting / Maintenance
Documents used in the development of Oracle
Application
AIM ( Application Implementation
Methodology ) Documentation
1) MD020 ( Methodology
document ) HLD ( High Level Document )
It will be prepared by Solution Architect
2) BR030 or BR100
Setup document ( Business
Requirement )
It will be prepared by Sr. F.C
3) MD050 Functional Design Document
It will be prepared by the Jr. F.C
4) MD070 Technical Design Document
It will be prepared by T.C
5) MD120 Migration Document ( instance moving from
phase to another phase )
It will be prepared by DBA
6) UTD Unit Test Document or TE040
7) CV040 Conversion Functional Design Document
It will be prepared by Functional Consultant
8) CV060 Conversion Technical
Design Document
It will be
prepared by Technical Consultant
9) CR Document ( support ),
Change Request
It will be prepared by the Technical
Consultant
Migration Documents are of two types
1)
Installation Process : Installation stages are four 1)
development 2) testing 3) production and
4) Quality. When A form or a report is moving form one instance to other instance,
after it has been developed, it’s all associated components are also to be
moved. It will be done by the DBA.
2)
Execution Process:
It will be developed by the Technical Consultant. It has to be developed
by specifying the logic implemented and functionality of an application.
CR Document :
It
tells about the request made by the client, It could be minor changes such as
some fields are to be added / deleted to the existing form or may be deletion
of procedure.
Software used in development of Oracle Application
1) SQL 2) PL/SQL 3)
FORMS6i 4) REPORTS6i
5) XML Publisher with MS – Word 6) UNIX 7)
JAVA
Versions of Oracle Application
10.7
|
Standalone
|
11i
|
11.0.3,
11.5.3,
4, 5, 6, 7, 8, 9,
11.5.10,
11.5.10.2
|
Release – 12
( R -12 )
|
12.0.0
12.1.1
12.1.2
12.1.4
|
Fusion
|
Future
release
|
Standard
Version is 11.5.10
Modules provided by the Oracle Apps
Application is combination of
Front and Back
Front
end is Forms, Reports, Programs
Back
end is tables, views
Oracle Apps has been developed with around 260 modules.
Dept of the Company is called
as Module in Oracle Applications
No comments:
Post a Comment