ORACLE

SubramanyamMaharshi YadavAnil KessireddySuneel Joseph

1

Contents• Intro to ERP• What is ERP• Evolution• Phases of ERP system• Ideal ERP system• Benefits• Oracle Company P• Products & Services• Oracle – Enterprise Business Suite (EBS)• Oracle Apps Product families• Foot print• Benefits of EBS

• Oracle Architecture (Business and Technical Architecture)

• Multi Org Structure• Data Partition• Security model• Oracle Differentiators • MOAC• Flexi fields (key and data)• Shared Entities• Application Object Library (AOL)• Oracle 11i and R12 (updates; D2K and Java

Applets)

• Oracle Financials• Oracle Supply Chain Management (SCM)• Financials and SCM• Oracle Log in

2

Introduction to ERP

3

Company Profile

• Oracle is a US-based company specialized in Enterprise software solutions, mainly in Database Management along with developing Hardware systems.

• The Enterprise Software giant provides a range of tools for managing business data, supporting business operations and facilitating collaboration and application development.

• Evolved as the second largest software company.

4

Products & Services

PRODUCTS• Database

• Fusion Middleware• Industry Applications• Server and Storage

Systems• Enterprise Manager• Oracle Support• Oracle On Demand

SERVICES• Consulting• Financing• On Demand• SupportSOLUTIONS• Java• Business Intelligence• Enterprise Performance

Management• Data warehousing

5

Oracle E-Business Suite• In order to optimize all the business functions, a complete solution

enabling all these functions access to dynamic data within the organization is necessary. A common data pool which is updated by real-time information should be accessible to all users across different function is very essential.

• Oracle’s E-Business Suite provides a complete solution which encompasses all business functions across various industries incorporating best practice functionalities. Some of the modules covered under Oracle E-Business Suite are as follows:

• Oracle SCM• Oracle Financials• Oracle CRM• Oracle HRMS• Oracle Project Portfolio Management• Oracle Warehouse Management Systems• Oracle OTM

6

Oracle SCM

• Advanced Procurement• Manufacturing• Order Fulfillment• Value Chain Execution• Asset Lifecycle Management• Product Lifecycle Management• Global Trade Management Value Chain

Planning

7

ORACLE FINANCIALS• Oracle Financials delivers a state of art reporting platform

that is natively built on top of an analytical data model.• Single step posting from transactions to the analytical data

model ensures consistent timely and accurate information for both management and external reporting.

• All queries and reports are accurate upto the minute providing multidimensional analysis without the need for a separate data warehouse.

• Simultaneously meet diverse corporate, management, and reporting requirements, such as U.S. GAAP, IFRS, and local statutory requirements

• Embedded transactional intelligence provides access to the most current information

8

Why only ORACLE financials

• Even though none of the tailor made ERP systems hold good in all conditions, ORACLE financials is preferred because of its low cost and less time taken for implementation.

• ORACLE financials is composed of different modules like General Ledger, Inventory, Order entry, Payables, Personnel, etc..

9

Shared entities• An entity is a thing of significance, either real or conceptual, about which

the business or system being modeled needs to hold information. Sample entities: EMPLOYEE, DEPARTMENT, etc.

• Shared Entities are those Oracle Apps entities which are owned by one apps i.e. module but shared by other apps modules as well.

• 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 suit

• Example: You create suppliers in purchasing module (as suppliers are owned by purchasing).

When you need to make payment to your suppliers you will open payables modules and will query same suppliers there to make payment. Hence you see one entity shared by two different modules.

10

11

12

• To Summarize:

• Shared Entities in R12 E- Business Suite enable one – time definition of an object and use of that object across several products.

• Shared Entities are “owned” by a single product for table purposes only.

14

15

To Summarize:

Shared Entities in R12 E- Business Suite enable one – time definition of an object and use of that object across several products.

Shared Entities are “owned” by a single product for table purposes only.

General Ledger Receivables Payables Assets Cash Management Purchasing Inventory Global Consolidations Advanced Collections Lease Managements

16

General Ledger – It receives the accounting information from many oracle applications. After the accounting information is imported then journals can be posted and accounting balances can be updated.

Cash Management – it reconciles cash payments, adjustments, corrections to cash payments. Payables – Suppliers invoices are entered into payables, if appropriate, matched to POs. During

process the invoice distribution is copied from the PO in case of expenses or appropriate liability created in case of inventory item.

Purchasing – Purchasing captures accounting information about requisition & POs. POs are sent to suppliers who respond by delivering goods or services and sending invoices are processed in payables.

Inventory – Purchasing uses items defined in oracle inventory. If the item is designated as a planned item then demand can be generated in the form of requisition and sent to purchasing where POs are generated.

17

Discrete ManufacturingManufacturing Existing SystemFlow Sequencing Flow ManufacturingProduct Scheduling Process Manufacturing

18

Discrete Manufacturing – It helps to manage the entire product life cycle for discrete manufacturing process from starting stage to ending.

Flow Manufacturing – It supports the entire build-to-order manufacturing process including stock, assembles and engineering works. It initiates schedule as soon as customer orders are completed and ensures shipment as soon as build is complete.

Production Scheduling – it enables to take control production scheduling problems and helps to maximize shop floor throughput besides utilization of optimum resources.

19

20

21