Oracle Fusion Cloud Financials: Receivables Implementation

Oracle Fusion Cloud Financials: Receivables Implementation Overview

• Course Objectives
• Introducing Receivables
• Lesson Objectives
• Oracle Financials Cloud Applications
• Introduction to Oracle Cloud Applications
• Oracle Cloud Strategy
• Oracle Cloud Applications: Product Families
• Oracle Financials Cloud Overview
• Financials Cloud: Key Features
• Oracle Financials Cloud Implementation Resources
• Order to Cash Overview
• Receivables Overview
• Customer Model Overview
• Tax Overview
• Transactions Overview
• Accounting Methods Overview
• Receipt Creation
• Overview of Cash Management
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Summary

Enterprise Structure and Ledgers Overview

• Objectives
• Enterprise Structures
• Enterprise Structures Overview
• Legal Entities Defined
• Legal Entity, Ledgers, and Balancing Segment Values
• Legal Addresses, Jurisdictions and Authorities: Overview
• Reporting Structures
• Manage Legal Reporting Units
• Financial Reporting Structures Overview
• Chart of Accounts: Components
• Assigning Segment Labels
• Accounting Calendar: Overview
• Manage Currencies: Overview
• Ledgers
• Ledgers Overview
• Ledger Structure
• Geographies Overview
• Sharing Common Applications Configurations
• Practice
• Rapid Implementation
• Implementation Simplification
• Rapid Implementation Process
• Practice
• Deploying the Accounting Flexfield
• Demo
• Practice
• Specifying Ledger Options
• Review and Submit Accounting Configuration
• Practice
• Summary

Configuring Business Units and Reference Data Sets

• Objectives
• Business Unit Features
• Business Unit Structure: Overview
• Implementing Business Units Overview
• Manage Business Units
• Assigning Business Unit Functions
• Manage Service Provider Model
• Managing Service Provider Relationships
• Practice
• Manage Data Reference Sets
• Managing Reference Data Sets
• Assignments to One Set Only with Common Values
• Practice
• Assigning Sets to Business Units
• Reference Data Sets for Business Units in Receivables
• Practice
• Summary

Configuring Oracle Fusion Tax

• Objectives
• Tax Overview
• Tax
• Tax Architecture
• Tax Configuration
• Key Building Blocks of Tax Configuration
• Foundation Tax Configuration
• Tasks to Configure Tax
• Tax Foundation Setup Examples
• Setting Up Foundation Tax Components
• Configuration Owners and Options
• Tax Regimes
• Defining Defaults
• General and Compounding Level Controls
• Configuration Options and Service Subscriptions
• Tax Defaults, Status, and Jurisdiction
• Taxes
• Tax Rule Defaults: Place of Supply
• Tax Statuses
• Tax Jurisdictions
• Tax Rates
• Setting Up Tax Rates Overview
• Override of Tax Rates on Tax Lines
• Other Controls and Defaults
• Tax Recovery Rates
• Third-Party Partner Integration
• Service Subscriptions in the Cloud: Vertex
• Practice
• Tax Configuration with Rapid Implementation Spreadsheets & Tax Determination Process
• Rapid Implementation Spreadsheets
• Tax Setup Spreadsheets
• Tax Determination Process: How Taxes are Calculated
• Tax Reporting
• Setting Up Global Tax Reporting
• Reporting and Analysis
• The Tax Simulator
• Practice
• Summary

Configuring Oracle Receivables

• Objectives
• Configuring Receivables Using Rapid Implementation
• Credit to Cash
• Configuring Receivables Using Rapid Implementation
• The Rapid GL Implementation Workbook: Natural Accounts Spreadsheet
• Completing Your Setup
• Managing the Receivables System Options
• Billing and Revenue General Information Options
• Billing and Revenue Accounting Options
• Billing and Revenue Transactions Options
• Billing and Revenue Transaction and Statement Delivery Using Email Options
• Billing and Revenue Late Charges Options
• Processing Interest Invoice Late Charges by Legal Entity
• Enabling Processing of Late Charges by Legal Entity
• Billing and Revenue Customers Options
• Billing and Revenue AutoInvoice Options
• Billing and Revenue Tuning Segments Option
• Cash Processing General Information Options
• Cash Processing Application Exception Rule Options
• Cash Processing Accounting Options
• Other Cash Processing Options
• Rapid Implementation and Receivables System Options
• System Options Values Created by Rapid Implementation
• Practice
• Managing AutoAccounting Rules
• AutoAccounting Rules: Table Names and Constant Values
• Rapid Implementation: AutoAccounting
• Practice
• Manage Remit-to Address
• Managing Remit-to Addresses
• Remit-to Addresses: Automatic Assignment
• Practice
• Manage Receivables Activities
• Managing Receivables Activities
• Receivables Activities: Setup
• Rapid Implementation: Receivables Activities
• Practice
• Manage Statement Cycles
• Managing Statement Cycles
• Sending Statements
• Email Delivery of Statements
• Resending Email
• Using Email Delivery of Statements
• Setting Up Customer Profiles for Email Delivery of Statements
• Setting Up Customer Contacts for Email Delivery of Statements
• Practice
• Managing Other Options 5-57
• Defining Approval Limits
• Other Optional Implementation Tasks
• Legal Entity Document Sequencing
• Managing Receivables Document Sequencing
• Gapless Document Sequencing
• Disallow Future-Dated Invoices Created Manually When Chronological Document Sequencing is Enabled
• Foreign Currency Conversion Options
• Define Users for Credit Memo Workflow
• Configurable Credit Memo Request Approval Workflow Notifications
• Configurable Receivables Credit Memo Request Manual Entry
• Workflow Notification
• Configuration Prohibit Users Self Approval Section
• Manage Value Sets
• Summary

Configuring Customer Billing

• Objectives
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• AutoInvoice Setups
• AutoInvoice Process
• AutoInvoice Interface Tables
• Profile Option Settings
• Transaction Flexfields
• Optional Setups
• Grouping Rules: Part One
• Grouping Rules: Part Two
• Line Ordering Rules
• Import Exceptions Overview
• Payment Terms & Transaction Types
• Defining Payment Terms
• Transaction Types Overview
• Defining Transaction Types
• Using Natural Application Only and Allow Overapplication Options
• Practice
• Transaction Source & Memo Lines
• Transaction Sources Overview
• Defining Transaction Sources
• Defining Transaction Sources for AutoInvoice
• Define Transaction Sources for CPQ Cloud Integration
• Practice
• Defining Standard Memo Lines
• Balance Forward Billing Setups
• Setting Up Balance Forward Billing
• Deliver Balance Forward Bills Using Email
• Balance Forward Billing in Advance of the Billing Cycle End Date
• Recurring Billing & Instalment Update Setups
• Receivables Recurring Billing: Overview
• Receivables Recurring Bill Plans: What Can You Do?
• Creating a Recurring Bill Plan: Contract Attributes
• Receivables Installment Update: Overview
• Setup Detail for Due Date
• Setup Detail for All Other Adjustments
• Summary

Configuring Customer Payments

• Objectives
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Setups for Receipt Creation
• Defining Remittance Banks and Bank Accounts
• Practice
• Receipt Class, Receipt Method, and Bank Account Relationship
• Defining Receipt Classes
• Assigning Receipt Methods
• Practice
• Defining Receipt Sources
• Practice
• AutoCash Rules
• Application Rule Sets
• Defining Application Rule sets
• Tax Treatment Option
• Smart Receipts
• Recommendations for Receipt Processing: SmartReceipts
• Settings That Affect Recommendations for Receipt Application
• AutoMatch Rules
• Defining AutoMatch Rules
• Threshold Settings
• AutoMatch Calculation
• Defining Receipt Application Exception Rules
• Implementation Considerations for Lockbox
• Implementation Considerations for Lockbox
• Receipt Match By and SmartReceipts
• Cash Budget Funding with Receivables Receipts
• Cash Budget Funding with Receivables Receipts
• Setup for Cash Budget Funding with Receivables Receipts
• Remittance Bank Account Impact on Funding Cash Budget via Journal Entries
• Summary

Configuring Revenue for Receivables

• Objectives
• Revenue Recognition Setups
• Setups for Revenue Recognition
• Revenue Scheduling Rules
• Revenue Scheduling Rule Types
• Revenue Policies
• Defining Revenue Policies
• Credit Classification
• Refund Policy Threshold
• Payment Terms Threshold
• Revenue Contingencies
• Defining Revenue Contingencies
• Summary

Configuring Subledger Accounting

• Objectives
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Subledger Accounting Overview
• The Create Accounting Process Flow
• Key Features of Accounting Methods
• Accounting Methods Overview
• Predefined Accounting Methods
• Accounting Event Model Example
• Receivables Accounting Event Model
• How the Different Types of Rules Fit Together
• Managing Accounting Methods and Rules Flow
• Modified Formulas
• Managing Modified Formulas
• Formula Definition
• Predefined Formula Functions
• Mapping Sets Overview
• Creating Mapping Sets
• Account Rules Overview
• Creating Account Rules: Rule Type
• Creating Account Rules: Value Types
• Account Rules Best Practices
• Conditions
• Practice
• Creating Description Rules
• Practice
• Creating Supporting References
• Creating Journal Line Rules
• Practice
• Journal Entry Rule Sets Overview
• Creating Journal Entry Rule Sets
• Practice
• Configure & Manage Accounting Methods
• Accounting Methods
• Creating Accounting Methods
• Practice
• Additional Attributes for Deriving Receivables Accounting
• Updating the Subledger Accounting Method with New Attributes
• Migrating the Accounting Configuration
• Create Accounting Process
• The Create Accounting Process
• Manual Features of Subledger Accounting
• Subledger Accounting Advanced Features
• Advanced Features of Subledger Accounting
• Subledger Accounting Profile Options
• Accrual Reversals Flow
• Online Accounting Messages
• Accounting Lines Window
• Multifund Accounting
• Overview of Detailed Receivables Distributions
• Guidelines for Enabling Detailed Receivables Distributions
• Subledger Accounting Setup for Detailed Receivables Distributions
• Preparing Primary Ledger
• Support Receivables Detailed Distributions for Invoices with Rules
• Cash Pooling for Receivables Multifund Accounting
• Cash Pooling Example
• Implementing Method-1
• Implementing Method-2
• Enabling the AR_CASHPOOLING Lookup Code
• Multifund Accounting with User Modifications to Subledger Accounting Rules
• Multifund Accounting with User Modifications to Subledger Accounting Rules – Steps to Enable
• Summary

Customers

• Objectives
• Customer Model
• Customers and Parties
• The Trading Community Model
• Managing Customers
• Customer Profile Classes
• Managing Customer Profile Classes
• Profile Class Tab: Part One
• Profile Class Tab: Part Two
• Late Charges Tab
• Practice
• Customer Creation
• Customer Model
• Header
• Address
• Address Business Purposes
• Customer Account Level Setup for XML Invoice Delivery
• Portal Upload and Custom Delivery Methods for Customer Transactions
• Search for Customer by Site Number
• Assign the Primary Receipt Method to Manual Transactions
• Simplified Customer Upload
• Simplified Customer Upload using ERP Integration
• Practice
• File Based Data Import Process
• Manage Data Import Process Overview
• Data Quality Service
• Import Process for Customers and Consumers
• Defining Data Quality Services for File-Based Import and Data Import
• Remove Customer Profile Attribute Values in Bulk Through Customer Import
• FAQs for Manage Data Import
• Summary

Entering Transactions and Payments Overview

• Objectives
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Receivables Overview
• Transaction Processing
• Transactions Overview
• Invoice Components
• Opening an Accounting Period
• Practice
• Creating an Invoice Manually
• Transaction Defaults
• Completing Transactions
• Practice
• Key features of Transaction Processing
• Third-Party Tax Registration Number Defaulting for Receivables
• Transactions
• The Logic for Automatic Assignment of Third-Party Tax Registration Number to Receivables Transactions
• Management of Negative Invoice Line Amounts and Transaction Completion
• Steps to enable Management of Negative Invoice Line Amounts and Transaction Completion feature
• Search for Invoices and Credit Memos That Require Review for Transaction Completion
• Receivables Transaction Review and Control
• Process steps for Review and Control of Receivables Transactions
• Project and Contract Information on Receivables Pages
• Electronic Invoicing Enrichment for Legislative Updates
• Transaction Printing After Electronic Invoice Generation
• Credit Memo Creation in the Earliest Open Accounting Period
• Manual Creation and Application of Prepayment Invoices
• Receipt Processing
• Overview of Customer Receipts
• Receipt Creation
• Manual Receipt Entry Process
• Practices
• Receipt Processing
• Transaction Sweep to Future Accounting Period Using a Scheduled Process
• Sweep Pending Approval Transactions
• Summary

Configuring Oracle Cash Management

• Objectives
• Cash Management Overview
• Define Banks, Branches, and Accounts
• Set Up and Maintain Banks, Branches, and Bank Accounts
• Manage and Maintain Banks
• Manage and Maintain Branches
• Manage and Maintain Bank Accounts
• General Tab
• Control Tab
• Security Tab
• Business Unit Access Tab
• Configuring Cash Management Rapid Implementation
• Bank Account Transfers
• Bank Account Transfer
• Configuring Bank Statement Processing
• Key Setup Tasks for Bank Statement Processing
• Manage Cash Transaction Type Mapping
• Bank Statement Transaction Codes
• Practice
• Payment Code Map Groups
• Code Map Group Example
• Bank Statement Formats
• Parse Rule Sets
• Parse Rule Set Example
• Bank Statement Transaction Creation Rules
• External Transactions Overview
• Practice
• Performing Bank Statement Processing
• Bank Statement Processing Overview
• Manual Reconciliation
• Bank Statement Handling and Reconciliation Overview
• Create Bank Statements in Spreadsheet
• Reconcile Bank Statements directly from General Ledger Journal Entries
• Manage Cash Management Profile Options Setup
• Reconciling Journal Lines For Multiple Cash Account Combinations
• Exclude Reversal Journal Entries from Bank Statement Reconciliation
• Reconcile Zero Amount System Transactions
• Intraday Bank Statement Support
• Configuring Automatic Bank Reconciliation
• Cash Management Setups for Automatic Reconciliation Overview
• Bank Statement Reconciliation Setups
• Manage Bank Statement Reconciliation Matching Rules Setup
• Bank Statement Reconciliation Matching Rules
• Structured Payment Reference On Receipts Created Using Lockbox
• and Services
• Journal Reconciliation With Value Date
• Matching Type
• Practice
• Bank Statement Reconciliation Tolerance Rules
• Practice
• Bank Statement Reconciliation Rule Sets
• Practice
• Performing Automatic Reconciliation
• Automatic Reconciliation of Bank Accounts for a Bank, Bank Branch,
• or Legal Entity
• Advanced features of Cash Management
• Reporting and analysis
• Configurable Cash Management Workflow Notifications
• Cash Management Infolets
• Cash Positioning and Forecasting – Cash Balances
• Cash Position Page
• 5 Day Forecast Page
• Transactions Cube
• Ready to Use Smart View Templates
• Manual Transactions
• Extended Cash Forecasts
• Notional and Physical Cash Pools
• Summary

Configuring Oracle Bill Management

• Objectives
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Bill Management Overview
• Bill Management Account Overview Work Area Features
• Print Transactions
• Review Balance Forward Bill Details Using Bill Management
• Balance Forward Bill View and Download in Bill Management
• Bill Management Setup Overview
• Demonstration Overview: Using Bill Management
• Bill Management Configuration Steps Overview
• Register External Users
• Setting Up System Options
• Summary

Reporting for Receivables, Cash Management, and Tax

• Objectives
• Review OMBP: Customer Invoice to Receipt
• Oracle Modern Best Practice: Customer Invoice to Receipt
• Receivables Reports
• Receivables
• Receivables Analytics Publisher Reports
• Receivables Oracle Transactional BI Reports
• Receivables Subject Areas
• Receivables Subject Area Additions
• OTBI Receivables Subject Area
• Cross-Pillar Reporting Between Receivables and Projects
• Use Additional attributes in Receivables Subject Areas
• Drilldown from OTBI Receivables Reports to Customer Details
• Receivables to Ledger Reconciliation Report Dashboard
• Improved Receivables to Ledger Reconciliation Drilldown Scalability
• Setting Up for the Receivables to Ledger Reconciliation Report
• Prepare Receivables to General Ledger Reconciliation Process
• Receivables to Ledger Reconciliation Report: Security
• View MultiFund Accounting on the Aging and General Ledger Reconciliation
• Reports
• Billing Work Area Infotiles
• Infotiles: Receipt Batches and Lockbox Exceptions
• Infotiles: Unapplied Receipts and Unapplied Credits
• Subledger Accounting Reports
• Subledger Accounting
• Subledger Accounting Predefined Reports Overview
• Subledger Accounting Analytics Publisher Reports
• Subledger Accounting Subject Areas
• Cash Management Reports
• Cash Management
• Cash Management Analytics Publisher Reports
• Cash Management Transactional Business Intelligence Report
• Cash Management Subject Areas
• Tax Reports
• Tax
• Tax Reporting Tools
• Tax Reporting Ledger
• Tax Reports Based on the Tax Reporting Ledger
• Summary

Implementing Credit Management

• Objectives
• Credit Profiles Overview
• Credit Profile Settings
• Credit Manager
• Credit Analyst
• Scoring Model Overview
• Creating Scoring Model Process
• Assigning Scores Examples
• Assigning Weights
• Demonstration: Overview: Creating a Scoring Model
• Calculating the Score
• Creating a Credit Case Folder Template
• Creating a Case Folder Template
• Override Default Scoring Models on Credit Case Folders
• Additional Attributes for Credit Checking Service
• Order Level Credit Recommendation
• AR_TRX_BAL_SUMMARY Table
• AR_TRX__SUMMARY Table
• Refreshing the Tables
• Importing Credit Data
• Summary
• A Configuring Oracle Payments for Funds Capture
• Objectives A-2
• Overview of Payments A-3
• Overview of Funds Capture A-4
• Funds Capture Concepts A-5
• Funds Capture Overview A-7
• Implementation Considerations for Automatic Receipts A-9
• Prerequisites for Defining Funds Capture A-12
• Defining Funds Capture A-13
• Managing Funds Capture Payment Methods A-14
• Key Decisions and Best Practices for Funds Capture Payment Methods A-15
• Managing Funds Capture Process Profiles A-17
• Retrieve Funds Capture Acknowledgment Files Using a Wildcard Search A-19
• Using the Wildcard Character A-20
• Retrieval of Funds Capture Acknowledgment Files Using a Wildcard A-21
• Formatting Messages A-23
• Building Settlements into a Settlement Batch A-26
• Payment System Accounts A-27
• Transmitting Messages to the Payment System A-28
• Use Two-Factor Authentication for Inbound File Transmission A-29
• Managing Internal Payees A-30
• Creating and Assigning Routing Rules to Internal Payees A-32
• Reevaluate Routing Rules during receipt remittance A-34
• Key Decision and Best Practices for Internal Payees A-35
• Security Concepts A-37
• Security Overview A-39
• Managing System Security Options A-40
• Creating a Wallet File and Master Encryption Key A-41
• Key Decisions and Best Practices for Security A-42
• Rotating the Master Encryption Key A-44
• Rotating the Subkeys A-45
• Encrypting Bank Account Data A-47
• Configurable Encryption and Signature Keys for Stronger Payment File
• Security A-49
• Masking Credit Card and Bank Account Numbers A-51
• Viewing Six Digits of the Bank Account Number A-53
• Settling Tokenized Credit Card Transactions from Third-Party Systems A-54
• Importing and Exporting Tokenization Setup Data A-55
• Testing Tokenization Setup A-56
• Using the Receivables AutoInvoice Import Template A-57
• How to Display the New Credit Card Columns A-59
• Removal of Personally Identifiable Information A-60
• Web Service to Update Invoices with Credit Card Information A-61
• Summary A-66