PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

XMLP - trouble showing database image in the report.

edited Jun 18, 2014 12:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered
I have trouble showing database image (employee photo stored in the table ) in the XMLP report.

The report is generated from a custom page using App Server as mentioned in this article.

E-BI/XMLP: How to Create BI/XML Publisher Reports Using Dynamic Images Stored in Database Tables? [ID 1085746.1]

Peoplecode in the Field Change to generate Image URL,

Local Request &req = %Request;
Local Record &rec = GetLevel0()(1).GetRowset(Scroll.QE_EMPL_PHOTO2)(CurrentRowNumber()).QE_EMPL_PHOTO2;
Local string &url = %Response.GetImageURL(&rec);
Local string &ImgURL = &req.Scheme | "://" | &req.ServerName | &url;

the URL looks like this

&req.Scheme  = http

&req.ServerName = DEV

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