Skip to content

Configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6

Here I am going to explain how to configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6.

The E business suite integrated soa gateway configuration require a Oracle SOA suite  with weblogic on separate server.

Refer the document for how to install

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

In this note, Go to

Section 1: Configuring Oracle E-Business Suite Integrated SOA Gateway for SOAP Services on a New Installation of Release 12.2.3 or Higher

In this section , They mentioned to install oracle SOA suite server as per section 4

Here I had chosen  the below version of Oracle SOA suite to install on the separate server

  • For Oracle SOA Suite 11g and Oracle Applications Adapter 11g on Oracle WebLogic Server 11g

How to Install Oracle SOA Suite:

Download Oracle SOA Suite software from

Prepare a new linux server for Oracle SOA Suite

Complete  all the prerequisites on this server. (See my OBIEE installation guide for complete prerequisites activities)

Install  Oracle Database software and create a database for SOA Suite.

Install Jdk  (jdk-7u79-linux-x64.rpm)

Create repository creation for SOA

Select the below component while creating repository

–> AS Common Schemas –>  Metadata Services

–> SOA and BPM infrastructure –> SOA Infrastructure & Business Activity Monitoring & User Messaging Service

Install Oracle weblogic Server 10.3.6

Install Oracle SOA suite

Configure Oracle SOA Suite


Integartion SOA gateway :

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Go to Section 1.1: Setup Tasks on Oracle E-Business Suite Release 12.2.3 or Higher

Here you noted : ASADMIN password change, Try to change user management If you can’t see reset password field , change password using secutiry – users -define.

And also Weblogic and SOA gateway server address should be you mentioned which you are  installed Oracle SOA suite server and weblogic server address and ipaddress.

Section 1.2: Configuration Steps on Oracle SOA Suite to Integrate with Oracle E-Business Suite

Once done the above steps, you may go to Integrated SOA responsibility–> select your interface name or internal name  and regenerate the wsdl and deploy the SOAP service. please verify can you able to view wsdl file or not. If you can able to view wsdl  with soa suite server address, the SOAP service is working fine.









User ASADMIN does not have the privilege of deploying/undeploying composites

I am trying to deploy the SOAP service in ebs 12.2.6 with integrated SOA gateway. I can able to deploy the wsdl file but I can’t able to view wsdl files. The below error appeared when I try to open view wsdl file

“Failed to Load a composite for composite identified by default”

So I realized  the error seems to be part of SOA server. I looked the SOA server log from EM console. It shows below error

# START_TIME: 2016-11-17T11:16:46.968+03:00
# END_TIME: 2016-11-17T12:16:46.968+03:00

# /Farm_base_domain/base_domain/soa_server1/soa-infra:oracle_soainfra

[2016-11-17T12:00:57.533+03:00] [soa_server1] [ERROR] [SOA-21537] [oracle.integration.platform.blocks.deploy.servlet] [host:] [nwaddr:] [tid: [ACTIVE].ExecuteThread: ‘2’ for queue: ‘weblogic.kernel.Default (self-tuning)’] [userId: ASADMIN] [ecid: 005GNi0iuAiESO15zvg8yW00004y00001p,1:26140:36] [APP: soa-infra] [DSID: 0000LXlX7_9EOP15zvg8yW1OBMle000006] Sending back error message: User ASADMIN does not have the privilege of deploying/undeploying composites. Only users of SOAAdmin/SOAOperator role are authorized to deploy/undeploy composites..
[2016-11-17T12:01:17.366+03:00] [soa_server1] [ERROR] [SOA-21537] [oracle.integration.platform.blocks.deploy.servlet] [host:] [nwaddr:] [tid: [ACTIVE].ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)’] [userId: ASADMIN] [ecid: 005GNi1pk8XESO15zvg8yW00004y00001q,1:26142:37] [APP: soa-infra] [DSID: 0000LXlXCYjEOP15zvg8yW1OBMle000007] Sending back error message: User ASADMIN does not have the privilege of deploying/undeploying composites. Only users of SOAAdmin/SOAOperator role are authorized to deploy/undeploy composites..


So The ASADMIN requires some privileges in SOA server for deploying services.

Solution :

SOA Server Enterprise Manager Console

–> Weblogic Domain –> <domain name>

–> Security –> Application roles

–> Application Stripe — soa-infra

Select SOAAdmin roleand click edit, and add user ASADMIN

Select SOAOperator role and click edit, and add user ASADMIN


Again now  I tried to deploy the services, it’s working fine.

Oracle EBS upgrade from 12.2.0 to 12.2.6

Here I am going to explain about how to upgrade from 12.2.0 to 12.26 version.

Well, I hope you’re now successfully completed 12.1.3 to 12.2 version upgrade .So What is the next step to follow

First Step is you need to enable online patching, P

Enable Online Patching :

follow the below document for enabling online patching

1.Verify the database version

I hope you’re upgraded database to or  12c while during upgrade 12.1.3 to 12.2

2.Ensure that the required Database patches for Release 12.2 have been applied

Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade (Doc ID: 1349240.1)

check with, If you need to apply database patches or not. you please review the above document as well

3.Apply the latest Oracle E-Business Suite Online Patching Readiness and GSCC Report Patch

Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)

you need to apply the patch

  • 22200487:R12.AD.C Release 12.2 or higher

4.Run the Online Patching Enablement – Readiness Reports

Follow the instructions as per the document, you may get list or reports.  you may analyze the report and try to fix the EBS violations. If High priority violations, fix it before you start to apply enable online patch.

However , you should check with Oracle Support Team regarding those reports you got.

5.Fix Violations Listed in the Online Patching Readiness Report that Require Manual Intervention

Follow document

6. Verify database tablespace free space

Follow document

7. Run the Online Patching Enablement – Status Report

Follow document

8.Ensure that all middle-tier E-Business Suite services are shut down

Stop the service

9.Download and apply the Online Patching Enablement patch

Download and apply the Online Patching Enablement patch: 13543062:R12.AD.C. Use Autopatch in hotpatch mode to apply the patch (adpatch options=hotpatch,forceapply).

10. Compile Invalid Objects

connect with apps schema
exec sys.utl_recomp.recomp_parallel

Afterwards , follow the document and get the report again, try to fix the EBS violations.

Database Initialization Parameters

SQL> show parameter service_names

———————————— ———– ——————————
service_names string EBSUPGR, EBS_PATCH

SQL> show parameter recyclebin

———————————— ———– ——————————
recyclebin string OFF

If the _SYSTEM_TRIG_ENABLED parameter is set to false, then system triggers are not processed. The post Online Patching Enablement parameter must be set to true.

SQL> select x.ksppinm name,
y.ksppstvl value,
ksppdesc description
from x$ksppi x,
x$ksppcv y
where x.inst_id = userenv(‘Instance’)
and y.inst_id = userenv(‘Instance’)
and x.indx = y.indx
and x.ksppinm = ‘_system_trig_enabled’ 2 3 4 5 6 7 8 9 ;

are system triggers enabled

Upgrade to 12.2.6 :

follow the document

Apply the Latest AD and TXK for Release 12.2

refer this document

Oracle E-Business Suite Release 12.2: Suite-Wide Release Update Pack and AD/TXK Delta Information (Doc ID 1583092.1)

Section 1: AD and TXK RUP Information

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Please ensure required database patches applied or not ( and also check application patches as well (check

Database parameter

SQL> show parameter optimizer_adaptive_features

———————————— ———– ——————————
optimizer_adaptive_features boolean FALSE

Apply the R12.AD.C.Delta.8 and R12.TXK.C.Delta.8 Release Update Packs

3.1 Path A — Upgrade and New Installation Customers

Stop the all services and Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.

you should apply patch using adop, you can download those patches and put it in default $PATCH_TOP location.

remaining steps , follow the document 1617461.1


Mandatory Steps for Custom Schema Upgrade for 11i / 12.0 / 12.1

Follow the document

For creating a Custom application:

For the custom products that already exist, you must run adsplice on the Run File system to lay down the file system. For running adsplice, refer to

Creating a Custom Application in Oracle E-Business Suite Release 12.2(Doc ID: 1577707.1)

Apply the Latest Oracle E-Business Suite Release Update Pack for Release 12.2

please refer to Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

Once applied patches, you can see the application EBS version is upgraded to 12.2.6

Then  follow the Post upgrade steps

Upgrade oracle ebs 12.1.3 to 12.2.0

Here I have demonstrated how to upgrade your current EBS version 12.1.3 to 12.2.0.  I will write next part how to upgrade from 12.2.0 to 12.2.6

Step by step document for upgrade database to (Its required also, so download this document)


Step by Step document for update ebs version 12.1.3 to 12.2.0


catalog start with rman hangs

When I am trying to restore the full database to target new host,  I have used to catalog the backup piece but It took more time but not complete

RMAN> catalog start with ‘/u02/backup/backup/’;

Starting implicit crosscheck backup at 26-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 26-FEB-16

Starting implicit crosscheck copy at 26-FEB-16
using channel ORA_DISK_1


Solution :

Disable the recovery file destination, and then tried to catalog the backuppiece, Its okay now.

SQL> alter system set db_recovery_file_dest=” scope=both;


Setup DNS for RAC 12c implementation in virtual Box

If you are plan to implement rac setup in virtul box for your lab practise, you need to setup a dns configuration necessary steps to use single client access name (SCAN) introduced in 11gR2 RAC.

The DNS setup may be a separate server, or you can make it on any one of the nodes you’re preparing for rac implementation.

Here I have chosed to setup on rac first node, so you need to do some setup here

RAC First node :

Step 1:

Below rpm package need to installed on rac first node.

[root@racnode1 ~]# rpm -qa|grep bind


Step 2:

check named.conf file available in /etc/ and also /var/named, If it’s not available, Please copy those files from

[root@racnode1 etc]# pwd
[root@racnode1 etc]# ls
named.conf named.conf.bkp named.rfc1912.zones named.root.hints rndc.conf
[root@racnode1 etc]# cp * /etc


[root@racnode1 etc]# cd ..
[root@racnode1 sample]# cd var
[root@racnode1 var]# ls
named var
[root@racnode1 var]# cp -r named /var


Step 3: edit the file like below

[root@racnode1 var]# cat /etc/named.conf
// Sample named.conf BIND DNS server ‘named’ configuration file
// for the Red Hat BIND distribution.
// See the BIND Administrator’s Reference Manual (ARM) for details, in:
// file:///usr/share/doc/bind-*/arm/Bv9ARM.html
// Also see the BIND Configuration GUI : /usr/bin/system-config-bind and
// its manual.
// Those options should be used carefully because they disable port
// randomization
// query-source port 53;
// query-source-v6 port 53;

// Put files that named is allowed to write in the data/ directory:
directory “/var/named”; // the default
dump-file “data/cache_dump.db”;
statistics-file “data/named_stats.txt”;
// memstatistics-file “data/named_mem_stats.txt”;
forwarders {;};

key ddns_key
algorithm hmac-md5;
secret “gTsUbdMeXIAIOfeSUO6abZ2LkFqwOu3gKHih1Y4jqNEJeQXnnBM8S1xx”;

zone “” IN {
type master;
file “”;
allow-update { none; };

zone “” IN {
type master;
file “”;
allow-update { none; };

Step 4:  Create entries in zone file

[root@racnode1 named]# cat

$TTL 86400

@ IN SOA 2
1H )
101 IN PTR
102 IN PTR
111 IN PTR
112 IN PTR
201 IN PTR
202 IN PTR
203 IN PTR


[root@racnode1 named]# cat
$TTL 86400
42 ; serial (d. adams)
3H ; refresh
15M ; retry
1W ; expiry
1D ) ; minimum IN NS
localhost IN A IN A IN A IN A IN A IN A IN A IN A


Step 5: Start the named service


[root@racnode1 named]# service named start
Starting named: [ OK ]

[root@racnode1 named]# chkconfig named on

Step 6: resolv.conf looks like below

[root@racnode1 named]# cat /etc/resolv.conf

options timeout:1
options attempts:2

Step 6:

[root@racnode1 named]# nslookup rac-scan


Step 7:  Go to  second node

[root@racnode2 ~]# service named status
named is stopped
[root@racnode2 ~]# cat /etc/resolv.conf


options timeout:1
options attempts:2

[root@racnode2 ~]# nslookup rac-scan



Step 8: /etc/hosts file look like below on each node but don’t added scan address here

[root@racnode1 named]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail. localhost.localdomain localhost
::1 localhost.localdomain localhost6 localhost
# Public racnode1 racnode1 racnode2
# Private racnode1-priv racnode2-priv
# Virtual racnode1-vip racnode2-vip


Step 9:

[root@racnode1 named]# grep ^hosts /etc/nsswitch.conf
hosts: files dns

Backup the Siebel Gateway name server data

Its necessary to take the backup of siebel gateway name server data before or after making any configuration changes.  So you should take the backup of siebns.dat file

Application :

Administration-  system configuration –> Enterprises

Click Backup enterprise ( it will generate siebns.dat along with date in gateway server).

or Command prompt

[siebel@premiadb siebsrvr]$  srvrmgr /g premiadb /e MigEnt /u SADMIN /p  password

srvrmgr> backup nameserver
Command completed successfully.

We can use below command also

srvrmgr> backup namesrvr
Command completed successfully.


Backup location in linux :

[siebel@premiadb admin]$ pwd
[siebel@premiadb admin]$ ls -ltr siebns*
-rw-r–r– 1 siebel siebapp 117 Feb 4 10:34 siebns.dat
-rw-r–r– 1 siebel siebapp 1192361 Feb 23 14:45 siebns.dat_20160223_144538
-rw-r–r– 1 siebel siebapp 1192361 Feb 23 14:46 siebns.dat_20160223_144614


Step by step Siebel 15.0 Industry applications installation guide on Redhat Linux 6.2

Hello Guys, If you are looking the siebel installation guide on redhat linux 6 , this document will guide you to install  siebel 15.o industry application on redhat linux 6.2.  This document may be useful for you when you’re going to deployment siebel on your environment.

Download the document :

Step by step Siebel 15.0 industry applications installation guide on Redhat linux 6.2

User creation with particular directory access through FTP

Requirements :

Create a user

The user should not able to access through terminal like putty…etc

The user Should able to access his custom report directory path only with ftp client

the user need that directory path read and write permission

OS: Redhat 5.6 64bit

Step 1:

check below package are installed or not
[root@ebsdev ~]# rpm -qa|grep vsftpd

Step2 : If its not installed, install below rpm package

[root@ebsdev install]# ls
[root@ebsdev install]# rpm -ivh vsftpd-2.0.5-16.el5_5.1.x86_64.rpm
warning: vsftpd-2.0.5-16.el5_5.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:vsftpd ########################################### [100%]
Step 3:

[root@ebsdev install]# service vsftpd restart
Shutting down vsftpd: [FAILED]
Starting vsftpd for vsftpd: [ OK ]

Step 4: User creation

[root@ebsdev install]# useradd -g dba ftpuser
[root@ebsdev install]# passwd ftpuser

Step 5: Provide that directory path only access this to ftp user

[root@ebsdev ~]# chmod o+w /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US

[root@ebsdev install]# usermod -d /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US ftpuser

step 6: Disabled signon access for terminals

modified the line

[root@ebsdev install]# vi /etc/passwd




Step 7: allow chroot local user in ftp

[root@ebsdev vsftpd]# pwd
[root@ebsdev vsftpd]# vi vsftpd.conf

Add below Bolded line

# You may specify an explicit list of local users to chroot() to their home
# directory. If chroot_local_user is YES, then this list becomes a list of
# users to NOT chroot().

Step 8: restart vsftpd service

[root@ebsdev vsftpd]#service vsftpd restart

step 9: Try to login with credentials in ftp and also putty terminal

You can’t login in putty but you can able to login FTP with home path which directory you configured, you can’t go other directory. you have only that directory access.


Siebel ERP Integration performance issue

Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.

So I took the awr reports from both database  and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.

So i just went to siebel application and look the all components group log level ,How about ? Yes I found out there some of the components groups logging was enabled to 5, It should not be like always,  So I have decreased the default log level to 1 and clear that web service cache, and then I tried to push the transaction, it completed within 10 seconds.

And also i have disabled SOA auditing feature from ERP, Now data came within 4 seconds.