search for books and compare prices
Tables of Contents for Oracle Certified Professional Financial Applications Consultant Exam Gui De
Chapter/Section Title
Page #
Page Count
Preface
xix
Acknowledgements
xxiii
Introduction
xxv
UNIT I Preparing for OCP Exam I: Financial Management
Introduction
3
46
Essential Setup and Implementation Steps
4
2
Oracle General Ledger and Assets Functionality
6
5
Oracle General Ledger
6
3
Oracle Assets
9
2
Overview of Information Flow Between Oracle Integrated Applications
11
2
Introducing Financials Applications Implementation
13
6
High-Level Process Flows of Oracle Applications
13
2
Integration Among Oracle Applications
15
2
High-Level Setup and Implementation Issues for the Enterprise Management Applications
17
2
Financials Applications Integration
19
30
How Information Is Shared with Other Oracle Applications
20
3
Implementation Considerations for Enterprise Management Applications
23
13
Features of the Application Desktop
36
13
Financial Management Setup
49
56
Implementation Process Steps for General Ledger and Assets
50
34
Major Aspects of Implementing General Ledger and Fixed Assets
50
25
Functionality of Multiple-Organization Support
75
6
Vision Demonstration Database Structure
81
3
Creating a Chart of Accounts
84
10
Value Sets
85
1
Accounting Flexfield Structure
85
4
Entering and Controlling Accounting Flexfield Segment Values
89
1
Entering and Maintaining Accounting Flexfield Combinations for Posting and Budgeting
90
2
Creating Flexfield Security and Cross-Validation Rules
92
2
Creating a Set of Books
94
5
Defining an Accounting Calendar
95
1
Defining Currencies
95
1
Defining a Set of Books
95
2
Setting Up Financial Controls
97
2
Implementation Considerations
99
6
Considerations for Setting Up a Set of Books
99
1
Considerations for Setting Up a Chart of Accounts
100
5
Basic Journal Entries and Reporting
105
66
Creating Basic Journal Entries
106
35
Entering, Posting, and Reviewing Journal Entries
107
3
Reversing Journal Entries
110
3
Importing Journal Entries
113
3
Entering Journal Entries Through ADI
116
7
Creating Recurring and Formula Journal Entries
123
4
Approving Manual Journal Entries
127
2
Using Balancing Accounts
129
2
Creating Summary Accounts
131
5
Transferring Balances Between Accounts
136
5
Reporting and Analysis Tools
141
30
Running Standard Reports
141
3
Creating Basic FSG Reports
144
16
ADI Report Wizard
160
2
ADI Request Center
162
6
ADI Analysis Wizard
168
1
Understanding the Integration with Oracle Financial Analyzer
169
2
Multiple-Currencies Accounting
171
20
Accounting for Foreign and Multiple Currencies
172
16
Defining Foreign Currencies
172
2
Entering Foreign Currency Journals
174
2
Revaluing Foreign Currency Balances
176
2
Translating Foreign Currency Balances
178
1
Multiple Reporting Currencies
179
9
Implementation Considerations
188
3
Inquiry/Reporting Requirements
188
1
Security
189
1
Effective Date for Conversion Options
189
1
When to Initialize Balances for Reporting Sets of Books
189
1
Special Accounting Steps
189
2
Oracle Assets Fundamentals
191
44
Creating Fixed Asset Books and Parameters
192
16
Definiing Key Flexfields
192
3
Setting Up System Controls
195
1
Creating Locations
195
1
Entering Asset Accounting Information
196
6
Creating Asset Categories
202
3
Setting Up Depreciation
205
3
Managing Assets
208
12
Adding Assets Manually
208
6
Depreciating Assets
214
6
Adding Assets from External Sources
220
8
Preparing Mass Additions
220
5
Posting Mass Additions
225
2
Deleting Mass Additions
227
1
Implementation Considerations
228
7
Key Flexfields
229
1
Initial Assets Conversion
229
1
Depreciation Requirements
230
1
Tax Requirements
230
1
Importing Assets from External Systems and Other Modules
231
1
Multiple-Currencies Requirements
231
1
Setting Up Oldest Date in Service
232
1
Asset Accounting
232
1
Capital Budgeting
232
1
Security
233
2
Oracle Applications Integration
235
52
Integration
236
6
How Oracle Assets Integrates with Oracle Financials Modules
236
3
How Oracle Payables Integrates with Oracle Assets
239
1
Implementation Considerations
240
2
Features of the Application Desktop
242
1
Managing Budgets
242
29
Creating Budgets
243
7
Entering Budget Amounts
250
13
Using the Budget Wizard
263
4
Reviewing and Updating Budgets
267
4
Reporting and Analysis Tools
271
16
Integration Fundamentals
271
2
Setting Up the Interface
273
8
Running Data Extract Jobs
281
6
Consolidation and Advanced Assets Functionality
287
60
Multicompany Accounting and Consolidations
288
23
Controlling Intercompany Transactions with Centralized Transaction Approval (CENTRA)
289
8
Multicompany Accounting Within One Set of Books
297
1
Setting Up the Global Consolidation System (GCS)
297
6
Consolidating Your Subsidiaries' Sets of Books
303
8
Managing Assets
311
16
Setting Up Additional Options
312
3
Cleaning Up and Purging Historical Data
315
1
Adjusting Assets
316
4
Adjusting Assets Using Unplanned Depreciation and Revaluation
320
3
Retiring Assets
323
2
Viewing Asset Information
325
2
Adding Assets from External Sources
327
2
Adding CIP Assets
327
1
Integrating Oracle Projects to Build CIP Assets
327
2
Managing Budgets
329
3
Preparing Capital Budgets
329
2
Projecting Depreciation for Budget Assets
331
1
Maintaining Tax Books
332
5
Creating a Tax Book
332
1
Entering Information in a Tax Book
332
2
Adjusting a Tax Book Depreciation Reserve
334
3
Reporting, Reconciling, and Year-End Processing
337
10
Submitting Reports for Printing or Viewing Online
337
2
Reconciling Asset Data
339
1
Performing Physical Inventory on Assets
340
7
UNIT II Preparing for OCP Exam 2: Applied Technology
System Administration
347
70
Managing Application Security
348
9
Defining Application Users
349
2
Customizing Application Privileges
351
2
Defining Responsibilities
353
2
Defining Custom Menus
355
2
Managing Concurrent Programs and Reports
357
18
Submitting Requests Through SRS
358
3
Monitoring Request Processing
361
3
Defining Request Groups
364
1
Customizing SRS Report Processing
365
2
Defining Request Sets
367
7
Controlling Report Behavior
374
1
Controlling User Access Via Request Sets
374
1
Administering Concurrent Managers
375
14
Defining Managers and Their Work Shifts
375
5
Specializing Managers
380
2
Classifying a Program as a Request Type
382
1
Controlling Concurrent Managers
382
5
Managing Parallel Concurrent Processing
387
2
Managing Profile Options
389
6
Setting Profile Option Values
389
3
Storing User Defaults in Profile Options
392
1
Typical Profile Option Modifications
392
3
Auditing System Resources
395
6
Ways to Audit Oracle Applications Performance and Resources
395
3
How to Modify Auditing-Related Profile Options
398
1
How to Use Auditing Reports
399
2
How to Implement Auditing to Suit Your Environment
401
1
Document Sequencing
401
4
Document Sequence Types
401
1
Sequencing Documents in Oracle Applications
402
3
Incorporating Custom Programs
405
6
Identifying an Executable to Oracle Applications
406
1
Defining a Concurrent Program
407
3
Specifying Concurrent Program Parameter Information
410
1
Managing Printers
411
6
Defining Printer Types
412
1
Registering Printers
413
1
Associating Output Files to Various Printer Components
413
1
Creating a Custom Print Style and Printer Driver
413
4
Flexfields
417
82
Flexfield Overview
418
17
How Flexfields Are Used by Oracle Applications
419
2
Differences Between Key and Descriptive Flexfields
421
2
Key and Descriptive Flexfields Used by Oracle Applications
423
10
Flexfield Value Security
433
1
Cross-Validation Rules Used in Flexfields
434
1
Implementing Value Sets
435
19
Options for Validating Flexfield Segment Values and Report Parameters
435
3
Choosing Appropriate Validation Options for a Particular Segment
438
2
Considerations When Planning a Validation Strategy
440
2
Defining New Value Sets
442
6
Define Allowable Values for a Value Set
448
6
Planning and Defining Key Flexfields
454
18
Intelligent Keys
455
1
Key Flexfields Required by Oracle Applications
455
2
Purpose of Flexfield Qualifiers
457
1
Optional Key Flexfield Features
457
2
Designing a Key Flexfield Structure
459
2
Selecting the Appropriate Key Flexfield to Define
461
1
Defining Structure Information for the Key Flexfield
461
3
Defining Segments Attributes as Planned
464
3
Defining Flexfield Qualifiers
467
1
Defining Segment Qualifiers
468
2
Implementing Optional Features
470
2
Planning and Defining Descriptive Flexfields
472
8
Identifying the Descriptive Flexfields to Be Used
472
1
Organizing the Information According to Usage
473
1
Planning the Layout of the Descriptive Flexfield
474
2
Planning the Behavior of the Descriptive Flexfield
476
1
Defining a Descriptive Flexfield Structure
477
2
Define Global Segments
479
1
Defining Context-Sensitive Segments
479
1
Implementing Cross-Validation Rules
480
4
Purpose of Cross-Validation
480
1
Cross-Validation Rules
481
3
Controlling the Interaction of Multiple Cross-Validation Rules
484
1
Implementing Flexfield Value Security
484
6
How Flexfield Security Is Accomplished
485
1
Useful Flexfields for Security
486
1
Designing a Security Plan
486
1
Controlling Interactions Between Security Rules
486
1
Defining Security Rules
487
1
Assigning Security Rules
488
1
Enabling Security
489
1
Using Advanced Validation Capabilities
490
9
Advanced Validation Capabilities in Oracle Applications
490
3
Cascading Flexfields
493
1
Special and Pair Value Sets
494
5
Alerts
499
68
Oracle Alert
500
36
Basics of Oracle Alert
501
1
Business Needs Satisfied by Oracle Alert
501
2
Types of Alerts
503
1
Alert Action Types
504
1
Alert Action Levels
504
1
Defining an Event Alert
505
27
Steps Involved in Implementing Alerts
532
1
Precoded Alerts Available in Oracle Alert
533
3
Implementing Periodic Alerts
536
6
Business Requirements Satisfied by Periodic Alerts
537
1
How to Implement a Periodic Alert
537
5
Alert History
542
7
Why Do You Need Alert Histories?
542
1
Features of an Alert History
543
2
How to Review an Alert History
545
3
Documenting Alerts
548
1
Response Processing
549
6
Business Needs that Can Be Met Through Response Processing
549
2
Features of Response Processing
551
1
How Response Processing Works
552
3
Implementation Considerations
555
12
Planning a Successful Implementation of Oracle Alert
555
3
Configuring Oracle Alert for Your Business
558
6
Identifying Your Business Needs and Mapping Them to Responsibilities
564
1
Predefined vs. Custom Responsibilities and Oracle Alert Manager
565
2
Workflow
567
60
Overview of Oracle Workflow
568
3
Concepts of a Workflow
568
2
Oracle Workflow Components
570
1
Overview of the Workflow Engine
571
11
How the Workflow Engine Manages a Process
571
4
Applying Workflow Engine APIs to Function Activities
575
7
Overview of the Workflow Directory Service
582
5
How Oracle Workflow Acquires Information About a Role
582
4
Mapping Oracle Workflow to a Directory Repository
586
1
Planning and Monitoring a Workflow Process
587
18
Components of a Workflow Process
588
13
Planning a Workflow Process
601
2
Monitoring Workflow to View its Progress
603
2
Diagramming a Workflow Process
605
11
Preparing a Workflow Diagram
605
6
Incorporating Standard Activities in a Process
611
4
Reviewing the Process Definition for the Item Type
615
1
Fundamentals of the Implementation Wizard
616
5
Features of the Wizard
616
1
Importance of the Wizard in AIM
617
1
Process Grouping Used in the Wizard
618
1
Process Hierarchy Used in the Wizard
619
1
Key Terms Used in the Wizard
620
1
Using the Wizard
621
6
Using the Wizard to Set Up Applications
621
6
UNIT III Preparing for OCP Exam 3: Procurement
Basic Purchasing and Receipts
627
96
Integration with Oracle Applications
628
7
Within the Procurement Modules
629
2
Oracle Purchasing with Other Oracle Applications Modules
631
2
Oracle Payables with Other Oracle Applications Modules
633
2
Setup and Implementation
635
39
Setup Steps and Considerations Common to Oracle Purchasing and Payables
635
7
Setup Steps and Considerations Unique to Oracle Purchasing
642
9
Setup Steps and Considerations Unique to Oracle Payables
651
9
Setup Steps and Considerations Unique to Oracle Cash Management
660
4
Financial, Purchasing, Receiving, and Payables Options
664
10
Creating Supplier Information
674
18
Steps to Create Supplier Information
674
11
Defining Supplier Site Information
685
5
Identifying Supplier Contact Information by Site
690
1
Merging Suppliers
691
1
Creating Purchase Requisitions
692
11
Creating a Purchase Requisition
692
6
Setting Up a Requisition Template
698
2
Using the Order Pad in the Supplier Item Catalog
700
3
Creating Standard Purchase Orders
703
11
Creating a Standard Purchase Order
703
11
Entering Purchase Order Receipts
714
9
Finding Expected Receipts
714
2
Receiving an Item (Manual, Express, Cascade)
716
2
Receiving Unordered Items
718
2
Receiving Substitute Items
720
1
Defining Payment-on-Receipt Options
720
1
Defining EDI Options
721
2
Document Approval and Invoice Entry
723
40
Defining Approval Rules
724
5
Defining Approval Groups
724
3
Defining Approval Assignments
727
2
Defining Document Routing
729
7
Defining Document Routing Options
729
5
Setting Document Approval Routing Options
734
2
Entering Invoices
736
14
Entering Basic Invoice Information
736
3
Entering Detail Invoice Information
739
9
Entering Freight, Tax, and Miscellaneous Charges
748
2
Matching Invoices to Purchase Orders
750
13
Matching an Invoice to a PO Shipment or Distribution
750
3
Matching All PO Shipments (QuickMatch)
753
1
Entering Debit and Credit Memos
754
1
Matching Debit and Credit Memos to Invoices
754
4
Recording Price Corrections
758
1
Reviewing Matching Exceptions
759
2
Adjusting PO-Matched Invoices
761
2
Cash Management
763
38
Setting Up Oracle Cash Management
764
5
Setting Up Oracle Payables System Parameters
765
1
Setting Up Cash Management System Parameters
766
1
Defining Bank Transaction Codes
767
2
Reconciling Bank Statements
769
18
Reconciling Bank Statements Automatically
770
2
Setting Reconciliation Tolerances
772
2
Reconciling Multicurrency Transactions
774
1
Reconciling Bank Statements Manually
775
8
Open Interface Transactions
783
3
Reconciling Bank Errors and Corrections
786
1
Cash Forecasting
787
14
Defining Forecast Templates
787
5
Generating Cash Forecasts
792
5
Querying, Reviewing, and Modifying Cash Forecasts
797
2
Exporting Cash Forecasts to Excel Spreadsheets
799
2
Advanced Purchasing
801
54
Evaluating Supplier Performance
802
3
Identifying Supplier Performance Reports
803
2
Using the Submit Reports Form
805
1
Manually Creating Requests for Quotation
805
12
Defining Supplier Lists
805
2
Creating a Request for Quotation Manually
807
10
Entering Quotations
817
11
Entering Quotations Manually
817
6
Creating Quotations Automatically
823
2
Approving Quotations
825
3
Contract Purchase Orders
828
6
Entering Contract Purchase Agreements
828
4
Referencing a Contract Purchase Agreement on a Standard Purchase Order
832
2
Blanket Purchase Agreements
834
14
Entering Blanket Purchase Agreements
834
7
Creating Releases Against a Blanket Purchase Agreement
841
7
AutoCreate
848
7
Finding Purchase Requisitions
849
2
Selecting Purchase Requisition Lines
851
2
Creating New or Adding to Documents
853
2
Advanced Payables
855
66
Entering Recurring Invoices
857
5
Create a Special Calendar
857
1
Enter Recurring Invoices
857
5
Managing Invoices
862
12
Applying Holds to Supplier Site Invoices
863
1
Applying Holds to Selected Invoices
864
2
Applying Holds to Schedule Payments
866
1
Releasing Holds
866
4
Approving Invoices
870
1
Cancelling Invoices
871
1
Adjusting Invoices
872
2
Processing Procurement Card Transactions
874
8
Setting Up Procurement Card Processing
874
5
Loading Transactions
879
1
Employee Verification
879
1
Manager Approval
880
1
Adjusting Transaction Distributions
880
1
Creating Invoices
880
2
Approving and Paying Invoices
882
1
Entering Manual Payments
882
8
Selecting Invoices to Pay
883
4
Paying from the Invoice Workbench
887
2
Paying Suppliers with Future-Dated Payments
889
1
Overriding Payment Controls
890
1
Processing Payment Batches
890
14
Initiating New Payment Batches
891
3
Creating and Finding Payment Batch Templates
894
1
Modifying Payment Batches
895
2
Formatting Payment Batches
897
1
Confirming Payment Batches
898
1
Finding Payment Information
899
3
Processing EDI Payments
902
1
Making Electronic Payments to Different Supplier Bank Accounts (Flexible Payments)
903
1
Recording Stop and Void Payments
904
3
Placing Stop Payments
904
1
Releasing Stop Payments
905
1
Voiding Payments
905
1
Voiding Unused Payment Documents
906
1
Automatic Tax Calculation
907
10
Assigning the Source and Hierarchy for Tax Defaulting
908
3
Defining Tax Names
911
2
Defining Withholding Tax Groups
913
1
Defining VAT Tax Names
914
1
Defining EU Suppliers
915
1
Recording VAT Charges
916
1
Reviewing VAT Charges
916
1
Loading Electronic Bank Statements
917
4
Manually Entering Bank Statements
917
1
Updating Bank Statements
918
3
UNIT IV Preparing for OCP Exam 4: Order Fulfillment
Customers and Orders
921
58
Introduction to the Order Fulfillment Process
922
9
Overall Order Fulfillment Process Flow
923
8
Creating Customers
931
6
Using Customer Profile Classes
931
3
Entering Information About Customers
934
3
Implementing and Setting Up Customers
937
14
Setting Up Customers as Required for the Order-Fulfillment Applications
937
14
Processing Orders
951
9
Processing, Scheduling, and Approving Orders
951
9
Fulfilling and Shipping Orders
960
16
Fulfilling Customer Orders, Including Picking and Shipping
960
16
Invoicing Customers and Closing Orders
976
3
Preparing Orders for Invoicing to Customers, and Closing Orders
977
2
Basic Order Fulfillment
979
80
Implementing and Setting Up Order Entry
980
19
Completing the Implementation and Setup of Order Entry/Shipping
981
18
Integrating Order Entry/Shipping and Receivables
999
3
Identifying Shared Data Between Order Entry/Shipping and Receivables
999
1
Determining Data Imported from Other Applications
1000
2
Entering and Correcting Transactions
1002
12
Processing and Revising Transactions
1002
12
Entering and Applying Receipts for Customers
1014
11
Receiving and Applying Payments
1015
10
Tracking and Collecting Past Due Receivables
1025
5
Identifying Past Due Receivables and Administering Collection Activities
1025
5
Reconciling, Reporting, and Completing the Receivables Cycle
1030
5
Completing the Receivables Cycle
1030
5
Implementing and Setting Up Receivables
1035
22
Completing the Implementation and Setup of Oracle Receivables
1035
22
Loading Electronic Bank Statements
1057
2
Advanced Order Fulfillment
1059
74
Using Oracle Cash Management with Receivables
1061
2
Completing the Implementation and Setup of Oracle Cash Management
1061
2
Administering Pricing and Discounts
1063
13
Managing Pricing
1063
9
Managing Discounts
1072
4
Processing Orders
1076
10
Applying Sales Credits, Discounts, and Notes to a Sales Order
1076
4
Approving Orders and Lines
1080
1
Applying and Removing Holds
1081
3
Cancelling Orders and Lines
1084
2
Viewing Order and Line Details
1086
1
Drop-Shipping Orders
1086
6
Determining When to Ship Full or Partial Orders
1087
2
Entering Full and Partial Drop-Ship Orders
1089
1
Viewing Full and partial Drop-Ship Orders
1090
1
Fulfilling and Invoicing Full and Partial Drop-Ship Orders
1090
1
Entering and Processing Returns of Drop-Ship Orders
1091
1
Invoicing and Closing Orders
1092
11
Tracing Transaction Sources
1093
3
Defining Grouping and Invoicing Rules
1096
1
Defining Receivable Accounts and Interfaces
1097
6
Processing Returns
1103
3
Authorizing Returns
1103
2
Return Types
1105
1
Entering and Correcting Transactions
1106
12
Billing Customers In Advance or In Arrears
1106
2
Defining Recurring Transactions
1108
2
Creating Debit and Credit Memos
1110
4
Defining Deposits and Guarantees
1114
1
Using Tax Options
1115
3
Receipts
1118
7
Processing Automatic Receipts
1118
5
Lockboxes
1123
2
Past Due Receivables
1125
5
Reviewing Customer Account Status
1126
4
Gathering Collection Information for Past Due Receivables
1130
1
Reconciling, Reporting, and Completing the Cycle
1130
3
Reconciling Receipts and Accounts
1130
1
Performing Bank Reconciliation
1130
1
Using Standard Reports
1131
2
Cash Management II
1133
12
Miscellaneous Transactions
1134
7
Creating Miscellaneous Transactions
1134
2
Creating Payments and Receipts Transactions
1136
2
Recording Exceptions
1138
1
Entering Reversals
1138
2
Using Attachments
1140
1
Posting and Reconciliation Inquiry and Reports
1141
2
Posting Bank Reconciliation Transactions to GL
1141
1
Archiving and Purging Imported Bank Statements
1142
1
Cash Forecasting
1143
2
Index
1145