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.
<<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.
1 - don't use content sets or
2 - if using content sets don't use the FSG in a report set.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms