This works out off the box in the 11.2.x release but there's a few things to do if your web traffic is routed through a proxy.
In FDMEE add Select Source System, add Type 'Oracle Financials Cloud' and enter a Name/Desctiption
ODI Context Code 'GLOBAL'
Save and then hit 'Configure Source Connection'
Enter the URL in the format below plus username and password (must be a native user in OFC)
https://fusion-name.fa.ocs.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL
Hit 'Test Connection':
Ouch....
Check the process log and you may find a similar error
INFO [AIF]: Standard Error: javax.xml.ws.WebServiceException: Failed to access the WSDL at: https://fusion-name.fa.ocs.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL. It failed with:
Connection timed out: connect.
The connect timed out error may indicate that your web traffic goes through a proxy.
Here's the fix on the FDMEE Server:
1) Navigate to ..\Oracle\Middleware\user_projects\epmsystem1\bin\deploymentscripts
Edit File setCustomParamErpIntegrator.bat
a) Add the following options to the JAVA_OPTIONS section:
-Dhttps.proxyHost=<Proxy Server> -Dhttps.proxyPort=<Proxy Port>
b) If it's a Windows server, add two more JVMOptions to the Windows registry.
First you must update the JVMOptionCount and increase the decimal value by 2.
Then add new keys:
Example:
JVMOption51 -Dhttps.proxyHost=<Proxy Server>
JVMOption52 -Dhttps.proxyPort=<Proxy Port>
2) Navigate to ..\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\FusionCloud
Edit file FusionCloudAdapter.bat
a) Update the Proxy Server/Port
details:
set
customProxyHost=<server name>
set customProxyPort=<port>
b) Update JAVA_OPTS to
remove the quotation mark ( " )
set
JAVA_OPTS="-DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%
-DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% -Dhttps.proxyHost=%customProxyHost%
-Dhttps.proxyPort=%customProxyPort%
-Dweblogic.security.SSL.ignoreHostnameVerification=true"
to
set
JAVA_OPTS=-DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%
-DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% -Dhttps.proxyHost=%customProxyHost%
-Dhttps.proxyPort=%customProxyPort%
-Dweblogic.security.SSL.ignoreHostnameVerification=true
Restart The FDMEE Service.
Hit the Test Connection again.
Lovely....
Note if you are using the 11.1.2.4 release you will need to update to a later version of Java as the one shipped with this release does not support TLS 1.2 or higher of which OFC uses versions 1.2 and 1.3 (Details on how to do this in Doc ID 2351499.1).
An indication of this would also be in the process log:
INFO [AIF]: Standard Error: javax.xml.ws.WebServiceException: Failed to access the WSDL at: https://fusion-name.fa.ocs.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL. It failed with: Received fatal alert: protocol_version.