EPM account creation

[Ankky]

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

[rushikeshvartak]

{
"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"
}
}

[Ankky]

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.

[Dhruv_S]

Hi @Ankky 

Please refer to the below documentation. 

Reference: Understanding the Integration between EIC and Oracle EPM Cloud Service (saviyntcloud.com)

Preparing for Integration

Before you configure the integration, make sure that the following prerequisites are met:

1. 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

[Ankky]

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.

[Dhruv_S]

Hi @Ankky 

What is the error you are getting with IDCS URL?

Please share error snippet from the logs.

Regards,

Dhruv Sharma

[Ankky]

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"

[ravidave]

Hi @Ankky 

Unfortunately, currently Oauth is not supported for EPM connector. You can utilize our Ideas portal to submit an enhancement request.