Data Integration
Discussion List
-
Data Integration/Management Error HandlingWe have a flat file load which loads into our EPBCS application into a custom BSO cube. Our load failed because members in our Project dimension did not exist, but exist… -
Missing members but still loading dataContent: We try to load data using file as a source. Whenever members are unrecognized we receive an 3303 error and the data load fails. Sometimes during other integrati…Jeroen Goudvis 52 views 10 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Pipeline Sequence- Inconsistent Order when launchedSummary: Has anyone noticed inconsistencies with the order of the stages and jobs within stages when running pipelines? Is there a limit to the number of jobs within a s…Sara Beth Good-151018 41 views 2 comments 1 point Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
The requirement is to extract data from EPM backend tablesSummary: Hi Everyone, While doing the development, came across a requirement where customer needs the member id's along with the member names while extracting the data f…
-
how to use application substitution variables in PipelineSummary: We want to use substitution variables (Start month, end month) that defined at at application level in Data load rule. not able to find how to use it in pipelin…
-
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 32 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 41 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 51 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 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 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 52 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 …