Single Sign On (SSO) Setup from Oracle EBS to Triniti Application / eWorksheet

Software Requirements: Winscp, Putty, VPN.

Details required to login to server using winscp: Hostname, port number, username and password for that particular instance.

Step 1: Connect to VPN, if you are not in that network where server resides.

Step 2: Login to winscp using the server details, Open putty using command "Ctrl+P" and then switch to sudo user, using below command:

sudo -i -u sudo_username_here

and provide password

Step 3: Copy Custom JSP (tri2ssourl.jsp - This jsp is attached to this blog page at the end. Don't forget to change url "http://hletkdev.global.triniti.com:8680/tabimpl/jsp/basicjsp/logon.jsp" in that JSP to which ever instance you need to redirect) into Oracle EBS to $OA_HTML path. To know $OA_HTML path, run below command in putty:

echo $OA_HTML

If nothing is displayed by that command, then request the DBA Team to check the issue with environment variable $OA_HTML.

Once the issue is resolved, Go to that $OA_HTML path(what ever path is displayed by the echo command) in winscp, copy(drag) the jsp from LOCAL to $OA_HTML path in server.

Step 4: Compile the Custom Jsp

Compile the custom JSP page by running the below commands one by one:

cd $FND_TOP

ojspCompile.pl --compile -s tri2ssourl.jsp --flush

If "command not found" error comes, Then run the below command.

echo $FND_TOP

If nothing is displayed by that command, then request the DBA Team to check the issue with environment variable $FND_TOP.

Once the issue is resolved (or) if it is showing path for FND_TOP, run below command:

export PATH=$PATH:$FND_TOP/patch/115/bin

Run this command and try again Step4.

If the JSP compilation is successful, you will get messages as below:

[appldev@hlr12dev 12.0.0]$ ojspCompile.pl --compile -s tpmssourl.jsp --flush

logfile set: /Data/HLR12DEV/inst/apps/HLR12DEV_hlr12dev/logs/appl/rgf/ojsp/ojspc_error.log

starting...(compiling all)

using 10i internal ojsp ver: 10

quick compile:

files to compile...1

translating and compiling:

translating jsps...1/1 in 1s

compiling jsps...1/1 in 1s

Finished!

If JSP compilation got failed. Then open the error log, which was shown as logfile set(as highlighted above) in your putty command line "/Data/HLR12DEV/inst/apps/HLR12DEV_hlr12dev/logs/appl/rgf/ojsp/ojspc_error.log".

If you find the error in that log as below:

[11354] !!COMPILATION ERROR(0) tpmssourl.jsp:

_tpmssourl.java:17: package org.apache.commons.codec.binary does not exist

import org.apache.commons.codec.binary.Base64;

_tpmssourl.java:198: cannot find symbol

symbol : variable Base64

location: class _tpmssourl

byte[] encoded = Base64.encodeBase64(trinitiId.getBytes());

Note: _tpmssourl.java uses unchecked or unsafe operations.

Note: Recompile with -Xlint:unchecked for details.

2 errors

[11354] compiling: 2s elapsed, 0 successful 1 failed

COMPILED: 1 [failed: 1] in 2s

The reason for this is, commons-codec jar which contains org.apache.commons.codec.binary.Base64 class is not loaded. We need to add the jar to below mentioned classpath.

By default, the jsp compiler script uses following configuration file

$INST_TOP/appl/admin/ojspCompile.conf

This conf file has a classpath field in it which is usually pointed to file

$INST_TOP/appl/admin/ojspCompile.properties

This property file lists the classpath used for JSP compilation.

So if commons-codec jar is not listed in this file, the jsp will not compile by ojspCompile.

1. Download commons-codec jar.

2. Copy to some custom path.

3. And add the path along with jar name to ojspCompile.properties file.

4. Bounce the server.(Refer Step7 for help).

5. Go to Step 4.

Step 5: Create a form function with type"SSWA jsp function" and HTML call as "tri2ssourl.jsp"

Navigation:

First login to EBS portal -->Select Functional Developer -- >Core Services-->Functions --> Click on Create Function

here fill the required details like below:

click on continue

click on apply.

Step 6: Add this newly Created function to Menu in Oracle EBS

Navigation:

Logon to Oracle EBS portal with valid credentials. Select System Administrator -- > Application -- > Menu

In this example, we have used Order Management Super User, Vision Operations (USA) Responsibility with this existed Menu ADS_OM_SUPERMENU.

Note: For query mode press f11 after entering search criteria press ctrl+f11.

Here we need to give the details as like below. Here we need to add new record by clicking plus symbol.

Here Prompt will be the name of the link which is visible in portal (any name can be given). Function name should be selected from list of values which we have created in the

previous step.