CloudIO - Oracle EBS Integration

Accessing CloudIO Application from Oracle EBS UI




Introduction

Applications running on CloudIO Platform can be accessed from Oracle EBS UI without having to re-login into CloudIO. CloudIO Application can be accessed in the following ways from Oracle EBS. CloudIO Application Screens can be opened as a standalone application or embedded within Oracle EBS OAF Header.


Menu Function


Tools Menu or Toolbar Icon (Zoom Functionality)

Oracle EBS Configuration

Steps to be performed on Oracle EBS side to integrate CloudIO within Oracle EBS UI.

Setup Profile

Define a profile XXRA_HOME_PAGE_URL as shown below



Ensure that the profile access is set to only Site Level.

Set Profile Value

Set the CloudIO Application base URL as a site level profile value for the above defined profile as shown below e.g. https://apps.cloudio.io or http://internal.cloudio.io:8080

OA_HTML Setup

Copy the provided ra.jsp & raframe.jsp files to $OA_HTML on all the Oracle EBS Application Middle-tier and compile using the following command
cd $OA_HTML
$FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'ra.jsp' --flush 
$FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'raframe.jsp' --flush
Note: Make sure to bounce oacore services after compiling the above jsp files.

Menu Setup

CloudIO Applications can be accessed through the Oracle EBS Menu Function, thereby users can click on the Standard Oracle EBS Menu Function to navigate to a screen on the CloudIO Application without having to re-login
Define a Form Function of type "SSWA jsp function" with HTML Call value as shown in the below table based on the target Page Type

Examples


Note: To pass role code as a parameter &rc=rolecode.

Eg., &rc='ORDER_MGMT_USER'

Add the above-defined functions to the required Menu as shown below


Tools Menu/Icon Setup (Forms Personalization)

In order to drill-down to a specific transaction from an Oracle EBS Form to a CloudIO screen using the Tools menu, you can use Forms Personalization to define a Menu & create a "Launch a Function" action as shown below




GWT Example

='raparams=$p$editcustomerheader%26_wcOMCustomerHeader%3D[custaccountid_%3D_' || :ORDER.SOLD_TO_ORG_ID || ']%26_wcOMOrderHeader%3D[headerid_%3D_' || :ORDER.HEADER_ID || ']%26forceLink%3DY%26target%3DmainTabs:orderTab%26global.oactivetab%3DY%26global.showalerts%3DY%26clearFilters%3DY' 

Where editcustomerheader is the page code and OMCustomerHeader & OMOrderHeader are the data sources to be queried and mainTabs:orderTab is the target Item Id and %26, %3D are the URL encoded values for ampersand (&) & equals (=) symbols.
AngularJS Example

='raparams=%23/app/dp-orderdetails/' || :ORDER.HEADER_ID 

Where %23 is the URL encoded value for hashtag (#).

Note: The above parameters string should be URL encoded i.e. #, =, & characters should replaced with their respective URL Encoded value. Refer to http://www.w3schools.com/tags/ref_urlencode.asp for more details.

Find below a sample CloudIO UI embedded within Oracle EBS

CloudIO Configuration

Steps to be performed on CloudIO side to integrate CloudIO within Oracle EBS UI

Authentication Provider Setup

Set the Authentication Provider on the Administration -> Setup page to "OracleAppsLocal" and bounce the CloudIO Server

Role Setup (Optional)

Check the "Auto Assign" checkbox on the Define Roles screen for the roles that should be automatically assigned to the Oracle EBS Users who are navigating to CloudIO Applications without having their username setup in CloudIO. During the first attempt to access CloudIO Applications from Oracle EBS Menu, CloudIO will automatically create a user account of type "OracleApps" and assign the roles that have Auto Assign checked.

RA_USER_SESSIONS

Create a synonym RA_USER_SESSIONS on the Application Schema "apps" for XXCLOUDIO.RA_USER_SESSIONS table.

Have questions about Oracle Applications vs. CloudIO?
Checkout our FAQs
https://cloudio.io/docs/oracle-applications.html