Friday, 1 April 2022

FDMEE Integration to Oracle Cloud Financials with a Web Proxy

 

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.
 


 

No comments:

Post a Comment

Cannot execute maxl statement. Essbase Error (1200448): [For Input string: "0,00"]

Cannot execute maxl statement.  Essbase Error (1200448): [For Input string: "0,00"] Essbase 21c (EPM 11.2.18) Error with a smartvi...