HR模块照片无法导入系统

  HR模块中，在做人员资料维护的时候，照片无法加载。EBS系统报如下错误：

 

ORACLE 错误 &ERRNO: PER_IMAGE_UPLOAD_PKG 中检测到 &REASON 。 (ERRNO=)
(REASON=ORA-29532: Java 调用被未捕获的Java 例外终止：
java.security.AccessControlException: the Permission
(java.net.SocketPermission hostname.xxx.com resolve) has not been
granted to APPS. The PL/SQL to grant this is dbms_java.grant_permission(
'APPS','SYS:java.net.SocketPermission','hostname.xxx.com','resolve'
))

 

从错误提示看好像是APPS缺少权限。查了下metalink发现是个bug，但也可以手工给APPS付权限。其实在错误信息里已经告诉我们怎么做了。dbms_java.grant_permission(
'APPS','SYS:java.net.SocketPermission','hostname.xxx.com','resolve')

 

来看看oracle的解释：

This is due to AD Bug 1486132 - lack of java permissions.
The 11i.PER.B readme file describes the manual step required to
correct the problem. The following statement should be run from
the SYSTEM account.

exec dbms_java.grant_permission -
APPS','java.net.SocketPermission','*','connect,resolve');

Note the '-' terminator at the end of the first line which was ommitted from the PER.B readme (see Bug 1628965). This manual step can be replaced by applying the patch for Bug 1524970. This step is not required for PER.C

具体操作：

以系统权限连接oracle数据库，然后执行错误信息里的语句：

SQL>exec dbms_java.grant_permission(
'APPS','SYS:java.net.SocketPermission','hostname.xxx.com','resolve')

--执行完成后再次导照片，没有成功。可能是没有退出应用的缘故。

SQL>exec dbms_java.grant_permission -
APPS','java.net.SocketPermission','*','connect,resolve');

--执行完成后再次导照片，还是不行。提示信息跟原来比有变化：The PL/SQL to grant this is dbms_java.grant_permission(
'APPS','SYS:java.net.SocketPermission','hostnameIP：1541','connect,resolve'
))

退出应用，重新登录问题解决。