How to Create Web Service in Oracle EBS (Integrated SOA Gateway)

Step I

create one process package to deploy to database server ex. to XXTEST_INTERFACE_PKG.pls

in package test 1 PROCEDURE INSERT_AP_INTERFACE and 2 parameter in 2 parameter out

in package to add script 

CREATE OR REPLACE PACKAGE XXTEST_INTERFACE_PKG AS

/*#

 * This is the public interface for the AP Physical Invoice. 

 * It is provided to insert interface data from external system.

 * @rep:scope public

 * @rep:product AP

 * @rep:lifecycle active

 * @rep:displayname XXAP Physical Invoice Interface

 * @rep:compatibility S

 * @rep:category BUSINESS_ENTITY XXAP_INTERFACE

 */

--

-- Insert AP_INTERFACE (PUBLIC)

--   Insert interface data.

-- IN:

--          P_ORG       - Location

--          P_NUMBER       - Invoice Number

--          P_RESULT    - out parameter

--          P_ERROR_MESSAGE    - out parameter

/*#

 * Insert interface data

 * @param P_ORG Location

 * @param P_NUMBER Invoice Number

 * @param P_RESULT Import Resurt

 * @param P_ERROR_MESSAGE Error Message (if result is not OK)

 * @rep:scope public

 * @rep:lifecycle active

 * @rep:displayname XX Insert interface data

 */

PROCEDURE INSERT_AP_INTERFACE (

          P_ORG                IN  Number,

          P_NUMBER            IN  VARCHAR2,

          P_RESULT          OUT VARCHAR2,

          P_ERROR_MESSAGE   OUT VARCHAR2

);

END XXTEST_INTERFACE_PKG;

/

Step II

save package space to XXTEST_INTERFACE_PKG.pls and copy file space to program path in Oracle EBS

Step III

Run command 

$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=asadmin SQLAP:patch/115/sql:XXTEST_INTERFACE_PKG.pls:12.0=XXTEST_INTERFACE_PKG.pls

check error and fix. this command to gennarate .ildt to completed

Step IV

run next script

$FND_TOP/bin/FNDLOAD apps/apps_cps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct XXTEST_INTERFACE_PKG_pls.ildt

Step V

log in Oracle EBS by ASADMIN to check and deploy service

connect repose "Integrated SOA Gateway"

check service by search or check by a module in package script

to set Service name and deploy, check service to avaliable

FInish