Tyco IS Oracle Apps Support Project

Chandrasekhar RedrotuhuFinancial Techno functional Consultant

Oct 07, 2015

Agenda Oracle EBS At TYCO

EBS Technical Architecture

EBS Functional Applications

Oracle E-business Suite Concepts

Applications – Finance

Processes Flow

Current Environment Details

Defect Fix Cycle

Tools Usage

Ticketing Tool

Version Control Tool

Module Wise Flow Diagram

Project Governance

Application Directory Structure For R12

EBS Functional ApplicationsHigh Level Applications Diagram

Oracle Applications R12 Architecture

Oracle E-Business Suite Concepts

Oracle EBS at Tyco•Installation of Oracle Applications first performed in 1998

-10.7 Smart-Client Application (Prod 16.1)-Oracle 7.x database-Citrix-Meta Frame Middle ware used to access the applications over the WAN for distributed offices-GL, AP, FA, INV, PO, ONT, OTM,

•Upgrade to Oracle 11i in 2002-Upgraded to version 11.5.5-Database version 8.1.7.x-GL, AP, FA, INV, PO, ONT,

•I-Expense Implementation 2004-Implemented OIE.I RUP 1

•Perpetual Inventory Deployment 2004-Expanded to 150 inventory Orgs with local warehouses-MSCA

Oracle EBS at Tyco•Upgrade of Applications in 2006

-Upgraded applications to version 11.5.10.2-Upgraded database to version 9.2.0.7 (subsequently upgraded to 9.2.0.8)

•Implementation of 170 Systems Mark view in 2007-Imaging for AP Expense Reports-Imaging and Workflow for Supplier Invoices-OCR Implementation in December, 2008

•Hardware Upgrade in 2009 (EVE Project)-Upgraded hardware and changed technical architecture

•Upgrade of Applications in Apr-2014-Upgraded applications to version 12.1.3-Upgraded database to version 11.2.0.3.0

•Implemented Projects module and Field Services

Oracle General Ledger- Inbound Month-End Feeds from Legacy

(Mainframe) System- Inbound Feeds from Oracle Applications

Modules- Inbound weekly feed of Payroll GL Information

Applications - Finance

Maintenance of COA involves maintenance of rollup groups, parent-child relationships, additions/deletions to values and others for the General Ledger segments.

1. Company2. Town3. Department4. Account Major5. Account Minor6. Future

Processes Diagram

Current Environment Details

EBS Version 12.1.3

DB Version 11.2.0.3.0

DB Size 2.8 TB

3rd Party Applications

Vertex, BaaN, PeopleSoft, DW-BI, Antenna (Mobile Field Service), Planet Press (Invoice Printing), R2Web (Report to Web), Aceva(Application for collection), D &B interface, HEAT (Help desk ticketing system),Salesforce, Workday, Informatics, GPS- Trimble, BAAN, Hiperion etc.

Disaster Recovery

DR Plan - Utilizing the services of a third party site and restoration is from tape. Recovery method - Utilizing EMC BCV technology. 2 hours to perform a restore. currently in the middle of a tech refresh on DMX frame so the technology will change once the VMax is brought on-line. However, methodology will be similar.Development restores from tape and takes about 8 hrs. Backed up once a week.

Application patch set details 12.1.3 latest patches

Customization Details (approximately)

Reports 100+

Interfaces 100+

SQL Plus, SQL Loader, Host Program 75, 20, 60+

OA Framework, Workflow 55, 15+

Forms, Forms-Personalizations, custom.pll 35+, 270, > 50

Packages, Procedure and Functions 500+

Table and View 950+

Defect Fix cycleIdentified Defects once assigned to Wipro Development team will follow the below process:

Resource assigned to look into the defect will start with Analysis in the Development environment and will identity the fix subsequent to his analysis.

Post Analysis, the assigned resource will go ahead with the required develop activity to fix the issue. Once its fixed he will do unit testing to check if the desired functionality is achieved through the fix.

After completion of the development process, with the help of the onsite coordinator the code will be moved to UAT testing environment with the help of Tyco IS IT team. End Users/Business Team will carry out the testing to verify whether the issue is fixed or not.

After successful completion of UAT and all the defects raised during UAT are addressed, the code fix for the defect will be moved to production.

EnhancementsEnhancements assigned to Wipro Development team will follow the same process as described above.

Tools Usage

Sl. No. Tool Name Purpose

1 SQL Developer PL/SQL Development

2 Oracle Reports Builder 10g Oracle Reports Development

3 Oracle Forms Builder 10g Oracle Forms Development

4 Oracle BI Discoverer Administrator Oracle Discoverer Reports Development

5 Oracle BI Discoverer Desktop Oracle Discoverer Reports Development

6 XML Publisher Oracle Reports Development

7 Oracle application Framework(OAF) Oracle webpages Development

8 Oracle Workflow used for business process collaborations across two or more applications

Ticketing Tool

Version Control Tool(SVN)

Oracle General Ledger

General

Financials

Load/

Create

Journals

Post

Journals

Allocations Period

End Close

Open/

Close

Period

Oracle Accounts Payable

Setup

Suppliers

Create

PO:

Non-

Inventory

Load/

Create

Invoices

Match

Invoices

Pay

Invoices

Oracle I-Expense

CaptureExpenses

Approve

Expenses

Audit

Expenses

Create

Invoices

Pay

Expenses

Oracle Assets

Create

Assets

Maintain

Assets

Close

Period

Maintain

System

Module Wise Flow Diagram

Project GovernanceThis governance indicates how the project will be planned, tracked, monitored,

organization structures of customer and Wipro, levels of escalations etc.

Questions

For more information, please visit.

Contact: +1-5516897258 / credrouthu@tyco.com

Useful ERP Info.

http://csrerp.blogspot.com/p/home_14.html?_sm_au_=iVVL5RHLZVrD7jM5