Oracle Financials Administration / Edition 1

by Shankaran Iyer

Overview

Oracle Financials is a key component of the Oracle Applications Suite - Oracle's complete front to back-end e-business solution. This title addresses the specific needs of a database administrator using Financials. It also covers updating and installing Oracle Financials.

Product Details

ISBN-13:	9780072130980
Publisher:	McGraw-Hill Companies, The
Publication date:	12/01/2001
Series:	Oracle Press Series
Pages:	448
Product dimensions:	7.52(w) x 9.32(h) x 1.25(d)

Table of Contents

	Acknowledgments	xv
	Introduction	xvii
Part I	Introduction
1	Introduction to the Oracle Application Suite	3
	What's in the Oracle Application Suite	4
	Summary	22
2	Roles and Responsibilities of a Financials Administrator	23
	Who Is a Financials Administrator?	24
	Financials Administrator's Responsibilities	26
	Skill Sets of a Financial Administrator	32
	Finding Success as a Financials Administrator	34
	Types of Financials Administrators	35
	Summary	36
Part II	Setting Up the Financials Environment
3	Installing and Configuring the Technology Stack	39
	Improvements in Oracle Financials 11i	40
	Summary	54
4	Upgrading to Oracle Application Suite 11i	57
	Upgrade Objectives	59
	Pre-Upgrade Considerations	62
	Preparation, AutoUpgrade, and Post-Installation Process Categories	66
	AutoUpgrade	79
	Upgrade Case Study	96
	Handling Customizations	97
	Summary	100
5	Managing the Financials Environment	101
	AD Utilities	102
	Analyzing the Database	119
	Changing the Oracle Applications Password	119
	Migrating the Oracle Applications Database	120
	Managing Oracle Workflow	120
	Summary	132
6	Managing the Concurrent Manager	133
	What Is Concurrent Manager?	134
	Summary	146
Part III	Database Administration and Maintenance
7	Managing Database Growth	149
	Components of Database Growth	150
	Advantages of Managing Database Growth	150
	Using Database Statistics to Monitor Growth	151
	Techniques for Managing Growth	157
	Tips for Administrators	169
	Summary	175
8	Change Control and Patch Management	177
	Introducing Patches and Upgrades	178
	Optimizing Strategic Business Processes	190
	Summary	199
9	Managing CBO in an Oraclel li Environment	201
	Rule-Based Optimization vs. Cost-Based Optimization	202
	Why Is CBO Required for Oraclel li?	203
	Setting the Optimizer Mode	203
	CBO Architecture	204
	Methods of Collecting Statistics	205
	Initialization Parameters for Implementing CBO in Oraclel li	210
	Understanding Plan Stability	211
	Summary	219
10	Open Interfaces	221
	What Are Open Interfaces?	222
	Building Your Own Open Interface	224
	Overview of Programming Techniques	225
	Tuning the Interface Programs	234
	Summary	235
11	Troubleshooting	237
	Setting Up the Printer	238
	Troubleshooting the Cost-Based Optimizer	241
	Troubleshooting Workflow	242
	Performance Tuning	244
	Miscellaneous Troubleshooting	249
	When Upgrade Fails	250
	Summary	252
Part IV	Tuning Your Environment
12	Application Performance Tuning	255
	Getting Ready to Tune Performance	256
	Tuning Applications	258
	Tuning the Server	280
	Tuning Memory	280
	Tuning I/O	295
	Tuning the CPU	296
	Tuning SQL	296
	Tuning the Network	306
	Oracle Performance Diagnostic Tools	309
	Summary	322
13	Collecting Statistics Using Statspack	323
	What Is Statspack?	324
	Benefits of Using Statspack vs. utlbstat/utlestat	325
	Using Snapshots in Statspack	326
	Statspack Installation and Setup	330
	Purging and Archiving Statspack Tables	336
	Analyzing Statspack Tables	337
	Summary	343
14	Capacity Planning and Sizing	345
	Benefits of Capacity Planning	346
	Methodology for Capacity Planning	348
	Summary	360
Part V	DBA Tools and Processes
15	Financials Administrator's Toolkit	365
	Financials Administrator's Toolkit: A Closer Look	366
	Oracle Enterprise Manager: An Introduction to the Management Pack Features	370
	Summary	390
16	Backup and Recovery	393
	Backup Requirements of an E-Business Site	394
	Backup and Recovery Processes and the Application Administrator	395
	Application Availability	396
	Standby Recovery Database	403
	Oracle8i Backup Features to Leverage with Applications	407
	Introduction to Oracle Recovery Manager	409
	Summary	417
17	Security	419
	Securing the Oracle E-Business Environment	420
	Managing Security in Oracle Applications	423
	Implementing Security in Custom Modules	424
	Implementing a Virtual Private Network Using Fine Grained Access Control	426
	Oracle Advanced Security	429
	Summary	437
18	Using Oracle8i Features	439
	Fine Grained Access Control	440
	Partitioning	449
	Locally Managed Tablespaces	455
	Database Resource Manager	460
	Oracle Management Pack for Oracle Applications	470
	Other Oracle8i Features	475
	Summary	479
Part VI	Miscellaneous Topics
19	The Oracle Portal Technology	483
	What Is Oracle Portal?	484
	Using Oracle Portal for Application Customization	486
	Installation and Configuration Issues	488
	Examples	492
	Summary	495
20	Oracle Financial Analyzer	497
	Introduction to Oracle Financial Analyzer	498
	Installation and Configuration of OFA	504
	Implementation Tips and Recommendations	507
	Summary	510
	Index	511