You are previewing Special Edition Using Oracle® 11i.
O'Reilly logo
Special Edition Using Oracle® 11i

Book Description

The first part of Special Edition Using Oracle 11i introduces the Oracle ERP applications and R11i concepts. The reader is then educated on proven techniques for implementing these complex and integrated systems. Configuration and usage of each of the financial, distribution, manufacturing, HRMS, and projects applications are covered, followed by a discussion of working with Oracle Support, consulting firms, and compatible software vendors. The appendixes review the employment market, consulting opportunities, and provide the reader with an implementation checklist. All of R11i's new features are covered in-depth and in practical terms. Not only will readers understand Oracle's new capabilities, they will be able to apply them right away.

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Authors
  3. Tell Us What You Think!
  4. I. Introducing the Oracle Applications
    1. 1. Reviewing ERP and Oracle Corporation
      1. Introduction
      2. Understanding ERP Concepts
        1. Understanding the Attributes of ERP Systems
      3. ERP Advantages Drive Implementation Projects
      4. ERP Disadvantages Must Be Overcome
      5. Application Service Providers
        1. Advantages of Business On-Line
        2. Disadvantages of Business On-Line
      6. Oracle Is a Leading-Edge Technology Company
        1. Rapid Growth
        2. New Products and Capabilities
        3. Constant Change
        4. Competitive Nature
        5. Experimental Disposition
        6. Discourages Customization of Its Applications
      7. Understanding the Oracle Corporation Impact on You—the Customer
        1. Understanding the Impact of Oracle on Type One Customers
        2. Understanding the Oracle Impact on Type Two Customers
      8. Summary
    2. 2. Introducing the Oracle Applications
      1. Financial Applications
        1. General Ledger
        2. Payables
        3. Receivables
        4. Fixed Assets
        5. Projects
      2. Manufacturing Applications
        1. Bills of Material and Engineering
        2. Work In Process
        3. Cost Management
        4. Planning
      3. Supply-Chain Management Applications
        1. Purchasing
        2. Order Management
        3. Inventory
      4. Human Resources Applications
        1. Human Resources Management Systems
        2. Payroll
        3. Advanced Benefits
      5. Other Application Features
        1. Workflow
        2. Multi-Org
        3. System Administration
        4. Other Software
      6. 11i Architecture Concepts
      7. Summary
  5. II. Implementing the Oracle Applications
    1. 3. Software Implementation Methods
      1. Using Oracle’s Application Implementation Method
        1. AIM Is a Six-Phase Method
        2. Defined Deliverables
        3. Advantages of AIM
        4. Disadvantages of AIM
      2. Understanding Rapid Implementations
        1. Description of Rapid Implementation Techniques
        2. Advantages
        3. Disadvantages
      3. Understanding the Program Office
        1. Advantages
        2. Disadvantages
      4. Understanding Phased Implementations
        1. Advantages
        2. Disadvantages
      5. Case Studies Illustrating Implementation Techniques
        1. Big Companies
        2. Small Companies
        3. Green Field Companies
        4. Public Sector
          1. The ASP
      6. Summary
    2. 4. Understanding What Affects the Degree of Effort and Cost
      1. Using the Number and Type of Applications to Estimate Costs
      2. Understanding the Relative Complexity of Each Application
      3. Business Systems Complexity
        1. Counting the Number of Users and Sites
        2. Understanding the Agendas of Users
        3. Considering Other Types of Complexity
        4. Understanding the Effect of Complexity on the Simple Project
      4. Minimizing Customizations and Extensions to Lower Costs
        1. Automating Data Conversion Work
        2. Interfaces
        3. Reports
      5. Business Processes
        1. Documenting and Understanding Processes
        2. Flexible or Rigid Business Requirements and Processes
      6. Other Projects in Process
        1. Non-Oracle Applications
        2. Reengineering and Best Practices
        3. ISO9000
        4. Merger and Acquisition Activity
      7. Capability of the Project Team
        1. Developing the Ability to Resolve Issues
        2. Improving and Managing Tolerance for Change
        3. Understanding the Personality of the Organization
      8. Summary
    3. 5. Project Management and Control
      1. Understanding Project Team Roles
        1. The Steering Committee
        2. The Project Management Team
        3. The Core Team
      2. Developing Issue-Resolution Techniques
      3. Implementing Status Reporting for Your Project
      4. Creating Meeting Minutes
      5. Identifying Red Flags
      6. Maintaining the Project Plan
      7. Maintaining Control of the Project Scope
      8. Managing the Critical Path
      9. Establishing Quality Control Procedures
      10. TAR Tracking, Resolution, and Logging
      11. Understanding the Impact of Other Projects
      12. Summary
    4. 6. Getting Started
      1. Forming the Project Team
        1. Sponsor
        2. Project Manager
        3. Applications Consultant
        4. Technical Staff
          1. Database Administrator
          2. Applications System Administrator
          3. Operating System (Unix or NT) Administrator
          4. Development Staff
          5. Support Staff
      2. Starting Quickly
        1. Set Up a “War Room”
        2. List High-Level Business Requirements
        3. Organize Documents on a Server
        4. Gather Business Volumes and Frequencies
        5. Collect Samples of Inputs and Outputs from the Existing Business Processes
      3. Selecting and Scheduling the Modules
      4. Understanding Typical Tasks, Deliverables, and Milestones
        1. Get Organized
        2. Create the Project Work Plan
        3. How Much Time Is Needed?
        4. Create an Education Plan
        5. Create a Project Environment and Infrastructure Plan
        6. Communicate Your Project Strategy
        7. Develop a Quality Plan
        8. Document the Scope and Objectives of the Project
        9. Develop a Staffing Plan
      5. Summary
    5. 7. Analyzing the Project
      1. Project Analysis Overview
      2. Business Process Analysis
        1. Understanding the Business
        2. Discovering and Documenting the Business Requirements
        3. Discovering the Degree of Fit
        4. Developing a Vision of How the Future Business Process Will Work
      3. Determining Your Reporting Needs
      4. Infrastructure Analysis
        1. Physical Architecture
        2. Developing a High-Level Application Model
        3. Database Instances
        4. Determining IT Department Staffing
      5. Customizations
      6. Legacy Data and Conversion
      7. Understanding Typical Tasks, Deliverables, and Milestones of the Analysis Phase
        1. Determining Existing Business Scenarios
        2. Determining the Existing Computer System Architecture
        3. Determining the Business Transaction Volumes and Frequencies
        4. Agreeing on Detailed Business Requirements
          1. Analyzing Transaction Requirements
          2. Performance and Equipment Requirements
          3. Security Requirements
          4. Reporting and Executive Information Requirements
          5. Audit and Control Requirements
        5. Determining Your Future Business Processes
        6. Determining the Degree of Fit
        7. Transitioning Your Organization
        8. Analyzing and Developing a Data Conversion Strategy
        9. Analyzing and Developing an Application Integration Strategy
      8. Summary
    6. 8. Converting Analysis into Solutions
      1. Designing Customizations
        1. Project Design and Build Standards
        2. Source Code: SQL, PL/SQL, and Programming Languages
        3. Oracle Tools
        4. Designing New Tables
        5. Source Naming Conventions
        6. Custom Installation Routines
      2. The Solution/Conceptual Design Document
        1. The High-Level/Functional Design Document
        2. The Low-Level/Technical Design Document
      3. Estimating Customizations
      4. Managing the Phase
        1. Phase Success Factors
        2. Revisiting Business Requirements
        3. Designing the Technical Architecture
        4. Data Conversion
      5. Initial Project Documentation
        1. Training Documentation
        2. Transitioning to Production
        3. Designing the Transition and Contingency Plans
        4. Preliminary Application Setup Documents
      6. Preparing for System Test
      7. Performance Testing Preparation
      8. Designing the Support Organization
      9. Summary
    7. 9. Enabling the System
      1. Customizations
        1. Modifications
        2. Progressing from the Simple to Complex
        3. Creating and Testing Customizations
        4. Documenting the Customizations
        5. Building Custom Reports
        6. Data Conversion, Interfaces, and APIs
          1. Determining Order of Applications to Convert
          2. Manual, Programmatic, or Automated Data Conversion?
          3. Writing and Testing Data Conversion Programs
          4. Data Conversion Sizing
          5. Using the Open Interfaces
          6. Oracle HR APIs
      2. Managing the Phase
        1. Phase Success Factors
        2. Phase Milestones
        3. Setting Up New Hardware
        4. Installing the Applications
        5. Optimal Flexible Architecture Standard
        6. Deliverables
        7. Testing Strategies
        8. Conference Room Pilot
      3. Some Alternatives to Customizations
        1. Folders
          1. Folder Queries
          2. Sorting in a Folder
        2. Flexfields
          1. Key Flexfields
          2. Descriptive Flexfields
        3. Using the Custom Library
          1. Building Code with the Custom Library
          2. Recommendations and Coding Standards for the Custom Library
        4. Performance Testing
          1. Performance Testing Tools
        5. Additional Reference Material
          1. Technical Reference Manuals
        6. Understanding the Position of Oracle Support
      4. Summary
    8. 10. Launching Your New Systems
      1. Managing Change
        1. Communicating
        2. Establishing User and Management Expectations
        3. Resolving Issues and Concerns
        4. How Much Training Is Appropriate?
      2. Transitioning to New Systems
        1. Preparing for the Transition
        2. Configuring the Production System
        3. Training Your Users
        4. Converting and Loading Data
        5. Dealing with the New Release
        6. Preparing to Support Production Users
      3. Supporting Production Operations
        1. Auditing the Production Systems
        2. Maintaining the Production Systems
        3. Tuning Production Systems
        4. Beginning Continuous Improvement
      4. Summary
  6. III. Configuring and Using the Oracle Applications
    1. 11. Using Oracle General Ledger
      1. Introduction
      2. Relationship to Other Oracle Applications
      3. Discovering New Features in Release 11i
        1. AutoAllocation Workbench
        2. Automatic Journal Reversal
        3. Global Consolidation System
        4. Intercompany Accounting and Balancing
        5. Global Intercompany System
        6. Subledger Drill-Down
          1. Flexfield Pop-Up Window
          2. Segment Value Inheritance
          3. Calendar Auditing
          4. Multicurrency
          5. Revaluation
          6. Multiple Reporting Currencies
          7. Financial Statement Generator
          8. Euro Enhancements
          9. Closing Journals
          10. Process Navigator Close Process
      4. Resolving Issues and Gaps
        1. Summary Accounts
        2. Rollup Groups
        3. Parent Values
        4. Gaps
        5. Parent Accounts
        6. Proposed Enhancements
          1. Ability to Print Range of Journals by User
          2. Change Account Type
          3. Multiple Sorting Options for Account Analysis Reports
      5. Configuring the GL Application
        1. Resolving Critical Setup Issues
          1. Determining the Structure of the Key Accounting Flexfield
          2. Determining the Sets of Books for Your Enterprise
        2. Required Setup Tasks
        3. Understanding Each Setup Task
          1. Defining Responsibilities
          2. Set of Books Setup
            1. Chart of Accounts
            2. Defining Value Sets
            3. Defining a Flexfield Structure
            4. Defining Segment Values
            5. Defining Rollup Groups
            6. Defining Security Rules
            7. Defining Cross-Validation Rules
            8. Dynamic Insertion
            9. Defining an Accounting Calendar
            10. Defining Calendar Period Types
            11. Defining Calendar Periods
            12. Defining Currencies
            13. Defining Conversion Rate Types
            14. Entering Conversion Rates
            15. Creating the Set of Books from an AFF, Currency, and Calendar
            16. Assigning the Set of Books to Responsibilities (or Site)
            17. Entering Account Code Combinations
            18. Defining Intercompany Accounts
            19. Defining Additional Suspense Accounts
            20. Defining Summary Accounts
          3. GL Setup
            1. Setting Up Journal Approval
            2. Defining Daily and Period Rates
            3. Defining Historical Rates
            4. Defining Shorthand Aliases
            5. Defining Journal Entry Sources
            6. Defining Journal Entry Categories
            7. Defining Statistical Units of Measure
            8. Defining Journal Reversal Criteria
            9. Defining Budgetary Control Groups
            10. Defining Encumbrance Types
            11. Defining Automatic Posting Options
            12. Setting the Profile Options
            13. Defining and Assigning Document Sequences
            14. Setting Up the Global Consolidation System
            15. Setting Up the Global Intercompany System
          4. Additional Setups
            1. Configuring the Desktop Integrator
      6. Processing Transactions
        1. Open/Closed Periods
        2. Processing Actual Journals
        3. Entering Journals Online
          1. Batch Level Information
          2. Header Level Information
          3. Line Level Information
          4. Import Journals
          5. Reversing Journals
          6. Recurring Journals
            1. Defining Recurring Formula
            2. Generating Recurring Journal Entries
          7. MassAllocations
            1. Defining MassAllocation Formula
            2. Generating MassAllocation Entries
          8. Using the Desktop Integrator Wizard for Entries
          9. MassAllocations Versus Recurring Journals
          10. Understanding Statistical Entries
          11. Understanding Intercompany Entries
          12. Understanding Currency Processing
          13. Posting the Journals
        4. Revaluation
        5. Translation
        6. Consolidation and Elimination
        7. Processing Budget Journals and Transactions
          1. Budgeting and Encumbrances
          2. Understanding the GL Budgeting Process
          3. Determining Degree of Control
          4. Control Level
          5. Funds Check Level
          6. Other Control Levels
          7. Defining a Budget
            1. Defining Budget Organizations
          8. Entering Budget Amounts
            1. Defining Budget Formulas
            2. Defining Mass Budgets
            3. Using Desktop Integrator Wizard for Budgets
            4. Freezing the Budget
        8. Processing Encumbrances
          1. Encumbrance Types
          2. Entering Encumbrances
          3. Processing Year-End
        9. Understanding the Global Accounting Engine
          1. Setup Steps
        10. How the Engine Works
          1. Reviewing GAE Reports
      7. Understanding Reports
        1. Understanding the Financial Statement Generator
          1. Defining a Row Set
          2. Defining Row Orders
          3. Defining a Column Set
          4. Defining a Content Set
          5. Defining Report Display Groups and Sets
          6. Using the Desktop Integrator Wizard for Reports
      8. Summary
    2. 12. Using Oracle Payables
      1. Relationship to Other Oracle Applications
      2. New Features in Release 11i
        1. Accounting Handled in the AP Subledger
        2. Invoice Gateway
        3. Accounting Events
        4. Viewing the Accounting Lines Window
        5. The T Accounts Window
        6. Recoverable Taxes
        7. Record Refunds
        8. VAT on Expense Reports
        9. MLS Support
        10. Rounding Account for Liability and Cash Clearing
        11. Charge Allocations Replaces the Proration Feature
        12. Invoice Matching to Receipts
        13. Enhanced Accounting for Calculation of Currency Gain or Loss
        14. Improvement of Future Dated Payment and Prepayment Functionality
        15. Summarized Accounting Entries
      3. Configuring the Application
        1. Resolving Critical Setup Issues
        2. Required Setup Tasks
        3. Understanding Each Setup Task
          1. First Steps
          2. Creating a Set of Books
          3. Entering Payment Terms
          4. Defining Matching Tolerances
          5. Tax Authority Type Suppliers
          6. Defining Tax Names and Groups
          7. Defining Invoice Approval Codes
          8. Defining Distribution Sets
          9. Defining Lookups for AP and Vendors
          10. Defining Payment Programs and Formats
          11. Defining Payment Interest Rates
          12. Defining Bank Accounts
          13. Defining Expense Report Types
          14. Defining Employee Lookups
          15. Defining Locations
          16. Defining Employees
          17. Defining Reporting Entities
          18. Defining Income Tax Regions
          19. Defining Inventory Organizations
          20. Defining Financials Options
          21. Defining Payables Options
          22. Defining AP Periods and Period Types
          23. Open Periods in the AP Calendar
          24. Defining Report Sets
          25. Defining Report Formats
          26. Defining Special Calendars
          27. Defining Budgetary Control
          28. Defining Sequential Numbering
          29. Defining Descriptive Flexfields
          30. Setting the Profile Options
      4. Processing Transactions
        1. Setting Up and Modifying Vendors
        2. Entering Invoices
        3. Using Expense Reports
        4. Importing Invoices
        5. Defining and Creating Recurring Invoices
        6. Approving Invoices
        7. Adjusting Invoice Payment Schedules
        8. Adjusting Distributions
        9. Adjusting Purchase Order Matched Invoices
        10. Entering Notes
        11. Writing Off Accruals
        12. Entering Prepayments
        13. Making Payments
          1. Automated Checks
            1. Selecting Items for Payment
            2. Payment Build
            3. Modifying the Selection
            4. Formatting Payments
            5. Confirming Payments
            6. Resetting a Payment Batch
          2. Processing a QuickCheck
          3. Entering Manual Payments
          4. Wire Transfers
          5. EDI
          6. EFT
        14. Changing Payment Distributions
        15. Future Dated Payments
        16. Processing Stop and Void Payments
        17. Reconciling Cash
      5. Balancing the Subledger to the General Ledger
      6. Using Open Interfaces in This Application
        1. Posting to the General Ledger
        2. Creating Mass Additions to Oracle Assets
        3. Using Oracle Alert
        4. Laser-Printed Checks
      7. Using Oracle Cash Management
        1. Bank Reconciliation
          1. AutoReconciliation
        2. Using Cash Forecasting
        3. Release 11i Features
          1. Cash Forecasting Integration with Oracle Projects
          2. Cash Forecasting Integration with Oracle Sales
          3. Cash Forecasting Integration with Oracle Treasury
          4. Bank Reconciliation Integration with Oracle Payroll
          5. Reconciliation of Voided and Reversed Transactions
          6. General Ledger Reconciliation Report
          7. Enhanced Value Date Support
        4. Configuring Oracle Cash Management
          1. Setting Profile Options
          2. Configuring System Parameters
          3. Configuring Bank Transaction Codes
          4. Setting Up Bank Statement Open Interface
          5. Setting Up Reconciliation Open Interface
          6. Setting Up Forecasting Open Interface
          7. Defining Cash Forecasting Templates
          8. Sequential Document Numbering
          9. Defining Request Sets
          10. Defining Descriptive Flexfields
        5. Processing Cash Management Transactions
          1. Reviewing Cash Management Reports
          2. Statement Reports
          3. Transaction Reports
          4. Archiving and Purging Transactions
      8. Summary
    3. 13. Using Oracle Receivables
      1. Introduction
      2. Relationship to Other Applications
      3. Discovering New Features in Release 11i
        1. Using iReceivables
        2. Using Credit Card Processing
        3. Using the Credit Memo Request Workflow
        4. Using AutoAccounting Enhancements
        5. Using AutoInvoice Exception-Handling Enhancements
        6. Using Bills of Exchange Enhancements
      4. Resolving Common Issues and Gaps
        1. AR Is Not a Sales History Reporting System
        2. AR Is Not a Point of Sales System
        3. AR Is a Subsidiary Ledger to the General Ledger
        4. AR Might Impact Your Customers
        5. The Remit-To Strategy Is Not Always Geographical
        6. The Due Date Is Used in Aging Calculations
        7. Performance and Access Issues
      5. Configuring the Application
        1. Resolving Critical Setup Issues
          1. Determining How to Set Up Customers
          2. Generating GL Account Distributions
          3. Using Manual or Automatic Receipts
          4. Understanding Taxation
        2. Setup Tasks
        3. Understanding Each Setup Task
          1. Creating a Set of Books
          2. Setting Up the Account Generator
          3. Creating Transaction Flexfields
          4. Defining the System Item and Territory Flexfields
          5. The Territory Flexfield
          6. Defining Organizations
          7. Creating the Sales Tax Location Flexfield
          8. Defining AutoCash Rule Sets
          9. Defining Receivable Lookups
          10. Defining Demand Class Lookups
          11. Defining AutoInvoice Line Ordering
          12. Defining AutoInvoice Grouping Rules
          13. Defining Application Rule Sets
          14. Defining System Options
          15. Defining Flexible Address Formats
          16. Defining Countries and Territories
          17. Defining Payment Terms
          18. Assigning Reporting Set of Books
          19. Defining Accounting Rules
          20. Maintaining Accounting Periods
          21. Setting Up AutoAccounting
          22. Defining Cash Basis Accounting
          23. Defining Transaction Types
          24. Defining Transaction Sources
          25. Defining Collectors
          26. Setting Adjustment Approval Limits
          27. Defining Remittance Banks
          28. Defining Distribution Sets
          29. Defining Receivable Activities
          30. Defining Receipt Classes
          31. Defining Payment Methods
          32. Defining Receipt Sources
          33. Defining Aging Buckets
          34. Defining Statement Cycles
          35. Defining Statement Messages
          36. Defining Dunning Letters
          37. Defining Dunning Letter Sets
          38. Defining Territories
          39. Defining Salespersons
          40. Setting the Profile Options
          41. Defining Customer Profile Classes
          42. Defining Customers
          43. Defining Remit-To Addresses
          44. Defining Customer Relationships
          45. Defining Lockboxes
          46. Defining the Transmission Format
          47. Defining the Receipt Program
          48. Defining Unit of Measure Classes and Units of Measure
          49. Defining Memo Lines
          50. Defining Cross-Currency Receipts
          51. Defining Taxes
          52. Defining Document Sequences
      6. Converting Data for Major Entities
        1. Creating or Modifying Customers
        2. Creating Open Balances
        3. Creating Transaction History
      7. Processing Transactions
        1. Creating Invoice Transactions
          1. Manually Creating Invoices or Memos
          2. Running AutoInvoice for Batches of Imported Transactions
        2. Processing Receipt Transactions
          1. Applying Receipts Manually
          2. Processing Lockbox Transactions Automatically
          3. Creating Chargebacks
          4. Creating Adjustments
        3. Performing Collection Activities
          1. Recording Calls
          2. Analyzing a Customer Account
          3. Placing an Account on Credit Hold
          4. Creating Statements
          5. Creating Dunning Letters
      8. Balancing the AR Application Internally
      9. Balancing the Subsidiary Ledger to the General Ledger
      10. Using Open Interfaces in This AR
        1. Incoming Transactions to Be Invoiced
        2. Importing and Maintaining Customer Records
        3. Importing Bank Receipts
        4. Updating the General Ledger
        5. Importing Sales Tax Rate Data
        6. Using the Tax Vendor Extension
      11. Understanding Key Reports
        1. Collection Reports
        2. Execution Reports
        3. Invoice Print Reports
        4. Listing Reports
        5. Tax Reports
        6. Miscellaneous Reports
      12. Troubleshooting
    4. 14. Using Oracle Assets
      1. Relationship to Other Applications
      2. Discovering New Features in Release 11i
        1. Security by Book
        2. Asset Maintenance
        3. Maintain Asset Insurance Values
        4. Mass Reclassification
        5. Mass Transfers
        6. Maintaining CIP Assets in Tax Books
        7. The Ability to Run Depreciation Multiple Times for a Current Period
        8. Support for Short Tax Years
        9. What-If Depreciation Analysis on Hypothetical Assets
        10. Unplanned Depreciation
        11. Improved Exception-Handling During Depreciation
        12. View Accounting Lines
        13. MRC Transaction Upgrade Utilities
        14. Multiple Language Support
      3. Critical Implementation Factors
        1. Issues and Gaps
        2. Reviewing Top Enhancement Requests
        3. Resolving Critical Setup Issues
        4. Understanding Each Setup Task
          1. Creating the General Ledger Set of Books
          2. Defining Units of Measure
          3. Defining Employees
          4. Defining Descriptive Flexfields
          5. Defining Journal Entry Formats
          6. Defining Vendors
          7. Creating the Asset Key Flexfield
          8. Creating the Asset Category Key Flexfield
          9. Creating the Location Key Flexfield
          10. Defining System Controls
          11. Defining Locations
          12. Creating Asset Key Flexfield Combinations
          13. Defining QuickCodes
          14. Defining Fiscal Years and Calendars
          15. Defining Book Controls
            1. Calendar Information
            2. Accounting Rules
            3. Natural Accounts
          16. Journal Categories
          17. Configuring Account Generator for Assets
          18. Defining Depreciation Methods
          19. Defining Depreciation Ceilings
          20. Defining Investment Tax Credits
          21. Defining Prorate Conventions
          22. Defining Price Indexes
          23. Defining Asset Categories
          24. Defining Financial Options
          25. Setting the Profile Options
      4. Converting Data for Major Entities
        1. Understanding the Mass Additions Interface
        2. Adding Assets Manually
        3. Assigning Assets to Depreciation Books
        4. Transferring Assets
        5. Retiring Assets
        6. Making Mass Transactions
          1. Mass Additions
          2. Mass Copy
          3. Mass Transfers
          4. Mass Change
          5. Mass Retirements
          6. Mass Revaluation
          7. Mass Depreciation Adjustment
          8. Mass Additions Purging
          9. Data Archive and Purge
        7. Using Construction in Progress
        8. Understanding Investment Tax Credits
        9. Understanding Units of Production
        10. Understanding Capital Budgeting
        11. Understanding Depreciation
      5. Balancing the Subledger to the General Ledger
      6. Using Open Interfaces in This Application
        1. Fixed Asset Desktop Integrator
        2. Importing Assets Using the Mass Additions Interface
        3. Using the Budget Interface
        4. Using the Production Interface
        5. Using the Adjusted Current Earnings Interface
        6. Using the INV Interface
      7. Understanding Key Reports
      8. Summary
    5. 15. Using Oracle Projects
      1. Introduction
      2. Relationship to Other Applications
      3. Discovering New Features in Release 11i
        1. Multicurrency Transactions
        2. Multicurrency Billing
        3. Interproject Billing
        4. Cross-Charging and Intercompany Billing
        5. Tax Information by Receivables Invoice Lines
        6. Project Allocations
        7. Enhanced Reporting and Analysis
          1. View Accounting Lines Window
          2. T-Accounts Window
          3. Subledger Accounting—Drill Down from GL
          4. Projects Intelligence
            1. Workbook—Project Cost Analysis
            2. Workbook—Project Margin Analysis
            3. Workbook—Project Revenue Analysis
        8. Enhanced Transaction Import
        9. Integration with Other Oracle Applications
          1. Oracle Internet Time
          2. Oracle Cash Management
        10. Oracle Activity Management Gateway Release 11i
        11. Oracle Project Connect (for Microsoft Project) Version 2.5
      4. Critical Implementation Factors
        1. New Products
          1. Project Resource Management
          2. Oracle Time and Labor
          3. Project Contracts
        2. Enhancement Requests
      5. Configuring the Application
        1. Resolving Critical Setup Issues
          1. Implementing Oracle Projects as a Standalone Application
          2. Designing Your Chart of Accounts
          3. Human Resources Organizations
          4. Reporting
          5. Other Impacted Applications
        2. Basic Setup Tasks
        3. Understanding Each Setup Task
          1. Setting the Profile Option PA: Licensed to Use Project Billing
          2. Setting the Profile Option HR: Cross Business Group
          3. Setting the Profile Option HR: Enable Security Groups
          4. Defining Your Set of Books
          5. Enabling Currencies You Plan to Use
          6. Defining Locations
          7. Defining Organizations
          8. Defining Organization Hierarchies
          9. Runing the Enable Multiple Security Groups Process
          10. Defining Security Profiles (and Global Security Profiles)
          11. Specifying a Project Burdening Hierarchy for Each Business Group
          12. Defining Job Groups
          13. Defining Jobs
          14. Defining Job Mapping
          15. Defining Employees
          16. Defining Customers
          17. Setting Up Output Tax Codes for Customer Invoices
          18. Setting Up Output Tax Exemptions for Customer Invoices
          19. Defining Implementation Options
          20. Defining PA Periods
          21. Defining Expenditure Categories
          22. Defining Revenue Categories
          23. Defining Units
          24. Defining Descriptive Flexfields
          25. Defining Expenditure Types
          26. Defining Nonlabor Resources
          27. Defining Transaction Sources
          28. Defining Cost Rates for Expenditure Types
          29. Defining Usage Cost Rate Overrides
          30. Defining Compensation Rules
          31. Defining Labor Cost Multipliers
          32. Implementing Overtime Processing
          33. Defining Cost Bases and Cost Base Types
          34. Defining Burden Cost Codes
          35. Defining Burden Structures
          36. Defining Burden Schedules
          37. Defining Billing Cycles
          38. Defining Payment Terms
          39. Defining Agreement Types
          40. Defining Bill Rate Schedules
          41. Defining Invoice Formats
          42. Defining Credit Types
          43. Defining Event Types
          44. Defining Budget Types
          45. Defining Budget Entry Methods
          46. Defining Budget Change Reasons
          47. Defining Resource Lists
          48. Defining Project Statuses
          49. Defining Class Categories and Class Codes
          50. Defining Service Types
          51. Defining Project Role Types
          52. Defining Project Customer Relationships
          53. Defining Contact Types
          54. Defining Probability Lists
          55. Defining Project Types
          56. Defining Project Templates
          57. Defining Derived Columns
          58. Defining Displayed Columns
          59. Specifying Profile Option Values
          60. Defining Request Groups for Report and Process Security
          61. Defining Responsibilities for Different Functional Users
          62. Defining Frequently Used Folders
          63. Setting Up AutoAccounting
          64. Defining Indirect Projects for Cost Collection
          65. Defining Contract Projects for Cost Collection
            1. Creating a Project Type Using the Class Contract
            2. Creating a Project Template Using a Contract Project Tpe
            3. Creating a Contract Project Using a Contract Project Template
            4. Applying Project Versus Task Overrides
            5. Fixed Dates on Bill Rate Schedules
          66. Defining Capital Projects for Cost Collection
            1. Creating a Project Type Using the Class Capital
            2. Create a Project Template Using a Capital Project Type
            3. Create a Capital Project Using a Capital Project Template
            4. Define an Asset on a Capital Project
          67. Enabling Oracle Internet Time
      6. Advanced Configuration Tasks and Extensions
        1. Oracle Projects Advanced Configuration Tasks
          1. Setting Up AutoAccounting
            1. Example of Setting Up AutoAccounting
            2. Defining a Rule to Determine the Company Using a Constant
            3. Defining a Lookup Set to Determine the Department from an Intermediate Value
            4. Defining a Rule to Determine the Department Using an Intermediate Parameter and Lookup Set
            5. Defining a Rule to Determine the Account Using a SQL Statement
          2. Account Generator
            1. Example of Setting Up Account Generator
            2. Starting a Basic Workflow for Project Supplier Invoice Account Generation
            3. Assigning a Constant Value to Your Company Segment (Node 2)
            4. Assigning a Lookup Set to Your Department Segment (Node 3)
            5. Creating a Workflow Function to Call Your SQL Procedure (Node 6)
            6. Finished Workflow Example
          3. Allocations
            1. Defining an Allocation Rule
            2. Defining the Prorate Basis
            3. Defining the Project Allocation Sources
            4. Defining the Project Allocation Targets
            5. Defining the Project Allocation Offset
          4. Burdening
            1. Burden Options
            2. Burden Cost on Same Expenditure Item (Project A)
            3. Burden Cost on Same Expenditure Item (Project A) - Account for Burden Cost Components (Project Burden)
            4. Burden Costs as Separate Expenditure Item (Project A)
          5. Project/Budget Workflows
            1. Common Setups Steps for Project and Budget Status Workflows
            2. Project Status Change Workflow
            3. Entries Budget Status Change Workflow
            4. Advanced Workflow Setups
          6. Interproject Billing Setup
          7. Multicurrency Setup—General Ledger
          8. Multicurrency Setup—Projects
          9. Multicurrency Billing Setup
          10. Multinational Global Projects
          11. Client Extensions
        2. Setting Up Projects to Integrate with Other Oracle Applications
          1. Advanced Setup Tasks—Profile Options
          2. Projects Integration with Oracle Purchasing
          3. Projects Integration with Oracle Payables
            1. Creating an Employee as a Supplier
            2. Defining Payables Distribution Sets
            3. Setting Up Account Generator for Payables and Expense Reports
            4. Setting Up and Enabling Oracle Internet Expense
          4. Projects Integration with Oracle Receivables
            1. Setting the Require Salesrep Option
            2. Defining Transaction Types for Invoice Processing
            3. Defining Automatic Accounting in Oracle Receivables
            4. Salesreps and Credit Types
            5. Setting Up Invoice Line Tax Codes
          5. Projects Integration with Oracle Inventory
            1. Establishing Transaction Types in Inventory
            2. Setting Profile Option and Expenditure Type Class
            3. Verifying Transaction Source
        3. Setting Up Projects to Integrate with External Systems via Activity Management Gateway
          1. Database Setups
          2. Projects Application Setups
          3. Setting Up Security
          4. Implementing Your Interface Code That Calls the Appropriate AMG APIs
          5. Existing Integration Between Oracle Projects and External Systems
            1. Integration to Project Management Systems—COTS Solutions
            2. Oracle Projects to P3E Integration (Releases 11 - 11i)
            3. Project Loader (Releases 10.7 - R11i)
            4. Project Connect (Releases 10.7 - R11i)
            5. Other Applications
      7. Converting Legacy Data
        1. Projects, Tasks, Agreements, Funding, and Budgets
          1. Tools to Load Project Setup Information
            1. DataLoaders
            2. Project Loader
          2. Items to Consider in Converting Project Setup Information
        2. Transactions Costs, Revenue, and Billing
          1. Converted Project Costs and the General Ledger
          2. Transaction Import
          3. Converting Revenue and Billing Amounts
          4. Conversion Events
        3. Balancing the Conversion
          1. GL Balances
          2. External Systems
      8. Processing Transactions
        1. Creating Basic Expenditure Items
          1. Creating Labor Transactions
            1. Oracle Internet Time
            2. Pre-Approved Batch Entry of Labor
          2. Creating Expense Report Transactions
            1. Oracle Internet Expense Entry
            2. Pre-Approved Batch Entry Expense Reports
          3. Creating Usage Transactions
          4. Creating Inventory Transactions
            1. Miscellaneous Project Issues
            2. Running the Cost Collector Process
          5. Transaction Import for Importing Inventory Costs to Projects
          6. Distributing Costs
            1. Distributing Labor Costs
            2. Distributing Expense Costs
            3. Distributing Usage Costs
          7. Interface Streamline Processes
          8. Interface Labor Costs to GL
          9. Interface Expense Reports to Payables
          10. Interface Usage and Miscellaneous Costs to GL
          11. Transferring Costs from Other Applications
          12. Processing Adjustments
          13. Contract Projects: Revenue Recognition and Invoicing
            1. Preparing for Revenue and Invoice Generation
            2. Entering Agreements and Funding
            3. Entering Revenue Budgets
            4. Creating Revenue and Invoice Events
            5. Revenue and Invoice Distribution Rules
            6. As-Works Occurs
            7. Cost-to-Cost (Percent Spent)
            8. Based on Physical Percent Complete
            9. Distribution Rule Scenarios
          14. Work/Work
          15. Work/Event
          16. Event/Work
          17. Cost/Work
          18. Cost/Event
            1. Revenue Generation Processes
            2. Invoice Generation Processes
          19. Transferring Revenue and Invoices to Other Applications (Streamline Processes)
            1. Adjusting Revenue and Invoices
            2. Credit Memos
            3. Cancel/Write Off a Released Invoice
            4. Invoice Cancel
            5. Invoice Write-Off
          20. Changing Invoice Currency
          21. Capital Projects: Asset Generation
            1. Placing an Asset in Service
            2. Generating Asset Lines and Interfacing Assets to Oracle Assets
        2. Advanced Transactional Features
          1. Burdening
            1. Burden on the Same Expenditure Items
            2. Burden on Separate Expenditure Items
            3. Burden Schedule Changes—Compiling a New Version
          2. Allocations
            1. Generating Allocation Transactions
            2. Reviewing Allocations Results
            3. Releasing or Deleting Allocations Results
      9. Project Reporting
        1. Expenditure Inquiry
          1. Viewing Expenditures—Expenditure Inquiry Form
          2. Folder Tools
          3. Viewing Accounting Lines
          4. Viewing Item Details
        2. Understanding Project Commitments
          1. What Qualifies As Commitments
          2. Formulas for Calculating Amounts and Quantities
          3. Relieving Commitments
        3. Project Status Inquiry
          1. Populating the Summarization Tables
          2. Setting the Reporting Period
          3. Viewing Information—Project Status Inquiry Form
          4. Project Status Screen
          5. Task Status
          6. Resource Status
          7. Folder Tools
          8. Viewing Multiple Budgets and Resource Lists
          9. Modifying Project Status Columns
            1. Modifying Columns to Be Factored By or Totaled
            2. Changing the Default Columns or Adding New Columns
            3. Adding Calculations to Predefined Definitions
          10. PSI Client Extension
        4. Reconciling Projects to GL
          1. Account Setup
          2. How to Find Project Details from Your General Ledger
          3. Timing Differences—Closing Cycle
      10. Troubleshooting
        1. Troubleshooting Using Custom Folders with Expenditure Inquiry
        2. Troubleshooting Transaction Import Integration
        3. Labor Distribution
        4. Troubleshooting Expense Report Distributions, Interface to Payables
        5. Troubleshooting Revenue Processing
        6. Troubleshooting Invoice Processing
        7. Adding New Organizations in Oracle Human Resources
      11. Summary
    6. 16. Using Oracle Purchasing
      1. How Purchasing Relates to Other Applications
      2. Discovering New Features in Release 11i
        1. Advanced Workflow Technology
          1. Process Navigator Workflows
          2. Improved Notifications
        2. Approved Supplier List
        3. Automatic Sourcing
        4. Copy Documents
        5. Country of Origin Information
        6. Expiration Date in Blanket Agreements
        7. Electronic Document Delivery
        8. General Ledger Drill-Down
        9. Invoice-to-Receipt Matching
        10. Material Shortage Alerts
        11. Multiple Reporting Currencies
        12. Payment on Receipt
        13. Purchasing Documents Open Interface
        14. Receipt-Based Exchange Rate
        15. Receiving Customer Returns
        16. Recoverable Taxes
      3. Critical Implementation Factors
        1. Defining Your Accrual Options
        2. Defining Your Control Options
        3. Defining Your Default Options
        4. Defining Your Numbering Options
        5. Issues and Gaps
          1. Reviewing Top Enhancement Requests
      4. Configuring the Application
        1. Resolving Critical Setup Issues
        2. Understanding Each Setup Task
          1. Defining the Set of Books
          2. Defining Descriptive Flexfields
          3. Defining Organizations
          4. Defining Cross-Reference Types
          5. Setting the Profile Options
          6. Defining Financials Options
          7. Defining Accounting Flexfield Combinations
          8. Defining Tax Names
          9. Defining Payment Terms
          10. Opening and Closing Periods in the Accounting Calendar
          11. Opening and Closing Periods in the PO and INV Calendars
          12. Defining Locations and Location Associations
          13. Defining the Job Flexfield
          14. Defining Jobs
          15. Defining the Position Flexfield
          16. Defining Positions
          17. Defining Position Hierarchies
          18. Entering Employees
          19. Defining the Item Categories Flexfield
          20. Defining Item Categories
          21. Defining Category Sets
          22. Setting the Default Category Set
          23. Defining Control Rules and Groups
          24. Defining Position Controls or Controls for Jobs
          25. Filling the Employee Hierarchy
          26. Setting Up the Users
          27. Setting Up Purchasing Quickcodes
          28. Defining Freight Carriers
          29. Defining Inspection Codes
          30. Defining Hazard Classes
          31. Defining UN Numbers
          32. Defining Standard Notes
          33. Defining Unit of Measure Classes and Units of Measure
          34. Defining Unit of Measure Conversions
          35. Defining the System Items Key Flexfield
          36. Defining Item Attribute Controls
          37. Defining Item Templates
          38. Defining the Item Catalog Flexfield
          39. Defining Item Catalog Groups
          40. Defining Buyers
          41. Defining Items and Item Relationships
          42. Defining Line Types
          43. Starting the Autosubmit Program
          44. Defining Purchasing Options
          45. Defining Receiving Options
          46. Defining Transaction Reasons
          47. Configuring Flexbuilder
          48. Requesting the Receiving Transaction Processor
          49. Defining Concurrent Processing Intervals
      5. Converting Data for Major Entities
        1. Entering Vendors
        2. Processing Requisitions and Express Requisitions
        3. Processing Requests for Quotation
        4. Processing Purchase Orders
          1. Entering Purchase Orders
          2. Entering Releases
          3. Using Autocreate
        5. Approving and Forwarding Documents
        6. Using MassCancel
        7. Entering Receipts and Receiving Transactions
        8. Processing Returns to Vendor
        9. Writing Off Accruals
        10. Purging Purchasing and AP Together
        11. Importing Requisitions
      6. Reviewing Topics of Interest
        1. Using Oracle Alerts and Workflow
      7. Understanding Key Reports
      8. Troubleshooting
    7. 17. Using Oracle Inventory
      1. Introduction
      2. Oracle Inventory Relationships to Other Applications
      3. Discovering New Features in Release 11i
      4. Critical Implementation Factors
        1. Reviewing Top Enhancement Requests
      5. Configuring the Application
        1. Required Setup Tasks
        2. Creating a Set of Books
        3. Defining the System Items Key Flexfield
        4. Defining the Item Categories Key Flexfield
        5. Defining the Item Catalog Group Key Flexfield
        6. Defining the Stock Locators Key Flexfield
        7. Defining the Account Alias Key Flexfield
        8. Defining the Sales Order Key Flexfield
        9. Defining Locations
        10. Defining Employees
        11. Defining the Organization Calendar and the Calendar Exceptions
        12. Defining Organizations
        13. Defining Organization Inventory Parameters
        14. Changing to a Valid Organization
        15. Defining Intercompany Relations
        16. Defining Receiving Options
        17. Defining Picking Rules
        18. Defining Available-to-Promise Rules
        19. Defining Planners
        20. Defining Unit of Measure Classes, Units of Measure, Unit of Measure Conversions, and Interclass Conversions
        21. Defining Subinventories
        22. Defining Stock Locators
        23. Defining Item Attribute Controls
        24. Defining Categories
        25. Defining Category Sets
        26. Defining Default Category Sets
        27. Defining Statuses
        28. Defining Item Catalog Groups
        29. Defining Item Types
        30. Defining Item Templates
        31. Defining Items
        32. Defining Cross-Reference Types
        33. Defining Item Delete Constraints
        34. Defining Cost Types
        35. Defining Cost Activities
        36. Defining Material Subelements
        37. Defining Material Overheads
        38. Defining Default Material Overhead Rates
        39. Defining Freight Carriers
        40. Defining the Organization Shipping Network
        41. Defining Shipping Methods
        42. Defining Economic Zones
        43. Defining Movement Statistics Parameters
        44. Defining Account Aliases
        45. Defining Transaction Source Types
        46. Defining Transaction Types
        47. Defining Transaction Reasons
        48. Defining Purchasing Options
        49. Opening Accounting Periods
        50. Starting the Material and Cost Interface Concurrent Managers
        51. Setting the Profile Options
        52. Defining Container Types
        53. Defining Commodity Codes
        54. Defining and Cross-Referencing Customer Items
        55. Defining Notification Lists
        56. Defining Shortage Parameters
        57. Defining Kanban Pull Sequences
      6. Loading System Items
      7. Processing Transactions
        1. Entering Receipts and Receiving Transactions
        2. Entering Returns and Adjustments
        3. Transferring Material Between Subinventories
        4. Transferring Material Using Move Orders
        5. Transferring Material Between Organizations
        6. Maintaining Shipments
        7. Miscellaneous Transactions
        8. Receiving and Inspecting Customer Returns
        9. Returning Items to Customer
        10. Purging Transactions
        11. Reserving Inventory
        12. Entering Statistics
        13. Item Definition
        14. Defining Lot and Serial Number Information
        15. Defining Item and Subinventory Information
        16. Defining Item Relationships, Cross-References, and Manufacturer Part Numbers
        17. Defining Item Transaction Default Subinventories and Locators
      8. Additional Application Functions
      9. Summary
    8. 18. Using Oracle Order Management
      1. Introduction
      2. Relationship to Other Applications
      3. Discovering New Features in Release 11i
        1. Order Management As a Fulfillment Engine
        2. Order Capture from Any Source
        3. Order Import Enhancements
        4. Item Cross-Reference
        5. Decimal Quantity Handling
        6. Over/Under Shipment
        7. Returns Enhancements
        8. Order Changes
        9. Order Cancellations
        10. Order Copy
        11. Credit Checking
        12. Holds and Releases
        13. Error Message Handling Window
        14. Freight and Special Charges
        15. Invoicing
        16. Order Numbering
        17. Defaulting
        18. Line Sets
        19. Order Workbench Enhancements
        20. Enhanced Planning and Reservation Logic
      4. Configuring the Application
        1. Resolving Critical Setup Issues
        2. Setup Tasks
        3. Understanding Each Setup Task
          1. Defining a Set of Books
          2. Defining Key Flexfields
          3. Defining the Stock Locators Flexfield
          4. Defining the Sales Order Flexfield
          5. Defining the Item Flexfield
          6. Defining the Territory Flexfield
          7. Defining the Sales Tax Location Flexfield
          8. Defining Item Categories Flexfield
          9. Defining Item Catalog Group Flexfield
          10. Defining Inventory Organizations, Organization Parameters, Subinventories, and Picking Rules
          11. Defining Profile Options
          12. Defining Item Validation Organization Parameter
          13. Defining Invoicing Information
          14. Defining Salespersons
          15. Defining Tax
          16. Defining Quick Codes
          17. Defining Workflow
          18. Defining Document Sequences (Order Numbering)
          19. Defining Order Import Sources
          20. Defining Units of Measure
          21. Defining Item Information
          22. Defining Item Configurations
          23. Managing Pricing
          24. Managing Customers, Customer Profiles, and Customer Relationships
          25. Entering Customer Agreements
          26. Defining Transaction Types
          27. Defining Cost of Goods Sold
          28. Defining Defaulting Rules
          29. Defining Credit Checking
          30. Defining Holds
          31. Defining Attachments
          32. Defining Freight Charges
          33. Defining Freight Carriers
          34. Defining Shipping Tolerances
        4. Providing Data for Major Entities
          1. Releasing Orders to Manufacturing
          2. Sending Shipments to Oracle Accounts Receivable for Invoicing
          3. Importing Order Information into Order Management
          4. Using the Demand Interface
          5. Using the Inventory Interface
          6. Using the RMA Interface
          7. Using the Ship Confirm Open Interface
      5. Processing Transactions
        1. Order Processing
          1. Sales Order Workbench
          2. Entering Sales Orders
          3. Copying Sales Orders
          4. Scheduling Orders
          5. Canceling Orders and Returns
          6. Applying Mass Changes
          7. Applying and Releasing Holds
          8. Closing Orders
        2. Understanding Pricing Functions
        3. Understanding How Credit Checking Works
        4. Understanding Shipping Tolerances
        5. Processing Returned Material
        6. Understanding Order Import
        7. Understanding Invoicing Activity
        8. Understanding Order Purge
      6. Understanding Key Reports
      7. Troubleshooting
    9. 19. Using Oracle Engineering and Bills of Material
      1. Using Oracle Engineering
        1. Discovering New Features in Release 11i
        2. Critical Implementation Factors
          1. Issues and Gaps
        3. Configuring the Application
          1. Resolving Critical Setup Issues
          2. Understanding Each Setup Task
            1. Setting the Profile Options
            2. Entering Employees
            3. Defining Change Order Types
            4. Defining Engineering Change Order Departments
            5. Defining Autonumbering
            6. Defining Approval Lists
            7. Defining Reasons
            8. Defining Priorities
            9. Running the AutoImplement Concurrent Manager Program
        4. Converting Data for Major Entities
        5. Processing Transactions
          1. Maintaining Engineering Change Orders
          2. Defining, Implementing, Mass Changing, and Purge Engineering Change Orders
            1. Defining an Engineering Change Order
            2. Implementing Engineering Change Orders
            3. Mass Changes Using Engineering Change Orders
            4. Purging Engineering Change Orders
          3. Managing Engineering Prototypes
            1. Defining an Engineering Item and Revisions
            2. Defining an Engineering BOM and Routing
            3. Defining Item/Organization Attributes
            4. Transferring Engineering Data
        6. Using Open Interfaces in This Application
          1. Importing Item Information
          2. Using Engineering Alerts
        7. Understanding Key Reports
      2. Using Oracle Bills of Material
        1. Discovering New Features in Release 11i
        2. Critical Implementation Factors
          1. Issues and Gaps
        3. Configuring the Application
          1. Resolving Critical Setup Issues
          2. Understanding Each Setup Task
            1. Setting the Profile Options
            2. Defining Exception Templates
            3. Defining and Building the Workday Calendar
            4. Assigning a Calendar to an Organization
            5. Defining Bills of Material Parameters
            6. Defining Department Classes
            7. Defining Resources and Resources Groups
            8. Defining Simulation Sets
            9. Defining Locations
            10. Defining Departments
            11. Assigning Resources and Shifts to Departments
            12. Defining Overheads and Associating Overheads with Departments
            13. Defining Alternates
            14. Defining Standard BOM Comments
            15. Defining Standard Instructions
            16. Defining Change Order Types
            17. Defining Delete Constraints
        4. Converting Data for Major Entities
        5. Processing Transactions
          1. Maintaining Bills of Material
            1. Defining a Bill
            2. Mass Changing Several Bill
            3. Deleting Item Information
          2. Defining Routings and Standard Operations
          3. Calculating Lead Times
          4. Understanding Configure To Order
        6. Using Open Interfaces in This Application
          1. Using the Bill and Routing Import Interface
        7. Understanding Key Reports
      3. Troubleshooting
    10. 20. Using Oracle Cost Management
      1. Understanding the Structure of the Cost Management Application
        1. Understanding Definitions of Cost Elements
        2. Activities
        3. Basis Types
      2. Cost Management’s Relationship to Other Applications
      3. Discovering New Features in Release 11i
      4. Critical Implementation Factors
      5. Configuring the Application
        1. Required Setup Tasks
        2. Resolving Critical Setup Issues
          1. Costing Organization Parameters
          2. Defining Default Interorganization Information
            1. Default Interorganization Options
            2. Default Interorganization Transfer Accounts
          3. Inventory or Manufacturing Costing
          4. Defining WIP Accounting Classes
            1. Types of Discrete Production
            2. Repetitive Accounting Classes
            3. WIP Accounting Class Elemental Accounts
        3. Setup Tasks
        4. Understanding Each Setup Task
          1. Setting Profile Options
            1. CST: Account Summarization
            2. CST: Cost Rollup—Wait for Table Lock
            3. CST: Cost Update Debug Level
            4. CST: Exchange Rate Type
          2. Setting the Security Functions
            1. Privilege to View Cost (CST_VIEW_COST_INFORMATION)
            2. Privilege to Maintain Cost (CST_MAINTAIN_COST_INFORMATION)
            3. Other Privileges That Might Be Implemented with Security Functions
          3. Defining Cost Types
          4. Defining Activities and Activity Costs
          5. Defining Cost Groups
          6. Defining Material Sub-Elements
          7. Defining Overhead and Overhead Cost Sub-Elements
            1. Defining Resources
            2. Entering Employees and Employee Labor Rates
          8. Defining Material Overhead Defaults
          9. Associating Expenditure Types with Cost Elements
          10. Defining Category Accounts and Associating Category Accounts with WIP Accounting Classes
      6. Processing Transactions
        1. Defining Item Costs
        2. Copying and Mass Editing Item Costs and Accounts
          1. Mass Editing Item Costs
          2. Mass Editing Item Accounts
          3. Copying Cost Between Two Cost Types
        3. Rollup Assembly Costs
        4. Updating Standard and Average Costs
          1. Reporting Pending Adjustments
          2. Reporting Cost Update Adjustments
        5. Periodic Costing
        6. Maintaining Accounting Periods
        7. Closing Discrete Jobs
          1. Costing Repetitive Schedule Period Close Transactions
        8. Purging Cost Information
        9. Purging Margin Analysis Load Run
        10. Purging Standard Cost Update History
      7. Understanding Key Reports from Cost Management
      8. Troubleshooting
    11. 21. Using Oracle Planning Applications
      1. Introduction
      2. Using Oracle Master Scheduling/MRP
      3. Discovering New Features in Release 11i
      4. Critical Implementation Factors
      5. Configuring the Application
        1. Resolving Critical Setup Issues
          1. MPS Versus MRP Planning for Items
          2. Determining the Planning Process for Your Organization
        2. Oracle Master Scheduling/MRP Setup Tasks
        3. Understanding Each Setup Task
          1. Establishing System Administration
          2. Defining Key Flexfields
          3. Establishing a Set of Books
          4. Defining Supplier-Planned Inventories
          5. Defining Deliver-To Locations
          6. Defining Employees
          7. Defining Planning Parameters
          8. Defining Planning Exception Sets
          9. Defining Demand Classes
          10. Defining Planners
          11. Setting Up the Planner Workbench
          12. Setting the Profile Options
          13. Defining Forecast Sets
          14. Defining the Master Demand Schedule
          15. Defining the Master Production Schedule and Options
          16. Defining Material Requirements Plan and Options
          17. Identifying Workflow Options
          18. Defining Shipping Methods and In-Transit Lead Times
          19. Defining Sourcing Rules and Bills of Distribution
          20. Establishing Assignment Sets
          21. Defining Interorganization Shipping Network
          22. Defining the Distribution Requirements Plan
          23. Starting the Planning Manager
          24. Running Information Audit
        4. Converting Data for Major Entities
      6. Processing Transactions
        1. Maintaining Forecasts
          1. Manual Forecast Entry
          2. Forecasting Based on Historical Data
          3. Copying and Merging Forecasts
          4. The Forecast Consumption Process
        2. Maintaining Master Schedules
          1. Loading a Master Schedule
          2. Manual Master Schedule Entries
          3. Schedule Relief
          4. Reducing MPS
        3. Generating an MPS Plan
        4. Material Requirements Planning
          1. Generating an MRP
          2. Controlling the Plan
          3. Copying MPS and MRP Plans
          4. Using the Planner Workbench
          5. Reviewing Plan Information
          6. Net Change Replan
          7. Implementing Recommendations
      7. Using Supply Chain Planning
        1. Sourcing Rules and Bills of Distribution
          1. Enhanced Sourcing in R11i
          2. Sourcing Rules
          3. Bills of Distribution
          4. Assigning Sourcing Rules and Bills of Distribution
          5. Graphical View
        2. Master Scheduling
        3. Material Requirements Planning and Distribution Requirements Planning
        4. Supply Chain Planner Workbench
      8. Using Oracle Alerts with This Application
      9. Using Open Interfaces in This Application
      10. Taking Advantage of Best Practices
      11. MRP: Understanding Key Reports
      12. MRP: From Here
      13. Using Oracle Capacity
        1. Discovering New Features in Release 11i
        2. Configuring the Application
        3. Understanding Each Setup Task
          1. Defining Resources Groups (Optional)
          2. Defining Simulation Sets (Optional)
          3. Defining and Loading Bills of Resources (Optional)
          4. Defining Multidepartment Resources (Optional)
          5. Horizontal Plan Display Options
          6. Setting Profile Options
      14. Processing Transactions
        1. Rough Cut Capacity Planning
          1. Creating Bills of Resources (Optional)
          2. Routing-Based RCCP
          3. Rate-Based RCCP
          4. Viewing RCCP
          5. Using RCCP Data
        2. Capacity Requirements Planning
          1. Routing-Based CRP
          2. Rate-Based CRP
          3. Viewing CRP
      15. Oracle Capacity: Understanding Key Reports
      16. Oracle Capacity: From Here
      17. Troubleshooting Oracle Planning Applications
    12. 22. Using Oracle Work In Process
      1. Discovering New Features in Release 11 and Release 11i
      2. Critical Implementation Factors
        1. Issues and Gaps
          1. Reviewing Top Enhancement Requests
        2. Required Setup Tasks
      3. Configuring the Application
        1. Resolving Critical Setup Issues
        2. Table Showing Setup Tasks
        3. Understanding Each Setup Task
          1. Defining Work In Process Parameters
          2. Defining WIP Accounting Classes
          3. Setting the Profile Options
          4. Defining Production Lines
          5. Defining Repetitive Assemblies
          6. Defining Schedule Groups
          7. Defining Employees
          8. Defining Labor Rates
          9. Defining Shop Floor Statuses
          10. Defining Job and Schedule Documents
          11. Defining Operation Documents
          12. Defining Report Sets
      4. Converting Data for Major Entities
      5. Processing Transactions
        1. Work In Process Transactions
          1. Processing Shop Floor Transactions
            1. Intraoperation Steps
            2. Adding, Updating, and Deleting Operations
            3. Resources
            4. Move Transactions
            5. Shop Floor Statuses
            6. Job and Repetitive Schedule Statuses
          2. Processing Material Transactions
            1. Supply Types
            2. Issuing/Returning Material
          3. WIP Completion Transactions
        2. Purging Jobs and Schedules
        3. Managing Discrete Jobs
          1. Discrete Job Types
          2. Defining Discrete Jobs
          3. Using the Planner Workbench with Discrete Jobs
          4. Simulating a Discrete Job
          5. Updating a Discrete Job
        4. Managing Repetitive Schedules
          1. Defining a Production Line
          2. Assigning an Assembly to a Production Line
          3. Defining a Repetitive Schedule
          4. Using the Planner Workbench
          5. Updating Repetitive Schedules
          6. Production Rates and Capacity
          7. Autorelease of a Schedule
      6. Balancing the Subledger to the General Ledger
      7. Using Open Interfaces in This Application
      8. Understanding Key Reports
      9. Troubleshooting
    13. 23. Implementing Oracle Human Resources and Oracle Payroll
      1. Critical HRMS Implementation Factors
        1. The Initial Phase
        2. Resources
          1. Functional Consultants
          2. Technical Consultants
        3. Executive Sponsorship
        4. Documentation
        5. Parallel Testing
        6. Celebrating Successes
      2. Common Unrealistic Project Expectations
        1. HR/Payroll Is Just Another Oracle Application
        2. Vertex Will Handle All My Taxing Issues
        3. No More Manual Wage Attachment Calculations
        4. Updating the FIT Taxable Balance Is Straightforward
        5. When We Are on Oracle, Payroll Should Run Much More Quickly
        6. When Oracle Is Implemented, We Will Not Have to Rely on IT Support Anymore
      3. Historical Data Conversion Approaches
        1. Manual Entry
        2. Screen Loader
        3. Oracle APIs
        4. Data Pump
      4. Other Data Conversion Considerations
        1. Finding Oracle’s Application Program Interfaces
        2. Oracle 11i HRMS API Conversion
        3. Conversion Options: What History Should You Migrate to Oracle HRMS?
      5. Upgrading to 11i
      6. Complete Reinstall of 11i
      7. DateTrack Information
        1. Date Track Profile Options
        2. Date Track User Decisions
      8. Required Oracle HRMS Setup Steps
        1. Defining Key Flexfields
        2. Defining Descriptive Flexfields
        3. Defining Extra Information Types
        4. Enabling Currencies
        5. Defining Users
        6. Public Synonyms and Grant Permissions to Roles
        7. Defining Application Utilities Lookup Tables
        8. Defining Locations
        9. Defining Business Group Organization
        10. Defining View All Access to Business Group
        11. Defining Human Resources Organizations
        12. Defining Government Reporting Entity Organizations
        13. Defining Other Organizations
        14. Defining Benefit Carriers
        15. Defining Organization Hierarchies
        16. Defining Jobs
        17. Defining Positions
        18. Defining Position Reporting Hierarchies
        19. Defining Career Paths for Jobs and Positions
        20. Defining Grades
        21. Defining Grade Rates
        22. Defining Pay Scales
        23. Defining Progression Point Values
        24. Defining Grade Steps and Points
        25. Defining Payment Methods
        26. Defining Consolidation Sets
        27. Defining Payrolls
        28. Defining Earnings
        29. Defining Deduction and Benefit Elements
        30. Defining Employer Liability Elements
        31. Defining Information Elements
        32. Defining Benefit Plans
        33. Defining Taxability Rules for Tax Categories
        34. Defining Input Values for Elements
        35. Defining Validation Formulas
        36. Defining Element Links for Earnings, Deductions, and Benefits
        37. Defining Taxation and Other Elements
        38. Defining Payroll Balances
        39. Defining User Tables
        40. Defining Payroll Formulas
        41. Defining Payroll Formula Results
        42. Defining Salary Basis
        43. Enabling Salary Approvals
        44. Defining Proposal Reasons and Performance Ratings
        45. Defining Benefit Coverages
        46. Defining Element Sets
        47. Defining Person Types
        48. Defining Assignment Statuses
        49. Defining Special Information Type Key Flexfield
        50. Defining Workers Compensation Codes and Rates
        51. Defining Workers Compensation Job Codes
        52. Defining Absence and Paid Time Off Accrual Plans
        53. Defining Human Resources Budgets
      9. Troubleshooting
    14. 24. Using Oracle Human Resources
      1. Discovering New Features in Release 11i
      2. Globalization Support
      3. Human Resources Self Service
      4. HR Tips
        1. Forms Configurator
        2. New Hire Reporting
        3. Employee Hire Process
        4. Employee Termination
        5. Managing Employee Absences
        6. Position Management and Position Control
        7. Standard Benefits
        8. Government Reporting
          1. EEO Reporting Setup Steps
          2. AAP Report Setup Steps
          3. VETS-100 Setup Steps
          4. ADA
          5. OSHA
        9. Pay Scales and Pay Progression
        10. Setting Up Collective Agreements
        11. Beneficiaries with Oracle HR
        12. Batch Element Entry Uses
      5. Application Data Export
        1. Producing MS Word Documents Using ADE
          1. Recommended Solution
          2. Setup Steps
        2. Implementing HR After Financials
      6. Troubleshooting
    15. 25. Using Oracle Payroll
      1. Discovering New Features in Release 11i
      2. Payroll Processing (from Batch Element Entry to CheckWriter to GL)
        1. Payroll Processing: BEE
        2. Payroll Processing: Payroll Processing
        3. Payroll Processing: Processing Prepayments
        4. Payroll Processing: Payments Processing
        5. Payroll Processing: Voiding Payments Process
        6. Payroll Processing: Costing
        7. Payroll Processing: Transferring to GL
        8. QuickPay Processing
      3. Overriding Tax Information
      4. Processing State Quarterly Wage Listings
        1. SQWL Setup
        2. SQWL Running
      5. W-2 Year-End Processing
      6. Regular Versus Supplemental Pay Runs
      7. Costing of Earnings
      8. Costing of Overtime
      9. Overtime FLSA Compliance
      10. 401(k) Calculations/Company Match
      11. 403(b) and 457 Deferred Compensation Elements
      12. Using Special Inputs Elements
      13. Generating Arrears for Nonrecurring Elements (via Recurring Zero Dollar Elements)
      14. Retro Pay
      15. Tax Balance Adjustments
        1. Tax Balance Adjustments Example
      16. Tax Only Earnings
      17. Costing and Transfer to General Ledger
        1. GL Flexfield Changes: Steps to Change Payroll Cost Allocation
      18. Laser Printing of Payroll Checks
      19. Oracle Fast Formula
      20. Year-to-Date Balance Conversion
      21. Third-Party Administrator Transfers (Pro-C, PL/SQL)
      22. Time and Attendance Integration with BEE
      23. Other Interfaces
      24. Establishing Latest Balances
        1. How It Works
      25. Compensation Approaches
        1. Compensation Approaches: Regular Pay Increases
        2. Compensation Approaches: Allowances/Special Types of Pay
        3. Compensation Approaches: Retro Payments
        4. Compensation Approaches: Supplemental
        5. Compensation Approaches: Summary
      26. Understanding Key Reports
      27. Oracle Time Management: Tables and Policies
      28. Troubleshooting
    16. 26. Using Oracle Advanced Benefits
      1. Introduction
        1. Oracle Basic Benefits
        2. Oracle Standard Benefits
        3. Oracle Advanced Benefits
        4. OAB Key Decision Factors
      2. Implementation Strategies
        1. Complete Reinstall of 11i
          1. Conversion Versus Process New Elections
      3. Compensation Objects
        1. Programs
        2. Program Enrollment Requirements
        3. Plan Types
        4. Plans
        5. Plan Enrollment Requirements
        6. Options
      4. Life Events
        1. Using Life Events
        2. Configuring Life Events
        3. Life Event Processing
      5. Eligibility Profiles and Derived Factors
      6. Benefit Program Setup Example
        1. Step 1: Define Program/Plan Year Periods
        2. Step 2: Define Life Event Reasons
        3. Step 3: Define Participant Eligibility Profiles
        4. Step 4: Define Dependent Eligibility Profile
        5. Step 5: Define Plan Types
        6. Step 6: Define Options
        7. Step 7: Define Basic Plan Information
        8. Step 8: Define Program
        9. Step 9: Define Program Enrollment Requirements
        10. Step 10: Define Standard Rate Calculations
      7. Imputed Income for Domestic Partner Benefits
      8. Using Imputed Income for Domestic Partner Benefits
      9. Flex Credits and Benefit Pools
        1. Step 1: Define Flex Credit Plan Type
        2. Step 2: Define Flex Credit Plan
        3. Step 3: Define the Program
        4. Step 4: Define Flex Credits
        5. Step 5: Define Flex Credit Standard Rate
        6. Step 6: Define Benefit Pools
          1. Using Flex Credits
      10. Summary
    17. 27. Administering the Oracle Applications
      1. Release 11i Changes
      2. Understanding Security
        1. Responsibilities
          1. Defining a Responsibility
        2. Data Group
        3. Request Group
        4. Menus
          1. Analyzing the Menu Reports
          2. Protecting Yourself During an Upgrade
          3. Modifying Existing Menus
            1. Combining Pieces of Several Menus
        5. Menu Exclusions
        6. Excluded Items and Securing Attributes
        7. Users
          1. Defining a User
          2. Auditing Users
            1. Sign-On Auditing
            2. AuditTrail
      3. Maintaining Profile Options
      4. Understanding Concurrent Processing
        1. Setting Up Workers and Schedules
        2. Concurrent Programs and Reports
          1. Defining and Registering Executables
          2. Defining Sets
        3. Managing Concurrent Requests
          1. Inactive Stage Statuses
          2. Pending Stage Statuses
          3. Running Stage Statuses
          4. Completed Stage Statuses
        4. Understanding the concsub Syntax
      5. Understanding Printers
        1. Defining a New Printer Driver
          1. Using Escape Codes
        2. Defining a New Printer Style
        3. Defining a New Printer Type
        4. Registering a Printer
      6. Troubleshooting
    18. 28. Using Oracle Workflow
      1. Skills Required to Use Workflow
        1. User Skill Set
        2. Technical Skill Set
      2. Target Users
        1. Functional Designers
        2. Technical Designers
        3. Project Managers/Presenters
        4. Non-Apps Users
      3. Discovering New Features in Release 11i
        1. Process Workflows
        2. Document Management Integration
        3. Support for Forced Synchronous Processes
        4. Web Pages to Manage Preferences
        5. Advanced Queues Integration
        6. Launch Process Web Page
        7. Quick Start Wizard
        8. Enhanced Notification Rules
        9. Enhancements
          1. APIs
        10. Notifications
        11. Workflow Administration
        12. Workflow Engine
        13. Workflow Home Page
        14. Workflow Monitor
        15. User Key
      4. Understanding the Major Components of Workflow
        1. Workflow Builder
        2. Workflow Engine
        3. Workflow Definitions Loader
        4. Notification System
        5. Workflow Monitor
        6. Workflow Item Types and Items
      5. Using the Workflow Engine
        1. Initiating a Workflow Process
        2. Activity Status
        3. Calling the Workflow Engine
        4. Workflow Program Interfaces
        5. Understanding the Background Engine
        6. Deferred Processes
        7. Timed-Out Processes
      6. Using the Workflow Directory Services
      7. Creating a Workflow Process
        1. Using the Workflow Builder
        2. Planning the Process
          1. Process Activities
          2. Function Activities
          3. Notification Activities
        3. Defining the Item Type
        4. Defining Item Type Attributes
        5. Defining Lookup Types and Codes
        6. Defining Messages and Message Attributes
          1. Message Attributes
        7. Defining a Function Activity
        8. Assigning a Cost to a Function Activity
        9. Handling Exceptions
        10. Defining a Process Activity
      8. Diagramming the Workflow Process
        1. Drawing the Diagram
        2. Editing a Transition
        3. Customizing a Node
        4. Setting Activity Attribute Values
        5. Referencing Standard Activities
      9. Creating Notification Activities
        1. E-mail
        2. Notifications Web Page
        3. Notification Viewer
        4. Automatic Processing Rules
      10. Monitoring Workflow Processes
        1. Workflow Status Form
      11. Using the Workflow Administrator
        1. Reviewing the Process List
        2. Reviewing the Notifications List
        3. Filtering the Activities List
      12. Considerations in Setting Up Workflow
        1. Defining the WF_RESOURCES Environment Variable
        2. Defining a Web Agent
        3. Assigning the Administrator to a Role
        4. Customizing Web Pages
        5. Securing Web Pages
        6. Using Notification Mailer
          1. Setting Up Mail Accounts
          2. Setting Up Message Templates
        7. Establishing Access Protection
        8. Workflow Definitions Loader
      13. Setting Up a Data Store
      14. Predefined Workflows Embedded in Oracle Applications
      15. Troubleshooting
    19. 29. Understanding Multi-Org
      1. Oracle Applications and Multiple Organizations
      2. Understanding the Key Tables
      3. Critical Implementation Factors
        1. Understanding Organization Structures
          1. Centralized Transaction Processing Within Oracle Applications
          2. Decentralized Transaction Processing Within Oracle Applications
          3. Limitations on Centralization/Decentralization Support
          4. Linking the Organizational Structures
          5. Security
        2. Seed Data Replication
      4. Configuring the Application
        1. Setup Steps
      5. Reporting
        1. Oracle Payables
        2. Oracle Receivables
      6. Troubleshooting
  7. IV. Appendixes
    1. A. Employment Market
      1. Introduction
      2. Skills Needed to Become a Consultant
        1. Technical Consultants
        2. Functional Consultants
        3. Project Management
        4. Database Administrator
      3. Character Traits of a Good Consultant
      4. Consulting Advantages
      5. Consulting Disadvantages
      6. Support Jobs
      7. Product Development Jobs
      8. Sales/Marketing Jobs
      9. Recruiting Jobs
      10. Working for Oracle Corporation
      11. Working for Oracle Customers
      12. What Happened in the Early 2000s?
        1. Upgrades to R11i, R12
        2. Phase II Applications/Functionality
      13. Oracle Corporation Is an Engine of Growth
    2. B. Consulting Market
      1. Independent Consulting
        1. Independent Consulting: Advantages to Consultant
        2. Independent Consulting: Advantages to Employing Company
        3. Independent Consulting: Risks to Consultant
        4. Independent Consulting: Risks to Employing Companies
      2. Smaller, Specialized Consulting Firms
        1. Smaller, Specialized Consulting Firms: Advantages to Consultant
        2. Smaller, Specialized Consulting Firms: Advantages to Employing Company
        3. Smaller, Specialized Consulting Firms: Disadvantages to Consultant
        4. Smaller, Specialized Consulting Firms: Disadvantages to Employing Company
      3. Larger, Diversified Consulting Firms
        1. Larger, Diversified Consulting Firms: Advantages to Consultant
        2. Larger, Diversified Consulting Firms: Advantages to Employing Company
        3. Larger, Diversified Consulting Firms: Disadvantages to Consultant
        4. Larger, Diversified Consulting Firms: Disadvantages to Employing Company
      4. Oracle Corporation Consulting
        1. Oracle Corporation Consulting: Advantages to Consultant
        2. Oracle Corporation Consulting: Advantages to Employing Company
        3. Oracle Corporation Consulting: Disadvantages to Consultant
        4. Oracle Corporation Consulting: Disadvantages to Employing Company
      5. Summary
    3. C. Implementation Checklist
      1. Plan and Initiate the Project
        1. Management Commitment
        2. Planning
        3. Staffing
        4. Controls
        5. Communication
        6. Logistics
      2. Analyze the Business and the Technology
      3. Build and Configure Your System
      4. Transition to the New System
      5. Support the Production Systems