Thursday, October 20, 2011

Unable to upload pictures from people form. It shows Done in the bottom of the page but picture is not displayed

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    

Unable to upload pictures from people form. It shows Done in the bottom of the page but picture is not displayed

Symptoms:

Whenever user uploads the image, the image data is populated to fnd tables where the column type is
BLOB. But, the image column in per_images is of type LONG RAW. PERWSIMG uses
a java stored procedure to convert the blob into LONG RAW and copies
the data into PER_IMAGES.

To do this, java stored procedure need to
have a db connection, for this db username and password are required. Till
now, GLBUDGETPWD has been used to get the db password and now this is
obsoleted and de-supported.

From the Patch:

In Release 11i the HRMS application provides the ability to
associate pictures with people.

During the upgrade process to Release 12 the internal column
data type used to store these pictures will be changing. That
upgrade process will also convert all existing pictures so
they can be stored in the modified column.

This patch has been provided for customers who have a large
number of person images and wish to reduce the downtime period
when upgrading to Release 12. This patch delivers and executes
a concurrent program which can be used to convert the PER_IMAGES
table definition and existing images in advance of the
Release 12 upgrade.

The concurrent program is executed once the patch has been
applied and the Concurrent Manager has been restarted. It is
recommended to execute the concurrent program while users
will not need to load or update person pictures.

This patch also delivers an updated version of the Person
Image Form. This Form version is compatible with the
concurrent program and modified column data type.

While the concurrent program is running user create, update
and delete operations on the Person Image Form will not be
permitted.

If the concurrent program should fail, due to
another process accessing the images at the same
time, then the concurrent program should be restarted
when no users or other processes require the Person
image functionality.

Solution:



The issue can be resolved by upgrading to file PERWSIMG.fmb and version 115.20 or higher.The following bug outlines this solution:
Bug.926768: PER_IMAGES Long Column Migration + Concurrent Program Patch  

1. Download and review the readme and pre-requisites for Patch.4926768 

2. Ensure that you have taken a backup of your system before applying 
the recommended patch. 

3. Apply the patch in a test environment. 

4. Confirm the following file versions: 
       PERWSIMG.fmb and version 115.20
You can use the commands like the following: 
       strings -a $XX_TOP/filename |grep '$Header' 

5. Retest the issue. 

6. Migrate the solution as appropriate to other environments. 

References:

135460.1 - Image Upload using Oracle HRMS Release 11i 
202003.1 - Unable To View JPEG Image After Upload Has Completed
780262.1 - Unable to Load a Picture Image for Employees in Form PERWSIMG 


Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: