Data Integration
Discussion List
-
Calling Data Management REST API through scheduling PBC Groovy RuleSummary: We've built an Integration between ERP and PBC. We want to execute this integration every two hours for only a few days during a month. We want to automate this…Jeroen Goudvis 173 views 14 comments 0 points Most recent by Tim Good SC&H EPM Platform and Freeform -
Data Load Rule Convert character from source to numberSummary: Hello, I need to load data from an external source where one field contains a single character, ie, A, B etc. I need to convert this to a number in the target a…
-
How to Re-name Data Integration in PlanningSummary: We need to re-name Data Integrations in Planning? How can we do it? Content (required): We need to re-name Data Integrations in Planning? How can we do it? Re-n… -
Loading Text to Planning App - Considerations?Are there any best practices or considerations around loading text to an EPM app (Planning in this case)? I have ~6,000 bottom level members in the Entity dimension, and…
-
Data Load Rule still iming out after increasing Batch TimeoutSummary: Content (required): We have a data load rule that is consistently timing out within 5-6 minutes. We increased the Batch Timeout to 60 minutes but the data load …Paulene Lomeda-Oracle 128 views 5 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
How to merge columns in Import FormatSummary: Hello, I am doing a metadata build of the Employee dimension with source from an MSSQL table with multiple fields. The query I defined in Data Exchange pulls 3 …
-
Data Management - IGNORE like mapping being treated as a memberWe have a bunch of Multi Dimensional mappings for the Account dimension. We want to IGNORE any member that was not part of the previous mappings. When we do a * to IGNOR…Peter Joelson 948 views 8 comments 0 points Most recent by Jonathan A Cohen EPM Platform and Freeform
-
Exporting of attributes along with level 0 dataSummary: We have a ASO plan type from which we want to export level 0 data but at the same time we also want to extract attribute associated with the sparse dimension le… -
Is it possible to use OAuth 2 in pod-to-pod integrations?Hello, I am wondering if it is possible to use OAuth 2 when setting up pod-to-pod integrations in Data Management? Documentation only shows the ability to setup basic us…Christopher Jolie 53 views 2 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Push Budget from EPM Planning to PPMSummary: Push Budget from EPM Planning to PPM options Content (required): Looking for best practice recommendations. This is a non-Planning Module implementation Groovy …
-
Netwsuite integration fails when using System – Initialization with PBCS workbooksSummary: Content (required): We are using NetSuite Planning and Budgeting (NSPB) (built on Oracle Hyperion EPM technology). To connect it to NetSuite, in NetSuite we hav… -
Masking sensitive dataSummary: How do i mask some data (salary and wages) in DM or Planning? Content (required): I have a requirement to ensure none, including administrators should not be ab… -
EPM Integration Agent Stop Working from YesterdaySummary: EPM Integration Agent Stop Working from Yesterday Content (required): EPM Integration Agent Stop Working from Yesterday. I have checked the certification is sti…
-
How to use a semicolon as a character in a source expression without breaking everytingSummary: When using a semicolon within a source expression it's interpreted as a separator between stacked import format expressions and breaks up the expression, result…
-
Can you drill through to multiple currencies?Summary: We have two main reporting currencies that are users leverage, USD_Reporting and EUR_Reporting. I have enabled dill through data back for both currencies, howev…
-
How to transform (not map) the Source-Entity column based on another dimensionSummary: I'm trying to find a way to transform the Source-Entity based on another dimension, so that the result can still be mapped after. Content (required): Let's say …
-
EPM 22.04 Data Management JSONObject["Consol"] not found.Summary: EPM 22.04 introduced a bug when integrating FCCS with Planning. When calling a Data Management Extract -> JSONObject["Consol"] not found. There is no such chang…User_2025-03-07-20-48-43-319 83 views 8 comments 0 points Most recent by SureshM-Oracle EPM Platform and Freeform
-
Data Management Range Mapping to Wildcards, possible?Hi All! Is there any way we can have the mapping below with Sql script? Range from 92??-???? to 933?-???? mapped to 92??_???? to 933?_???? Thank you -
automate start period and end period input when executing DLR in data managementSummary: Content (required): We are currently working on a custom query integration to extract data from a BI report in the ERP side using data management in ARCS. We al…
-
Data Management - Lookup dimension in a metadata load?Is there a way to use a lookup dimension as part of a metadata load? When we tried to set one up for our Projects dimension. It only allowed "Generic" dimension (aka met…Peter Joelson 42 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
How frequently can we clear the 'Data' and 'Logs' folder under application folder for EPMAgent?Summary: Will it affect anything if I delete all the files under 'Data' and 'Logs' folder monthly? Content (required): EPM agent Version (include the version you are usi… -
Data Load Rule with Export Mode is Loading only One Record instead of Two in Data ManagementSummary: We have an integration to load Oracle GL data to Planning Cloud. I came across an issue in Data Management that out of two records for a statistical account onl…Ija Vidaurri 124 views 5 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
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…yanni vossos 136 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Best practices for updating EPM Integration Agent on Linux platformSummary: Hello experts, I'm looking for best practices of updating EPM Integration Agent on Linux Platform. Content: What are the recommendations to update Integration A…Ganesh Golla 42 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
How to check EPM Agent Run status on Linux machineSummary: We have configured the EPM Agent in asynchronous mode on OCI box (Linux). We need to monitor Agent run status. Content (required): To Monitor Agent status, we a…
-
EPM Integration Agent Unable to WriteBackSummary: Am trying to Writeback Forecast data from PBCS to On-premise DB and getting error which i am not able to fix. Content (required): Trying to export data from PBC…Amith Kumar Madisetty 44 views 12 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Integration Agent two different ARCS pods.Hi all, We need to clone our ARCS prod POD to test POD. Both instances have configured a separate integration agent. What will happen after the cloning to the test envir…yanni vossos 11 views 1 comment 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Integration agent two different FCCS pods possible?Hi all, As we migrating our FCCS application to enterprise license POD DSO, is it possible to connect to an existing integration agent from the old POD? Thank you yannis
-
Why Run Integration role doesn't allow user to browse and select file in DLR for data load uploadSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Exporting data from PCMCS with DM how do I round the output values to 2 decimal placesSummary round exported values from PCMCS to export fileContent There does not appear to be a way to export values from PCMCS with DM, so that the values are rounded to 2…Dawn Watson 101 views 7 comments 1 point Most recent by User_2025-02-05-23-55-14-602 EPM Platform and Freeform