Data Integration
Discussion List
-
Attribute Columns getting loaded with only Start Position of 1 - not pointing to correct column #Summary: I am connecting to a Custom Oracle Fusion BI Report - I have everything linked correctly and all the UD fields are populating correctly, however; when I try to … -
False error from Batch execution in Data ManagementSummary: False error from Batch execution in Data Management Content (required): We have been getting this false error message from Batch execution in DM "EPMAT-1:EPMFDM… -
Are there any known issues between EPM Integration Agent and EBS v9.2?We have been using the Integration Agent with EBS numerous times successfully, but running into a very puzzling problem. Our usual process is to connect directly to the …Mike Falconer-160618 91 views 4 comments 0 points Most recent by Fred_Mamadjanov EPM Platform and Freeform -
Batch in Data Management gives a false green check when the Load Rule has failedSummary: Batch in Data Management gives a false green check when the Load Rule has failed Content (required): Batch in Data Management gives a false green check when the…
-
Data Management/Data Integration Performance TuningSummary: A new section of the admin guide has been released that discusses performance tuning strategies for Data Management/Data Integration. This is a great place to s…Mike Casey-Oracle 181 views 1 comment 7 points Most recent by Ganesh Golla EPM Platform and Freeform -
How to import non-numeric & numeric data to multiple accountsSummary: I'm trying to import employee data through data management for NetSuite PBCS. Content (required): We have employee number, department, and subsidiary. The non-n… -
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 172 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 131 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 956 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 81 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 41 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 121 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 131 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 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform