Creating and Editing FSG Reports with Oracle ADI

1. Creating and Editing FSG Reports with Oracle ADI Jerry Reller Sr. Financial Analyst ZiLOG, Inc. jreller@zilog.com

2. ZiLOG is using Oracle 11i (11.5.7). • Multi-Org • Multiple books • Multiple Currencies • Global Accounts • Global Calendar

3. Oracle ADI • Overview of ADI (Application Desktop Integrator) • Excel/Text interface with Oracle Applications • ZiLOG uses for General Ledger • Upload journal vouchers and budgets • Fixed assets • Upload assets • Use to publish Standard and FSG Reports

4. FSG (Financial Statement Generator) FSG’s– Used for financial statements ie Balance Sheet, P&L, Cost Center Statements Spend Reports, Cash Flow , etc. GAAP and Management Reports

5. Components of an FSG Report Column Set (required) Content Set (Optional) Row Set (required)

6. FSG Advantages • Use components with multiple reports • Auto copy components and modify the copy • Combine components in Ad Hoc report • Able to combine several books into a single report prior to consolidation

7. Creating and Modifying FSG’s using Oracle ADI • Use Oracle Excel to create and edit reports • Copy and paste values • Row and column grouping • Spelling check • Able to visualize the report layout • Have access to Oracle list of values

8. ADI Menu Bar Ledger Icon

9. Report Wizard Step 1 Define Report Click “Next>”

10. Report Wizard Step 2

11. Report Wizard Step 3

12. Report Wizard Step 3

13. Report Wizard Step 3

14. Duplicate values can be copied and pasted Rows and Columns are grouped

17. Ungroup to view column Attributes

18. Report Objects

31. Publishing “scroll”