PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Has anyone successfully displayed an image from the PSCONTENT table into a BI Publisher report defin

edited Apr 26, 2019 5:02AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

People CS 9.2

Tools 8.54.33

Sql Server 12.0.5

Added image field type to query and converted to base 64 encode with this statement:

SELECT CAST('' AS xml).value( 'xs:base64Binary(sql:column("PSCONTENT.CONTDATA"))'  , 'varchar(max)' )   FROM PSCONTENT  WHERE CONTNAME = 'my_image') AS my_image_converted

Generated my xml file and loaded to RTF document

Dropped my image field on RTF document and change property to

<fo:instream-foreign-object content-type="image/jpg">

<xsl:value-of select="my_image_converted"/>

</fo:instream-foreign-object>

Uploaded RTF document to report definition


Executed report definition thru a push button

Report PDF output is generated but the image is not displayed

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center