Friday, March 8, 2013

Generate Webservice / deploy / redeploy buttons not visible in Oracle E Business Suite (EBS)

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides robust communication and Infrastructure for Integration with E-Business Suite (EBS) Applications. Oracle E-Business Suite Integrated SOA Gateway is build on top of Oracle Fusion Middleware & Service Oriented Architecture (SOA) technology.

As a Integration Architect / Designer you will require to route your integration requests through Integrated SOA gateway to EBS for more standardize Integratiion approch. Oracle provide all Integration Interfaces detail at common location that is Integration Repository. You can create web service for supported Interface types using Integration repository. However to generate web services for respective Interface type you have to have appropriate roles and responsibilities assigned to your user.

Integrated SOA Gateway implements Role Based Access Control security for secure access to Interfaces.There are 3 different roles to provide different access to Integrated SOA Gateway.

  • Integration Repository Administrator
  • System Integration Developer
  • System Integration Analyst
Below table show each role and access to the features for respective roles. This roles have to be manually assigned to each user when required except for SYSADMIN.



This is most common issue while performing EBS Integration. You have to follow below steps for assigning appropriate role to the user and then user should be able see Generate WSDL button or SOA provider section is web services are already generated.

Option 1 :

user SYSADMIN user which is by default having appropriate roles assigned and you should be able to see Generate WSDL buttion.

Option 2:
Get the appropriate role assigned by requesting your system administrator. Below are the steps system Administrator need to follow to assign correct role for the user. So that user can have access to Generate WSDL / deploy / redeploy access.

1. Log into Oracle Applications using sysadmin/.
2. Select the User Management responsibility in the Navigator.
3. Click the Users link from the navigation menu to open the User Maintenance window.
4. Locate the user trying to use.
5. Assign the role and select the "Irep Administrator" role.
6. Bounce the middle tier because after assigning roles they don't take affect unless the cache is cleared and bounce middle tier.
7. Now log in as the user and access the " Integrated SOA Gateway" responsibility ->Integration Repository and should see the Generate WSDL button