Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
03/18/2024 10:48 AM
Hello experts,
We are in process of on-boarding EPM connector in EIC. We are able to sucessfully add/remove access from EPM pods, however, we are unable to create account.
Could someone please confirm the EPM URL format that needs to be added to connection. I believe, it should IDCS URL but the connection is failing with IDCS URL.
Thanks
03/18/2024 11:34 AM
{
"FinancialApplication": {
"URL": "https://epm-test-a545690.epm.au2.oraclecloud.com",
"POD_NAME": "epm-test"
},
"PlanningApplication": {
"URL": "https://planning-test-eklm-test.pbcs.au2.oraclecloud.com",
"POD_NAME": "planning-test"
}
}
03/18/2024 11:41 AM
Thanks for the response, @rushikeshvartak
These are the POD URLs which are working fine. Could you please confirm what should be mentioned as EPM URL.
03/27/2024 09:39 PM
Hi @Ankky
Please refer to the below documentation.
Reference: Understanding the Integration between EIC and Oracle EPM Cloud Service (saviyntcloud.com)
Before you configure the integration, make sure that the following prerequisites are met:
Get the Oracle EPM Identity Domain URL from the Oracle EPM team. The domain name in this URL is specified in the EPM_DOMAIN, EPM_API_VERSION, and EPM_REPOSITORY parameters while creating the connection with Oracle EPM.
Sample URL: https://planning-test-abc-test.pbcs.us2.oraclecloud.com
Regards,
Dhruv Sharma
03/27/2024 11:17 PM
Hello @Dhruv_S ,
Thanks for responding.
I had gone through the document already. We received a URL from application team which is working with OAuth authentication via postman but the I don't see a way to configure OAuth in connector. Could you please confirm if EPM connector supports OAuth authentication? Also, Please confirm the exact API being invoked while creating the account.
Thanks.
03/28/2024 05:53 AM
Hi @Ankky
What is the error you are getting with IDCS URL?
Please share error snippet from the logs.
Regards,
Dhruv Sharma
04/02/2024 12:45 AM
Hi @Dhruv_S,
Below is the error we are observing in logs:
"2024-03-29T11:52:56.763+00:00","ecm","","null-q98g7","","org.springframework.web.client.HttpServerErrorException: 500 Internal Server Error at com.saviynt.connectorms.ConnectorMsHelperService.testConnection(ConnectorMsHelperService.groovy:644) at com.saviynt.ecm.integration.ExternalConnectionCallService.testExternalConnection(ExternalConnectionCallService.groovy:1042) at com.saviynt.ecm.utility.domain.EcmConfigController$_closure21.doCall(EcmConfigController.groovy:769) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:159) at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62) at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59) at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69) at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82) at java.lang.Thread.run(Thread.java:750)"
"2024-03-29T11:52:56.373+00:00","ecm","connectorms.ConnectorMsHelperService","http-nio-8080-exec-3-q98g7","ERROR","Error occurred while testing OracleEPM for connection LRP"
"2024-03-29T11:52:56.763+00:00","ecm","","null-q98g7","","org.springframework.web.client.HttpServerErrorException: 500 Internal Server Error at com.saviynt.connectorms.ConnectorMsHelperService.testConnection(ConnectorMsHelperService.groovy:644) at com.saviynt.ecm.integration.ExternalConnectionCallService.testExternalConnection(ExternalConnectionCallService.groovy:1042) at com.saviynt.ecm.utility.domain.EcmConfigController$_closure21.doCall(EcmConfigController.groovy:769) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:159) at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62) at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59) at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69) at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82) at java.lang.Thread.run(Thread.java:750)"
"2024-03-29T11:52:56.373+00:00","ecm","connectorms.ConnectorMsHelperService","http-nio-8080-exec-3-q98g7","DEBUG","Status to return is false"
04/04/2024 06:33 AM
Hi @Ankky
Unfortunately, currently Oauth is not supported for EPM connector. You can utilize our Ideas portal to submit an enhancement request.