Oracle Fusion Cloud Financials: Using General Ledger Ed 3

Oracle Fusion Cloud Financials: Using General Ledger Overview

• Course Objectives
• Course Approach
• Course Schedule
• Lesson Objectives
• Introduction to Oracle Cloud applications
• Oracle Cloud Strategy
• Oracle Cloud applications: Product Families
• Oracle Financials: Overview
• Key Features in Oracle Financials
• General Ledger Functions and Features
• General Ledger Accounting Cycle
• The Financial Reporting Center Overview
• Other Reporting Interfaces Overview
• Summary

Reviewing Enterprise Structures

• Objectives
• Define Enterprise Structures
• Rapid Implementation Workbook
• Manage Legal Entities
• Legal Entities Definition
• Legal Entity and Ledgers
• Legal Entities and Intercompany Transactions
• Legal Entity and Its Relationship to Intercompany Transactions
• Legal Entity and Consolidation Rules
• Country-Specific Legal Entity Sequences
• Practice Overview: Searching for a Legal Entity
• Chart of Accounts Components
• Practice Overview: Entering Values
• Assigning Segment Labels
• Sharing Ledger Components Across Oracle Applications
• Practice Overview: Reviewing Shared Components
• Defining Hierarchies: Overview
• GL Rapid Implementation Additional Features
• Cross-Validation Rules and Segment Value Security Rules
• Cross-Validation Rules: Considerations
• Cross-Validation Rules: Actions
• Cross-Validation Rules: Using FBDI
• Filters Overview
• Filters and Conditions
• Practice Overview: Defining Cross-Validation Rules
• Cross-Validation Rules: Using Combination Sets
• Manage Account Combination Validation Rules Process
• Dynamic Combination Creation Allowed
• Account Combinations
• Enabling Account Combinations
• Practice Overview: Creating an Account Combination
• Account Shorthand Alias
• Practice Overview: Creating an Account Shorthand Alias
• Summary

Exploring Calendars and Ledgers

• Objectives
• Manage an Accounting Calendar
• Accounting Calendar Considerations
• Period Frequency
• Adding a Calendar Year
• Calendar Auditing
• Practice Overview: Creating a Calendar
• Ledgers and Accounting Configurations
• Define Ledger Components
• Ledgers and Subledger Accounting
• Practice Overview: Creating a Primary Ledger
• Specify Ledger Options
• Processes Using Ledger Options
• Single Currency Journals
• Practice Overview: Specifying Ledger Options
• Overview of Average Balance Processing
• Examples of Average Balances: Day One
• Examples of Average Balances: Day Two
• Examples of Average Balances: Day Three
• Amount Types for Average Balance Processing
• Set Up Average Balance Processing
• Review and Submit Accounting Configuration
• Manage Reporting Currencies
• Reporting Currencies: Conversion Levels
• Practice Overview: Defining Reporting Currencies
• Practice Overview: Completing the Ledger Configuration
• Define Secondary Ledgers
• Secondary Ledgers: Scenarios
• Secondary Ledgers: Conversion Levels
• Legal Entity-Specific Secondary Ledgers with Controlled Replication from
• Primary Ledgers
• Chart of Accounts Mapping Feature
• Chart of Accounts Mapping: Actions
• Chart of Account Mapping: Using FBDI
• Segment Mapping Rules
• Account Mapping Rules
• Multiple Source Segment Rules
• Balance Cubes: Overview
• Balance Cubes Naming
• Balance Cube Dimensions
• Manage Ledger Sets
• Ledger Set Classification for Consolidated Views
• Practice Overview: Creating a Ledger Set
• Data Access Set Security: Overview
• Data Access Set Security
• Data Access Set Security: Example
• Practice Overview: Reviewing Data Access Set Security
• Summary

Creating Journal Entries

• Objectives
• Oracle General Ledger Accounting Cycle
• Practice Overview: Opening the First Accounting Period
• Integrating Journal Entries in the Cloud
• Manage Journal Sources and Categories
• Journal Sources
• Journal Categories
• Practice Overview: Creating a Journal Source and Category
• Performing Journal Entry Functions
• Capturing Journal Transactions
• Journal Components
• Manual Journal Entries
• Posting Journal Batches
• Posting Journals
• Unposted Journal Batch Statuses
• Single and Multicurrency Journals
• Balancing Single Currency Journals
• Balancing Multicurrency Journals
• Data Access Set Impact to Posting
• Manage AutoPost Criteria Sets
• AutoPost Criteria Sets: Parameters
• Practice Overview: Entering and Posting a Manual Journal
• Reversing Journal Entries
• Manually Reversing Journals
• Automatically Reversing Journal Entries
• Manage AutoReverse Criteria Sets
• Reverse Journal Batch
• Synchronize Reversals Between Primary and Secondary Ledgers
• Practice Overview: Reversing a Journal Manually
• Manage Accounting Automation
• Additional Considerations for Accounting Automation
• Journal Entries in Spreadsheets
• Display Error Message in Separate Column in Create Journals Spreadsheet
• Integrating with General Ledger: Submit Journals
• Practice Overview: Entering and Posting a Journal in a Spreadsheet
• Configuring Import Submission Options for the Journal Creation Spreadsheet
• Setting Up Default and Hide Submission Options
• Setting the Submission Option Defaults
• Hiding Submission Options
• Importing Journals
• Separate Journals by Accounting Date During Journal Import
• Using Separate Journals by Accounting Date During Journal Import
• Importing Journal References
• Reviewing Journal Import Data
• Journal Import Verification Process
• Correcting Journal Import Errors
• Inquiries: General Accounting Dashboard Overview
• General Accounting Dashboard: Account Monitor
• Defining Account Groups: Header Section
• Defining Account Groups: Accounts Section
• Practice Overview: Using the Account Monitor
• General Accounting Dashboard: Account Inspector
• Summary

Using Foreign Currencies

• Objectives
• Overview of Currency
• Integrating with Subledgers
• Currency Concepts
• Currencies: Overview
• Practice Overview: Creating a Currency
• Conversion Rate Types: Overview
• Cross Currency Functionality
• Explain Cross-rate Rules
• Conversion Example
• Practice Overview: Creating Conversion Rate Types
• Daily Rates: Overview
• Practice Overview: Entering Daily Rates
• Practice Overview: Entering and Reviewing a Foreign Currency Journal
• Summary

Managing Intercompany Transactions

• Objectives
• Oracle Intercompany Transactions: Overview
• Manage Intercompany Transaction Processing
• Intercompany General Ledger Integration
• Intercompany Receivables and Payables Integration
• Intercompany Transactions Dashboard
• Manual Intercompany Transaction Processing
• Creating Intercompany Transactions Using a Spreadsheet
• Practice Overview: Creating Intercompany Transactions Using a Spreadsheet
• Intercompany Transactions Import Error Correction Spreadsheet
• Practice Overview: Creating Intercompany Transactions with Invoice
• Generation
• Intercompany Allocation: Overview
• Intercompany Allocation Journals
• Intercompany Allocation Transactions
• Example: Intercompany Allocations
• T – Accounts: Journal 1
• T – Accounts: Journal 2
• T – Accounts: Journal 3
• Intercompany Allocations Example
• Multitier Intercompany Operations
• Multitier Intercompany Operations Landing Page
• Automated Intercompany Cross Charge of Payables Invoices
• Creating Credit Memos for Negative Intercompany Transactions
• Using Intercompany Import for Invoice or Credit Memo
• Importing and Exporting CSV Files
• Points to Consider with Credit Memo for Negative Intercompany Transactions
• Reconciliation Reports
• Intercompany Reconciliation
• Intercompany Reporting and Analysis
• Practice Overview: Running the Reconciliation Report
• Transaction Account Definition
• Summary

Performing Period Close

• Objectives
• Overview
• Close Monitor Overview
• Close Monitor Explained
• Setting Up the Close Monitor
• Navigating in the Close Monitor
• Viewing in the Close Monitor
• Open and Close Periods Life Cycle
• Accounting Period Statuses
• Accounting Periods: Overview
• Period Close with Oracle Financials
• Close Status Section
• Preventing GL Closure When Subledgers Are Open
• Preventing GL Period Closure Setup
• Period Close Best Practices
• Period Close Checklist
• Period Close Components
• Allocation Concepts
• Allocation Components
• Defining Allocation Requirements
• Generation of Allocations
• Cross Ledger Intercompany Allocations
• Step Down Allocation: Example One
• Step Down Allocation: Example Two
• Allocation Rule Concepts
• Allocation Rule Deployment
• Allocations: Best Practices
• Practice Overview: Creating and Generating an Allocation Rule
• Revaluation: Overview
• Translation and Reporting Currencies Overview
• Revaluation and Translation Concepts
• Revaluation and Translation Setup
• Revaluation Process
• Revaluation Example
• Revaluation Tracking by Multiple Segments
• Revaluation Tracking by Multiple Segments Setup
• Revaluation in Reporting Currency Ledger
• Practice Overview: Defining and Running a Revaluation
• Translation Process
• Translation and Remeasurement
• Differences Expanded
• Translation versus Remeasurement Example
• Historical Rates and Amounts
• Historical Rates and Amounts using FBDI
• Practice Overview: Creating a Translation
• Import Journal Entries: Overview
• Journal Import Verification Process
• Journal Import Validates
• Reconciliation
• Reconciliation Concepts
• Clearing Accounts Reconciliation for Journal Lines
• Steps to Enable Clearing Accounts Reconciliation
• Other Considerations
• Performing Clearing Accounts Reconciliation
• Spreadsheet-Based Clearing Accounts for Reconciliation
• Practice Overview: Clearing Accounts Reconciliation
• Payables Tax Reconciliation with General Ledger Report
• Summary

Maintaining General Ledger Options

• Objectives
• Manage Suspense Accounts
• Practice Overview: Creating a Suspense Account
• Manage Statistical Units of Measure
• Practice Overview: Creating a Statistical Unit of Measure
• Manage Processing Schedules
• Practice Overview: Creating a Processing Schedule
• Summary

Performing Consolidations

• Objectives
• Consolidation Methods
• Reporting Only Consolidation Method: Example
• Reporting Consolidation with Multiple Levels: Level One
• Reporting Consolidation with Multiple Levels: Level Two
• Elimination Entries Example
• Elimination Entries Example: Transaction
• Elimination Entries North America Level One Example: Elimination Entry
• Balance Transfer Consolidation Method
• Transfer Ledger Balances Process Parameters
• Practice Overview: Creating a Chart of Accounts Mapping
• Practice Overview: Submitting the Transfer Ledger Balances Process
• Reporting Only Versus Balance Transfer: Pros
• Reporting Only Versus Balance Transfer: Cons
• Oracle Hyperion Financial Management Integration: Overview
• Financial Management Integration Option
• Financial Management Integration Implementation
• Mapping Segments to Financial Management Dimensions
• Summary

Loading Budgets

• Objectives
• Budgeting Preparation
• Budget Scenario Dimensions
• Integration with Oracle Hyperion Planning
• Importing Budget Data from a Flat File
• Importing Budget Data from a Flat File: Steps
• Importing Budget Data from a Spreadsheet
• Importing Budget Data from a Spreadsheet: Import Correction
• Practice Overview: Uploading a Budget Using a Spreadsheet
• Summary

Accounting Data Archive and Purge

• Objectives
• Accounting Data Archive and Purge
• Manage Archive and Purge Policies
• Steps in Archive and Purge Accounting Data
• Enable the Business Object for Archive
• Validate the Accounting Data
• Archive and Purge the Accounting Data
• Summary