CloudIO - Oracle EBS Integration
Accessing CloudIO Application from Oracle EBS UI
IntroductionApplications 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.
Tools Menu or Toolbar Icon (Zoom Functionality)
Oracle EBS ConfigurationSteps to be performed on Oracle EBS side to integrate CloudIO within Oracle EBS UI.
Setup ProfileDefine a profile XXRA_HOME_PAGE_URL as shown below
Ensure that the profile access is set to only Site Level.
Set Profile ValueSet 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 SetupCopy 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 SetupCloudIO 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
Note: To pass role code as a parameter &rc=rolecode.
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
='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.
='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 ConfigurationSteps to be performed on CloudIO side to integrate CloudIO within Oracle EBS UI
Authentication Provider SetupSet 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_SESSIONSCreate 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