UNABLE TO VIEW OUTPUT WHEN PUBLISHING REPORT SET WITH CONTENT SET (Doc ID 827461.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Report Manager - Version: 11.5.10 to 12.1.2
This problem can occur on any platform.

Symptoms

Issue appears to be the same as that noted in note:
<<Note.758046.1>> Publish and Presentation Fails Could Not Identify Expansion Value finding that when using Report Sets with content sets that they will fail and not generate output. The log file shows:

PUBLISH_PRESENT_WRAPPER module: Publish and Presentation Program:
Param size? 31 Is In set? truein set - , NVT name = PUBLISH_SET_ID, val = 18641 END PARAM
Publishing with FO Generation started
content set id is not empty and it is an fsg submission
Failed to get the expanded values: Start of root element expected.
Published doc Id: -1Publishing did not complete successfully, unable to insert data into database
Submission-Publishing Wrapper Finished at Tue May 05 16:25:37 EDT 2009

As per this note and reference bug:
<<Bug 7589088>> - FSG WITH CONTENT SET:CONTENT SET ID IS NOT EMPTY

The solution is:
Please ask the customer to apply <<Patch 7375915>> and <<Patch 7350414>> This should resolve the issues.

These patches have been applied and issue remains:
1.) $Header: FRMStringUtils.java 115.5 2008/09/08 08:30:14
2.) select bug_id, bug_number from ad_bugs
where bug_number in ('7375915','7350414')

--Returns 2 rows; one for each bug/patch


Report Sets without content sets complete without this error... data is visible.
Individual Reports with content set complete with success when not in a report set.


WORKAROUNDS
-----------
1 - don't use content sets or
2 - if using content sets don't use the FSG in a report set.

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