Special Edition Using Oracle® 11i

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