Cover image for Oracle financials handbook
Title:
Oracle financials handbook
Author:
James, David, 1964-
Personal Author:
Publication Information:
Berkeley, Calif. : Osborne/McGraw-Hill, [1999]

©1999
Physical Description:
xxxix, 723 pages : illustrations ; 23 cm
General Note:
Includes index.

"2375-7"--Spine.

The authorized Oracle Press editions"--Cover.
Language:
English
Title Subject:
Added Author:
ISBN:
9780078823756
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 J34 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

This book/CD-ROM reference discusses the various products contained in Oracle Financials, with an emphasis on its accounting packages. It provides detailed implementation instructions and advice. It offers a blueprint for planning an implementation.


Table of Contents

Acknowledgmentsp. xvii
Introductionp. xxi
Part I Getting Started
1 An Overview of Oracle Applicationsp. 3
The Structure and Scope of Oracle Applicationsp. 4
Accounting Methodsp. 8
Operational Controlp. 9
The Package Familiesp. 10
What Are the Benefits?
Reasons for Implementing Oracle Financialsp. 12
What Are Your Objectives? Setting Parameters and Expectationsp. 13
Reengineer--Now or Later?p. 13
Which Oracle Architecture Should You Use?p. 14
Conclusionp. 15
2 Implementing Oracle Financials--Essential Conceptsp. 17
Capturing the Financial Information Relevant to Your Businessp. 18
Flexfieldsp. 19
Workflowp. 26
Accounting for Transactionsp. 27
Meeting the Varied Needs of Complex Organizationsp. 29
The Organizational Model Within Oracle Applicationsp. 30
Financials in the Global Businesses Environmentp. 36
Creating a Model of Your Businessp. 36
Global Financial Applicationsp. 39
Conclusionp. 41
Part II What Can the Package Do?
3 Oracle General Ledgerp. 45
The Heart of Your Accounting Systemp. 46
Overview of General Ledgerp. 49
Integration with Other Financials Modulesp. 55
General Ledger Setupp. 69
Accounting Flexfield Design--Best Practicep. 75
What to Considerp. 75
Good Design Principlesp. 86
What to Avoidp. 90
General Ledger Reportingp. 92
Financial Statement Generatorp. 92
Oracle Financial Analyzerp. 100
The Applications Desktop Integrator (ADI)p. 102
Oracle General Ledger Data Modelp. 102
Conversion from Legacy Systemsp. 105
Conclusionp. 110
4 Budgeting and Allocationsp. 113
Differences Between Financial and Management Accountingp. 114
The Limitations of Financial Accountingp. 115
Different Types of Reportsp. 115
Bridging the Gapp. 116
Budgetingp. 116
The Budgeting Processp. 117
Budgetary Control for Nonprofit Organizationsp. 118
Types of Budgetsp. 119
Allocationsp. 122
Allocation Formulasp. 122
Conclusionp. 124
5 Oracle Payablesp. 127
Purposes of a Payables Systemp. 128
Innovative Uses of Oracle Payablesp. 129
An Overview of Payables in Your Businessp. 133
Timing Your Liabilityp. 134
The Payables Workflowp. 134
The Payables Cyclep. 137
Supplier Datap. 147
Accounting Methodsp. 150
Accounting Entries for Payables Transactionsp. 151
Integration with Other Financials Modulesp. 155
The Oracle Payables Data Modelp. 157
Conclusionp. 162
6 Oracle Receivablesp. 165
Oracle Receivables and Your AR Business Processesp. 166
Creating and Managing the Customer Databasep. 168
Customer Profilesp. 169
The Customer Accountp. 170
Business Purposesp. 172
Transactionsp. 172
Invoicesp. 173
Tax Considerationsp. 174
Automatic Account Generation (AutoAccounting and Flexbuilder)p. 177
Printing Transactionsp. 179
Debit Memosp. 180
Credit Memosp. 180
Receiptsp. 181
Adjustmentsp. 190
Commitmentsp. 192
Customer Follow-Upp. 195
Customer Callsp. 195
Dunning Lettersp. 196
Statementsp. 201
Integration with Other Modulesp. 202
Order Entryp. 202
Projectsp. 204
Inventoryp. 204
General Ledgerp. 204
Receivables Open Interfacesp. 205
The Receivables Data Modelp. 207
Advanced Featuresp. 213
The Customer Account and Balance Duep. 214
Reconciliationp. 216
The Purge Featurep. 217
Receivables Conversion Issuesp. 218
Conclusionp. 223
7 Oracle Cash Managementp. 225
The Need for Cash Managementp. 227
Bank Reconciliationp. 228
Cash Forecastingp. 232
Cash Management Interfacesp. 234
The Bank Statement Open Interfacep. 234
The Reconciliation Open Interfacep. 234
The Forecasting Open Interfacep. 235
The Cash Management Data Modelp. 235
Conclusionp. 236
8 Oracle Assetsp. 239
An Overview of Depreciationp. 240
Business Taxes and the Need for Multiple Sets of Booksp. 241
Ledger Accountingp. 242
Tagging with Asset Identifiersp. 243
The Asset Key Flexfieldp. 245
The Category Flexfieldp. 245
The Location Flexfieldp. 247
Merger and Acquisition Considerationsp. 249
Taxesp. 249
Property Tax Calculationp. 249
Income Tax Calculationp. 250
Leased Assetsp. 255
The Asset Additions Cyclep. 255
Capital Budgetingp. 257
Converting to Oracle Assetsp. 257
Converting Tax Booksp. 260
Trade-offs Between Recordkeeping and Reportingp. 260
Conclusionp. 261
9 Oracle Purchasingp. 265
Purchasing Overviewp. 266
Requisitionsp. 267
Suppliersp. 269
Supplier Relationshipsp. 270
Communicating with Suppliersp. 279
The Implications of Multi-Orgp. 281
Multiple Organizations in Inventoryp. 281
Receivingp. 282
Exceptionsp. 283
Receipt Routingp. 284
Drop Shipment Receiptsp. 284
Productivity versus Securityp. 285
Integration with Other Modulesp. 286
Payables Integrationp. 287
Projects Integrationp. 288
Order Entry Integrationp. 288
Inventory Integrationp. 288
Accounting Issuesp. 289
Average and Standard Costingp. 290
Accrual Accountsp. 290
Automatic Account Generation (AutoAccounting and Flexbuilder)p. 291
Implementationp. 292
Converting the Vendor Masterp. 292
Converting Transactionsp. 293
Converting Purchasing Historyp. 295
Testingp. 295
Customizationp. 296
Conclusionp. 297
10 Oracle Inventoryp. 301
Overview of Inventoryp. 302
Integration with Other Modulesp. 304
Item Setupp. 305
Item Numbersp. 305
Attributesp. 308
Revisionsp. 317
Bills of Materialp. 317
Grouping Itemsp. 319
Categories and Category Setsp. 319
Catalogsp. 322
Issues of Volumep. 323
Physical Storage and Managementp. 324
Inventory Organizationsp. 324
Subinventoriesp. 326
Locatorsp. 327
Lot Processingp. 328
Serial Number Processingp. 329
Balancesp. 330
Countingp. 331
Forecasting and Demandp. 339
Kanbanp. 341
Conversion Issuesp. 342
Item Master Conversionp. 343
Transaction Conversionp. 344
Location Conversionp. 345
Accounting Entries for Inventory Transactionsp. 348
Additional Accounting Transactionsp. 350
Variancesp. 352
Average versus Standard Costingp. 354
Nonmaterial Expense Collectionp. 355
Setting Standard Costsp. 356
The Costing Tablesp. 361
Determining Sales Pricesp. 363
Project Manufacturingp. 363
Activity-Based Costingp. 363
Planning and Debugging Cost Transactionsp. 364
Operation of Oracle Inventoryp. 366
Responsibilitiesp. 366
Interface Manager Processingp. 367
Archiving and Deleting Datap. 368
Advantages of an Open Designp. 369
Conclusionp. 370
11 Oracle Order Entryp. 373
Customer Relationshipsp. 375
Agreementsp. 376
Ordersp. 376
Order Typesp. 377
Holds and Approvalsp. 377
Items in Order Entryp. 378
Available-to-Promisep. 382
Standard Value Rule Setsp. 382
Inquiriesp. 383
Shipment Schedulingp. 383
Sales Creditsp. 384
Notes and Attachmentsp. 385
Internal Ordersp. 385
RMAs (Return Material Authorizations)p. 386
Oracle Web Customersp. 388
Report Outputp. 388
The Order Cyclep. 389
Delivery-Based Shippingp. 390
Pick Releasep. 391
Ship Confirmp. 392
Backordersp. 393
Drop Shipmentp. 393
Pricingp. 395
Applying Pricesp. 396
Discountsp. 396
Price List Elementsp. 398
Maintaining Price Listsp. 399
GSA Pricingp. 402
Multicurrency Pricingp. 402
Accountingp. 402
Integration with Other Modulesp. 404
Integration with Receivablesp. 405
Integration with Inventoryp. 406
Integration with Purchasingp. 406
Integration with Sales and Marketingp. 406
Conversion Issuesp. 407
Order Importp. 407
Responsibilitiesp. 408
Conclusionp. 409
12 Using Multiple Currenciesp. 411
Multicurrency Accountingp. 412
Foreign Currency Transactionsp. 413
Revaluationp. 414
Conversionp. 415
Balance Translationp. 415
The Europ. 415
Reporting in Multiple Currenciesp. 417
Conclusionp. 418
13 Oracle Self-Service Web Applicationsp. 421
Oracle's Vision and Directionp. 422
Expressing the Vision Through the Applicationsp. 423
Overview of Oracle Workflowp. 423
Workflow Architecturep. 425
Improved Relationshipsp. 427
Integration with Other Financials Modulesp. 428
Central Controlp. 429
Oracle Self-Service Web Applicationsp. 429
Oracle Web Customersp. 430
Web Suppliersp. 432
Oracle Web Employeesp. 435
Conclusionp. 439
Part III Managing and Customizing an Applications Environment
14 The Oracle Financials Environmentp. 443
Online Operationsp. 445
Query Modep. 446
Data-Entry Modep. 447
Messagesp. 448
Navigation and Special Functions in Formsp. 449
Display Formatsp. 450
Multiple Open Windowsp. 452
Batch Operationsp. 453
The Concurrent Managerp. 453
Concurrent Program Parametersp. 457
Report Sets and Report Groupsp. 458
Printing and Other Means of Outputp. 459
Flexfieldsp. 461
Key Flexfieldsp. 462
Descriptive Flexfieldsp. 464
Contextsp. 465
Flexfield Validationp. 466
Flexfield Securityp. 468
Flexfield Definitionp. 469
National Language Support (NLS)p. 472
AOL-Level Language Determinationp. 472
National Language Support for Reportsp. 473
National Language Support for Flexfieldsp. 474
National Language in Datap. 474
Alertsp. 474
Application Managementp. 476
Users and Responsibilitiesp. 477
Securityp. 479
Instancesp. 482
File Storagep. 485
Quickcodes and Lookup Typesp. 485
Managing the Applications Environmentp. 487
Multiple Environments for Developmentp. 488
Multiple Use of the Applications in Productionp. 491
Multi-Orgp. 492
Profile Optionsp. 494
Oracle's Application Implementation Methodology (AIM)p. 495
Hardware Considerationsp. 496
Database Server Sizing: Your Processor, Memory, and Disk Spacep. 498
Windows 2000 and Unix Operating Systemsp. 502
Distribution of Platformsp. 507
The Client Sidep. 508
Network Linksp. 510
Conclusionp. 511
15 Customization and Modificationp. 513
Anticipating and Planning Customizations and Modificationsp. 515
Risks and Costs in Customizationp. 517
The Framework for Modificationsp. 520
Custom Outputp. 524
Overview of the Open Interfacesp. 532
Populating the Open Interfacesp. 534
Scripts For Inserting Rows into Standard Tablesp. 538
Updating Standard Tablesp. 541
Using Descriptive Flexfieldsp. 545
Customizing Workflowsp. 549
Bespoke/Custom Formsp. 549
Messagesp. 552
Performance Tuningp. 553
The Analysis Processp. 555
The User Reference Manualsp. 556
The Technical Reference Manuals (TMs)p. 556
Reading Codep. 556
Laboratory Methodp. 559
Detailed Table Analysisp. 561
Regression Testingp. 563
Using Regression Tester for Mass Updatesp. 564
Document Controlp. 565
Log Maintenancep. 566
Configuration Managementp. 573
Programming and Documentation Standardsp. 575
Conclusionp. 578
16 Project Organization and Managementp. 581
Oracle Software as a Step Toward Corporate Maturityp. 583
Spreadsheets versus Project Management Softwarep. 584
Developing the Project Planp. 587
The Project Budgetp. 589
The Project Management Hierarchyp. 591
Team Formationp. 593
Functional Team Leadsp. 594
Database Administratorp. 594
Programmersp. 596
Sources of Staffingp. 597
Staff Sizep. 598
Types of Contractsp. 599
Project Phasingp. 602
Managing Your Relationship with Oraclep. 602
Oracle Releases and Versionsp. 603
Resolving Errors: TARs and Patchesp. 604
Managing Bug Fixesp. 606
Reference Sources for Oracle Applicationsp. 607
Applications User Referencesp. 608
AOL Referencesp. 609
Online Help Within the Applicationsp. 610
Applications Technical Referencesp. 610
Oracle Tools and RDBMS Referencesp. 612
Third-Party Oracle Referencesp. 613
Operating System Referencesp. 613
User's Group Materialsp. 613
Managing Implementation Activitiesp. 614
Written Business Proceduresp. 615
Testingp. 616
Configuration Managementp. 621
Problem Managementp. 622
Quality Assurancep. 622
Conclusionp. 623
17 Data Conversion, Training, and Cutoverp. 625
Training Requirementsp. 626
Introductory Trainingp. 626
Technical Trainingp. 628
Cutover Trainingp. 629
The Data-Conversion Approachp. 630
Data Mapping: Legacy to Oraclep. 631
Conversion Processing and Cleanupp. 634
Conversion Strategiesp. 637
The Cutover Planp. 639
Phased Cutoverp. 644
Post-Cutover Activityp. 644
Sunsetting the Legacy Systemp. 645
Conclusionp. 646
18 Live Operation Considerationsp. 649
Closing Accounting Periods-Month-End and Year-Endp. 650
Year-Endp. 652
Subledger Drill-Down and Audit Trailsp. 653
The Import References Tablep. 653
The Global Accounting Enginep. 654
Enhanced Auditability Between General Ledger and Subledgersp. 656
Useful Accounting Workaroundsp. 656
Cross-Ledger Transactionsp. 656
Transfer to Doubtful Debtp. 659
Segment-Level Securityp. 660
Flexible Date Formatp. 661
Automatic Job Submissionp. 661
Matching and Carry-Forward in GLp. 663
Troubleshooting Common Problemsp. 664
Identifying Customizations Prior to an Upgradep. 665
Inability to Close a Periodp. 666
Invalid Bank Accounts and EFT Programsp. 668
Mass Update of Customer Information in Receivablesp. 669
Mismatched Account Typesp. 670
Correcting Data Problemsp. 671
Improving Performance in a Live Systemp. 672
Boosting the Hit Rate of Receivables Lockboxp. 672
Rebuilding Interface Tablesp. 676
Running the GL Optimizerp. 676
Concurrent Manager Queue Designp. 677
Conclusionp. 677
A Overview of Other Oracle Applicationsp. 681
The Customer Suitep. 682
Oracle Sales Compensationp. 682
Oracle Sales and Marketingp. 684
Oracle Call Centerp. 685
The Human Resources Suitep. 685
Oracle Human Resourcesp. 686
Oracle Payrollp. 688
Oracle Training Administrationp. 689
The Projects Suitep. 689
Oracle Project Time and Expensep. 692
Oracle Project Costingp. 692
Oracle Project Billingp. 693
Oracle Activity Management Gatewayp. 695
Oracle Project Connectp. 695
The Oracle Project Analysis Collection Packp. 696
The Manufacturing Suitep. 696
Oracle Bill of Materialsp. 697
Oracle Engineeringp. 699
Oracle Master Production Schedulep. 699
Oracle Material Requirements Planningp. 700
Oracle Work in Processp. 700
Oracle Flow Manufacturingp. 701
Oracle Process Manufacturing (OPM)p. 701
Oracle Servicep. 702
Oracle Qualityp. 704
Indexp. 707

Google Preview