Oracle EBS SOA 接口删除及发布

文章目录删除接口测试接口连通性删除服务器上的接口文件删除系统表涉及内容重新发布接口开发WebService包生成ildt文件重启OAFM服务备注删除接口测试接口连通性select utl_http.request(http://xxx.xxx.xxx.xxx:8050/webservices/SOAProvider/plsql/scux_soa_data_find_pkg/?wsdl) from dual删除服务器上的接口文件删除SOA服务器上的WebSerives文件进入目录$INST_TOP/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。删除系统表涉及内容--删除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;重新发布接口开发WebService包注意包体注释部分的修改且包体Header注释部分必须通一格式。包头创建要用“AS”不要用“IS”否则生成ildt文件时报错。生成ildt文件新建$CUX_TOP/soa目录$ cd $CUX_TOP $ mkdir soa将package包头——pls文件上传到$CUX_TOP/soa目录下生成ildt文件$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -generate -verbose -force -usernamesysadmin cux:soa:Cux_Car_Om_Allocation_Load_Pkg.pls:12.0Cux_Car_Om_Allocation_Load_Pkg.plsUPLOAD ildt文件FNDLOAD apps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct Cux_Car_Om_Allocation_Load_Pkg_pls.ildt重启OAFM服务admanagedsrvctl.sh start oafm_server1 apps admanagedsrvctl.sh stop oafm_server1 apps备注如果修改了ASADMIN用户的密码需要执行如下动作Run the txkISGConfigurator.xml utility 命令如下ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStopyes