oracle report
DESCRIPTION
Oracle ReportTRANSCRIPT
![Page 1: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/1.jpg)
Financial Reporting in Oracle R12 FSGs and Report Manager
Presented by: Lee Briggs
March 21, 2013
![Page 2: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/2.jpg)
2
Agenda
• Introductions
• Overview of Report Manager
• Required Setups
– Applications
– PC Settings
• Tutorial
• Tricks of the Trade
• Summary
![Page 3: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/3.jpg)
Lee Briggs | Director, Financial Management Practice
• Professional Summary
– Coordinator of the Desktop Integrator Special Internet Group (OAUG)
– Director of the BizTech Financial Management Practice, specializing in the design, implementation and project management of Oracle Financials projects.
– 35+ Full Implementations of Oracle Financials (11.0.3 thru R12.1.3)
– Background in training, analysis and project management.
– Multiple Presenter at Collaborate and OpenWorld
• Qualification Summary
– Oracle Certified Specialist in General Ledger
– Oracle Certified Specialist in Accounts Payable
– Masters Degree in Management Studies
– Bachelors (with Honors) in Accounting and Finance
Mobile: (215) 208-7909 Email: [email protected] Twitter: @BTLeeBriggs Website: www.BizTech.com
Prior Experience:
Project Experience:
![Page 4: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/4.jpg)
• Professional Services Firm – Professional Services firm focused on Oracle applications and
technology – Oracle Platinum Partner – Highest Level of certification – Specialized Pillar Partner in BI/EPM, EBS, CRM, and Core Technology – Over 400 successful Oracle implementations over the past 15 years – NY, PA, NJ, VA offices with Regional, Global, and International clients – 100+ Consulting Resources
• Centers of Excellence across key solutions and industries – Solutions: Oracle Applications, Technology, BI/EPM, and Managed
Services – Industries: Financial, Professional, Business Services; Communications
and Media; Manufacturing; Distribution; Public Sector, Government; Healthcare and Life Sciences
• BizTech Software Solutions : BizTech Integrators, BizTech Insight Accelerators, BizTech Reporting Foundation
• Oracle License Reseller
About BizTech
![Page 5: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/5.jpg)
Overview of Report Manager
• Integrated Reporting Module within Oracle eBusiness Suite
• Provides an online repository for Financial and Standard Reports
• Personalized look and feel to all reports
• Accessed through a web browser, rather than Java forms
• Securitized by user
5
![Page 6: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/6.jpg)
Required Setups
• Patch up!!
– 11.5.10 – Patchset FRM.H
– R12.0 – Patchset FRM.A
– R12.1 – Patchset FRM.B
• Browsers
– Report Manager users MUST run Internet Explorer for full functionality (Note 1077728.1)
6
![Page 7: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/7.jpg)
Required Setups
• Ensure Desktop Integrators (Web ADI in 11i) are fully configured
– Great Presentation from Collaborate 2011 which details all configurations
• Desktop Integrator – “You mean I can load data from a spreadsheet straight into an interface?”
• Available at http://www.biztech.com/collaborate11-oaug-session-presentations/
7
![Page 8: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/8.jpg)
Internet Explorer Settings
• Navigate to Tools -> Internet Options and choose the Security tab
• Select Local Intranet and choose the Custom Level button.
– Set the option “Initialize and script Active X controls not marked as safe” to "Prompt" or "Enable".
– Set “File download” to enabled.
– Set “Allow Status bar updates via script” to “Enable”.
– Set “Initialize and script ActiveX controls not marked as safe” to prompt
8
![Page 9: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/9.jpg)
Excel 2010 Settings
• Click File -> Options
• Click 'Trust Center' link in the 'Excel Options' window.
• Click 'Trust Center Settings...' button.
• In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
• Under 'Macro Settings' check 'Disable all macros with notification'.
• Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
• Click 'OK' button to close the 'Trust Center' window.
• Click 'OK' button to return to the spreadsheet.
9
![Page 10: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/10.jpg)
Excel 2007 Settings
• Click the Office Button (top-left button in the window)
• Click the 'Excel Options' button.
• Click 'Trust Center' link from the menu on the left.
• Click 'Trust Center Settings...' button.
• In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
• Under 'Macro Settings' check 'Disable all macros with notification'.
• Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
• Click 'OK' button to close the 'Trust Center' window.
• Click 'OK' button to return to the spreadsheet.
10
![Page 11: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/11.jpg)
Excel 2003 Settings
• On the Tools menu, point to Macro and then click Security.
• In the Security dialog box, click the Trusted Sources tab.
• Click to select the Trust access to Visual Basic Project check box.
11
![Page 12: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/12.jpg)
Tutorial
• Update GL Superuser Responsibility
• Submit an FSG (with Generic Template)
• View Output
• Create an FSG Template
12
![Page 13: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/13.jpg)
Update GL Super User Responsibility
• “Report Manager Super User” is a “valid” responsibility
– Doesn’t have all drill-down permissions that may be needed
• “General Ledger Super User” responsibility has the drilldown permissions, but no Report Manager access
• SOLUTION – Add the “RptMgr SuperUser” menu to GL_SUPERUSER menu (then log off and on)
13
![Page 14: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/14.jpg)
Update GL Super User Responsibility
14
![Page 15: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/15.jpg)
Update GL Super User Responsibility
15
![Page 16: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/16.jpg)
Submit an FSG
• Navigation
– Report Manager > Financial Report Submission
16
![Page 17: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/17.jpg)
Submit an FSG Step 1 – Submission Parameters
17
![Page 18: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/18.jpg)
Submit an FSG Step 2 – Publishing Parameters
18
![Page 19: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/19.jpg)
Submit an FSG Step 3 – Storage Location
19
![Page 20: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/20.jpg)
Submit an FSG Step 4 – Presentation
20
![Page 21: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/21.jpg)
Submit an FSG Step 5 – Review
21
![Page 22: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/22.jpg)
Monitor Requests
22
![Page 23: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/23.jpg)
View Output in Report Manager
• Navigation
– Report Manager > Repository Management
23
![Page 24: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/24.jpg)
View Output in Report Manager
24
![Page 25: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/25.jpg)
View Output in Report Manager
25
![Page 26: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/26.jpg)
Create an FSG Template
• Navigation
– Report Manager > Financial Report Template Editor
• Each FSG that you want to use in Report Manager HAS to have it’s own template
26
![Page 27: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/27.jpg)
Create an FSG Template
27
![Page 28: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/28.jpg)
Create an FSG Template
28
![Page 29: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/29.jpg)
Basic Excel Formatting
29
![Page 30: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/30.jpg)
Moving Line Descriptions away from the left
30
![Page 31: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/31.jpg)
Uploading Template
31
![Page 32: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/32.jpg)
Running the FSG with the new Template
• Almost same process as before
– Picking the new template
– Report Manager remembers the last folder you saved the report
32
![Page 33: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/33.jpg)
Submit an FSG Step 1 – Submission Parameters
33
![Page 34: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/34.jpg)
Submit an FSG Step 2 – Publishing Parameters
34
![Page 35: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/35.jpg)
Submit an FSG Step 3 – Storage Location
35
![Page 36: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/36.jpg)
Submit an FSG Step 4 – Presentation
36
![Page 37: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/37.jpg)
Submit an FSG Step 5 – Review
37
![Page 38: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/38.jpg)
Sample Output
38
![Page 39: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/39.jpg)
Tricks of the Trade
• Update the FSG definitions
– Remove all underline formatting from the rowsets
• FSG will insert a line (row) with “-” or “_”, which will look messy
• Remove that formatting, and let native Excel formatting take care of it
39
![Page 40: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/40.jpg)
Tricks of the Trade
• Only use Report Manager for “Management Reporting” once numbers are final
– Analysts should continue to submit FSGs through General Ledger
• Content Sets can work
– Use Sequential Content Sets
– Oracle Support is working on getting parallel content sets working
40
![Page 41: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/41.jpg)
Tricks of the Trade
• Avoid logos
– Display nicely in PDF and HTML outputs
– Lose proportions and colors in Excel format
41
![Page 42: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/42.jpg)
Tricks of the Trade
• Decide on your Report Repository structure early
• Ledger
– Financial Reports (FSG) • Income Statement
• Balance Sheet
• Trend Analysis
– Operations Reports (Standard) • Module 1
• Module 2
42
![Page 43: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/43.jpg)
Tricks of the Trade
• Fed up with running the same report multiple times for different segment values?
• Report Manager’s Security Workbench allows you to put security on Value Sets
– Run the report once
– Users with access to Company 100 will only be able to see Company 100
43
![Page 44: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/44.jpg)
Summary
• Overview of Report Manager
• Required Setups
– Applications
– PC Settings
• Tutorial
• Tricks of the Trade
44
![Page 45: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/45.jpg)
Upcoming Presentations
• Collaborate 2013
– Financial Reporting in Oracle R12 - FSGs and Report Manager (ADI SIG, April 7th, 2:30pm)
– Exploring the Mystery that is AGIS (April 10th, 11am)
45
![Page 46: Oracle Report](https://reader033.vdocuments.us/reader033/viewer/2022051116/563db954550346aa9a9c4862/html5/thumbnails/46.jpg)
46
Contact Information
Lee Briggs
Director, Financial
Management Practice
c. 215 208 7909
Twitter: @BTLeeBriggs