Deploying REST Webservice using Oracle Integrated SOA Gateway and testing it using POSTMAN (with basic authentication)

In this post, we will understand how to use Oracle Integrated SOA Gateway to deploy REST webservices and how to test them using POSTMAN with basic authentication. For this we will be using sample User Interface which is provided by Oracle.

References:
NOTE:1311068.1 – Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2
NOTE:1317697.1 – Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2

Login with the user who is having access to Responsibility "Integrated SOA Gateway". We have logged in to user sysadmin. Click on Integrated SOA Gateway

Now click on Integration Repository

Click on Search button

In Business Entity textbox enter & select User and click Go button

You will be presented by list of all user interfaces, click on the below Interface:

Name: User

Internal Name: FND_USER_PKG

Below page will be displayed. Go to Tab "REST Web Service"

Enter any Service Alias like FND_USER_TEST and then select the service operations to expose. Here we have selected only one operation "Pre-validate EBS user" (Internal Name: ISUSERACTIVE). Finally click on Deploy button to finish deploying the web service.

Confirmation message will be displayed that your web service has been deployed.

Now go to tab Grants, select your operation and click on Create Grant button

On Grants page select the Grantee Type "Specific User" and click on search button in Grantee Name textbox

In Search textbox, enter the text "SYS" and click Go button. Matching values will be displayed. Click on quick select button to select the Grantee Name (Code: SYSADMIN).

Grantee Name will be selected. Click the Create Grant button to finish giving the grant for the selected operation.

Grant will be given and confirmation message will be displayed.

Now go to REST Web Service tab and click on View WADL link

WADL for the webservice will be displayed.

WADL URL will be like: <host-name>:<port>/webservices/rest/<Service-Alias>/?WADL

In WADL you will be able to see:

Now to test this webservice we will need the resource path. So our full resource path will be:

Base Path/Resource Path

Open the below URL to see the structure of input payload (type="ISUSERACTIVE_Input"):

Below XSD will be displayed:

So in this, input payload has two elements: RESTHeader and InputParameters
For testing this method you can skip RESTHeader (but try to see the RESTHeader.xsd)
InputParameters has one element: P_USERNAME
So now we know the Resource URL and input payload. So we can test the web service.
Open the POSTMAN. Enter the resource URL and select the type POST

Go to Authorization tab and select Basic Auth and enter username and password of Sysadmin (because we have granted the access to Sysadmin) and Click on Preview Request button to add this information to Header