Report Manager: Step by Step Setup Guide For Publishing FSGs [ID 734015.1] | |||||
| |||||
修改时间 19-OCT-2010 类型 HOWTO 状态 MODERATED |
Applies to:
Oracle Report Manager - Version: 11.5.10.2 to 12.1.3 - Release: 11.5 to 12.1Information in this document applies to any platform.
Goal
What are the steps necessary to implement Report Manager functionality to submit and publish FSG (Financial Statement Generator) reports?Solution
1. A recorded Report Manager training session is available for you to view.Access this from MetaLink Note 603169.1.
Follow the link in the note to replay the Report Manager webcast training session.
2. Note 726774.1 goes through in detail, the steps necessary to be able to successfully use Report Manager for publishing FSGs and drilling down. Read through the note before continuing.
3. Here are the major steps necessary to implement this functionality. See Note 726774.1 for detailed instructions.
a. Define the Menu to be used by the Responsibility that will access the Report Manager functionality.
This menu must contain each of the Functions needed for Report Manager.
b. Define the Responsibility you wish to use to access the Report Manager functionality.
Assign the Menu from the prior step to the Responsibility.
To be able to run General Ledger Standard Reports from Report Manager using this responsibility, set the Request Group Name to 'GL Concurrent Program Group'. If you want to run reports from a different application from Report Manager, create a separate responsibility, with the corresponding Request Group.
c. Assign the Responsibility to the User. Note that you must use Internet Explorer as your browser.
d. Sign on as the User and select the Responsibility you created
e. Select the Financial Template Editor menu item to create the Templates for your FSGs. Enable Drilldown on the templates.
f. Select the Financial Report Submission menu item to publish an FSG. Enter all required parameters, and specify the template you created. Submit the report.
g. Click on Monitor the Request
When submitting any report from Report Manager, there will be two requests that will be submitted:
“ (Financial Statement Generator)”
“ (Publish and Presentation Program)”
The first request is the FSG program (RGRARG), which produces an XML file (the one with the XML tags). This XML file is then used by the second request, which is the XML Publisher Program, and produces the published output.
Note that there may be third program (FO Generator), (in 11i if patch 7350414 or 11i.ATG_PF.H.Rup7 (6241631) has been applied). This program will produce the HTML output.
h. After the requests are completed, check the status. Both must be completed successful in order to have your published output.
If the FSG program is not successful, the XML Publisher program cannot be successful, as the input for it needs to come from the 1st program.
If both are successful, click on the output for the Publish and Presentation program.
i. For drilldown, click on the amount. If the cell you are attempting to drill on is the result of a calculation, drilldown will not be allowed on that amount. Drilldown is only allowed for amounts that are results of account assignments in the FSG.
References
NOTE:603169.1 - WebADI and Report Manager Webcasts for EBS 11i/R12 -- Replay is Now AvailableNOTE:726774.1 - Overview of Report Manager
NOTE:800633.1 - Unable To Publish The Report In HTML. HTML Icon Is Disabled
NOTE:827288.1 - Poor Performance In HTML Due To FO Generator
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/86584/viewspace-683763/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/86584/viewspace-683763/