OEG One - List of Contents
This is the list of contents included in OEG One Membership
Browse Contents
Summary
Oracle Financials Cloud
Financials Cloud Modules
- General Ledger Fundamentals and Deep Dive
- Intercompany Fundamentals and Deep Dive
- Subledger Accounting (SLA) Fundamentals and Deep Dive
- Payables Fundamentals and Deep Dive
- Procure to Pay (P2P) Fundamentals and Deep Dive
- Receivables Fundamentals and Deep Dive
- Advanced Collections Fundamentals and Deep Dive
- Assets Fundamentals and Deep Dive
- Cash Management Fundamentals
- Fusion Tax Management Fundamentals
- Approval Management Fundamentals and Deep Dive
- Rapid Implementation Fundamentals and Deep Dive
Financials Cloud Tools
- FBDI – File Based Data Import – Fundamentals
- OTBI – Oracle Transactional Business Intelligence – Fundamentals
- Hyperion SmartView – Fundamentals
- Hyperion Financial Reporting Studio (Web Reporting Studio) – Fundamentals
- ADF-DI – Application Developer Foundation – Desktop Integrator – Fundamentals
Oracle Fusion Accounting Hub Cloud (FAH)
- Concept, Example and Setting Up AHC
- SLA Structure for External Application
- Importing Transactions and Create Accounting
- Description Rules, SLA Structure and Sources, Attributes etc
- Accounting in Multiple Ledgers etc
- Mapping Sets etc
- Event Types and Adding Tables, Columns etc
Oracle Revenue Management Cloud (RMCS)
- Revenue Management Implementation Considerations
- Revenue Management Fundamentals
- ASC 606 and IFRS 15: Revenue Principles
- Configuring Revenue Management
- Configuring Standard Selling Prices
- Integrating with Revenue Management
- Managing Contracts and Revenue
- Revenue Management Process Flow
Oracle PPM Cloud
- Project Foundation
- Project Billing
- Project Costing
- Project Accounting
- Project Management
- Project Resource Management
- Project Integration Fundamentals
- Project Reports Fundamentals
- Project Data Conversion Fundamentals
Oracle SCM Cloud
- Inventory Fundamentals
- Product Management Fundamentals
- Requisitioning Fundamentals
- Purchasing Fundamentals
- Item Fundamentals
- Supplier Fundamentals
- Transaction Account Builder (TAB) Fundamentals
- SCM Approvals Fundamentals
- File Based Data Import Fundamentals
- Supplier Qualification Management (SQM)
- Procurement Contracts
Oracle Order Management Cloud
- Oracle Order Management Cloud Basics
- Order Orchestration
- Order Transformation Rules
- Order Approvals
- Pricing Cloud
- Shipping
- Global Order Promising (GOP)
- Order Management Cloud Transactions
Detailed
Oracle Fusion Fundamentals
Navigator
- Navigator and Menu Items
- Logging into Fusion
- Configure Offerings
- Creating Implementation Project
- Selecting Offerings
- Accessing Task List
- Performing Tasks
- Accessing Navigator Menus
- …more about Implementation Project
- Create user
- Assign roles
- Assign data access sets
Oracle Financials Cloud
General Ledger Cloud
Creating Legal Entity
- Creating an Address
- Creating a Legal Entity
- Registering a Legal Entity
- Creating COA Value Sets
- Defining COA Structure
- Defining COA Structure Instances
- Deploying Flexfield
- Defining COA Values
- Understanding FBDI
- Prepare Values in Spreadsheet
- Prepare Hierarchies in Spreadsheet
- Generate CSV and ZIP Files
- Upload Datafile
- Load Datafile to Interface Table
- Import Values from Interface
- Import Hierarchies from Interface
- Verify COA Values & Hierarchies
Accounting Calendar
- Defining Calendar
- Generate Calendar
- Defining Primary Ledgers
- Assigning Legal Entities
- Setting up Ledger Options
General Ledger Roles
- Understanding GL Roles
- Assigning Roles
- Assigning Data Access
- …More GL Setups
Cross Validation Rules
- Account Combinations Explained
- Effect of Dynamic Combination Creation
- Cross-Validation Rules Explained
- Structure of a Cross-Validation Rule
- Examples of Cross-Validation Rules
- Cross-Validation Rules VS. Segment Value Security (Security Rules)
- Configuring Cross-Validation Rules
- Verify Cross-Validation Rule by entering Journal
- Applicability of Cross-Validation Rules (Prospective / Retrospective)
- Important Notes
- Manage Cross-Validation Rules Violations
Segment Value Security (Security Rules)
- Segment and Segment Values Explained
- Segment Value Security Rules Explained
- Structure of a Segment Value Security Rule
- Role, Condition and Policy Explained
- Examples of Segment Value Security Rules
- Cross-Validation Rules VS. Segment Value Security (Security Rules)
- Enabling Security for a Value Set
- Configuring Segment Value Security Rules
- Verify Segment Value Security Rule by entering Journal and AP Invoice
- Important Notes
Account Inspector and Balance Inquiry in Oracle Fusion
- Account Inspector Explained
- Use cases for Account Inspector
- Scenario demonstrated for Account Inspector
- Detail Balance Inquiry Explained
- Scenario demonstrated for Detail Balance Inquiry
- Journal Line Inquiry Explained
- Scenario demonstrated for Journal Line Inquiry
Account Monitor
- Account Monitor Explained
- Account Group Explained
- Creating an Account Group
- Time Options and Comparison Options for Account Groups Explained
- Conditional Display of Account Combinations
- Example Scenarios for Account Monitor (total 7 Scenarios):
- Explained
- Executed
- Security (Access Options) for Account Group
- Display Options for Account Group:
- Account Monitor
- Infolets
- Close Monitor
- Financial Reporting Center
General Ledger Setup Validation
- Open First Period
- Enter and Post Journals
Budgets/Budgetary Control
- Enable Budgetary Control
- Create Budget
- Create Supplemental Rule
- Enter Budget Amounts
- Verify Budgetary Control
- Budget by Summarised Accounts/Periods
Secondary Ledgers
- Create Secondary Ledger
- Data Conversion Levels
- Daily Exchange Rates
- Primary to Secondary Mapping
- Subledger Options
- Verify Journal Generation
- Verify SLA Journal Generation
- Inter-company Transactions
- Inter-company Balancing
- Setup Inter-company Accounts
- Enter Inter-company Journal
- Post Journals
- Verify Inter-company Accounting
- Daily Exchange Rates
- Verify Foreign Currency Balances
- Setup Unrealised Gain/Loss A/cs
- Run Revaluation
- Verify Revaluation Journal
Reporting Currency Ledger
- RC and Translation
- Daily Exchange Rates
- Create RC Ledgers
- Data Conversion Levels
- Translate Balances
- View Translated Balances
- View Translated Journals
Consolidation
- Create COA Mapping
- Create Consolidation Ledger
- Perform Consolidation
- View Consolidation
Mass Allocation
- Create Account Hierarchy
- Calculation Manager & Point of View
- Setup Allocation Ratio
- Setup Allocation Formula
- Deploy Allocation Rule
- Generate Allocation
- Verify Allocation
Intercompany and AGIS Cloud
Intercompany Basic Transactions
- Prerequisite Concepts
- Balancing Segment Values (BSVs)
- Legal Entities
- Ledgers
- Intercompany Accounting:
- Traditional Accounting
- Accounting in Oracle Fusion
- Intercompany Concepts
- Intercompany Segment – Explained
- Types of Intercompany Transactions
- Examples of Intercompany Transactions
- Intercompany Setups
- Assigning BSVs
- Creating Intercompany Balancing Rules
- Enabling Intercompany
- Intercompany Transactions – Demonstrated on Fusion Instance
- GL Journal
- AP Invoice
- AR Invoice
Intercompany – Clearing Company
- Concept of Clearing Company
- Examples of Transactions involving Clearing Company
- Clearing Company in Intracompany Transactions
- Clearing Company in Intercompany Transactions
- Intercompany Basic Setup
- Clearing Company Setup
- Verification of Accounting using Clearing Company – Demonstrated on Fusion Instance using GL Journal
Global Intercompany (AGIS) – Without Invoicing
- Meaning of Global Intercompany Transactions
- Global Intracompany Transactions Without Invoicing – Flow Explained
- Business Scenario Explained
- Business Scenario Demonstrated on Fusion Instance
- IC Transaction Types
- IC Balancing Rules
- IC System Options
- IC Periods
- IC Organizations
- IC Manual Approval Rules
- Create IC Transaction
- View Journals for IC Transaction
- In Provider’s Ledger
- In Receiver’s Ledger
Global Intercompany (AGIS) – WITH Invoicing
- Meaning of Global Intercompany Transactions With Invoicing
- Global Intracompany Transactions WITH Invoicing – Flow Explained
- Business Scenario Explained
- Business Scenario Demonstrated on Fusion Instance
- Customer for Intercompany Transactions
- Supplier for Intercompany Transactions
- IC Customer Supplier Association
- IC Receivables Assignment
- Create IC Transaction
- View Invoices generated for IC Transaction
- Payables Invoice
- Receivables Invoice
- Create and View Accounting for the Invoices
Global Intercompany (AGIS) – Credit Memos
- Need of Credit Memos in Global Intercompany Transactions
- Positive vs Negative Global Intercompany Transactions
- How nature of Global Intercompany Transaction affects various particulars
- Business Scenario Explained
- Business Scenario Demonstrated on Fusion Instance
- Setups to enable creation of Credit Memos from Global Intercompany Transactions
- Create IC Transaction
- View Credit Memos generated for IC Transaction
- Payables Credit Memo
- Receivables Credit Memo
- Create and View Accounting for the Credit Memos
Global Intercompany (AGIS) – Using Transaction Account Definition (TAD)
- TAD – Meaning and Explanation
- Use Case of TAD in Global Intercompany Transactions
- TAD in the context of a Business Scenario – Explained
- TAD in the context of a Business Scenario – Demonstrated on Fusion Instance
- Account Rules
- Create TAD
- Assign TAD
- View Account Combinations Auto-generated by TAD
Global Intercompany (AGIS) – Reconciliation Report
- Intercompany Reconciliation – Explained
- Intercompany Reconciliation Business Scenario – Explained
- Reconciliation Report Steps – Explained
- Reconciliation Report Steps – Demonstrated on Fusion Instance
- Understanding the Reconciliation Report
- Drill-down
- Exporting the Report
Subledger Accounting (SLA) Cloud
Subledger Accounting Concepts
- What is Subledger Accounting (SLA)
- Transaction Accounting Explained
- How to associate Accounting Method with Ledger
- Roles required
SLA Structure
- Components in SLA:
- Account Rule
- Mapping Set
- Journal Entry Rule Set
- Journal Line Rule
- Navigation
- Structure Diagram
- AR Invoice Accounting Example – Explained
- Accounting before assigning Custom SLAM
- Creating Custom SLAM
- Account Rule
- Journal Line Rules
- Journal Entry Rule Set
- Activate Journal Entry Rule Set
- Assign Custom SLAM to Ledger
- Accounting using Custom SLAM
- Changes Explained
Create Accounting
- How Create Accounting process works – Explained
- Types of Accounting
- Draft
- Final
- Comparison between Draft and Final Accounting
- Executed Example – Draft Accounting
- Review Journal Lines
- Executed Example – Final Accounting
- Review Journal Lines
- Review GL Journals
- Incremental Accounting if changes made post Final Accounting
Subledger Accounting Options – Transfer to General Ledger
- Summarize by GL Period:
- Create multiple Invoices
- Create Accounting
- View and understand results
- Summarize by GL Date:
- Create multiple Invoices
- Create Accounting
- View and understand results
- Group by GL Period:
- Create multiple Invoices
- Create Accounting
- View and understand results
- Group by GL Date:
- Create multiple Invoices
- Create Accounting
- View and understand results
- Comparison of results under different options
Subledger Accounting Options – Other Options
- Enable posting from subledger
- Create Journal Category
- Rounding and Reversal Options
- Subledger Accounting System Options
Mapping Sets – Explained
- What is Mapping Set
- How Mapping Set works functionally
- Mapping Set Example and Use Cases
Mapping Sets – Worked Example
- Accounting before using Mapping Set
- Setups for Mapping Set
- Create Value Set
- Enter Values
- Create and Assign Sources
- Create Mapping Set
- Create Account Rule
- Assign Account Rule
- Create Accounting using Mapping Set
- View and understand results
Description Rules – Explained
- What are Description Rules
- Types of Description Rules
- Header Level
- Line Level
- Description Rule Example and Use Cases
Description Rules – Worked Example
- View Description before creating custom Description Rules
- Setups for creating Custom Description Rules
- Create Journal Category
- Create and Assign Sources
- View Sources
- Create Description Rules
- Create custom SLAM
- Assign Description Rules to SLAM
- Assign SLAM to Ledger
- Create Transactions
- Create Accounting using custom SLAM
- View and understand descriptions as per user-created Description Rules
Concept and Example
- Document Sequence
- Accounting Sequence
- Reporting Sequence
- Examples
Accounting and Reporting Sequences – Worked Examples
- View results before change
- Create AR Receipt
- View AR Receipt Document Number
- View GL and SLA Journals
- View AR Document Sequence
- Setups
- Enable Sequencing
- Create Accounting Sequence
- Assign Accounting Sequence
- Create Reporting Sequence
- Assign Reporting Sequence
- Transaction Flow
- Create AR Receipt
- Create Accounting
- View Accounting Sequence on GL and SLA Journals
- Period Closure
- View Reporting Sequence on GL and SLA Journals
- Important Points
Supporting References – Explained
- Concept and Explanation
- Types of Supporting References
- Without Balances
- With Balances
- Examples and Use Cases
- DFFs vs. Supporting References
Supporting References – Worked Example
- View results before change
- Setups
- Create DFFs
- Create and Assign Sources
- Setup Supporting References
- Assign Supporting Reference to JLR
- Transaction Flow
- Create Transaction
- Run Update Process
- View Supporting References
- Verify Supporting Reference Balances
- Create OTBI Analysis
- Open and view OTBI Analysis results
- Supporting Reference Tables for SQL Query
Advanced SLA Topics – Part-1
- Transaction Objects
- What are Transaction Objects
- Base Tables vs. Transaction Objects
- Why Transaction Objects are needed
- View Transaction Objects
- View Source Assignments
- Sources
- Accounting Attributes
- Event Model
- Process Categories
- Event Classes
- Event Types
- Accounting Classes
Advanced SLA Topics – Part-2
- Conditions
- Why Conditions are needed
- Conditions in JLR
- Conditions in Account Rule
- Business Flow
- Business Flow Class
- Business Flow Examples
Advanced SLA Topics – Part-3
- AR AutoAccounting
- What AutoAccounting does
- What SLA does
- AutoAccounting vis-a-vis SLA
- AR Multifund Accounting
- Creating a Multifund Accounting SLAM
Payables Cloud
Business Units
- Creating Business Units
- Business Unit Functions
- Business Unit Reference Data Sets
Banks Branches & A/cs
- Creating Bank
- Creating Branches
- Creating Bank Accounts
Payables Settings
- Payables & Procurement Options
- Setting up Invoice Options
- Setting up Payment Options
- Payment Methods
- Payment Terms
- Payment Documents
- Payment Process Profiles
- Distribution Sets
- …More Payables Setups
Procurement Agents
- Employee, User & Procurement Agent
- Roles for Procurement Agents
- Procurement Agents & Suppliers
AP Roles
- Understanding AP Roles
- Assigning Roles
- Assigning Data Access
Suppliers
- Creating Suppliers
- Entering Supplier Addresses
- Creating Supplier Sites
- Supplier Site Assignments
Payables Invoices
- Entering AP Invoices
- Invoice Validation
- Invoice Accounting
Payments
- Pre-requisites
- Creating Payment
- Payment Accounting
Automatic Offsets
- Concept and Explanation
- Available Automatic Offset Options:
- None
- Primary Balancing Segment
- All Segments Except Natural Account
- Invoice Accounting Demonstrated on Fusion Instance – for all 3 Scenarios
- Automatic Offsets vis-a-vis Intercompany Accounting
- Payables Transactions Accounted as Intercompany
- Payables Transactions not Accounted as Intercompany
- Prepayment Types
- Enter Prepayment Invoice
- Enter Payment
- Apply Prepayment to Invoices
- Prepayment Accounting
Dr/Cr Memos
- Enter Dr/Cr Memo
- Validate Dr/Cr Memo
- Dr/Cr Memo Accounting
- Matching Dr/Cr Memo to Invoice
Quick and Manual Payments
- Concept
- Payment Method
- Issue Payment
- View Format
- View Accounting
Electronic Payments
- Payment method
- Payment Document
- Payment Process Profile
- Issue Payment
- View Format
- View Accounting
One Time Payments
- Concept and Explanation
- Enabling Feature
- Verify Location
- Set Up Accounts
- Trading Community Source
- Payables Lookups
- Using Template
- View Requests
- Create Payment
- Verify Payment File
Invoice Account Coding Workflow
- Concept and Explanation
- Example Scenario
- Important Notes regarding Account Coding Workflow
- Enabling Feature
- Activate Feature for BU
- Configuring the Workflow in AMX (Approvals Management Extension)
- Routing the Invoice without Distributions, to Accountants
- Entering Distributions by Accountants
- An Exceptional Scenario in the Invoice Account Coding Workflow
Supplier Registration and iSupplier Portal
- Concept and Explanation
- Types of Supplier Registration Requests
- Creating Procurement Agent
- Configuring Approval Rules
- Creating Supplier Registration Request
- Approving Supplier Registration Request
- Verify Supplier
- iSupplier Portal
- Login as Supplier Contact
- Managing Documents
- Creating Invoice through iSupplier Portal
Document Sequencing
- Concept and Explanation
- Flow of Document Sequencing for Payables
- Types of Document Sequences
- Manual
- Automatic
- Gapless
- Sequencing Options — Oracle EBS R12 vs Oracle Fusion Cloud
- Setup for Payables Document Sequencing
- Enable Sequencing
- Create Category
- Create Sequence
- Assign Category
- Verify Document Sequencing on Payables Invoice
- Verify Document Sequencing on Payables Payment
- Important Points
- Concept and Scenario
- Global Segments
- Contexts
- Context Sensitive Segments
- Enter Values
- Search using custom fields
- Payment Methods
- Payment Documents
- Payment Process Profiles
- Auto-generate Check Payments
- Auto-generate Electronic Payments
- Payment Accounting
- Bills Payables
- Post Dated Checks
- Payment Methods
- Entering Future Dated Payments
- Update Payments on Maturity
- Bills Payable Flow and Accounting
Procure to Pay (P2P) Cloud
Oracle Fusion Procure to Pay Concepts and Accounting
- In Summary
- In Detail, including the following 6 stages (and sub-stages within these stages) of the P2P Cycle:
- Requisition stage
- Purchase Order stage
- Shipment by Supplier and Receipt stage
- Invoice stage
- Payment stage
- Reconciliation stage
PO to Invoice Matching Explained
- Concept of Matching
- Variables Compared in 2-Way Matching
- Variables Compared in 3-Way Matching
- Variables Compared in 4-Way Matching
Budgetary Control and Encumbrance Accounting Explained
- Meaning and Significance of Budgetary Control
- Meaning and Significance of Encumbrance
- Why Encumbrance Accounting is necessary
- Types of Encumbrances in Oracle Fusion
Accrual Explained
- Meaning and Significance of Accrual
- Accrual Options in Oracle Fusion
- For Inventory Items
- For Expense Items
- Accrual Scenarios that can arise in Oracle Fusion:
- Accrual at Receipt
- Accrual at Period End
- No Accrual (Scenario where Receipt may not be required)
In-Depth Accounting for Entire P2P Cycle in Oracle Fusion, in each of the above Scenarios – Explained
Accounting Entries for each event, type of Journal created (Actual / Encumbrance) covered for the following scenarios:
- Accrual at Receipt
- Accrual at Period End
- No Accrual (Scenario where Receipt may not be required)
Comparative View of Accounting across Scenarios covered
Oracle Fusion Procure to Pay – Setting up Budgetary Control and Encumbrance Accounting
Budgetary Control and Encumbrance Accounting Explained
- Meaning and Significance of Budgetary Control
- Meaning and Significance of Encumbrance
- Why Encumbrance Accounting is necessary
- Types of Encumbrances in Oracle Fusion
Budgetary Control and Encumbrance Accounting (BCEA) – Demonstrated on Fusion Instance
- Encumbrance Reserve Account
- Enabling BCEA for Ledger / Business Unit
- Defining Control Budget
- Setting up Control Level
- Defining Supplemental Rules
- Preparing Budget for Use
- Security Roles for BCEA
- Granting Data Access
- Opening Budget Periods
- Initializing Budget Balances
- Verifying Budget Balances
- Encumbrance Types in Oracle Fusion
- Opening Encumbrance Years
Oracle Fusion Procure to Pay – Setting up Transaction Account Definition
Transaction Account Definition Explained
- Meaning and Significance of Transaction Account Definition
- Transaction Account Types in Oracle Fusion Procurement
- Example Account Combination used in the video
Transaction Account Definition – Demonstrated on Fusion Instance
- Transaction Account Types in Oracle Fusion Procurement
- Creating Accounts
- Creating Account Rules
- Creating Transaction Account Definition
- Assigning Transaction Account Definition to the Ledger
Other Procurement Setups
- Inventory Organisations
- Subinventories and Locators
- Purchasing Line Types
- Security Roles and Data Access for Procurement
- Configuring Requisitioning Function
- Configuring Procurement Function
- Setting up Requisition Approval Rules
- Setting up Purchase Order Approval Rules
- Creating Procurement Agent
PR to PO Flow – Demonstrated on Fusion Instance
- View Budget Balances before starting the flow (so that impact may be analysed later)
- Requisition Creation
- Requisition Approval
- Create Accounting for the Requisition
- Requisition Accounting Explained
- Analyze impact of Requisition on Budget Balances
- Creation of Purchase Order from Purchase Requisition
- Approval of Purchase Order
- Create Accounting for the Purchase Order
- Purchase Order Accounting Explained
- Analyze impact of Purchase Order on Budget Balances
PO to Invoice Flow – Explained
- PO to Invoice Flow – Visually Explained
- Accrual Scenarios in Oracle Fusion Procure to Pay recapitulated
PO to Invoice Flow – Demonstrated on Fusion Instance
- Set up BCEA
- Set up TAD
- Other Procurement Setups
- Set up Purchase Order Approval Rules
- View Budget Balances before starting the flow (so that impact may be analysed later)
- Creation of Purchase Order
- Approval of Purchase Order
- Create Accounting for the Purchase Order
- Purchase Order Accounting Explained
- Analyze impact of Purchase Order on Budget Balances
- Create Payables Invoice by matching to Purchase Order
- Create Accounting for Payables Invoice
- Payables Invoice Accounting Explained
- Analyze impact of Payables Invoice on Budget Balances
Accrual at Receipt – PO to Receipt to Invoice Flow – Explained
- PO to Receipt to Invoice Flow – Visually Explained
- Accrual Scenarios in Oracle Fusion Procure to Pay recapitulated
- Security Roles and Data Access for Oracle Fusion Procurement recapitulated
- Accounting for Accrual at Receipt explained in depth for all stages of the P2P Cycle (including encumbrance accounting)
Accrual at Receipt – PO to Receipt to Invoice Flow – Demonstrated on Fusion Instance
- Set up BCEA
- Set up TAD
- Other Procurement Setups
- Set up Purchase Order Approval Rules
- Update Accounts Combinations
- View Budget Balances before starting the flow (so that impact may be analysed later)
- Creation of Purchase Order
- Approval of Purchase Order
- Create Accounting for the Purchase Order
- Purchase Order Accounting Explained
- Analyze impact of Receipt on Budget Balances
- Advanced Shipment Note Creation
- Receipt Creation
- Receipt Inspection
- Receipt Delivery into Inventory
- Create Accounting for Receipt
- Accounting for Receipt Explained
- Analyze impact of Purchase Order on Budget Balances
- Create Payables Invoice by matching to Purchase Order
- Create Accounting for Payables Invoice
- Payables Invoice Accounting Explained
- Analyze impact of Payables Invoice on Budget Balances
Accrual at Period End – Explained
- Concept of Accrual at Period End explained in detail
- Accrual at Period End – Scenarios / Examples
- Accrual Scenarios in Oracle Fusion Procure to Pay recapitulated
- Security Roles and Data Access for Oracle Fusion Procurement recapitulated
- Accounting for Accrual at Period End explained in depth for all stages of the P2P Cycle (including encumbrance accounting)
Accrual at Period End – PO to Receipt to Invoice Flow – Demonstrated on Fusion Instance
- Set up BCEA
- Set up TAD
- Other Procurement Setups
- Set up Purchase Order Approval Rules
- Update Accounts Combinations
- View Budget Balances before starting the flow (so that impact may be analysed later)
- Creation of Purchase Order
- Approval of Purchase Order
- Create Accounting for the Purchase Order
- Purchase Order Accounting Explained
- Analyze impact of Purchase Order on Budget Balances
- Receipt Creation
- Create Accounting for Receipt – Not Applicable
- Create Accrual Journals
- Review Accrual Journals
- Create Accrual Reversal Journals
- Post Accrual Reversal Journals
- Analyze impact of Accrual on Budget Balances
- Create Payables Invoice by matching to Purchase Order
- Create Accounting for Payables Invoice
- Payables Invoice Accounting Explained
- Analyze impact of Payables Invoice on Budget Balances
Pay on Receipt – Explained
- Concept of Pay on Receipt explained in detail
- Pay on Receipt – Scenario
- Security Roles and Data Access for Oracle Fusion Procurement recapitulated
- Important Points related to Pay on Receipt covered
Pay on Receipt Flow – Demonstrated on Fusion Instance
- Set up BCEA
- Set up TAD
- Other Procurement Setups
- Set up Purchase Order Approval Rules
- Update Accounts Combinations
- Configure Business Unit for Pay on Receipt Invoices and Debit Memos
- Configure Supplier Site for Pay on Receipt Invoices and Debit Memos
- View Budget Balances before starting the flow (so that impact may be analysed later)
- Creation of Purchase Order
- Approval of Purchase Order
- Advanced Shipment Note Creation
- Receipt Creation
- Receipt Inspection
- Receipt Delivery into Inventory
- Invoice Creation from Receipt
- Review AutoCreated Invoice
- Receipt Return
- Debit Memo Creation from Receipt Return
- Review AutoCreated Debit Memo
Invoice Encumbrance
- Concept of Invoice Encumbrance explained in detail
- Point at which funds are reserved on account of the Invoice in Oracle Fusion – demonstrated on the Fusion Instance
- Comparison of Invoice Encumbrance feature – Oracle Fusion vs Oracle E-Business Suite
- A Specific Requirement in Oracle Fusion regarding Invoice Encumbrance, and how to address it
Receivables Cloud
Creating Business Units
- Creating Business Units
- Business Unit Functions
- Business Unit Reference Data Sets
Receivables Setups
- Receivables System Options
- Receivables Activities
- Auto-Accounting
- Transaction Types
- Transaction Sources
- Remit to Addresses
Receivables Setups
- Banks, Branches, Bank Accounts
- Receipt Classes & Receipt Methods
- Receipt Sources
- …More AR Setups
AR Roles
- Understanding AR Roles
- Assigning Roles
- Assigning Data Access
Customers
- Pre-requisties
- Creating a Customer
- Creating Address
- Creating Address Purpose
- Sites & Reference Accounts
AR Invoices
- Opening First Period
- Creating Invoice
- Completing Invoice
- Invoice Accounting
Adjustments
- Setup Approval Limits
- Create an Adjustment
- Approve Adjustment
- Adjustment accounting
Credit Transactions
- Transaction Type
- Create a Credit Transaction
- Complete Credit Transaction
- Credit Transaction Accounting
- View from Original Transaction
- Unidentified Receipts
- Unapplied Receipts
- Applied Receipts
- On-Account Receipts
- Clearance Methods
- Accounting for above Stages
Customer Profile Classes
- Create a Customer Profile Class
- Assign Profile Class
- Modify Profile Class
- Verify Change of Attributes in Customers
- Account Level profiles
- Site Level Profiles
Multifund Account Receivables (MFAR)
- Concept and Explanation
- MFAR – Public Sector
- Receivables Accounting Flow – Explained
- Scenarios in MFAR
- Multifund Accounting Disabled
- Multifund Accounting Enabled
- Multifund Accounting Enabled – Multiple Revenue Lines
- Multifund Accounting Enabled – AR Receipt
- MFAR Setup
- Enable Feature
- Create SLAM
- Assign SLAM
- Effect of MFAR Demonstrated on Fusion Instance
Document Sequencing
- Concept and Explanation
- Flow of Document Sequencing for Receivables
- Types of Document Sequences
- Manual
- Automatic
- Gapless
- Sequencing Options — Oracle EBS R12 vs Oracle Fusion Cloud
- Setup for Receivables Document Sequencing
- Enable Sequencing
- Create Category
- Create Sequence
- Assign Category
- Verify Document Sequencing on Receivables Invoice
- Verify Document Sequencing on Receivables Receipt
- Important Points
Recurring Billing and Recurring Bill Plans
- Concept and Explanation
- Example / Use Case
- Flow of Recurring Billing
- Recurring Billing Frequencies available in Oracle Fusion Cloud
- Recurring Billing Scenario
- Setup for Recurring Billing
- Verify Invoices generated using Recurring Billing Plan
- Important Points
Receipts – Adjustments and Write Off
- Create a Receivable Activity
- Setup Approval Limits
- Document Sequences
- Enter Receipt and Apply to Invoice
- Perform Adjustment
- Perform Write Offs
- View Adj. and Write Off Accounting
- Create a Receivable Activity
- Create Transaction Type
- Setup Approval Limits
- Create Chargeback
- View Chargeback Accounting
- What is Reference Data Set
- Partitioning Data with RDS
- Sharing Data with RDS
- Create Reference Data Sets
- Assign Reference Data Sets
Advanced Collections Cloud
Fusion Advanced Collections Concept Explained
- Features in Fusion Advanced Collections Explained in Summary
Customer Structure and Collections Levels Explained
- Customer Structure in Oracle Fusion
- Collections Levels (Business Levels) Explained
- Available Collections Level in Fusion Advanced Collections
- Collections Levels (Business Levels) — Dunning Letters Example
- Collections Levels (Business Levels) — Different Levels for Different Customers
Collections Methods in Oracle Fusion Explained
- Collections Strategies Explained
- Dunning Plans Explained
Collections Scoring and Strategy Assignment Explained
- Meaning of Collections Scoring Formulas / Engines
- Collections Scoring Formulas in relation to Strategy Assignment
- Important Points related to Collections Scoring and Strategy Assignment
Dunning in Fusion Advanced Collections Explained
- Meaning and Significance of Dunning and Dunning Plans
- Meaning and Significance of Dunning Letters
- Collections Scoring Formulas in relation to Dunning Plans
- Types of Dunning
- Aged Dunning
- Staged Dunning
Customer Statements Explained
Collections Scoring Explained
- Meaning and Significance of Collections Score
- Collections Scoring Data Points Explained
- Collections Scoring Formulas (Engines) Explained
- Structure of a Collections Scoring Formula
- How a Collections Scoring Formula Works
- Collections Scoring Formula – Diagrammatic Explanation
Foundational Setups in Oracle Fusion Advanced Collections – Demonstrated on Fusion Instance
- Roles and Data Access for Receivables and Collections
- Creating and Assigning a Collector
- Setting up Collections Method
- Setting up Collections Level (Business Level)
Customer Scoring Flow in Oracle Fusion Advanced Collections – Demonstrated on Fusion Instance
- Reviewing Collections Scoring Data Points
- Creating a Custom Collections Scoring Formula
- Performing Collections Scoring
- Verifying Customer Score
Strategies Explained
- Meaning and Significance of Strategies, Strategy Tasks, Strategy Groups
- Relationship between Strategies, Strategy Tasks, and Strategy Groups
- How Strategy Assignment Works in Oracle Fusion
- Meaning and Significance of Lowest Applicable Score
Strategy Assignment Without Segmentation – Demonstrated on Fusion Instance
- Foundational Setups
- Creating Strategy Tasks
- Creating Strategies and Strategy Groups
- Creating Collections Scoring Formula
- Performing Collections Scoring
- View Assigned Strategy
- Verify Assigned Strategy Tasks
- Important Points related to Strategy Assignment
Segmentation Explained
- Strategy Assignment Methods in Oracle Fusion Advanced Collections
- Without Segmentation
- With Segmentation
- Meaning and Significance of Segments
- Basis of Segmentation
- Usage of Segmentation
- Segmentation in Oracle Fusion Advanced Collections — Scenario
Strategy Assignment With Segmentation (By Segment) – Demonstrated on Fusion Instance
- Foundational Setups
- Creating Strategy Tasks
- Creating Strategies and Strategy Groups
- Creating Collections Scoring Formula
- Creating Segments
- Creating Defaults
- Performing Collections Scoring
- View Assigned Strategy
- Verify Assigned Strategy Tasks
- Important Points related to Strategy Assignment by Segmentation
Dunning Explained
- Meaning and Significance of Dunning
- Meaning and Significance of Dunning Letters
- Types of Dunning
- Aged Dunning
- Staged Dunning
- Aged Dunning Explained
- Aging Methods Explained
- How Aged Dunning Works
- Staged Dunning Explained
- Dunning Stage Explained
- How Staged Dunning Works
- Dunning – Notable Points
End-to-End Aged and Staged Dunning Flows – Demonstrated on Fusion Instance
- Foundational Setups
- Define Dunning Plans
- Configuring Dunning Email Components
- Configuring Customer for receiving Dunning Letters
- Creating Delinquencies
- Viewing Delinquent Transactions
- Sending an Aged Dunning Letter
- Viewing the Aged Dunning Letter from the Customer Contact Inbox
- Sending a Staged Dunning Letter
- Viewing the Staged Dunning Letter from the Customer Contact Inbox
- Important Points relating to Dunning
Transaction Level Strategy Management – Explained
- Meaning of Transaction Level Strategy Management
- Transaction Level Tasks Vs. Regular Tasks
- Transaction Level Strategy and Strategy Group
- How Transaction Level Strategy Assignment is triggered
- Transaction Level Strategy Assignment – Scenario
Transaction Level Strategy Assignment – Demonstrated on Fusion Instance
- Foundational Setups
- Dunning Related Setups for sending Dunning Letters as part of Transaction Level Strategy Management
- Creating Transaction Level Strategy Assignment Setups
- Performing Transaction Level Strategy Assignment
- View Strategy Tasks assigned to Transactions
- Important Points related to Transaction Level Strategy Management
Dispute to Credit Memo Flow – Explained
- Meaning and Examples of Dispute
- Significance of Credit Memo in Disputes
- How a Credit Memo is auto-generated from a Dispute – Step-by-Step Explanation
Dispute to Credit Memo Flow – Demonstrated on Fusion Instance
- Foundational Steps
- Setting up Approval Rules
- Configuring Dispute Confirmation Letter Template
- Configuring Customer to receive Dispute Notice
- Managing Dispute Types
- Managing Dispute Reasons
- Creating Delinquencies
- Reviewing Delinquent Transactions
- Creating Dispute
- Auto-Creating Credit Memo
- View Auto-Created Credit Memo
- Credit and Rebill Scenario
Customer Bankruptcy – Explained
- Concept
- Effect of Customer Bankruptcy in Oracle Fusion
- How Customer Bankruptcy occurs in Oracle Fusion – Step-by-Step Explanation
Customer Bankruptcy Flow – Demonstrated on Fusion Instance
- Foundational Setups
- Enabling the Bankruptcy Feature
- Configuring Approval Rules
- Bankruptcy Status not updated – how to troubleshoot
- Managing Bankruptcy Reasons
- Configuring Bankruptcy DFFs
- Requesting Bankruptcy
- Approving Bankruptcy
- Updating the Collections Dashboard
- View Updated Customer Status
- Invoice Write-Off Scenario — how to Perform
Customer Statements – Explained
- Concept of Customer Statements
- Scope of Customer Statements
- Statement Cycles
- Statement Delivery Types
Customer Statements Flow – Demonstrated on Fusion Instance
- Foundational Setups
- Creating Statement Cycle
- Creating Aging Method
- Configuring Customer for Receiving Statements
- Managing Messages for Customer Statements
- Sending Customer Statements
- Reviewing Customer Statements from the Customer Contact Inbox
- Consolidated vs Separate Customer Statements — Scenario and Explanation
- How to implement Consolidated Customer Statements
Assets Cloud
Asset Key Flexfields
- Asset Category Flexfield
- Asset Key Flexfield
- Asset Location Flexfield
Setting up Flexfields
- Creating Assets Value Sets
- Creating Flexfield Structures
- Creating Flexfield Structure Instances
- Deploying Flexfields
Assets Setups
- System Controls
- Fiscal Years
- Calendars
- Pro-rate Conventions
- Depreciation Methods
- Asset Books
- Category Combinations
- Key Combinations
- Location Combinations
- …More Asset Setups
Assets Roles
- Generating Roles
- Understanding FA Roles
- Assigning Roles
- Assigning Data Access
Assets Setup Validation
- Open First Period
- Add an Asset
- Calculate Depreciation
- Asset Accounting
Amortisation
- What is Amortisation
- Amortised Adjustments
- Expensed Adjustments
- What is Cost Adjustment
- Enter Amortised Cost Adjustment
- Depreciation and Accounting
- Enter Expensed Cost Adjustment
- Depreciation and Accounting
Procuring Assets from Payables
- Payables to Assets Cycle
- Enter Invoice of Asset Purchase
- Invoice Accounting
- Create Mass Additions
- Prepare Mass Additions
- Creating new Asset
- Adding cost to existing Asset
- Post Mass Additions
- Find newly created Assets
- Depreciation
- Asset Accounting
Asset Revaluation
- Setup Revaluation Options
- Setup Revaluation Accounts
- Initiate Revaluation
- Preview Revaluation
- Run Revaluation
- Revaluation Status
- Run Depreciation and Accounting
- Revaluation Accounting
Asset Transfer
- Asset Assignments
- Employee, Expense A/c and Location
- Transfer between employees
- Transfer between Locations
- Transfer – Balancing Segment Value
- Transfer – Cost Centre
- Transfer – Other Segment Values
- Depreciation and Accounting
- Transfer of Costs and Dep Reserve
- Inter-company Accounting
Asset Reclassification
- Changing Asset Category
- Asset Category Defaults
- Depreciation Methods for Categories
- Initiate Reclassification
- Preview Reclassification
- Reclassification Accounting
Asset Retirement
- Setup Retirement Options
- Setup Retirement Accounts
- Partial Vs Full Retirement
- Setup Cost of Removal A/c
- Setup Distribution Set
- Initiate Retirement
- View Retirement
- Prepare Retirement
- Post Retirement
- Depreciation and Create Accounting
- View Retirement Accounting
- Related AR and AP Accounting
Asset Reinstatement
- What is Reinstatement
- Perform Reinstatement
- Depreciation and Create Accounting
- View Reinstatement Accounting
- Reinstatement Limitations
Tax Books
- Tax Books and Corporate Books
- Create a Tax Book
- Associate Tax Book with Corporate Book
- Accounting for Tax Books
- Set up Categories for Tax Books
Roles for Tax Books
- Understand Roles for Tax Books
- Access Oracle Identity Manager
- Access Users in OIM
- Assign Roles
Copy from Corporate to Tax Book
- Corporate Book Periods
- Tax Book Periods
- Copying Assets from Corp to Tax Book
- Depreciation Methods for Tax Book
- Accounting for Corporate and Tax Books
- Periodic Copy Cycle
Cash Management Cloud
Cash Management
- Cash Management Setups
- Banks, Branches & Bank Accounts
- Creating Bank
- Transaction Codes
- Entering Bank Statements
- Entering Bank Statement Lines
- Entering Receipts and Payments
- …More CM Setups
Manual Reconciliation
- Match Receipts
- Match Payments
Auto Reconciliation
- Enter Bank Statements, Lines
- Enter Receipts, Payments
- Setup Matching Rules
- Run Auto Reconciliation
- Validate Unreconciled Items
Reference Data Sets
- Concept
- Sharing/Partitioning Data
- Creating Reference Data Sets
- Assigning Reference Data Sets
- Data Elements & Reference data Sets
Cash Positioning
- What is Cash Positioning
- Fusion Vs EBS Functionality
- Payment Documents
- Receipt Class and Payment Methods
- Bank Statements
- Intraday Bank Statements
- Cash Position Data Processes
- View Cash Position
- Creating Payees
- Ad Hoc Payment Approval Rules
- Creating Ad Hoc Payments
- Creating Manual Transactions
- Bank Account Groups
- View Cash Position
Fusion Tax Cloud
Roles
- Understand Roles for Tax
- Access Oracle Identity Manager
- Access Users in OIM
- Assign Roles
Tax Model
- Tax for the Country
- Different States have different Tax Rates
- Item Specific Taxation
- Customer/Supplier Specific taxation
- Tax Recovery
Tax Regimes
- Create a Tax Regime
- Assign Applicable Legal Entities, BUs
Taxes
- Create a Tax
- Setup Tax Point Basis
- Set Exceptions/Exemptions Applicability
- Set Recovery Options
- Set Tax Accounts
Tax Statuses
- Create a Tax Status
- Set Exceptions/Exemptions Applicability
Tax Jurisdictions
- Create a Tax Jurisdiction
- Specify Tax Accounts
- Specify Tax Rates
- Tax Accounts for Tax Rate Periods
Tax Rates and Recovery Rates
- What is Tax Recovery
- Create a Tax Rate
- Create a Tax Recovery Rate
Tax Rules
- Create Tax Applicability Rule
- Create Place of Supply Rule
- Create Taxable Basis Rule
- Create Tax Calculation Rules
Verify Tax Application
- Enter a Receivable Invoice
- Save Invoice and Verify Applied Tax
- Enter a Payables Invoice
- Save and Validate Invoice
- Verify Tax Applied to Payables Invoice
- Verify Tax Accounting
Approvals Management
Approval Configuration Tasks
- BPM Worklist
- Payables Invoice
- Journals
- Intercompany
- Expense Reports
Assignees and Participants
- What is a Participant Box
- Enabling a Participant
- Approval Stages
- Approval Participants
- Serial and Parallel Participants
How Approval Config Works
- How to create Approval Configuration
- Functionality around Participant Box
- At Par and Lower Level Participants
- Serial and Parallel Participants
Approval Types
- Supervisory
- Job Level
- Position
- Approval Groups
- Resource
- Management Chain
Attributes, Conditions & Rules
- Header Level
- Line Level
- Creating Approval Rules
Testing Approval Trx Flow
- Enable Payables Invoice Approval
- Entering Invoice
- Submitting for Approval
- Approval Notification
- Approver Actions and Approval
- Invoice Approval Status
Approval Transaction Flow
- Enable Payables Invoice Approval
- Entering Invoice
- Submitting for Approval
- Approval Notification
- Approver Actions and Approval
- Invoice Approval Status
Parallel Approvals
- Participant Boxes
- Approvals in same Participant Box
- Approvals across Participant Boxes
- Parallel in Supervisory
- Parallel in Approval Groups
AMX List Builder Types
- List Builder Concept
- Types of List Builders
- Approval Groups
- Supervisory Approval
- Job Level Approval
- Position Approval
- Resource
- How “Participant Type” affects Approval Routing
- Each Type of List Builder explained
AMX Transactions
- Transactions Supported in AMX
- Journals
- Payables Invoice
- Intercompany Transactions
- Expense Reports
- Payables Payments
- BPM Worklist task to use, to configure each type of transaction for Approval
- From where to submit each type of Transaction for Approval
- How to approve each type of Transaction
AMX Rules, Rule Sets, and Conditions
- Roles required for AMX
- Relationship between Participant, Rule, Rule Set, Condition and Attribute
- How AMX Rules are evaluated
- Configuring Approval Rules in AMX
- How to configure the “IF” Conditions
- Examples of Attributes in a Condition
- Examples of Conditions in Approval Rules
- Example of Overlapping Conditions
Reminder Notifications
- Reminder Options
Auto Approval & Auto Rejection
- Auto Approval Rules
- Auto Rejection Rules
Applicability of Rules
- When Rules Overlap
- When none of the Rules apply
FYI Notifications
- Setting up FYI Rules
- Generating FYI Notifications
- Transaction Flow
Intercompany
Intercompany Basic Transactions
- Prerequisite Concepts
- Balancing Segment Values (BSVs)
- Legal Entities
- Ledgers
- Intercompany Accounting:
- Traditional Accounting
- Accounting in Oracle Fusion
- Intercompany Concepts
- Intercompany Segment – Explained
- Types of Intercompany Transactions
- Examples of Intercompany Transactions
- Intercompany Setups
- Assigning BSVs
- Creating Intercompany Balancing Rules
- Enabling Intercompany
- Intercompany Transactions – Demonstrated on Fusion Instance
- GL Journal
- AP Invoice
- AR Invoice
Intercompany – Clearing Company
- Concept of Clearing Company
- Examples of Transactions involving Clearing Company
- Clearing Company in Intracompany Transactions
- Clearing Company in Intercompany Transactions
- Intercompany Basic Setup
- Clearing Company Setup
- Verification of Accounting using Clearing Company – Demonstrated on Fusion Instance using GL Journal
Rapid Implementation
Rapid Implementation – Introduction
- Understanding Rapid Implementation
- Frequently Asked Questions
- How RI creates Rapid Setups
Configurations for Rapid Implementation
- Prepare for Rapid Implementation
- Configure MS Excel
ADF-DI for Rapid Implementation
- Download ADF-DI – How To
- Install ADF-DI – How To
- Configure MS Excel
- Relevance and Usage for Rapid Setups
How to Download RI Spreadsheets
- Download Various Spreadsheets for Rapid Setups
- Understanding Structure / Usage of each Spreadsheet
How to Populate RI Spreadsheets
- Populating CoA Values
- Populating Hierarchies
- Populating Legal Entities
- Populating Ledgers
- Populating Account Sequences
- . . . and a lot more
How to Auto-Create Rapid Setups
- Uploading Rapid Setups
- Importing Rapid Setups
- Verifying Rapid Setups
Rapid Setups – Chart of Accounts
- Auto-Create Chart of Accounts Value Sets
- Auto-Create Chart of Accounts Values
- Auto-Create Account Hierarchies
- Auto-Deploy GL Accounting Flexfield
Rapid Setups – Legal Entities
- Auto-Create Legal Entities
- Auto-Assign Balancing Segment Values
- Auto-Configure Legal Entity Assignments
- Auto-Configure Legal Entity Registrations
Rapid Setups – General Ledger
- Auto-Create Accounting Calendars
- Auto-Create Ledgers
- Auto-Configure Ledger Options
- Auto-Create Accounting Configurations
Rapid Setups – Business Units
- Auto-Create Business Units
- Auto-Configure Business Functions
- Auto-Configure Set Assignments
Rapid Setups – Accounts Payables
- Auto-Configure Common Options
- Auto-Configure Invoice Options
- Auto-Configure Payment Options
Rapid Setups – Accounts Receivables
- Auto-Configure System Options
- Auto-Configure Accounting Rules
Rapid Setups – Cash Management
- Auto-Create Banks
- Auto-Create Bank Branches
- Auto-Create Bank Accounts
Rapid Setups – Fixed Assets
- Auto-Create Category Values
- Auto-Create Location Values
- Auto-Create Key Values
- Auto-Create Category Combinations
- Auto-Create Location Combinations
- Auto-Create Key Combinations
- . . . and a lot more
Fusion Tools
FBDI (File Based Data Import)
File Based Data Import
- OER – Oracle Enterprise Repository
- UCM – Universal
- Content Manager
- Downloading Template
- Entering Data in Template
- Generating CSV and ZIP files
- Uploading Data to UCM
- Upload UCM Data to Interface Table
- Importing Data
- One example demo end-to-end
Hyperion Smartview
Hyperion Smartview
- Setting up Browser
- Downloading Smartview
- Installing Smartview
- Configuring Smartview
- Configuring MS Excel
- Logging into Smartview
SmartView Reports/Analysis
- Point of View
- Excel View
- Drag Drop Methods
- Ad hoc Reporting
SmartView Example
- Create a Sample Analysis
- (One example demo end-to-end)
Hyperion Financial Reporting Studio
Hyperion Financial Reporting Studio (HFRS)
- Setting up Browser
- Downloading HFRS
- Installing HFRS
- Configuring HFRS
- Logging into HFRS
HFRS Reports/Analysis
- Creating Database Connection
- Dimensions Layout
- Point of View
- Setting up Dimension Layout
- Setting up Grid Object Values
- Setting up POV Object Values
- Preview Report
- Publish report
- One example demo end-to-end
OTBI
Oracle Transactional Business Intelligence
- Report Catalogues
- Browsing Catalogues
- Shared Folders
- Subject Areas
OTBI Reports/Analysis
- Selecting Subject Area
- Selecting Report
- Columns
- Report Layout
- Report Filters
- Report Prompts
- Preview and Publish Reports
OTBI Reports/Analysis
- Preview and Publish Reports
- One example demo end-to-end
ADF-DI
ADF Desktop Interator
- Download Integrator
- Install ADF-DI
- Configure MS Excel
ADF-DI Uploads
- Download Spreadsheet Template
(E.g. Journals, AP Invoices, AR Invoices, Asset Addition etc) - Enter data in Template
- Validate Data
- Upload Data
ADF-DI Upload Journals
- Download Journals Template
- Enter Journal Lines in Excel
- Submit Upload from Excel
- Verify Uploaded Journal in Fusion
- One example demo end-to-end
Oracle Fusion Accounting Hub Cloud (FAH)
Concept, Example and Setting Up AHC
- What is Accounting Hub
- How Subledger Accounting works
- Subledger Accounting Structure
- Example
- Prerequisites
- Role creation and assignment
- Setting Up Application
- Setting Up Event Classes
- Setting Up Event Types
SLA Structure for External Application
- SLA Structure for the Application
- Create Accounting Classes
- Create Accounting Rules
- Create Journal Line Rule
- Create Journal Rule Set
- Associate Rules to Rule Set
- Accounting Method
- Assign Journal Rule Set to SLAM
- Assign Rule Set
- Activate Rule Set
- Subledger Accounting Options
- Accounting Options
- System Options
- Run Processes
Importing Transactions and Create Accounting
- Prerequisite
- Download required files
- Populate Data
- Required Setups
- Importing Transactions
- View Accounting
Description Rules, SLA Structure and Sources, Attributes etc
- Sources and Transaction Objects
- Sources
- Transaction Objects
- Understanding Seeded Apps
- SLA Structure
- Conditions
- Description Rules
- Mapping Sets
- Create New
- Application
- Event Class
- Event Type
- SLA Structure
- Conditions
- Description Rules
- Mapping Sets
- Import Transactions
- Create Accounting
- Verify Results
Accounting in Multiple Ledgers etc
- Accounting in multiple ledgers
- Accounting Methods
- Create Account Rules
- Create Journal Lines
- Assign Journal Rules
- Assign to SLAM
- Roles and Data Access
- Prepare Transactions
- Import Transactions
- View SLA Journals
Mapping Sets etc
- Example
- Create Value Sets
- Create Value Set Values
- Create Mapping Sets
- Assign Mapping Sets to Segment Rule
- Create Segment Rules
- Assign Account Rule to Journal Line
- Activate Rule Set Assignment
- Prepare Transactions
- Import Transactions
- View Accounting
Event Types and Adding Tables, Columns etc
- Concept: Event Types
- Create Event Types
- Examples of Event Types
- Accounting and SLA Structure
- Adding more columns to application tables
- Manually adding more columns
- Importing SLA Structure Components
Oracle Revenue Management Cloud (RMCS)
- Overview of Revenue Management
- ASC 606 and IFRS 15: Revenue Principles
- Applicability of new standards
- What has changed over typical way of revenue recognition
- Understanding of performance obligations
- The five key steps to revenue recognition
- Implementation Lifecycle
- Common Best Practices
- Overview
- Define revenue scheduling rules and performance satisfaction plans
- Define revenue scheduling rules and performance satisfaction plans
- Define source document types
- Revenue Management system options
- Implementation decision points
- Define revenue contracts with customer overview
- Define contract identification rules
- Define performance obligation identification rules
- Define performance obligation templates
- Define implied performance obligation templates
- Standard selling price overview
- Pricing dimension overview
- Pricing dimension structure overview
- Define price bands
- Overview
- Inbound integration with ETL
- Integrating with EBS
- Integrating with Receivables
- Integrating with Order Management and Supply Chain
- Integrating with 3rd party systems
- Outbound integration: Journals
- Overview
- Revenue Management Process Flow
Oracle PPM Cloud
- Create implementation user
- Creating Business Unit
- Business Unit Business Function
- Project Unit Organizations
- Organization Trees
- Organization Hierarchies and Classifications
- Project Organizations
- Project Accounting Business Function
- Project Unit Options
- Project Unit Set Assignment
- Units of Measure
- Project Status
- Project Class Categories
- Project Types
- PPM Roles
- Project Plan Types
- Project Template
- Revenue Categories
- Expenditure Categories
- Expenditure Types
- Planning and Billing Resource Breakdown Structures
- Labor Costing Rules
- Labor Costing Multipliers
- Burden Cost Codes
- Burden Cost Bases
- Burden Structures
- Burden Schedules
- Organization Costing Rules
- Service Types
- Work Types
- Capitalized Interest Rates
- Capitalized Interest Rate Schedules
- Nonlabor Resources
- Rate Schedules
- Mapping Sets
- Journal Line Rule
- Accounting Rule
- Journal Entry Rule Set
- Accounting Method Assignment
- Contract Line Types
- Contract Type
- Project Contract Business Unit
- Event Type
- Billing Cycle
- Invoice Format
- Revenue Method
- Invoice Method
- Specify Unit of Measure for Invoice Lines
- Synchronize Users
- Default Contract Business Unit
- Resource Organization
- Identify Resource
- Derive Billable from Work Type
- Derive Work Type for Project Expenditures
- Business Unit Set Assignment
- Transaction Sources
- Define Job
- Manage Task Descriptive Flexfield
Issue Types and Deliverable Types
- Understand what are Issue Types and Deliverable Types conceptually
- Create Issue Types from Setup and Maintenance
- Create Deliverable Types from Setup and Maintenance
- Create issue types as a Project Manager and Add Action Items
- Check the New Activity as a Team Member
- Edit Issue and Action Items and Close the Issue as a Team Member
- Add Deliverables to your Project
Project Gates
- Understand Project Gates conceptually
- Create a Project
- Add Gates
- Add tasks to the Project under the Gates
- Add Resources to the Project
- Assign Approvers to the Gates
- Approve Project Gates
- Flip Project Gate Status to “Open”
Oracle Social Network
- Understand what is Oracle Social Network conceptually
- Enable Oracle Social Networking Objects for Project Execution Management
- Share your Project in Oracle Social Network
- Add members to the Project in Oracle Social Network
- Send and Receive Messages within your Project Members
Enterprise Project Structures and Labor Demand
- Add elements in Enterprise Project Structure
- Configure Project Hierarchy
- Create Project Labor Request
- Search and Evaluate Resources
- Review Labor Demand
Talent Profile Content
- Understand what is Talent Profile Content conceptually
- Configure Profile Rating Model
- Rating Levels
- Review Points
- Configure Educational Establishments
- Configure Content Types
- Configure Content Items
- Add Requirements to Project Roles
- See the Requirements in Project Resource Requests
Resource Pools and Project Enterprise Resources
- Understand Project Resource Pools conceptually
- Understand Project Enterprise Resources conceptually
- Create Resource Pools
- Create Hierarchy of Resource Pools
- Create Project Enterprise Resources
- Assign Members to Resource Pools
- Move Resources from One Resource Pool to another
Project Integration with
- Financials
- SCM
- HCM
- OTBI Reports
- FBDI Process
Oracle SCM Cloud
Procurement and Inventory
- Create Location for Inventory Org
- Create Facility Shifts
- Create Facility Workday Pattern
- Create Facility Schedules
- Create Item/Master Inventory Organization
- Catalog and category
- Default category
- Create Inventory Organizations
- Create Sub-Inventory & Locators
- Define UOM
- Manage Business Unit Business Unit Business Functions
- Procurement Business Function
- Requisitioning Business Function
- Receiving Parameters
- Common Options
- Create Requisition DFF
- Define Requisition Value Sets
- Define Buyer assignment rule sets lookup
- Create Buyer assignment rules
- Roles for Procurement
- Assigning Roles to User
- Running LDAP Job
- Manage Procurement Agent
- Procurement Document Numbering
- Manage Line Types
- Manage Document Styles
- Create Purchasing Value Sets
- Define Purchasing
- Descriptive Flexfields (DFFs)
- Create Supplier
- Create Supplier Address
- Create Supplier Site
- Assign Supplier Site to Procurement BU
- Create Payment Terms
- Define Units of Measure
- Create FOB Lookup
- Create Freight terms lookup
- Setup Purchasing Profile Options
- Create Document Styles
- Setting up Item Profile Options
- Receiving descriptive flexfield
- Manage Item Classes
- Create Item
- Assign Items to Inventory Organization
- Operational attribute group
- Templates
- Item import – FBDI
- Serial control
- Lot number
- Setting up Supplier Number
Defining Supplier Type Lookup
Creating Lookup for Tax Organization Type
Defining Supplier Value sets
Creating Supplier Descriptive Flexfields
- Approval Groups for Procurement
- Implementation of Requisition Approvals
- Implementation of Purchasing Document Approvals
- Manage Mapping Sets
- Create Account Rules for Accrual Account
- Create Account Rules for Charge Account
- Create Account Rules for Variance Account
- Manage Transaction Account Definitions
- Assign Purchase Transaction Account
- Definitions to Subledger Accounting Options
- Prepare Transaction Upload Template
- Generate ZIP file
- Load ZIP file in ERP Cloud UCM
- Submit accounting process
- Review Journals in Subledger
- Review Journals in General Ledger
- Drill down from GL to Subledger
- Invoice Creation Based on Receipt
- Invoice Accounting
- Payment creation
- Payment Accounting
- Running Standard Reports
- Running BI Reports
- Supplier Import FBDI
- Master Item Creation Process
- Receipt Creation Process
- Receipt Routings
- Receipt Put Away
- Conducting Inspection & Delivery of Materials
- Checking On hand Availability
- Movement Orders
- Sub-Inventory Transfers
- Inter org transfer & Setting up parameters
- Manage Inter Organization Transfer
- Purchase Returns
- Creating Miscellaneous Receipts
- Creating Unordered Receipt
- Creating Blind Receipts/Receiving
- Review Completed Transactions
- Physical Count
- Cycle Count
Supplier Qualification Management (SQM)
Introduction to SQM
- Fusion Interface Basics
- Prerequisites for SQM:
- Roles
- Offerings
- Procurement Agents
- Concept and Flow of SQM
Questionnaires
- Creating Questions with several variations
Qualification Areas
- Create Qualification Area
- Set Up Scoring
- Set Up Automatic Requalification
- Add Questions in the Qualification Area
- Understand Knockouts
Qualification Model
- Create Qualification Area and understand the Possible Variations
- Add Qualification Areas
- Set Up Qualification Model Outcomes
Assessment Initiative
- Understand Initiative Types
- Create Initiative and Questionnaire
- Add Suppliers in the Initiative
- Preview the Initiative
Response and Evaluation
- Receive and Enter Responses from Suppliers
- Evaluate the Responses
- Verify Automatic and Manual Scoring
- Review the Initiative Outcome
Prerequisites
- Add Necessary Roles
- Configure Contract Management Business Functions
- Create Contract Type
- Configure Electronic Signature
- Configure Clause Types
- Setup Contract Clause Import File Location
Terms Library
You will learn the create the following in Terms Library:
- Clause
- Section
- Terms Template
- Question
- Rule
- Constant / Variable
- Folder
- Numbering Scheme
Create Contracts
- Create a Contract
- Duplicate Contract
- Amend Contract
Oracle Order Management Cloud
- Upstream and Fulfillment Source Systems
- Collect Order Reference Data
- Manage Order Profiles
- OM parameters
- Important Lookups
- Setup Order Extensible Flexfields
- Setup Holds
- Processing Constraints
- Setup Drop Ship Financial Flows
- Define Orchestration Process
- Create Orchestration Process Assignment Rules
- Pre Transformation Rules
- Product Transformation Rules
- Post Transformation Rules
- Configure Order Approval Rules
- Setting up Price Lists
- Customer Pricing Profiles
- Setup Pricing Segments
- Create Pricing Strategies
- Configure Pricing Strategy Assignments
- Create Shipping Charge List
- Service Mappings and Algorithms
- Shipping Document Sequence Categories
- Shipping Document Sequences
- Pick Release Sequence Rules
- Ship Confirm Rules
- Define Shipping Parameters
- Create Pick Wave Release Rules
- Approval Groups for Procurement
- Implementation of Requisition Approvals
- Implementation of Purchasing Document Approvals
- GOP Setup: ATP and sourcing rule
- Refresh GOP Server
- Navigation, Key Terminologies and Order Entry
- Approve Orders
- Apply and Release Holds
Fulfilling Order
Standard Shipment
- Reserve
- Pick
- Ship
- Invoice
Drop Ship
- Schedule
- Create PO
- Invoice
Back to Back
- Schedule
- Create PO / WO
- Pick
- Ship
- Invoice
- Credit Only
- Receive Only
- Receive and Credit Both