My Oracle Support Banner

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 AUGUST 13, 2020

Applies to:

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


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.