Oracle EBS中发布Web服务详细教程

本文讲解一下如何把自定义的PLSQL的Package发布成Webservice，并在Oracle Integration Repositoy里注册


1.创建Product Family
Product Family用于管理几个功能相近的Product（也可以立即为模块），统一管理客户化的Webservice接口

begin
  -- Call the procedure
  ad_pa_insert_package.insert_ad_pm_product_info(x_product_abbreviation        => 'os_xxx',
                                                 x_pseudo_product_flag         => 'N',
                                                 x_product_family_flag         => 'Y',
                                                 x_application_short_name      => NULL,
                                                 x_product_name                => 'Oracle Xxx Suite',
                                                 x_product_family_abbreviation => NULL,
                                                 x_product_family_name         => NULL,
                                                 x_aru_update_date             => to_char(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                                                 x_currdate                    => to_char(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                                                 x_last_updated_by             => -1,
                                                 x_created_by                  => -1);
  COMMIT;
end;

2.注册Product，即注册Xxx University(cux)应用到产品家族中
begin
  ad_pa_insert_package.insert_ad_pm_product_info(x_product_abbreviation => 'cux',
                         x_pseudo_product_flag => 'N',
                         x_product_family_flag => 'N',
                         x_application_short_name => 'CUX',
                         x_product_name => 'Xxx University',
                         x_product_family_abbreviation => NULL,

                         x_product_family_name => NULL,
                         x_aru_update_date => to_char(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                         x_currdate => to_char(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                         x_last_updated_by => -1,
                         x_created_by => -1);
  COMMIT;
end;

3.关联Xxx University应用到产品家族Oracle Xxx Suite下
begin
  -- Call the procedure
  ad_pa_insert_package.insert_ad_pm_prod_family_map(x_product_abbreviation => 'cux',
                          x_product_family_abbreviation => 'os_xxx',
                          x_aru_update_date => TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                          x_currdate => TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),
                          x_last_updated_by => -1,
                          x_created_by => -1);
  COMMIT;
end;


4.增加一个BUSINESS_ENTITY的lookup code(应用开发员职责->应用产品 -> 代码->Oracle Application Object)，这个Lookup会用在下一步的API中的@rep:category BUSINESS_ENTITY

这里增加的code为ORACLESEEKER


5.编写PL/SQL API Specification
CREATE OR REPLACE PACKAGE CUX_SUPPLIER_PKG AS
  /* $Header: $ */
  /*#