Back to LIT Academy

LIT Academy

Learner

Build first forms and reports while understanding consolidation and budgeting in EPM.

Learner

Hands-On PBCS and FCCS Basics

Build first forms and reports while understanding consolidation and budgeting in EPM.

Technical Track

  1. 1Replicate the Excel consolidation exercise in Oracle FCCS for 10 entities
  2. 2Replicate the Excel budgeting exercise in Oracle PBCS for 10 entities
  3. 3Prerequisites for Excel to EPM migration: data mapping, metadata design, user training
  4. 4Create your first PBCS data form: revenue planning by entity and month
  5. 5Create your first FCCS consolidation: entity hierarchy, ownership, intercompany
  6. 6Upload data to PBCS and FCCS using file-based load and common upload options
  7. 7Build a basic PBCS report: Actual vs Budget variance by entity

Functional Track

  1. 1Basics of accounting: journals, debits/credits, T-accounts, trial balance
  2. 2What is intercompany accounting? Why do we eliminate intercompany transactions?
  3. 3What is ownership consolidation? Parent-subsidiary relationships and minority interest
  4. 4What are allocations? Cost center allocations and overhead distribution
  5. 5What is driver-based planning? Revenue per employee, COGS as percentage of revenue
  6. 6What is rolling forecast? 12+12 model and always-on planning vs annual budget
  7. 7Compare manual Excel close vs FCCS close: time saved and error reduction

Completion Outcomes

  • Can build a 10-entity consolidation in FCCS from scratch
  • Can build a 10-entity budget model in PBCS from scratch
  • Can upload data files to both PBCS and FCCS using common load options
  • Understands intercompany eliminations and ownership consolidation in practice
  • Can explain driver-based planning and rolling forecast to a CFO

Estimated Duration

4-6 weeks
Back to LIT Academy