Reportingintermediate

Financial Statement Generator (FSG) in EBS

Explain how FSG allows finance users to build custom financial statements in EBS without technical development

The Financial Statement Generator (FSG) is EBS General Ledger's native tool for building custom, formatted financial reports — like a management P&L broken down by division, or a custom balance sheet variant — entirely through functional configuration, without requiring PL/SQL or Oracle Reports development. FSG reports are assembled from four core building blocks: Row Sets (defining which accounts/rows appear and how they're calculated, like 'Total Revenue' as a sum of specific natural account ranges), Column Sets (defining the time periods and comparison columns, like 'Actual vs Budget vs Prior Year'), Content Sets (defining which specific values — like which company or cost center — the report runs for, enabling one definition to generate many report instances), and optional Row Order/Display Sets for formatting refinement.

FSG is like a custom spreadsheet template a finance team builds once (defining which rows, which columns, which comparisons) that can then be automatically regenerated for each department (Content Set) every month with fresh numbers, without anyone needing to rebuild the spreadsheet structure each time.

Key Concepts

1
FSG reports are submitted as concurrent programs (via the 'Program - Report' submission) and can run for a single entity or, using Content Sets, automatically generate a separate report instance per entity in one submission — useful for distributing individual cost-center manager reports from a single FSG definition.
2
While FSG remains widely used in EBS environments (especially for statutory/management reporting that predates or doesn't warrant BI Publisher development), it has real limitations: formatting flexibility is fairly rigid compared to BI Publisher's Word/Excel template design, and complex conditional logic is harder to express purely through FSG's row/column calculation definitions.
3
Interviewers often ask candidates to compare FSG with BI Publisher for financial reporting needs, and to explain the practical purpose of Content Sets in generating multiple report instances from a single definition — a subtlety many newcomers to FSG miss.