Integration
Discussion List
-
Updated EPM balances are not reflected in ERP/GL essbase cubeSummary: We updated balances for a few accounts in EPM planning and pushed it to ERP GL using the ERP writeback job in DM. We are seeing all the balances are showing up … -
New Data Map Functionality is erroring out because member mappings not supported in the releaseWe are trying to map data from WFP to Financials using the new Member Mapping benefits. We get the following error: Why is this an available feature if it errors saying …
-
Cloud Data Management Flat File formatSummary: Content (required): When using Cloud Data Management for flat file exports, is there a way to rename the business dimension's field name when the default is "UD…
-
Groovy Data Movement Across ApplicationsSummary: Hi Experts, In the past, I have successfully used Groovy scripting to move data around within a cube, or between cubes in an Application using the GridBuilder o…
-
Error while loading Account Metadata from ERPSummary: Error in loading Account Metadata via BIP report Content (required): Hi All, Here i'm trying to load Account Metadata from ERP via BIP report. getting the below…
-
#SQL counter mapSummary: Hello, I'm building a new DM integrations and I was wondering if it's possible to build a #SQL mapping like the following: The condition depending on the value … -
How do I exclude the header row when importing dimension in a delimited file?Summary: I am importing a custom dimension using Data Management from a tab delimited file which has headers. The integration works perfectly, except that an error occur… -
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f… -
Downloading CSV files from EPBCS Inbox/Outbox Explorer using Groovy scripting and REST APIHi guys, We are trying to download CSV files that are published in Inbox/Outbox Explorer in EPBCS application. We tried to download these files using REST API using Scri…
-
EPM GL Budget write back to GL budget, does this require the all CoA segment defined as dimensionsSummary: The client wants to create the GL budget in EPM and once approved the budget will be written back to GL. In order to transfer the EPM budget information to the …
-
Export to file map / manipulate data "dimension"Summary: Map/manipulate data field in data management Content (required): We want to manipulate the values which are included in an export to file integration. We are ru…
-
Member Mapping in Data Map not AvailableWe are trying to setup data maps using the new member level mapping functionality. However, when we try to launch the data map we get the following error (we are in the … -
ERP Cloud BIP Report to EPBCS for loading Account dimension keeps failing!Hi All, I have created a BIP report in ERP Cloud, and while running the integration in data management it keeps failing with the following error: 2022-04-06 09:33:52,266…
-
Unable to add dynamic children in EPM via REST API CallSummary: In an attempt to automate the process of metadata sync between HCM cloud and EPM. I created an integration to leverage on atom feeds generated from the HCM solu…
-
FYI - The Out-of-the-box "OWP_Headcount Data for Reporting" uses an out-of-date FTE memberI could be crazy, but a while back OWP_FTE was adjusted to have a member for OWP_Total FTE that is used to FTE reporting, but OWP_FTE is used for calculations. Just an F…
-
Integrating NetSuite data to PlanningSummary: Incorrect data loaded into Planning from NetSuite Content (required): I have built an integration using Data Management to source my GL data from Netsuite and l…
-
Netsuite metadata integration parent issueSummary: We are using the default Netsuite metadata saved searches to retrieve the metadata from Netsuite for multiple dimensions. The data which is retrieved is not as …
-
Budget Write back EPM to ERP GL (mapping parents in EPM to base members in ERP)Summary: I have this requirement, where I need to push total value from parent members in EPM dimensions to one base member in respective dimension on the ERP side. This… -
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
Issue while loading Existing employees data in EPBCS WorkforceSummary: Issue while loading Property value in EPBCS Workforce Content (required): Hi All, I'm trying to load Existing Employees data to EPBCS Workforce from HCM Cloud,w…
-
How to apply 2 parameters in application filters to integrate BIP report in PBCSSummary: Hi All, Can anyone please help me on how to apply 2 parameters in application filters in target application->application filters in FDMEE to integrate BIP repor…
-
OAuth 2.0 Encryption REST APISummary: I see EPM Automate having an update for encrypting OAuth2.0 refresh token and client ID for accessing OCI (Gen 2) EPM Cloud environments. Is there a plan to inc… -
DM: Export dimension attributes from Data ManagementSummary: Content (required): Hi all Can someone please confirm if we can export from EPM Data Management Dimension attributes? I see that it is possible with EDM, but no… -
File name for download on data management load rule is not referenced?Summary: It is possible to set the name of the export file in the data load rule options. However, when the data load rule is ring the file produced is in the format of …
-
EPM Drill Through Resulting in SmartView "Cannot Connect to Provider" ErrorSummary: Drill through to the data stage (i.e. new sheet or web browser) has been working without a hitch, However now receiving the SmartView "Cannot Connect to Provide…
-
Can *End Users* import data into PBCS using Data Exchange?Admins can run Data Management processes in PBCS, no problem (via both the Data Exchange GUI, or Data Management). I am trying to allow regular users (or power users) to…
-
Is there a way to delete existing members in Planning using a DM integrationSummary: Is there a way to delete existing members in Planning using a DM integration. In Data Management, when we build a Metadata Integration is there a way to delete …