Data Integration
Discussion List
-
Mapping Audit ReportIn FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a…Brian Duncan 21 views 2 comments 0 points Most recent by Brian Duncan Financial Consolidation and Close -
audit log changes property of accountSummary: We want to track the changes on the property for the account members in the audit logs. Content (please ensure you mask any confidential information): When upda…Silvia Vilchis 71 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How do you obtain last modified date for a data integration within data exchange within Freeform?We only see the last executed date within the data exchange screen and we our audit report does not pickup any modifications we made to the data integration. Looking to …C Vincent 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Historical Rate disappears after data reload from DM using the replace modeSummary Historical Rate disappears after data reload from DM using the replace modeContent Hi all We are experiencing a strange behaviour from FCCS to which we would lik…NK2025 49 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Dummy dataSummary: Request for FCCS Dummy data for testing purposes. Content (please ensure you mask any confidential information): I do require sample multi-periods trial balance…Sarwar 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Reference Attribute values in Mapping ScriptSummary Reference Attribute values in Mapping ScriptContent Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O)… -
EPM agent is getting StuckSummary: EPM agent is getting stuck/Freeze Content (please ensure you mask any confidential information): Dear all, One year ago, we configured an EPM Agent and it was w…Ethien Eid 41 views 8 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
How to copy rate using pipeline?Summary: Error while executing pipeline to copy rates from P12 to P13 Following steps were followed to copy the rate from P12 to P13 using Pipeline: Create a copy rate p…SAJ 101 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Split Adjustment Periods for BS and PL in Data Integration?Summary: Need to load different adjustment periods for BS and PL accounts from Oracle ERP Cloud GL to FCC using Data Integration, but limited by the single-source-applic…ShanqiDaFu-Oracle 21 views 1 comment 0 points Most recent by ShanqiDaFu-Oracle Financial Consolidation and Close
-
Job scheduling in FCCS for first 10 days in a close cycleSummary: We want to trigger the data load pipeline daily from the 1st to the 10th of each month. How can we achieve this using job scheduling in FCCS? We do not want to …AishShirke 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
View member FCCS_YTD_Input does not behave correctly when importing dataSummary: View member "FCCS_YTD_Input" does not behave correctly when importing data from Application\Overview\Actions\Import data. The YTD values in the file are stored …Arild Bjorsvik 32 views 3 comments 0 points Most recent by Arild Bjorsvik Financial Consolidation and Close
-
FCC: Restrict Security for Users in Data IntegrationSecurity Setup to restrict users in Data Integration is msissing. Our business case foresees users who need to trigger a data integration and access the Data Load Workbe…Andreas Otto 33 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
Conditional Source Expression with Concatenation as outputSummary: We are migrating HFM Import scripts to cloud. I am planning to leverage Conditional expression to achieve similar functionality but it is not working. Basically…SrikanthReddy-Oracle 1 view 1 comment 0 points Most recent by Guixdx Financial Consolidation and Close
-
SAP S/4 Hana Connector to EPM applications (FCC/EPBCS)Summary: Does Cloud EPM (FCC/EPBCS) have SAP S/4 Hana Connector to pull data & drill through features? Content (please ensure you mask any confidential information): Ver…
-
How to export the Data Management/Data Exchange job details using EPMautomate?Summary: How to export the Data Management/Data Exchange job details using EPMautomate? Content (please ensure you mask any confidential information): Client wants to mo…Harshith J Rao 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
RestDataGrid error in integration Fusion - EPMSummary: This month, the system gave an error in the transfer of data from ERP to EPM. The error is "RestDataGrid_XXXXXXXX is invalid". I saw other people having the sam…Pieter-Jan Vandendriessche 11 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Why do the data load process steps vary?Summary: We've noticed that the five steps in the data load process vary. The last step sometimes says "consolidate data for consolidation application mmm-yy" and someti… -
FCC REST API GET Approval unit StatusSummary: Dear Community, We are currently setting up an Oracle EPM FCC instance and need the ability to read the Approval Unit Status for our planned Data Integration. O…Andreas Otto 77 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What are the recommended steps to follow for closing business operations from one countryHi All, Our client based out from US and is planning to close the UK operations. Can someone please provide what are the recommended steps to follow to close out all the…
-
ORA-00001: unique constraint violated ERRORSummary: We found this error on FCCS Data Integration with ERP CLOUD Content (please ensure you mask any confidential information): From FCCS Data Exchange > Application…Stefano Francese 1 view 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
Data Management Issue – TB Files Deleted & Mappings RevertingSummary: Is anyone experiencing issues in Data Management where TB files that were uploaded into a folder are being deleted unpredictably, and mappings are unexpectedly …B.Bhandari 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS tables for data similar to HFMSummary: Hi, We have one audit requirement requesting for FCCS schemas, tables, and databases in FCCS which contains data in backend. Do we have anything as such for fcc…Sud VJ 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can I use the 'Description' field in a Mapping with SQL Script?Summary: I'd like to use the 'Description' field (available in the workbench) in a SQL script for the mapping. Content (please ensure you mask any confidential informati…
-
Data with natural sign in FCCS (No Flip sign in data management)Hi All, We have a requirement to keep natural sign in FCCS rather than flipping the sign in data management. but the challenge is, If we don't flip the sign, data won't …Ashok_Yadav 22 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Data Management connection with Active Directory UserSummary: Is there a way to user Active Directory User or SSO user to configure data management connection ? Content (please ensure you mask any confidential information)…VineetPathak 11 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Data Exchange - Logic GroupHello friends! We have a situation in a customer Environment, that we use Logic Group in Data Management to replicate some data. But in the Data Exchange menu, I do not …Guido Zanella 21 views 3 comments 0 points Most recent by Guido Zanella Financial Consolidation and Close -
Migrate particular Data Integrations from Test to ProdSummary: Migrate particular Data Integrations from Test to Prod Content (required):I have created New data integrations in Data Exchange in FCCS Test Env. I would like t…Amit Agarwal-158816 41 views 2 comments 0 points Most recent by Harry Zhu Financial Consolidation and Close -
Exploring Automation Options for Loading Exchange Rates from Oracle ERP Cloud to FCCSHi Community, I’m currently exploring different approaches to automate the loading of exchange rates from Oracle ERP Fusion Cloud into FCCS. As part of this exploration,…
-
Loading FX Rates via Data ManagementSummary: Hi All, We are trying to load FX rates into FCCS Rates cube via DM and are running into issues. The data imports and exports fine but we do not see the rates lo…User_2025-02-12-04-44-51-669 403 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
What kind of file extensions are considered as invalidBased on Oracle EPM Apr'25 What's New, Block Upload Of Files With Invalid File ExtensionsMay I know what kind of file extensions are considered as invalid?Jennifer Kh'ng 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close