Wednesday, May 30, 2012

Types Of Documents: The Methodology of behind is

AIM -- Application Implementation Methodology Development by Oracle Corp

RICE                  Number                    Name                         Prepared By

Module Design          MDO50                  Functional Document                  Functional Consultant
Forms & Reports       MDO70                  Technical Design Document          Technical Consultant
                        MDO120                Migration Document                    Technical Consultant


Conversions             CVO40          Conversion Functional Design Document   Functional Consultant
Interface                 CVO60         
Conversion Technical Design Document    Technical Consultant


Support                  CR Document         Change Request                          Technical Consultant



Types Of Modules: 

Module: Module is nothing but one application it contains forms, reports and programs which are related for specific business functionality.

Example: PO - Module - This will be used to capture purchasing information like suppliers. their contact details, supplying material, unit price and discounts and so on.

ERP: Enterprise Resource planning

Financial: 
          
       AP -  Account Payable
       AR -  Account Receivables
       FA -  Fixed assets
       CM - Cash Management
       GL - General Ledger
       PA - Project Accounting

Manufacturing:

      PO    -      Purchase Order
      Inv   -      Inventory
      WIP  -      Work in Process
      BOM -      Bill of Material
      OM   -      Order Management
             -      Production
             -      MRP Schedules
             -      Enquiring

HRMS:

       -      People
       -      Payroll
       -      Benefits
OTL  -     Oracle Time & Labour

CRM:

      Customer Relationship and management
      Tele Services
      Service Contract
      Mobile Process








Tuesday, May 29, 2012

Introduction
 Types of ERP software's:
 
 Enterprise Resource Planning it is a integration of all resources Man,  Machines, material, Money.

       It is used to Increase productivity, Reduce work.
                                                                                 
                                                                     Output 
                                                Productivity = --------- 
                                                                     Input


ERPs  available in market
  • SAP
  • Oracle Applications
  • People Soft
  • Siebel
  • JD Edwards
Oracle Applications are used to capture Business functionality information of the Organization.
  •  Instances
                  Development stage 1
                  Development stage2
  • Testing -- Testing
  • Production -- Client Testing
Involved Personalities of Oracle Applications and their Roles and Responsibilities in brief.

 DBA:
  1. Installation Oracle Apps
  2. Data Backup of Hot backup and Cold backup.
  3. Apply Patches  1. Lower version to higher version    2. When ever Oracle Apps Networking Properly
  4. Performance Tuning to reduce sequel query time taken (Optimizing sequel query)
  5. Cloning: it is used to copy data & File system from one server to another server. (Mirror of existing data base).

Functional: 
  1.  Gather Business Requirement
  2.  Prepare MD050 Document
  3.  Prepare BR100 setup Document
  4.  Functional setup
Technical:
  1. Develop RICE components.
      R - Reports     -- Reports 6i, 10g
     
    I - Interface   -- Programs, SQL, PL/SQL
      C - Conversion--
    Programs, SQL, PL/SQL
      E - Extension  -- Forms 6i, 10g
  2. Prepare Documentation.
    1. MD070: Technical Design Document. 
    2. MD120: Migration Or Installation Document
    3. TE020: Unit Test Cases Document
  3. Performance Tuning.
  4. Prepare sequel queries based on end user requirement.
  5. AOL -> Application Object Library
  6. Attend weekly Meeting.

      MD070(Module Design): functional Design Document
      BR : Business Requirement.

   Legacy System:
                Any software other than Oracle Apps.
    Ex: AutoCAD, TIBCO, SAP, Mainframes.


   Types of projects:


  1. Implementation Project
  2. Customization Project
  3. Up-gradation ( 11.5.9 to 11.5.10.2)
  4. Supporting / Maintenance
Implementation Project:
     
        Client will be using another software to Maintain the business solution. now the client wants to have Oracle applications Package to capture the data.
That time we will start setups, data conversions, gap analysis, functions document prepare from the scratch - first time.
                           

Customization Project:
   
      Client was already using Oracle Applications, now the client would like to have few more modules to cover the business, for that we will customize new modules and integrate with existing modules.


Migration / Up-gradation Project:

     Client was already using oracle applications older version now client would like to move new version of Oracle Applications that time we will migrate older version objects in to new version.

Supporting or Maintenance:
            
        Once the implementation, customization and migration are over, then supporting project will be started where we will give supporting for the objects which were already developed, customized and migrated.