Hi there,
I not an HR person so never had to deal with such a requirement but let me try to understand your question better. Are the pictures already on the PS_EMPL_PHOTO table?

visible in the photo parts of the peoplesoft application.

Can you expand on this please?

The photos exist in another table: PS_PHOTOS. These need to be migrated into PS_EMPL_PHOTO.

One problem with doing an insert statement is that PS_PHOTOS.PHOTOGRAPH is a BLOB type where as the PS_EMPL_PHOTO.EMPLOYEE_PHOTO is a LONG RAW type.

I appreciate your help.

The EMPLOYEE_PHOTO on PS_EMPL_PHOTO is a blob and not LONG RAW. Did you try something like this:

You might also want to try the TO_BLOB() fucntion. It will convert RAW to BLOB. It is important to do that in your insert statement (like shown above).

Thanks, but please see below the describe on the tables on our system:

desc sysadm.ps_empl_photo;
EMPLID VARCHAR2(11)
PSIMAGEVER NUMBER(38)
EMPLOYEE_PHOTO LONG RAW

desc sysadm.ps_photos;
EMPLID VARCHAR2(11)
UM_USER_NAME VARCHAR2(150)
UPDATED_DTTM DATE
UM_RAW_IMAGE BLOB

I think the conversation from BLOB to LONG RAW is the problem. I cant find anything that will do the job. However, the PS_EMPL_PHOTO table is at the moment empty so can we change the type of the field and will it still work as normal through the front end?

Many thanks.

What version of Peoplesoft are you on? When I do desc on ps_empl_photo i get employee_photo as a blob.

PS_EMPL_PHOTO table is at the moment empty so can we change the type of the field

Yes, I would do that. Blob carries more advantages over LONG RAW and I would be surprised if this causes you any problem on the front end.

Hi we are on PS version 8.9.

I tried changing the field type this morning, however now when I manually uplaod a photo through the front end the image is not displayable (it has a red cross in the far left) where as when I did this before the data type change it was fine so I dont think that is going to work.

Thanks

I'm sorry to hear that. I would login a ticket with PeopleSoft customer connection site to help you with this issue. I'm kind of out of ideas on this one :( (I haven't had enough exposure to HR since I'm a FIN guy)

Cool - thats no problem... Thank you for all your effort :)

i have a similar situation. i need to display the picture of an employee who is currently logged in. when i checked in the above mentioned record EMPL_PHOTO, the values in the employee_photo are stored as BLOBS. can you tell me how should i display this photo on a page in Peoplesoft based on the current logged in User using Peoplecode?