Data Integration
Discussion List
-
No records exist when Batch job is executed in Data ManagementSummary: When data load rules are run in Data Management, it successfully loads transactions but when the Batch job which contains the same data load rules is run, the p…Paulene Lomeda-Oracle 31 views 4 comments 0 points Most recent by Paulene Lomeda-Oracle EPM Platform
-
Replacement of Data Management features by Data IntegrationStarting in release 23.07 (July 2023) we will begin to incrementally turn off features in Data Management and direct users to use the similar features in Data Integratio…
-
DM clone for Gen2 issues with Explicit Maps performance - running 600% or more longer then ProdSummary: I have been having issues in our DM production application with increased times in the Staging and Validation stages - we are preparing to go live in GEN2 - it …
-
Error: java.sql.SQLException: Protocol violation on EPM Integration agentSummary: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agent_epm_zip_102x805297a3.html We used above doc to configured EPM int…
-
Don't See Currency in Data Management Data Load MappingSummary: Need to update mapping for currency, but don't see the dimension in Data Load Mapping. Content (required): I have a multi data type file that I need to update s…
-
EPMAutomate logout querySummary: Does using the logout command logout all instances of epmautomate connections for a particular user from a particular server to a particular service/environment…Jeremy Stubbs 32 views 4 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle EPM Platform
-
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…
-
Not able to see Hierarchy Top Node in Options tab in Data IntegrationSummary: Trying to setup metadata integration using ERP COA Application Content (required): Not able to see the TREE (Hierarchy) which is created in ERP in option tab. A…
-
The member [NONE] does not exist for the specified cube or you do not have access to it.Summary: The member [NONE] does not exist for the specified cube or you do not have access to it. However, there is nothing in the data load workbench with that value. C…
-
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 …
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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 …
-
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t…
-
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…
-
Connection between BI tool- and Data Lake platform with Oracle EPM podsHi All, Is there any way we can connect Oracle EPM cloud based applications to Power BI? Also, can they provide different ways to load data from Oracle EPM apps to Data …