Data Integration
Discussion List
-
In Data Management->Data Load Mapping->Export to Excel does not show dimension detailsSummary: In Data Management->Data Load Mapping->Export to Excel it downloads an Excel. In this Excel in the Map tab there is a drop down for all the dimensions. SO when …rahul shinde-Oracle 31 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close -
Create drill regionSummary: Hello, now that we've migrated our EPM environment to Gen 2, I am unable to find the option to enable "Create Drill Region", as this is no longer available from…
-
Groovy script:restricting the usage of data load for common dataruleSummary: Looking for solution via groovy in FCCS : if user one has trigger the remote dataload pipline from FCCS for PCMCS then the process should be locked for rest of …Sreekumar Hariharan 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange - Data Export Planning ErrorSummary: Client wants a data export from a custom RevCOGS cube. They want account and period in the rows, and the DATAEXPORT business rule command requires a dense dimen…Nicholas Ho 94 views 15 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Disable check step in Data managementSummary: We are looking for a way to disable the check step in Data Management. Content (please ensure you mask any confidential information): In the Data Management Wor…Alyssa Longo 21 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Extracting YTD data from FCCS using Data ManagementSummary The attached document explains how to extract YTD data from FCCS using Data ManagementContent The current Essbase implementation for FCCS includes the view dimen…Mike Casey-Oracle 664 views 12 comments 3 points Most recent by User_IHTKW Financial Consolidation and Close -
Is there a way to extract manual consolidation journal entries using a data load rule?Hi, Our business clients currently post some consolidation journal entries at a parent entity member level and I was wondering if there was a way to extract those entrie…Sarah Paroya 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Snapshot/Clone incomplete, does not include data management workbenchContent workbench content is not included as part of clone/snapshot migration this is an issue when we need to clone an FCCS LIVE environment to troubleshoot the integra…User_2025-03-07-20-48-43-319 43 views 4 comments 1 point Most recent by Ritesch Malhoe Financial Consolidation and Close
-
Why is there a difference loading data with service administrator and user loads to FCCS app?Currently we are loading data at our client through data exchange. When we loaded our dec-23 data we found that the numbers in PL and BS were not the same when we loaded…Ritesch Malhoe 41 views 4 comments 0 points Most recent by Erringc Financial Consolidation and Close
-
Integration from EPM to ERP via BIP report is not workingSummary: Integration from EPM to ERP via BIP report is not working. It errors out in the 1st step with invalid parameters requested Content (please ensure you mask any c…AniN 42 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Pushing data from FCCS to client's on-premise HFM applicationSummary: The requirement is to push data from FCCS to client's on-prem HFM system. Requesting your recommendation/best practices regarding whether this integration (Data…Giridhar Kumar-280189 51 views 3 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
FCCS pipeline to run PCMCS rule setSummary: Hi Mike Casey, We are trying to find out the whether the FCCS pipeline can call PCMCS rule sets We have created connection in FCCS (for PCMCS) Created a pipelin…Sreekumar Hariharan 103 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Drill Through from PODSummary: I'm working with my Cyber security team and I'm building a case for a Web Server the architected defined to allow drill through to Oracle (OCI) PS tables via th…Jeff Gilliam 32 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
How to load parent member (store data type) with dynamic cal children account?Summary: I did integration from FCCS to PBCS but always failed to load parent member (store data type) with dynamic cal children account. FYI In FCCS the parent account …
-
Data Management Loading Differently for Power Users vs. AdminSummary: Data seems like it is loading differently for Power User's vs. and Admin into FCCS. Content (required): We have recently loaded data into FCCS using a Power Use…Matthew Gregory-137392 141 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Load Oracle Fusion GL to FCCS - P13 DataSummary: Content (please ensure you mask any confidential information): I'm trying to load P13 Trial balance data from Fusion GL to FCCS as normal using data integration…
-
Data Management : Unknown Member [Company] used in querySummary: We are in Data Management and we are importing data from ERP Cloud to FCCS. Import does not run if i set a single source company on Data Load Rule Filter. Conte…Stefano Francese 51 views 2 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close -
Unable to get "Parent Currency" expression in Data Export to File option in FCCS Data ManagementSummary: Data Load Rule has been created to export all the data in FCCS to flat file and in DLR filter, Against currency dimension, "Parent Currency" is used. When we ge…Harshith J Rao 11 views 2 comments 0 points Most recent by Harshith J Rao Financial Consolidation and Close
-
Data Integration Pipeline Administration Mode failingSummary: I am adding the Administration Mode As per documentation regarding pipeline, but it keeps failing, we have Type: EPM Platform; Job Type: Administration Mode; I …Vero Ortiz 81 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Super user cannot Export data using Call AIP. Getting error that user doesn't have privilege.Summary: We wanted use API Call to export the information created in the Jobs. Super user has Data integration roles (Drill Through, Run, Create) but still we are gettin…wojciech.furmanek 31 views 4 comments 0 points Most recent by wojciech.furmanek Financial Consolidation and Close -
Can a User run a pipelineSummary: Is there any way that a "User" can run a pipeline, removing the dependency on the Service Administrator? Content (please ensure you mask any confidential inform… -
Where can I see jobs scheduled via Data ManagementSummary: I schedule jobs via Data Management but I cannot edit or see the schedule. I can only see jobs that have run. Is there a way to schedule jobs and see the schedu…Catherine Arnold 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Currency for Data Import in FDMEEHi, I am using FINCLOUD as the source for FDMEE location, with the destination being a text file. In the Data Load Rule's Source options, I specified the Currency as "En…Sneha Mallick 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to export Data Load Workbench details, Process Details and Logs in FCCS Data Management?Summary: To understand the process to export Data Load Workbench details, Process Details and Logs in Data Management from one FCCS instance and import it into another F…Sujith Kandukuri 66 views 2 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Errors importing Data Management report templatesSummary Not able to import modified report template files to Data ManagementContent Hello everyone, In Data Management I've extracted and modified a report template (rtf…User_MB094 22 views 2 comments 0 points Most recent by JeroenDrupsteen Financial Consolidation and Close
-
Can we still use the same data load if the flat file is changing?Summary: We currently have a flat file provided to us from a vendor. This flat file is loaded via a data load rule. We have the import format mapping defined based on th…Casey Kempel 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is Oracle Decommissioning Data Management in FCCS?Description: To understand if the end users need to perform any activities in case Oracle is decommissioning data management in FCCS and shifting the functionalities to …Sujith Kandukuri 95 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Run integration export mode only None availableSummary: When trying to run the integration and load a csv file to FCC, the export modes Replace and merge are not visible, only a lot of None. Content (please ensure yo…Joost Mellegers 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Is there a check reports to set a condition for data load via Data Integration / Management?Summary: Content (please ensure you mask any confidential information): Hi all in FDMEE we could use this check report: https://docs.oracle.com/en/applications/enterpris…NK2025 21 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Copying select data from one scenario to another complicated by journalsSummary: I want to copy a subset of data from one scenario to another scenario. Using the Data Copy function, the problem I'm having is with the journals. If a journal h…