Error When Generating Report From GL Report Manager in Excel format : oracle.apps.bne.exception.BneSQLException - Cannot execute SQL Statement (Doc ID 2088804.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Report Manager - Version 12.1.3 and later
Information in this document applies to any platform.
Financial Statement Generator (FSG)

Symptoms

The users are able to generate the report in PDF and XML formats but getting an error when attempting to open the FSG report in Excel, from Report Manager:

ERROR
The following error has occurred


STEPS TO REPRODUCE:

1. Go to Report Manager > Financial Report Submission
2. Enter the Report Name and Period - all the rest use default values and click Next
3. Use as the default template "Generic FSG Template" and click Next
4. Use the same Storage Location and click Next
5. Do not create a Menu Item - just click Next
6. Finally, click Submit
7. Monitor the requests and wait for the related report (Publish and Presentation Program) request to complete, then click "Output"
8. Click "View Report Now" and get the screen where users can pick the output. Note it is possible to open the report in PDF and XML outputs, but when Excel is selected the error is thrown

Changes

None

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