Publishing FSG reports using XML Publisher

After a recent presentation I did within my company on XML Publishing in Oracle Apps, a colleague popped up with this question: How do I integrate FSG report output with XMLP ? I didnt have the answer then since I dont have much experience with FSG reports, but I chanced upon the information below in one of the user guides. It shows that it is actually simple to publish FSG report output using XMLP templates!

To publish your FSG report in one step:
----------------------------------------------------------------
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.


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.
Template Locale: Select the Language and Territory combination of the template
you wish to use.

Note: If you do not select a valid language and territory
combination, XML Publisher uses the template that corresponds to
your session language and territory. If a valid template for this
combination does not exist, XML Publisher uses the Default
Template. See Oracle XML Publisher User's Guide.
Output Format: Select the output format. If your selected template is RTF, you can
generate output in Excel (HTML), HTML, PDF, or RTF.

5. Submit your request.

6. View your published FSG report. Your FSG report will have the report formatting
of your report template.

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.
Template Locale: Select the Language and Territory combination of the template
you wish to use.
Note: If you do not select a valid language and territory
combination, XML Publisher uses the template that corresponds to
your session language and territory. If a valid template for this
combination does not exist, XML Publisher uses the Default
Template. See Oracle XML Publisher User's Guide.
Output Format: Select the output format. If your selected template is RTF, you can
generate output in Excel (HTML), HTML, PDF, or RTF.

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.

XML Publisher - How to do sorting on the XML dataset

How to do sorting in XMLP
---------------------------
Sorting can be done by inserting the tag within the repeating group.

Multiple sorts is possible by using multiple sort tags


There is no end tag required for this XMLP directive.

Ascending or descending order sorting is also possible using the following syntax
order='descending'?>

Data type sorting is also possible. This is especially useful if you want to do numeric sorting on an alphanumeric field. This can be done using the syntax below:
data-type='number'?>

The sort XMLP directive should immediately follow the XMLP for-each directive

E.g.

Introduction

About Myself:
I have been working as an Oracle Applications implementor and consultant for the past eight years. My career in software application development spans around 11 years.

The main focus of my experience has been in the technical aspects of Oracle Applications (integrations, conversions, workflow, forms, reports) with experience around the Supply Chain modules including ASCP, Inventory, Order Management, and Purchasing. I also have experience in Project Accounting and Manufacturing as well as Receivables and Payables modules.

Technically, I have considerable experience with SQL, PLSQL, Forms, Reports and workflow, XML Publisher and use of middleware integration technology (SOA).

My Oracle Applications consulting experience includes live implementations at Singapore,Australia, offshore support for implementations for GE Power Systems.

I am currently based in Sydney, Australia where I work as a senior technical consultant specializing in Oracle Applications consulting.

Oracle Applications R12 is the latest release of the Oracle ERP suite of products at the moment. The consulting community is excited about the soon to be released Oracle Fusion - which promises to bring together the disparate products which Oracle has acquired recently. There is also considerable excitement over SOA/BPEL middleware which Oracle is definitely touting as the backbone for Oracle Fusion.

My aim with this blog is to post my experiences using Oracle Applications which may be useful information for other Oracle Application consultants. I would also be posting my thoughts around the latest and greatest happenings in the Oracle Applications consulting space.