Oracle Apps Introduction 2

To implement any Oracle ERP the following Human Resources are required.
1)      DBA ( Database Administrator )
2)      Functional Consultant
3)      Technical Consultant

The ratio between Functional Consultant and Technical Consultant is  1 : 4
The No.of DBAs depends the servers using in the Application development.

 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. ( 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, Dollar à US )

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



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

11.5.3, 4, 5, 6, 7, 8, 9,
Release – 12
( R -12 )
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

Post a Comment