FSG XML Basic Template Does Not Format Columns And rows In PDF Or RTF Format In The Same Way As Excel Format (Doc ID 1051272.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Oracle Report Manager - Version 12.0.0 and later
Information in this document applies to any platform.
*** Checked for Relevance on 8-Aug-2013 ***
Executable:RGRARG - Financial Statement Generator
Executable:XDOREPPB - Generate PDF from XML output and given template
RGFSGXML - Program - Publish FSG


Symptoms

Trying to produce an FSG landscape report that will publish 14 columns and 46 rows (excluding headings) in PDF format. The same issue happens with RTF format.

The report can be output in HTML format from GL without any issues.

Can create a custom template in report manager and output the report in PDF format without any issues.

When run and publish in PDF format from GL, instead of just one page output, 4 pages are created.
This is because the columns wrap after column 8 and the rows have a page break after row 30 (excluding headings).

If use the seeded template in Report Manager to output the report in PDF format, it prints on two pages, the page break is after row 35 (excluding headings) but all 14 columns are shown on one line.

The reports have been specifically designed so that the output will fit on one page and need to be able to run and publish the reports in PDF format form GL, not Report Manager.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms