Implementation in production

 When you use an E-business suite, you need to engineer it to suit your business requirements. In this topic, you learn about the principles that form the basis of the business architecture of oracle 11i/R12 E-Business Suite.

This chapter describes how to implement a fresh version of oracle application R12/11i in your organization. We‘ll do the implementation of below requirements.

1. The organization makes electronic gadgets – Mobile, Television, Refrigerator
2. The organization is present in 3 regions – US, UK and India

Let’s consider that we have installed a production instance of R12 in the server.
What next?

Implementing Multiple Organization Support

Read the basics of multi-org structure @

Step 1: Develop the Organization Structure

A successful implementation of Multiple Organization support in Oracle Applications depends primarily on defining your organizational structure in the multi-level hierarchy used by Oracle Applications. The levels are:
• Business groups
• Primary ledgers (as defined in Accounting Setup Manager)
• Legal entities
• Operating units
• Inventory organizations
For details checck

Step 2: Define Accounting Setups
Use the Accounting Setup Manager in Oracle General Ledger to define accounting setups that include the following common financial components:
One or more legal entities (optional)
Primary ledger
  • Reporting Currencies (optional)
  • Balancing segment value assignments (optional)
  • Subledger Accounting Options

Operating Units (available if legal entities are assigned)
  • Intercompany Accounts (available if legal entities are assigned)
  • Intracompany Balancing Rules (optional)

Sequencing (optional)
Secondary Ledger (optional)

To use multiple organizations, you must define an accounting setup with at least one legal entity, a primary ledger that will record the accounting for the legal entity, and an operating unit that is assigned to the primary ledger and a default legal context (legal entity). It is also recommended that balancing segment values be assigned to the legal entity to help you identify legal entity transactions during transaction processing and reporting and to take advantage of Intercompany Accounting.
Note: If your enterprise structure requires that you define a business group, you should define accounting setups before business groups.


Installation step 1.1 - Create legal entity
Once the installation of R12 is complete, log into the system with user id and password as sysadmin/sysadmin and create the user who 'll handel the Accounting part. Assign Grants Accounting Super User to the user

Go to the grants accouting super user responsibility and define a new legal entity.
Navigation : Grants accouting super user ->Set up -> Financials -> Accounting setup manager -> Accouting setups

Installation step 1.2 - Accounting Setup

Installation step 1.2.1 - Chart of Account 
For details check 
Lets define a six segment chart of account as shown below
Navigation : Grants accouting super user ->Set up -> Financials -> Flexfields-> Key ->Segments

 Installation step 1.2.1 - Calendar

Types of users

users are involved in the transactional operations of an organization. These users are usually full-time users and require a robust interface with maximum features.

The desktop tier is only responsible for displaying forms. To forms-based users, the forms are displayed using java. Therefore, the desktop tier needs java virtual machine (JVM) and java archive (JAR) files to operate in the forms-based architectural mode.

JVM is installed either as a plug-in in Netscape Navigator or an ActiveX control in mocrosoft IE. Oracle 11i provides JInitiator as a JVM that can be downloaded and installed. You perform the installation procedure only once. JInitiator is considered an add-on to the browser.

Self-service users are infrequent users of oracle. They require a sinmple and quick interface. Typically, most users in an instance are self-service users

Business Intelligence (BI) users are mainly senior executives, who require a simple interface to reveal critical business information. Application designed for BI users provide a browser to eliminate the need for these users to learn a new system

Mobile Users are users whose jobs prevent them from using network-connected computers. By using a mobile interface, they can send or receive information at convenient locations. Usually, sales and inventory personnel belong to this class of users.

To self-service, business intelligence, and mobile users, forms are displayed using HTML or JavaScript. The browser is inherently capablle of handling HTML and javascript. As a result, additional downloads are not required

Applications File System

An Oracle Applications Release 12 system utilizes components from many Oracle products. These product files are stored below a number of key top-level directories on the database and application server machines.
Note: No Applications files are installed on desktop client machines, although JAR files and their supporting utilities are downloaded as required.

Depending on how you chose to install Applications, these product directories may be located on a single machine (the simplest case) or on multiple machines (the most common type of deployment). Operating system environment settings indicate the location of the various files in the file systems of the database and application server machines. This chapter discusses the association between these environment settings and the corresponding files and directories.

  1. The db/apps_st/data (DATA_TOP) directory is located on the database node machine, and contains the system tablespaces, redo log files, data tablespaces, index tablespaces, and database files
  2. The db/tech_st/10.2.0 directory is located on the database node machine, and contains the ORACLE_HOME for the Oracle10g database
  3. The apps/apps_st/appl (APPL_TOP) directory contains the product directories and files for Oracle Applications
  4. The apps/apps_st/comn or (COMMON_TOP or COMN_TOP) directory contains directories and files used across products
  5. The apps/tech_st/10.1.2 directory contains the ORACLE_HOME used for the Applications technology stack tools components
  6. The apps/tech_st/10.1.3 directory contains the ORACLE_HOME used for the Applications technology stack Java components

Shared Entities

Shared entities can be referenced by multiple products. These entities allow you to define broad-level structures that help you to include members when implementing the E-business suite. Which business unit will own specific data in a shared entity is at the discretion of the compnay. Employee data is always owned by human resources, provided the E-business suite is installed.

Oracle’s Application Implementation Methodology (AIM)

A methodology is a set of guidelines or principles that can be tailored and applied to a specific situation. In a project environment, these guidelines might be a list of things to do. A methodology could also be a specific approach, templates, forms, and even checklists used over the project life cycle. Therefore that was the driving factor for bringing AIM’s as methodology which was initially used by Oracle consulting , which is now most acceptable methodology for oracle application roll out.

So then what oracle application methodology in short AIM’s based out of

  • Multi-track methodology
  • Technology Modernization
  • Business Process Reengineering
  • Oracle Application/System Development
  • Organizational Change
  • Project Management
When it was first launched
The first version of AIM was initially released for use by Oracle Consulting staff in October 1994. Tasks, steps and deliverables for project life cycle Templates for many deliverables
AIM 2.0, a refined version of the method, was released in July 1997.
Oracle introduced AIM Advantage 3.0 in September 1999.

What is current version in market?
Oracle has launched AIM’s 3.1 version, which is also called as AIM’s Advantage, which is now a consider as web-deployed tool kit for planning, executing and controlling Oracle Applications implementation projects.

What is new in AIM’s?
In newer version couple of new enhancement has been made, they are Support for business process change using the new Business Process Architecture process Integration with Oracle products like Oracle Business Models and Oracle Tutor

Is any cost for holding AIM’s tool?
Yes, as reported on Oracle site it cost you USD $2195 for per Named User(.. this may be changed..check with Oracle site)

What other methods and tools are integrated with AIM 3.1?
AIM 3.1 is closely integrated with Oracle’s Project Management Method (PJM). AIM and PJM tasks are both reflected in the AIM Work Breakdown Structure (WBS).
  • Oracle Business Models (OBM)
  • Solution Value Assessment (SVA)
  • Oracle Support Assessment (OSA)
  • Learning Needs Assessment (LNA)
  • Enterprise Data Management System (EDMS)
  • Oracle Tutor
How I get the AIM’s software?
AIM’s download is only limited to OPN (Oracle Partner Network)

What is software requirement for AIM’s 3.1
1. Windows 2000, XP, NT
2. Adobe Acrobat Reader 6.0 or later
3. Microsoft Office 2000 or later
4. Microsoft IE 6.0 or later, or Netscape 7.0 or later

What is covered in AIM’s
1.    Technology Modernization
This can be understood as the IT track contains tasks and steps relating to the creation and maintenance of procedures governing the hardware, systems software, toolsets, and databases.
2.    Oracle Application/System Development
The Oracle Application/System Development track contains the tasks and steps relating to the development of custom or tool code to support interfaces, conversions, extensions, reports, and integration testing exercises. This track overlaps the process reengineering track with the iterative design and setup of the application modules.
3.    Business Process Reengineering
The BPR track contains tasks and steps relating to process reengineering and application configuration. Prototyping is used to facilitate the design of “To Be” processes.
4.    Organizational Change
The Organizational Change track contains the tasks and steps relating to culture and change readiness assessment, organizational and job analysis, facilities analysis and preparation, user procedures and performance based training.
5.    Project Management
This track contains the tasks and steps relating to the development and management of work products on an Oracle Applications engagement. Its focus is to ensure that projects are estimated correctly, managed successfully, and properly integrated