Data Integration
Discussion List
-
Data Integration can only select first 6 target Plan typesSummary: We have a Freeform application with 8 Plan Types. When creating a new data integration to load from a file we can only see the first 6 of them in the target Cub… -
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 91 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM Agent SQL parametersWe have this source query which is working well (see below), but we need to add a bit to update the period value. For example, if the EPM period (~Period~) is 02 then @P…
-
Data Management Mapping question - when two different categories of mapping for the same dimensionI need to set up a Data Management Load rule to transfer data from CPX to FIN cube in a custom Planning application. The source of the mapping must vary based on whether…Partha Sikdar 11 views 3 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
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 22 views 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 21 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
-
1remove restricted characters within data integration for attributesSummary: Current data integration Edit Source Expression functionality is limited with regards to Restricted Character handling Content (please ensure you mask any confi…
-
Using encrypted key pair authentication to connect to Snowflake through integration agentSummary: We are trying to connect to Snowflake using a JDBC driver through integration agent. I've added the following to my .ini file: [AGENT_JDBC_CONNECTIONS] snowflak…bpepper 121 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
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 -
groovy rule to track changed data to get entities loaded via data management in FCCSSummary: Requirement: We are currently looking to optimize our data load process and are looking for a way to track which entities have actually loaded to the applicatio…Amarnath_Kothapalli 21 views 3 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Looking for a way to use Azure service principal for connecting to EPMSummary: Hi, Looking for a way to use the Oracle EPM API through azure service principal instead of service account for authentication purpose? Found the below blog but …Tushant Pandey 1 view 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform
-
Please advise on how to extract Data Management Workbench data before Logic Group logics are appliedSummary: We have a process to extract Data Management workbench data (using SQL query) for all the locations for any specific period. Our process is working fine. Genera…
-
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 -
Data Exchange Workbench Source Period Dimension pull AmountSummary: Hi all, I'm encountering an issue in Workbench: the "Source Period" column is showing amounts instead of the period dimension. I've already mapped the "Dimensio…
-
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,…
-
EPM Data File does not show Import Format/Map and how to export this?Summary: When creating the data export to EPM Data File there is no option to upload Dim names as a CSV. Once a target app is created as EPM data file it does not allow …NarayananS 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Connecting EPM Integration Agent to Snowflake using OAuth2 login possible?Summary: We currently have EPM Integration Agent setup connecting to Snowflake with ARCS using a static user/password and Credential Store of Cloud. Our Tech department …
-
Upload file REST .out file - POSTMAN Vs Manual uploadSummary: Upload file REST .Out file - POSTMAN Vs Manual upload behaves different. POSTMAN upload of .out file is successful but when same .out file tried for manual uplo…
-
When loading 0 rows, the system indicates its an errorSummary: We have recently created a pipline for data to flow between applications. But sometimes a data load rule inside of the pipeline does not contain any data. The s…Pieter-Jan Vandendriessche 51 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Custom Scripts UDA is not working in DM - #Custom{UDA([Account], "RLev0")} -Summary: #Custom{UDA([Account], "RPLev0")} - is not working in Dm data load other generic functions are working fine. getting this error a- 2025-03-17 23:37:02,698 ERROR…