select utl_http.request(‘http://192.168.181.50:8050/webservices/SOAProvider/plsql/scux_soa_data_find_pkg/?wsdl’) from dual
1.删除服务器上的webserives文件进入目录/u01/erpapp/inst/apps/prod_erp/soa/PLSQL删除
PLSQL下面的目录名称就是如下SQL查出的CLASS_ID值
SELECT t.class_id
FROM fnd_irep_classes t
WHERE Upper(t.irep_name) = Upper(‘CUX_WS_AP_PAYMENTS_PKG’)
AND t.class_type = ‘PLSQL’;
这一步要注意,如果是修改了PLS中定义的记录类型或者入口函数的参数,一定要先在PLSQL/[class_id]/REST 目录下面对应服务所在里面把
$INST_TOP/soa/PLSQL
这个**dorp.sql下载下来,然后执行里面的drop语句。删除已定义的TYPE。
2.删除系统表涉及内容
–删除function和parameters
SELECT *
FROM fnd_form_functions t
WHERE t.function_name LIKE ‘%CUX_WS_AP_PAYMENTS_PKG%’;
SELECT *
FROM fnd_parameters t
WHERE t.function_id IN (SELECT ff.function_id
FROM fnd_form_functions ff
WHERE ff.function_name LIKE ‘%CUX_WS_AP_PAYMENTS_PKG%’);
DELETE fnd_parameters t
WHERE t.function_id IN (SELECT ff.function_id
FROM fnd_form_functions ff
WHERE ff.function_name LIKE ‘%CUX_WS_AP_PAYMENTS_PKG%’);
DELETE fnd_form_functions t
WHERE t.function_name LIKE ‘%CUX_WS_AP_PAYMENTS_PKG%’;
–删除IREP
SELECT *
FROM fnd_irep_classes_tl t
WHERE t.class_id IN (SELECT fic.class_id
FROM fnd_irep_classes fic
WHERE fic.irep_name = ‘CUX_WS_AP_PAYMENTS_PKG’ );
SELECT t.class_id
,t.irep_name
,t.*
FROM fnd_irep_classes t
WHERE t.irep_name = ‘CUX_WS_AP_PAYMENTS_PKG’ ;
DELETE fnd_irep_classes_tl t
WHERE t.class_id IN (SELECT fic.class_id
FROM fnd_irep_classes fic
WHERE fic.irep_name = ‘CUX_WS_AP_PAYMENTS_PKG’);
DELETE fnd_irep_classes t
WHERE t.irep_name = ‘CUX_WS_AP_PAYMENTS_PKG’;
–删除已发布服务名
SELECT t.*
,t.rowid
FROM applsys.fnd_soa_services t
WHERE t.service_alias = ‘AP_PAYMENT’;
3.重新执行WebService发布动作
3.1 开发webservice包,示例如下:
注意:包体注释部分的修改,且包体Header注释部分必须通一格式。包头创建要用“AS”不要用“IS”,否则生成ildt文件时报错。
3.2 生成ildt文件
3.2.1 新建$CUX_TOP/soa目录
$ cd $CUX_TOP
$ mkdir soa
3.2.2 将package包头–pls文件(3.1中的文件)上传到$CUX_TOP/soa目录下
3.2.3 生成ildt文件
$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -generate -verbose -force -username=sysadmin cux:soa:CUX_WS_AP_PAYMENTS_PKG.pls:12.0=CUX_WS_AP_PAYMENTS_PKG.pls
3.3 UPLOAD ildt文件
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct CUX_WS_AP_PAYMENTS_PKG_pls.ildt
4.重启OAFM服务
admanagedsrvctl.sh start oafm_server1 apps/apps
admanagedsrvctl.sh stop oafm_server1 apps/apps
注:如果修改了ASADMIN用户的密码需要执行如下动作:
Run the txkISGConfigurator.xml utility ,命令如下:
ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStop=yes
启动应用服务器
$ cd ~
$ startapp.sh
oracle实践之ebs-integrated-soa-gateway实施指南 - 豆丁网 (docin.com)