Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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?
Can you expand on this please?
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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:
(SELECT emplid, psimagever, TO_LOB (photograph)
FROM ps_photos)
More details about the to_lob function can be found here. Please let us know the outcome!
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).
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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.
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.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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)
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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?