Data Integration
Discussion List
-
Using Substitution Variables with Pipeline / REST API against ASO Target ApplicationSummary: Getting the following error when defining substitution variables for Pipleline variables or REST API periodname. EPMFDM-ERROR: {Month#Year} notation for Start/E… -
File import - tab delimiter not availableHi All I am using Data Integration to define an integration with a flat file source. When I select Tab as the delimiter in the File Options, I get a warning (Delimiter n…
-
Adding a space to the member alias when importing metadata to Data IntegrationSummary: The product alias is a combination of the product code plus the product description. Both are in a separate field and I want to concatenate those with: space hy…Jeroen Goudvis 34 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
3 Data Management/Data Exchange questions regarding data export to fileSummary: We have a requirement to produce an external file from EPBCS (BSO) cube, and it must be in a specific format, ie column layout, fill a column with a variable. 1… -
For YTD data load in FCC, what are the different ways to set up movement dimension?Summary: Please help with this query. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support yo…Kartikey Panday 42 views 4 comments 0 points Most recent by Kartikey Panday EPM Platform and Freeform
-
Are there plans to allows admins to run individual Stages in a Pipeline?Summary: The new pipeline functionality would be enhanced by allowing admins to either: A. Open a pipeline and run an individual stage manually Or B. Reference a pipelin… -
Drill through is not working properly for all entities in Oracle FCCS using data managementSummary: We have enabled drill region options in target application and used R13 as drill URL. Content (required): We are not able to see drill through option on data in…
-
Are there plans to add other Job Types to pipeline in future?Summary: At the moment, there's only a subset of job types available to add to a pipeline and our client is wondering whether this will be expanded in future. Content (r…
-
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… -
Mapping of Dimension Members between applications based on Alias to member?Summary: To my understanding, data can be pulled directly using DataExchange from Target Application. We are looking for a way to transfer data between 2 EPM Planning Cl…
-
Data Management Location folderSummary: After cloning EPBCS, location folders and its files are missing in target environment. Is it expected behaviour? How to restore them? Content (required): After …Meenakshi Rajagopalan 56 views 4 comments 1 point Most recent by Abderrazzak IDLAHCEN EPM Platform and Freeform
-
EPM Planning Dimension Export directly to SQLSummary: Greetings, is there a direct method of exporting a dimension in a Planning application to SQL (MSSQL or Oracle DB), via EPM Automate, ODI, Data Management/Integ…
-
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 53 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 82 views 5 comments 0 points Most recent by M. 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 55 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 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…