Current Status
Not Enrolled
Enroll in this course to get access
Price
Included with OEG One
Get Started
Course Duration: 30 Sessions * 1.5 hours = 45 Hours
| Agenda |
|---|
| Phase 1: Foundation and Application Setup |
| Introduction to FCCS |
| What consolidation means and why groups consolidate |
| Currency and intercompany challenges |
| Overview of Oracle FCCS |
| End-to-end consolidation data flow |
| Consolidation Concepts |
| Control versus ownership |
| Subsidiary, proportional and equity methods |
| Non-controlling interest |
| Types of eliminations |
| Local GAAP versus Group GAAP |
| Creating an FCCS Application |
| Application creation wizard |
| Fiscal year, period and calendar setup |
| Main currency configuration |
| Ownership Management, Multi-GAAP, Extended Dimensionality and Journals |
| Irreversible application design decisions |
| FCCS Navigation and Data Flow Model |
| Home page, cards and clusters |
| Navigator menu |
| Point of View (POV) bar |
| FCCS data flow from input to consolidated results |
| Phase 2: Application Structure, Metadata and Integration |
| Standard Dimensions – Part 1 |
| Account, Entity, Scenario, Year, Period and View dimensions |
| Hierarchies, parent and base members |
| Account types and behavior |
| Standard Dimensions – Part 2 & Custom Dimensions |
| Currency, Consolidation, Data Source, Intercompany, Movement and Multi-GAAP |
| Seeded members and their purpose |
| Creating and using custom dimensions |
| Ownership Management, Member Properties, Formulas and Solve Order |
| Ownership, consolidation and minority percentages |
| Ownership by period |
| Storage, time balance and exchange rate properties |
| Member formulas and solve order |
| Data Integration and Data Exchange |
| Data Exchange setup |
| File-based integrations |
| Import formats and period mapping |
| Source-to-target mapping |
| Scheduling integrations and drill-through |
| Metadata Management – Part 1 |
| Dimension editor |
| Adding, editing and moving members |
| Assigning member properties |
| Importing and exporting metadata |
| Validation messages |
| Metadata Management – Part 2 |
| Bulk metadata loads |
| Alias tables and attributes |
| Resolving validation errors |
| Database refresh and impact |
| EPM Automate |
| Installation and authentication |
| Backup, import, export and refresh commands |
| Task scheduling and automation |
| When to use automation over UI |
| Phase 3: Data, Forms and Reporting Structures |
| Data Load Methods |
| Load file formats |
| Loading trial balances |
| Load rules and options |
| Error logs |
| Clearing and reloading data |
| Smart View for FCCS |
| Installation and connection |
| Ad hoc analysis |
| POV control and member selection |
| Retrieve and submit data |
| Reusable templates |
| Data Forms and Manual Entry |
| Form design and layout |
| Rows, columns and POV |
| Form folders and access |
| Data entry and calculations |
| Substitution variables |
| Seeded Data Forms, Calculation Status and Node Status |
| Seeded forms |
| Calculation status indicators |
| Node status |
| Status changes |
| Alternate Hierarchy |
| Purpose of alternate hierarchies |
| Shared members |
| Reporting hierarchies |
| Aggregation behavior and pitfalls |
| Phase 4: Consolidation Engine |
| Consolidation Journals |
| Journal purpose and types |
| Create, submit, approve and post journals |
| Reversal and auto-reversal |
| Journal verification in Smart View |
| Intercompany Transactions, Eliminations and Plug Accounts |
| Intercompany setup |
| Trading partners |
| Eliminations |
| Plug accounts |
| Matching reports |
| Currency Conversion |
| Average, ending and historical rates |
| Rate maintenance |
| Exchange rate types |
| Translated data layer |
| Override Translation and CTA |
| Historical rate override |
| Amount override |
| Cumulative Translation Adjustment (CTA) |
| Balance sheet validation |
| Consolidation Process with Seeded Rules |
| Consolidation execution flow |
| Consolidation dimension stages |
| Seeded rules and sequence |
| Consolidation Process with Ownership Management |
| Ownership percentages |
| Consolidation methods |
| Non-controlling interest |
| Multi-level ownership |
| Valid Intersection and Custom Navigation Flow |
| Valid intersection rules |
| Preventing invalid data combinations |
| Custom navigation flows |
| Cards and clusters |
| Equity Method and Equity Pickup |
| Equity method |
| Equity pickup process |
| Investment carrying value |
| EPU troubleshooting |
| Phase 5: Security, Close and Governance |
| Security and Access Control |
| Predefined roles |
| Dimension and form security |
| Users and groups |
| Cell-level security |
| Task Manager and Close Governance |
| Task templates and schedules |
| Dependencies and approvals |
| Dashboards and alerts |
| Approval Unit Hierarchies and Approvals |
| Approval unit hierarchy |
| Promote, approve, reject and sign-off |
| Approval status and data locking |
| Delegation and escalation |
| Supplemental Data Management |
| Data collection forms |
| Collection intervals |
| Workflow and approvals |
| Disclosure integration |
| Phase 6: Analytics and AI |
| IPM Insights and AI Features |
| Predictive insights |
| Anomaly detection |
| Forecast variance analysis |
| Configuring insight rules |
| Interpreting AI recommendations |
If you have a paid account, login here.
(You are not logged in. You need to login to access the videos.)
- Login
