e09 publishing financial reports using r12 report manager
TRANSCRIPT
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
1/39
Copyright 2012. Apps Associates LLC. 1
Publishing Financial Reports Using
R12 Oracle Report Manager
Oracle Report Manager
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
2/39
Copyright 2012. Apps Associates LLC. 2
Apps Associates
Value Delivery
Core to Our Mission
E-Business SuiteImplementation &Managed Services
*OBIEE, Pre-Built BI Analytics
Hyperion EPM
Middleware,Integration
Infrastructure Services
Subject MatterExperts
Best PracticeMethodology
High Value ROI
Local / GlobalService Delivery
Boston
New York
Chicago
Atlanta
Germany
Netherlands
India
Middle East
* Selected by Oracle as BI Pillar Partner
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
3/39
Copyright 2012. Apps Associates LLC. 3
Agenda
Report Manager Set UpReport Template Editor SecurityFinancial Report SubmissionRepository Management
Account Drill DownReport Set Publishing
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
4/39
Copyright 2012. Apps Associates LLC. 4
Report Manager Overview
Report Manager is your centralized FSG reporting toolfor submission, publishing, presentation and storage of
financial system generated reportsReplaces and enhances the former Desktop ADIRequest Center and ADI Report Publishing
Utilizes all FSG report definition (row sets, column sets,content, etc)Online centralized reporting system and repository
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
5/39
Copyright 2012. Apps Associates LLC. 5
Report Manager Configuration
Responsibility and MenusResponsibility
Predefined Report Manager responsibilityMust define and assign additional menus
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
6/39 Copyright 2012. Apps Associates LLC. 6
Responsibility and MenusMenus
Set Up the following Functions to the menuNote: For each of the highlighted functions, please ensure youchoose the Function Name value without "_G
Report Manager Configuration
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
7/39 Copyright 2012. Apps Associates LLC. 7
Report Manager Configuration
Responsibility and MenusMenus Functions to add
FSG Drilldown Launch PageFSG Drilldown: Select Content Set Rows
FSG Drilldown: Effective Range Selection Page
FSG Drilldown: Balance Inquiry Page
Account Analysis and Drilldown
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
8/39 Copyright 2012. Apps Associates LLC. 8
Excel SettingsXP or 2003
Open Excel2. Go to Tools -> Macro -> Security -> Trusted Sources3. Check the "Trust access to Visual Basic Project" option
Excel 2007Open Excel Select the Office ButtonClick on Excel Options
Report Manager Configuration
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
9/39 Copyright 2012. Apps Associates LLC. 9
Excel SettingsExcel 2007 Continued
Click on Trust Center Click on Trust Center SettingsEnable all macros and check Trust access to VBA project objectmodel
Report Manager Configuration
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
10/39 Copyright 2012. Apps Associates LLC. 10
Internet Explorer and Browser SettingsNavigate to Tools -> Internet Options and choose the Security tab.1.
Select Local Intranet and choose the Custom Level button.2.
Set the following option to Prompt.3.
Initialize and script Active X controls not marked as safe
Navigate to Tools -> Internet Options and choose the Security tab
1.
Select the "Trusted sites2.
Select the "Trusted sites"3.
Select the "Sites" button. Under Security choose "Custom Level"
andensure that the Run ActiveX controls and plug-ins and Script ActiveX
controls marked for scripting are enabled
Report Manager Configuration
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
11/39 Copyright 2012. Apps Associates LLC. 11
Report Template Editor
What is it?Create custom templates in Excel for FSG report
publishingComes seeded with two generic templatesGeneric FSG Template
and Generic FSG Drill
Template Allows the user to specify the report layout and basicExcel features to enhance the report presentation
Capabilities to enable report drill down
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
12/39 Copyright 2012. Apps Associates LLC. 12
Navigate: Financial Report Template Editor
Report Template Editor
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
13/39 Copyright 2012. Apps Associates LLC. 13
Default Excel Report
Template
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
14/39 Copyright 2012. Apps Associates LLC. 14
Report Formatting Functions
Insert logo and change colors
Modify column and row text, size, formatting
Change page margins
and orientation
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
15/39 Copyright 2012. Apps Associates LLC. 15
Sample Template
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
16/39 Copyright 2012. Apps Associates LLC. 16
Excel Reporting Editing Functions
Edit template functions within ExcelCell Formatting
Page Layout
Page Break Preview
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
17/39 Copyright 2012. Apps Associates LLC. 17
Report Template Upload
Use Oracle menu to upload modified
template
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
18/39 Copyright 2012. Apps Associates LLC. 18
Report Template Upload
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
19/39 Copyright 2012. Apps Associates LLC. 19
Security
Four Types of Security:N one
Users have no restrictions on what report content they can viewFlexfield
Security
Standard flexfield
security
User to Value Security
Assign segment values to users -
Distribute departmental reports
Custom
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
20/39
Copyright 2012. Apps Associates LLC. 20
User to Value SecurityUtilize this functionality when running FSG reports with content
sets Allows you to control what the content set value you want the
user to viewExample -
You want to distribute your Income Statement by
department to each department owner
Using the Security Workbench
create a value set
Security
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
21/39
Copyright 2012. Apps Associates LLC. 21
Assign users to value or values to user
Owner, Viewer
assign privileges
All can only view reports within
their assigned values
Security
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
22/39
Copyright 2012. Apps Associates LLC. 22
Publishing a FSG ReportNavigate: Financial Report Submission
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
23/39
Copyright 2012. Apps Associates LLC. 23
Publishing Parameters
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
24/39
Copyright 2012. Apps Associates LLC. 24
Storage Location
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
25/39
Copyright 2012. Apps Associates LLC. 25
Presentation and Review
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
26/39
Copyright 2012. Apps Associates LLC. 26
View Requests (HTML)
Three Concurrent jobsFinancial Statement Generator Spawns
Publish and Presentation Program
FO Generator
ViewOutput
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
27/39
Copyright 2012. Apps Associates LLC. 27
Published Report
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
28/39
Copyright 2012. Apps Associates LLC. 28
Sample Report
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
29/39
Copyright 2012. Apps Associates LLC. 29
Repository for all published FSG reportsCreate folders to store reports
Allows users to view reports and Archive reportsUpdate Publishing parameters
Repository Management
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
30/39
Copyright 2012. Apps Associates LLC. 30
T
View Reports
Content Set andUser Value
Security controlled
ReportOutputoptionsExcel,
PDF andHTML
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
31/39
Copyright 2012. Apps Associates LLC. 31
Ability to drill back to Oracle from a published reportUtilized the new R12 Account Analysis HTML look andfellExport account inquiry data to ExcelExample
Drill Down
Account Drill Down
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
32/39
Copyright 2012. Apps Associates LLC. 32
An Oracle Application browser window will open
Account Drill Down
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
33/39
Copyright 2012. Apps Associates LLC. 33
Clicking on the credit column to drill back to the detail balances
Account Drill Down
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
34/39
Copyright 2012. Apps Associates LLC. 34
View Transaction will drill back to the Applications
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
35/39
Copyright 2012. Apps Associates LLC. 35
Define a Report Set or a Request Set in Oracle E- Business Suite
Running a Report Set and Publishing the Reports is atwo step process
Submit the report set
Publish the reports to the report repositoryYou must define the reporting publishing options foreach report, the first time you publish a report
Running and Publishing Report Sets
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
36/39
Copyright 2012. Apps Associates LLC. 36
Once the request complete, Navigate to Report SetPublish menu option
Running and Publishing Report Sets
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
37/39
Copyright 2012. Apps Associates LLC. 37
Retrieve the Report Set NameClick on the Update Publishing Parameters to enter the
publishing parameters
Running and Publishing Report Sets
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
38/39
Copyright 2012. Apps Associates LLC. 38
Once you have set up all the publishing parameter, selectall the reports to publish and the click on the publishbutton
Running and Publishing Report Sets
-
8/12/2019 E09 Publishing Financial Reports Using R12 Report Manager
39/39
Thank You