Data Integration
Discussion List
-
Jobs in EPM IntegratorSummary: I want to learn more about running integrations. Content (required): I have three questions regarding integrations: - Can integrations be scheduled from within … -
Data Integration between FCC and Planning app is not workingSummary: Integration is stuck with status "Current polled process status is: RUNNING" Content (required): Hello All, One of my existing integration between FCC and Plann…Fred_Mamadjanov 51 views 7 comments 0 points Most recent by Fred_Mamadjanov EPM Platform and Freeform -
Data Loads now appearing in JobsSummary: Content (required): I noticed today that when I ran a data load batch, the data load was showing up in the Jobs recent activity list. This never happened before… -
Adding Stages to PipelinesSummary: Trying to test the new pipeline functionality in a Gen1 TEST environment, but when I try to add a stage, I see a "Refreshing" window with no ability to add stag…
-
Getting conflicting results performance tuning data map pushes, any Data Management gurus out there?Summary: While trying to performance tune running Data maps in EPBCS we are getting conflicting results, and we are not able to zero in on an optimal batch size. Content…Dawn Watson 81 views 5 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
Batch to Pipeline conversionSummary: Batch to Pipeline conversion Content (required): In 23.06.60 as expected I am seeing Pipelines are introduced. Based on what I understood from earlier Oracle ev… -
Limit Power User Access for LocationSummary: Content (required): Can you limit which locations a power user can load to in data management? We would like to limit them to one location, so they don't accide…
-
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 51 views 4 comments 0 points Most recent by Paulene Lomeda-Oracle EPM Platform and Freeform
-
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 …
-
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 92 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 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 132 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 961 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 51 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…