Data Integration
Discussion List
-
Data Integration - MigrationHi all, I would like to ask you If anyone knows when the first stage of the migration to Data Integration in FCCS and PBCS will take place; In the previous Oracle Cloud … -
Does valid data still get loaded to FCCS if a data integration rule fails?Summary: We have always understood that if a user ran a data integration and it failed on export to FCCS (maybe because of invalid intersections) the WHOLE load failed. …Erringc 101 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
PCMCS - Data Management replaced by Data IntegrationSummary: Content (required): Hi, Since DM will be replaced by the new Data Integration by September, do you know where I can find it on PCM? I know that e.g FCCS has a m…Timestamp EPM Team 51 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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…
-
Lock Data Location in Data IntegrationSummary: Currently - I lock each data location in DM at the end of each month. Content (required): Switching to Data Integration - is there somewhere to lock the data lo…Casey Kempel 121 views 8 comments 0 points Most recent by Jose1234 Financial Consolidation and Close
-
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 61 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 …User_2025-12-19-01-50-28-141 41 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
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 -
Backup import failed due to special characters German Umlaut ä ü öI try to rename an application. My first attempt to create an empty application with the new name and import the backup file failed due to the error message there exists…Mueller 21 views 1 comment 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
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… -
Export of data with data management and suppression of zerosIn step 1 - when importing the data from FCC into Data Management, the zeros are suppressed. (by default) In step 2 - if the accumulation of rows in Data Management resu…Bjoern Schumacher 153 views 2 comments 0 points Most recent by User_KKXP6 Financial Consolidation and Close
-
data exchange validation checkerSummary: In Data Management, under the mapping section, there is a VALIDATE button which checks your maps are using a valid target dimension member. Is there currently s…
-
Export mode Replace in Data Management does not zerolize YTD valuesSummary: Export mode Replace in Data Management does not zerolize YTD values when there is no line of data for a given POV Content (required): We noticed that exporting …MCV 191 views 8 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Is it possible to copy one scenario to another, including performing math on source data?Summary: Copying Scenario A to Scenario B, with Scenario B's data being scaled/rounded to thousands. Content (required): I have a DLR to load data to Scenario A. I would…SAW23321 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
GL Integration with Oracle Tax ReportingSummary: Can Oracle GL Integration be done with Oracle TRCS using Data Management. Also, can the GL data be pulled in real time or upon a refersh? Content (required): Ve…
-
FCCS_110 rule to load 0 in place of #missingSummary: Need to write a config consol rule to replace #missing values with 0 Content (required): DSO application. I'm running into a variant of the issue where an accou…SAW23321 341 views 20 comments 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Has anyone tried an integration between Oracle Fixed Assets module to TRCS?Summary: Has anyone successfully done an integration (by Data Management) b/w Oracle FA to TRCS. I am trying to do it through a flat file by setting a connection as Data…
-
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 61 views 4 comments 0 points Most recent by Paulene Lomeda-Oracle EPM Platform and Freeform
-
Default Export Mode in Data IntegrationSummary: In data management -> target application -> application options -> Default Export Mode. We put the value as Replace. Is there a way to do that in data integrati…Casey Kempel 62 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close
-
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 …