利用XMLP发布FSG报表

功能:
1, XML Publisher可以跟FSG结合,产生出PDF格式
2, 12R下面才允许excel输出,11i暂时不支持.
3, ADI 不支持产生XML

步骤:
1, 定义FSG 报表
2, 产生FSG 报表 并且以 PDF 输出:
方法1:
   (1),到Financial Report 窗口submit FSG报表, 注意output 选择 XML
   (2),submit request:  'XML Report Publisher' ,选择出刚才跑的request id, 以及相关的template 输出.
方法2:
直接submit : Publish FSG Report 这个request 也可以得到同样的效果.

设置的步骤:
1, 登陆XML Publisher Administrator responsibility选择模板定义, 搜索 %FSG%
2, 可以看到一份: FSG: Basic Template
3, 下载,并在本机上面进行编辑,重新上传,注意选择 Data definition: FSG program 就可以.

相关的表:
XDO_DS_DEFINITIONS - Data source definition
XDO_TEMPLATES - template definition
XDO_TEMPLATE_FIELDS - template fields definition

请求:
XDOREPPB: XML Report Publisher, used to publish the XML Output generated from RGRARG (two step process).

RGFSGXML: Program - Publish FSG Report. This generates the XML output file and publishes it in one step, by launching RGRARG (Financial Statement Generator) and then XDOREPPB: XML Report Publisher (one step process).

发布FSG报表
一步发布:
1. Navigate to the Submit Requests window and select Program - Publish FSG report program.
2. Enter the name of your FSG report.
3. Enter your FSG report parameters.
4. Select your report template.
5. Submit your request. A parent request is submitted that will generate two child requests. One request generates the XML output and the other request publishes the FSG report from the XML output.
6. View your published FSG report. Your FSG report will have the report formatting of your report template.
7. Optionally, run the XML Report Publisher program with a different report template for the same FSG XML output request.

从menu发布:
To publish your FSG report from the Run Financial Reports window:
1. Navigate to the Run Financial Reports window.
2. Enter your FSG report parameters and select XML as the output option.
3. Submit your request. Your FSG program request generates XML output.
4. Once your request completes successfully, from the Submit Requests window, select the XML Report Publisher program and enter the following parameters:
Report Request: Select the report corresponding to your FSG report's XML output request ID.
Template: Select report template.
5. Submit your request.
6. View your published FSG report. Your FSG report will have the report formatting of your report template.
7. Optionally, run the XML Report Publisher program with a different report template for the same FSG XML output request.

从request发布:
To publish your FSG report from the Submit Requests window:
1. Navigate to the Submit Requests window and select Program - Run Financial Statement Generator program.
2. Enter the name of your FSG report.
3. Enter your FSG report parameters and select XML as the output option.
4. Submit your request. Your FSG program request generates XML output.
5. Once your request completes successfully, from the Submit Requests window, select the XML Report Publisher program and enter the following parameters:
Report Request: Select the report corresponding to your FSG report's XML output request ID.
Template: Select report template.
6. Submit your request.
7. View your published FSG report. Your FSG report will have the report formatting of your report template.
8. Optionally, run the XML Report Publisher program with a different report template for the same FSG XML output request.

NOTE:
1,因为oracle的xml发布是不支持Parallel processing type.所以在第一种方式进行运行的时候,type不能选择content set type为Parallel的方式.否则会有如下的信息抛出:
Content sets with the Parallel processing type are not supported with the Publish FSG Report program
for request_id 302111. 
2,在meun发布中有个注意点就是,如果你的content set选择是sequential的话,你才可以在XML Report Publisher program中选择得到.否则是选择不到的.
3,第三种方式跟第二种方式类似.
4,综合上看来,三种方式的难易程度是越来越难的,那个一步到底我认为比较适合财务低级点的财务人员用,第二种跟第三种差不多,第二种稍微简单点,第三种稍微复杂点.