Tuning Tips & Techniques

ORACLE

Oracle

Press

Oracle

E-Business Suite

12

Tuning Tips

&

Techniques

Richard

_Bingham

Mc

Graw Hill Education

New York

_Chicago

San Francisco Athens London Madrid Mexico

_City

Milan New Delhi

Singapore

Sydney

Toronto

[Contents

Acknowledgments

xv

Introduction xvii

1 Technical and Functional

_Summary

1

Oracle E-Business SuiteFunctional

_Summary

3

Functional Core

_Components

4

Business Structures 5

SeedData 6

Oracle E-Business SuiteTechnical

_Summary

11

Oracle Forms 12

HTML-Based User Interface 12

UserInterfacePersonalization 14

Business

_Intelligence

15

Reports

16

OracleWeb

_{Applications Desktop}

_Integrator

17

The Middle Tier 18

Applications

Technology

19

Basic Process Flows 20

Concurrent

_Processing

20

Oracle Workflow 22

TheOracleE-Business SuiteDatabase 23 The

_Applications

_Filesystem

24

OracleE-Business Suite

_Security

24

Integration

Technologies

25 TheManagement Infrastructure 26

Technical Evolution 27

Summary

28

X

Oracle

E-Business Suite 12

_{Tuning Tips}

&

_Techniques

2 Successful

_Enterprise

_Application

Management

29

Objectives:

A Definitionof Success and Failure 30

Success ^

Failure 31

"5 1

Participants

and Roles

The

_Systems

Administrator

_(sysadmin)

31

Database Administrator(DBA) 31

Network Administrator 32

Security

Administrator 32

The

_Help

Desk 32

Business

_Analysts

33

Super

Users 33

Cloud

_Manager

Role 34

The

_Enterprise

_Application

Model: Five Core

_Principles

34

Reliability

35

Availability

37 Performance 40

Optimization

43 Governance 46 Flexible

_Principles

48

Summary

49

3 Oracle E-Business Suite

_{Management Lifecycle}

₅₁

Example

Lifecycle

Models ₅₃

Software

_Development

_Lifecycles

₅₃

Application Lifecycle

Model (ALM) 55

Application

Performance

_Management

_{(APM) 56}

Information

_{Lifecycle Management}

_{(ILM) 56}

ITService

_Management

(ITSM) 57

Applying

Generic

_Lifecycles

₆₀

AFusion

_Lifecycle

Model ₆₁

Summary

₆₄

4 _{The Oracle E-Business}

_Suite

Management

Toolbox ₆₅

Why

aToolbox? 66 Toolbox Structure 66 Toolbox

_Scope

68 AlternativeViews 69

Summary

₆₉

5 A

_Reliability

_Management

Toolbox

71

What Is

_{Application Reliability?}

72

CausesofPoor

_Reliability

72

Measuring Reliability

₇₄

Managing

Reliability

₇₅

Reliability

Tools

Business Process

_Layer

80

Applications

Technology

Layer

96

Platform

_Layer

106

Summary

115

6 An

_{Availability Management}

Toolbox 117

What Is

_{Availability?}

118

Causesof

_Availability

Issues 119

Measuring

Availability

120

Managing

Availability

121

Availability

Tools 122

Business Process

_Layer

122

Oracle

_Applications

_Manager:

Business Flows 122

Workflow

_Monitoring

123

Business

_Intelligence

125

Enterprise Manager

126

Applications Technology

Layer

128

Multiple

Instance

_Availability

128

Reducing

Scheduled Downtime 130

Scripts

andOracle

_Applications

_Manager

135

Platform

_Layer

142

High-Availability

Architecture 142

Oracle

_System

Alerts 144

Enterprise Manager's

OracleE-Business Suite

_Plug-in

I44

Summary

155

7 A Performance

_Management

Toolbox

157

What Is Performance? 159

Causeof PerformanceIssues 159

Measuring

Performance 159

Managing

Performance 160

Performance Tools 1^2

Business Process

_Layer

164

Key

Performance Indicators 164

Product-Specific

Recommendations 164

Logs

andTraces 164

End User

_Experience

167

Applications Technology

Layer 170

Oracle

_Applications

Manager

(OAM) 170

Business

_Intelligence

and

_Reports

I74

Workflow 177

OracleE-Business Suite Search 184

Application

Data 185

Xii

Oracle E-Business Suite 12

_{Tuning Tips}

&

_Techniques

, , 197

Platform

_Layer

TheOracle

Enterprise Manager Plug-in

forOracle E-Business Suite 198

UserInterfaceand Client

Systems

198

201

Oracle FormsServer

202 OAFrameworkand Java

Database Performance Management 211

223 Network Management

Integration

Performance 228 Load

_Testing

228 229 Summary

8 An

_Optimization

Management

Toolbox 231

What Is

Optimization?

232

TOO

Causesof PoorOptimization ^JJ

Measuring Optimization

Managing

Optimization

234

Optimization

Tools 23^

Business Process _Layer 236

Uptake

New Features 236

Optimize

forNew _Usage 2^8

Personalizefor

_Productivity

239

FunctionalTasks 246

Functional

_{Configuration}

and

_{Change Management}

249

Proactive

_Support

251

Applications

Technology Layer

252

Business

_Intelligence

252

Extending

Features 254

Applications

Data Health 255

WebCenter 255

Caching

Framework 257

Integration

257

Oracle Workflow 258

Concurrent

_Processing

260

Alerts and Notifications 260

Setup

and

_{Implementation}

269

Platform

_{Technology Layer}

271

Technical Architecture 272

Simplify

Maintenance 273

Health Checks and Technical

_Compliance

277

Hardwareand

_Networking

279

Watching

the Watchman 283

Summary

284

9 A Governance

_Management

Toolbox 285

WhatIs

_Application

Governance? ₂₈₆

Measuring

Governance ₂₈₇

Managing

Governance ₂₈₈

GovernanceTools ₂₈₈

Business Process

_Layer

₂₉₀

Oracle

_Enterprise

_{Governance, Risk, and}

Compliance

(eGRC) 290

Managing

Customization andPersonalization 292

Functional Features 293

Configuration

_Management

293

Change

Management

298

Data Governance 302

Oracle

_Diagnostic

Framework 303

Applications

_Technology

_Layer

305

Technical Customization Governance 305

User

_Management

307

Security Concepts

308

Platform

_Technology

_Layer

₃₁₁

Authentication

_{Through Identity}

_Management

₃₁₂

TechnicalSecurityBestPractic.es

313

Database Governance

_Options

314

Auditing

315

Networking

317

Integration

318

Enterprise

Manager

Compliance

Standards 320

Summary

322

10

_Getting

and

_{Staying Healthy}

325

Application

Health

_Viewpoints

326

The

_Principals

326

The

_Layers

326

The Priorities 327

Monitoring

327

Understanding

Health Resources 329

The PastIsthe

_Key

totheFuture 329

Capacity

Planning

and

_Forecasting

329

Resource Profiles 330

Service

_Usage

Profiles 331

Elastic

_Capacity

331

Good Health Saves

_Money

332

Healthy

Processes and Procedures 332

Be a

Superhero,

Nota

Target

332

Quality

Information In and Out 334

Ttr

Effective

_Housekeeping

Cycle

1 335

Cycle

2 335

xiv

Oracle E-BusinessSuite 12

_{Tuning Tips}

&

_Techniques

MakingIt Fun 336

337

Help

Desks and

_Support

Help

Desk Toolsand

_Capabilities

337

Approach

33^

339 ProblemIdentification

TechnicalSkills 341

Support

Resources 343

Final

_Tips

for

_{Healthy Application}

Management 344

Project Management

34^

Reusable

_Templates

and Automation 345

Dedicated_Training 346

An Oracle E-BusinessSuiteChecklist 346

r 347

Summary

11

_Being

_Future-Ready

349

Usability

Drives

_Productivity

3^0

Adopting

New

_Technologies

352

Oracle E-Business Suite Evolution 355

The Fusion

_{Applications Roadmap}

356

Fusion

_Applications

Coexistence 358

Oracle

_{Enterprise Repository}

(OER) 358

HowtoBuild Your

_Strategy

361

Take Stock 361

GetUpto Date 362

Understand the Fusion

_Technology

362

Consolidate 363

Understand the Fusion

_{Functionality}

363

Share and Learn 364

Fusion

_Applications

_{Manageability}

364

Enterprise

Manager

364

Common Platforms 365

Problem

_Management

₃₆₆

Summary

367

A Further

_Reading

₃₆₉

Common

_{Applications Components}

₃₇₀

Customer

_Relationship

_Management

₃₇₁

FinancialsProduct

_Family

₃₇₄

Human Resource

_{Management System}

₃₇₇

Supply

Chain

_Management

₃₇₈