1. Advanced General Ledger (GL)

• Multi-Org Architecture (MOAC) and Ledger Sets
• Advanced Journal Processing (recurring, allocation, intercompany)
• Consolidation & Translation (Multiple Reporting Currencies)
• Advanced Reconciliation Tools (AGIS – Advanced Global Intercompany System)
• SLA (Subledger Accounting) – Setup & Customization
• Advanced Financial Reporting (FSG / Smart View / BI Publisher)

2. Advanced Accounts Payables (AP)

• Invoice Approval Workflows and Holds Management
• Prepayments, Advance Payments, Retentions
• Withholding Tax, Tax Configurations, and Multi-Currency Payments
• Payment Process Requests (PPR) – Advanced Setup and Troubleshooting
• Supplier Portal (iSupplier) Integration with AP
• Accruals Reconciliation and Period-End Processing

3. Advanced Accounts Receivables (AR)

• Customer Creation and Hierarchy Management
• Advanced Invoicing and Credit Memo Scenarios
• Lockbox, AutoInvoice, and AutoCash Rules
• Revenue Recognition Rules and Deferred Revenue Management
• AR/AP Netting and Customer Refunds
• Collection Strategies and Dunning Letters
• Period-End and Reconciliation Best Practices

4. Advanced Fixed Assets (FA)

• Asset Categories and Hierarchies
• Complex Depreciation Methods and Prorate Conventions
• Revaluations, Impairments, and Asset Transfers
• CIP (Capital Projects) to Asset Conversion
• Mass Additions (Integration with Payables/Projects)
• Retirements and Disposal Accounting
• FA and GL Reconciliation

5. Cash Management & Treasury

• Advanced Bank Reconciliation – Auto vs. Manual
• Cash Forecasting and Positioning
• Bank Statement Loader & Reconciliation Reports
• Payment Format Integrations with Banks (MT940, BAI2)
• Treasury Integrations with Payables & Receivables

6. Advanced Tax & Compliance

• E-Business Tax (EBTax) Advanced Setup
• Multi-jurisdiction and Multi-Currency Tax Rules
• Integration with Payables and Receivables
• Localization Features (India GST, GCC VAT, etc.)
• Compliance and Audit Controls (CCM, SOX Readiness)

7. Integration with Other Modules

• Finance-SCM Integration (Procure-to-Pay & Order-to-Cash Cycles)
• Integration with Projects (Capital Projects & Revenue Projects)
• Payroll & HRMS Interfaces with Finance
• Period Closing and Reconciliation Across Subledgers

8. Reporting & Analytics

• Financial Statement Generator (FSG) Advanced Features
• Oracle Business Intelligence (OBIEE / BI Publisher) for Finance
• Subledger Accounting (SLA) Queries and Custom Reports
• Drill-Down Reports for Audit & Compliance
• Financial Command Center (ECC Dashboards)

9. Period-End & Year-End Activities

• Month-End Close Checklists for AP, AR, GL, FA, CM
• Year-End Adjustments and Reconciliation
• Cross-Ledger and Cross-Module Balancing
• Best Practices in Close Management

10. Troubleshooting & Best Practices

• Common Errors in Finance Modules and Resolutions
• Reconciliation Tools for Audit Readiness
• Performance Tuning in Large Finance Instances
• Best Practices for Security, Access Controls & Segregation of Duties

Who can join this course?

• Minimum 3–5 years of technical experience in one or more of the following: Account or Finance Professional
• Basic proficiency in Finance Operations or business workflows.
• Willingness to shift from domain operations to ERP consulting roles.

Prerequisites

Familiarity with Financial processes:

• Procure-to-Pay (P2P)
• Order-to-Cash (O2C)
• Record-to-Report (R2R)

Basic exposure to:

• General Ledger (GL)
• Accounts Payable (AP)
• Accounts Receivable (AR)
• Cash Management
• Fixed Assets

Outcomes After Training

• Ability to analyze and map business processes to Oracle ERP.
• Capability to configure and test ERP solutions.
• Hands-on experience in functional flows and data migration tools.
• Exposure to integration and reporting tools.
• Oracle ERP Implementation Readiness in your domain.
• Resume strong enough to target ERP Functional Consultant or Associate Consultant roles