删除WebService服务指导文档

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)