Oracle Application:Data Model

           When we install Oracle Database by default system will creates SYS and SYSTEM schemas. These consist of all Data Dictionary Tables. Like this if we install Oracle Applications System will automatically creates schemas of all Modules (i.e. GL, AR, AP, etc.) with the respective module name as User and Password. Along with these schemas some special Schemas i.e. APPS, APPLSYS, APPLSYSPUB will be created for special purpose.

APPS Schema: 

• It is Public Schema.
• The APPS schema is an ORACLE schema that has access to the complete Oracle Applications data model. It is analogous to the SYSTEM schema, which has access to the entire database.
• AutoInstall creates the necessary grants and synonyms between the schemas.
• Oracle Applications responsibilities connect to an APPS schema.
• There is one APPS schema for every product installation group.
• It consists of a collection of public synonym of all the objects of all the schemas in the Application database. All the Procedures, Functions and Packages created must be stored in this Schema.

APPLSYS Schema: 

        This is a special Schema consists of the files starts with FND, ALR, WF and AD.

APPLSYSPUB Schema: 

    This schema is a collection of public synonyms of all FND Tables, which are used for User verification. This is the Gate Way User ID of Oracle Applications.

Few Other Base Product Schemas:

• GL ( General Ledger )
• INV ( Inventory)
• AP ( Accounts Payables)
• APPLSYS ( Application Object Library)
• ALR ( Alerts)

Product Directory Structure in Oracle Apps

          When Oracle Applications installs in a machine it creates a base directory with the name ORACLE. This is the base directory for accessing the application.

Oracle Applications supplied in three flavors
1. Production Oracle Applications: used for implementing in any organization.
2. Vision Oracle Applications: used for Demonstration or Training purpose.
3. Test Oracle Applications: used for R&D purpose
Product Directory Structure of Oracle Applications

VISDB: Consists of Oracle 8i / Oracle 9i / Oracle 10g Database executable files.
VISORA: Captures 8.0.6 / 9iAS / 10giAS middleware Database executable files.
VISCOMM: Captures Control Script files, which are used to Start or Stop the Application Services.
VISDATA: Captures all .DBF files.
VISAPPL: Captures all Module Specific Directories and Some Special Directories.
APPL_TOP (i.e. VISAPPL) Directory Structure

GL_TOP: (APPL_TOP/GL/11.5.0) is one of the Module Directory of Oracle Applications. It consists of a release directory (i.e. 11.5.0) under which Forms, Reports, BIN, LIB, SQL, etc.,

GL_TOP/11.5.0/Forms/US is forms directory to store all .FMX (Compiled) Form files of a specific module.

GL_TOP/11.5.0/Reports/US is a reports directory to capture all the .RDF (Compiled) Report files of a specific module directory.

US is a language specific directory.

GL_TOP/11.5.0/BIN will capture the C, C++, PRO*C, SQL *LOADER etc., files.

GL_TOP/11.5.0/LIB will capture all .OBJ files of C, C++ or JAVA CLASS files.

GL_TOP/11.5.0/Message will capture all .MSB message body files.

GL_TOP/11.5.0/LOG will capture all .LOG files.

GL_TOP/11.5.0/OUT will capture all .OUT files.

GL_TOP/11.5.0/SQL will capture all .SQL script files.

GL_TOP/11.5.0/HTML will capture all .HTML, .HTM web files.

GL_TOP/11.5.0/FND is a Special Directory known as Application Object Library (AOL) directory. It is used to capture all Modules Application Executable Files.

GL_TOP/11.5.0/AU is an Application Utility (AU) Directory. It consists of a application release Sub-Directory, which consists of Forms and Resource directories. It is used to store all .FMB and .PLL and PL/SQL Library files.

GL_TOP/11.5.0/AU/11.5.0/Forms/US will capture .FMB Form files of all Modules.

GL_TOP/11.5.0//AU/11.5.0/Resource is used to store .PLL and .PL/SQL Library files of Oracle Applications

                           

Please go through the below url you can find here more about product directory structure in oracle apps:

https://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120509.htm 

Application Implementation Methodology (A.I.M)

Application Implementation Methodology in short referred as AIM.

AIM- Oracle’s Application Implementation Methodology is a proven approach to implement Oracle Applications.

AIM defines an organization’s business needs at the beginning of the project and maintains their visibility through out the implementation

AIM Phases-AIM project is conducted in phases. The phases provide quality and control checkpoints to coordinate project activities that have a common goal.

The phases are

1) Definition- During this phase, we plan the project ,review the organization’s business objectives ,understand the business processes and evaluate the feasibility of meeting those objectives under time, resources and budget constraints. The emphasis is on building an achievable work plan and introducing guidelines on how the organization will work to achieve the objectives.To achieve an early understanding of current business operations and future processes,the team also performs baseline and process modeling during this phase.If business change is required,then the high level future process designs are drawn.The goal is to identify the future business and system requirements,propose a future business model and determine the current application and information technology architecture.The information gathered provides input to the downstream activities in subsequent phases.All business requirements are associated with planned future business processes.So sharing an accurate understanding of the requirements is a critical success factor to the project.

2) Operations Analysis- The project team develops the business requirement scenarios based on deliverable drawn out of the definition stages.These business requirement scenarios are used assess the level of fit between the detailed business requirement and standard application functionality.Gaps are identified and new proposed solutions are developed.Proposed solutions for gaps evolve into detailed design during a solution design phase.

3) Solution Design- The purpose of the solution design is to develop the detailed design to meet the future business requirements.

4) Build-The coding and testing of all customizations,data conversions and interfaces are done in this phase.Business system testing is performed to validate that the functionality meets the business requirements.If customizations,extensions and conversions are not required ,build phase is still important because it includes business system test..In confererence room pilot(CRP),the business system test validates the new system in an environment that resembles the production.

5) Transition-During transition,the project team deploys the new system into the organization.All the elements must come together to tranisition successfully to actual production.During transition users perform an acceptance test of the new system.

6) Production-It marks the last phase of the implementation and the beginning of system support cycle.

AIM Processes

1) Business process architecture (BP)
Business process architecture addresses the organization’s business processes and aligns them with the business requirement and applications to be implemented. High level process designs (BP0.070) and future process model (BP0.080) are a part of this.

2) Business requirements Definition (RD)
Business Requirements Definition defines the business needs that must be met by the implementation project .This is RD 0.020 which is the current business needs.

3) Business Requirement Mapping (BR)
Business requirement mapping compares the future business requirements to standard oracle application functionality and identifies the gaps. Business requirements scenarios (RD0.050) are then mapped to oracle functionality.

4) Application and Technical Architecture (TA)
During Application and Technical Architecture, the information systems are designed to reflect the business vision

5) Module Design and Build (MD)
Module design and build produces custom application extensions for gaps in functionality identified during BR.Custom application extensions include program modules( forms, reports, alerts and database triggers) that must be designed, built and tested before being transitioned in the new system.

6) Data Conversions (CV)
Data conversion defines the tasks and deliverable to convert legacy data to oracle application base tables.

7) Documentation (DO)
It defines the documentation requirements for the project and establishes which of the documentation tasks are required.

8) Business System Testing (TE)
Early in the project life-cycle, Business System Testing focuses on
linking test requirements back to business requirements and securing
project resources needed for testing.
Business System Testing provides a formal integrated approach to
Testing

9) Performance Testing (PT)
Performance Testing enables you to define, build, and execute a
performance test. The Performance Testing team defines the scope of testing and relates it to point-in-time snapshots of the transactions expected in the real
production system

10) Adoption and Learning (AP)
Adoption and Learning establishes a measurement system that provides
an evaluation of organizational performance to help make sure that
expectations are met during implementation and after production
cut-over

11) Production Migration (PM)
Production Migration moves the company, system, and people to the
new enterprise system.

Oracle E-Business Suite Modules

          Oracle e-Business Suite (EBS) itself is a very vast application starting from customer management to planning and demand supply of product and extended to project accounting to supply chain planning.

        So this vast application has splitted into different small independent modules which customers/users can install and use as per their business requirement and business feasibility.

Some of the key applications are:

·             Oracle Customer Relationship Management (CRM)

·             Services

·             Oracle Financial

·             Oracle Human Resource Management System (HRMS)

·             Oracle Project Portfolio

·             Oracle Contracts

·             Oracle Supply Chain Management (SCM)

·             Oracle Procurement

·             Oracle Value Chain Planning

Following Applications consists of different modules

Customer Relationship Management

The Oracle CRM (Customer Relationship Management) is a set of applications that give you information-driven sales, service, and marketing. Oracle CRM is built on an open, standards-based architecture that streamlines business processes, improves data quality, and allows all your key divisions to draw from the same source of data. With Oracle CRM, your company owns thesingle best tool for customer success—accurate information.

ü  Channel Revenue Management

1.   Oracle Accounts Receivable Deductions

2.   Oracle Channel Revenue Management

3.   Oracle Channel Rebate and Point of Sale Management

4.   Oracle Price Protection

5.   Oracle Supplier ship and debit

ü  Customer Data Hub

1. Oracle Customer Data Librarian

2. Oracle Customers Online

3. Oracle Trading Community Architecture

ü   Incentive Compensation

1.   Oracle Incentive Compensation

ü    Sales

1.   Oracle iStore

2.   Oracle Leads Management

3.   Oracle One-to-One Fulfilment

4.   Oracle Partner Management Vendor

5.   Oracle Proposals

6.   Oracle Quoting

7.   Oracle Sales for Handhelds

8.   Oracle Sales

9.   Oracle Sales Offline

10.    Oracle Telesales

11.    Oracle Territory Management

ü    Marketing

1.   Oracle Content Manager

2.   Oracle Marketing

3.   Oracle Web Analytics

Services

Oracle’s E-Business Suite family of Service Applications provides true information-driven customer service. It enables an organisation to meet and exceed customer expectations by empowering them with information that is consistent, accurate, and actionable.

ü  Maintenance, Repair and Overhaul

1.   Oracle Complex Maintenance, Repair and Overhaul

2.   Depot Repairs

a.    Common Applications

3.   Oracle Customer Interaction History

4.   Oracle Universal Work Queue

ü  Service

1.   Oracle Advanced Scheduler

2.   Oracle Field Services

3.   Oracle iSupport

4.   Oracle Knowledge Management

5.   Oracle Mobile Field Service

6.   Oracle Spares Management

7.   Oracle TeleService

ü    Communications

1.   Oracle Number Portability Concepts and Procedure

2.   Oracle Service Fulfilment Manger

3.   Oracle Telecommunications Billing Integrator

4.   Oracle Telecommunications Service Ordering Process

ü    Interaction Center Technology

1.   Oracle Advanced Inbound Telephony

2.   Oracle Advanced Outbound Telephony

3.   Oracle Email Center

4.   Oracle Interaction Blending

5.   Oracle Interaction Center Server Manager

6.   Oracle Scripting Developer

7.   Oracle Telephony Adapter SDK Developers

Financial

 The Oracle Financials application includes General Ledger, Cash Management, Payables, Receivables, Fixed Assets, Treasury, Property Management, Financial Analyser and a self-service expenses function.

ü  Across Financials

1.   Oracle Financials

2.   Oracle Financials RXi Reports Administration

ü  Assets

1.    Oracle Assets

2.    Oracle iAssets

ü  Cash and Treasury

1.   Oracle Cash Management

2.   Oracle Treasury

ü  Corporate Performance Management

1.   Oracle Enterprise Planning and Budgeting

ü  Financial Control and Reporting

2.   Oracle Advanced Global Intercompany System

3.   Oracle Financial Consolidation Hub

4.   Oracle Financial Services Accounting Hub

5.   Oracle General Ledger

6.   Oracle Internal Controls Manager

7.   Oracle Loans

8.   Oracle Public Sector Financials

9.   Oracle Public Sector Budgeting

10.        Oracle U.S Federal Financials

ü  Financials Common Modules

1.   Oracle E-Business Tax: Vertex Q-Series and Taxware Sales/ Use Tax System

2.   Oracle E-Business Tax

3.   Oracle E-Business Tax reporting

4.   Oracle Subledger Accounting

ü  Financial Localizations

1.   Oracle Financials for the Americas

2.   Oracle Financials for Asia/Pacific

3.   Oracle Financials for Europe

4.   Oracle Financials for India

5.   Oracle Receivables: Golden Tax Adapter for Mainland China

ü  Internet Expenses

1.   Oracle Internet Expenses

ü  Procure to Pay

2.   Oracle Payables

3.   Oracle Payments

ü  Credit to Cash

1.   Oracle Advanced Collection

2.   Oracle Bill Presentment Architecture

3.   Oracle Credit Management

4.   Oracle Loans

5.   Oracle iReceivables

6.   Oracle Receivables

ü  Financial Services

1.   Oracle Transfer Pricing

2.   Oracle Enterprise Performance

3.   Oracle Profitability Manager

4.   Oracle Financial Services

ü  Lease and Financial Management

1.   Oracle Lease and Finance Management

Oracle Human Resource Management

           The Oracle Human Resource Management System (HMRS) module helps companies manage the entire recruitment process and provides a real-time view of all HR activities such as recruitment, training, benefits and payroll. The HRMS suite fully integrates with all E-Business Suite applications and offers users an analytics package that allows for easy extraction of HR data.

1.          Oracle Human Resources
2.          Oracle Self-Service Human Resources
3.          Oracle Approvals Management
4.          Oracle Compensation and Benefits Management
5.          Oracle Configuring, Reporting and System Administrator
6.          Oracle Enterprise and Workforce Management
7.          Oracle Fast Formula
8.          Oracle iRecruitment
9.          Oracle Labor Distribution
10.          Oracle Learning Management
11.          Oracle Payroll
12.          Oracle Performance Management
13.          Oracle Succession Planning
14.          Oracle Time and Labor
15.          Oracle Workforce Sourcing, Deployment and Talent Management

Oracle Project

         Oracle Projects Portfolio of applications supports the full lifecycle of project and portfolio management. It provides a single, accurate view of all project-related activities. It allows users to select the best portfolio of initiatives, execute projects in adherence with methodologies, assign the right global resources, proactively streamline project delivery, and track profitability via accurate budgeting, forecasting, and billings/charge-backs.

ü  Assets and Real Estates

1.   Oracle Property Manager

ü  Grants

1.   Oracle Grants Accounting

ü  Projects

1.    Oracle Project Billing

2.    Oracle Project Costing

3.    Oracle Project Management

4.    Oracle Portfolio Analysis

5.    Oracle Project Resource Management

6.    Oracle Project Fundamentals

ü  Contracts

1.          Oracle Contracts
2.          Oracle Project Contracts
3.          Oracle Procurement Contracts
4.          Oracle Sales Contracts
5.          Oracle Service Contracts

Supply Chain Management

       The Oracle Supply Chain applications allow organisations to predict market requirements, innovate in response to volatile market conditions, and align operations across global networks. There are several industry-specific solutions available that incorporate demand management, sales and operations planning, transportation management etc.

ü  Asset Lifecycle Management

1.   Oracle Asset tracking

2.   Oracle Enterprise Asset Management

3.   Oracle Install Base

ü  Configurator

1.   Oracle Configurator

2.   Oracle Fusion Configurator

ü  Logistics

1.   Oracle Landed Cost Management

2.   Oracle Inventory

3.   Oracle Mobile Supply Chain Application

4.   Oracle Warehouse Management

5.   Oracle Integrating Oracle Transportation management with EBS

ü  Master data Management

1.   Oracle Product Information Management

2.   Oracle Site Hub

ü  Manufacturing

1.   Oracle Bills Of Materials

2.   Oracle Cost Management

3.   Oracle Flow Manufacturing

4.   Oracle Engineering

5.   Oracle Manufacturing Execution System for Discrete Manufacturing

6.   Oracle Manufacturing Operations Center

7.   Oracle Manufacturing: Subcontracting

8.   Oracle Manufacturing

9.   Oracle Quality

10.        Oracle Process Manufacturing Quality Management

11.        Oracle Shop Floor Management

12.        Oracle Work in Process

ü  Order Management

1.   Oracle Advanced Pricing

2.   Oracle Configure to Order

3.   Oracle Order Management

4.   Oracle Release Management

5.   Oracle Shipping Execution

ü  Process Manufacturing

1.   Oracle E-records

2.   Oracle Manufacturing Execution System for Process Manufacturing

3.   Oracle Process Manufacturing Cost Management

4.   Oracle Process Manufacturing Mobile Supply Chain Applications for Process Manufacturing

5.   Oracle Process Manufacturing Quality Management

6.   Oracle Process Manufacturing Regulatory Management

7.   Oracle Process Manufacturing System Administration

8.   Procurement

             Oracle Advanced Procurement is an integrated suite of applications that dramatically cuts all supply management costs. The solution helps you to reduce spending on goods and services, streamline procure-to-pay processes, and drive policy compliance.

ü  Contract Lifecycle Management

1.   Oracle Contract Lifecycle Management for Public Sector iProcurement

2.   Oracle Contract Lifecycle Management for Public Sector iSupplier

3.   Oracle Contract Lifecycle Management for Public Sector Sourcing

4.   Oracle Contract Lifecycle Management for Public Sector Purchasing

ü  Procurement

1.   Oracle iProcurement

2.   Oracle iSupplier Portal

3.   Oracle Purchasing

4.   Oracle Sourcing

5.   Oracle Supplier Management

Value Chain and Planning

Oracle's Value Chain Planning solution enables companies to become more information-driven with best-in-class supply chain planning applications built around a core of optimisation, sales and operations planning, and performance management.

ü  Value Chain Planning

1.   Oracle Advanced Planning Command Center

2.   Oracle Advanced Supply Chain Planning

3.   Oracle Collaborating Planning

4.   Oracle Demand Planning

5.   Oracle Global Order Promising

6.   Oracle Inventory Optimization

7.   Oracle Rapid Planning

8.   Oracle Service Parts Planning

9.   Oracle Strategic Network Optimization

ü  Manufacturing Planning

1.   Oracle Capacity

2.   Oracle Manufacturing Scheduling

3.   Oracle Master Scheduling/MRP and Supply Chain Planning

4.   Oracle Production Scheduling

ü  Demantra Planning

1.   Oracle Demantra Deductions and Settle Management

2.   Oracle Demantra Demand Management

3.   Oracle Demantra

4.   Oracle Demantra Predictive Trade Planning

5.   Oracle Demantra Sales

ü  Value Chain Planning

1.   Oracle Value Chain Planning

2.   Oracle Rapid Planning