Data Integration
Discussion List
-
CopytoObjectStore feature in pipeline doesnot copy file from Data Management specific locationSummary: I am using CopytoObjectStore feature in pipeline to copy file from Data Management specific location to Object Storage. In source path, I have selected Inbox an…Priyesh P. Rane 11 views 3 comments 0 points Most recent by Priyesh P. Rane EPM Platform and Freeform -
How do you "review the newly created schedules"?Summary:Looking for clarification on how to complete step 4 in this guide. This is related to the functionality being sunset in Data Management and being moved to EPM Pl… -
Export business rules and pipeline using EPM AutomateSummary: Hi Oracle, We want to export business rules and pipelines using EPM Automation command or any other automation so we can automate the process Version (include t… -
Executing Validate & Export for a Long List of Entities in Data Management After Mapping AdjustmentsHi everyone, I’m looking for a way to run a long list of import rules in Data Exchange that only includes the Validate and Export steps. The goal is to reload data for a…Bjoern Schumacher 11 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
data management epm cloudSummary: FCCS data management section expiring date Content (please ensure you mask any confidential information): does anyone know the official date of when data manage…samuel valecchi 11 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
FX Rates integration working in FCC but data does not get loadedSummary: I'm running an integration to load FX Rates into the Rates cube. All the steps work successfully on the workbench, but when I try to see the data through SmartV…Joao Carlos Monteiro 52 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Sending Budget Data to Fusion Cloud in 'Add_Data' Mode via EPM Integration AgentHello everyone, We are working on transferring budget data from an Oracle database to the Budget Control module in Fusion Cloud using the EPM Integration Agent. Here's a… -
Workiva connection identifiersSummary: Trying to find Identifiers for Workiva Connection Content (please ensure you mask any confidential information): Can someone please direct us how to pull the fo…andeemote 134 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
pipeline change logSummary: Is there a log (hopefully in the Audit Log) that shows date/time/UserID of changes to an existing pipeline Content (please ensure you mask any confidential info…Russ 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Exporting attribute values while exporting data into a file using DMSummary: While exporting data into a file from EPM application using data Integration, is it possible to export attribute values as well. For example, If we have Project… -
The form RestDataGrid_xxxxxxxxxx is invalid.Summary: We are seeing this error when loading the data into FCCS from ERP. What does this error mean? Can you please help us? Content (please ensure you mask any confid…Divya_Masoodi 41 views 2 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close -
Map default_movement in accounts dimension to a movement member in data exchangeSummary: We have created customized movement dimension members for our current client and utilized the default movement attribute in the account dimension. However, we e…Jane Wang 61 views 11 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close -
Drill Through from summary not working in FCCSummary: I've set Create Drill Region and Enable Drill from Summary to "Yes" and reloaded the data. Drill through works when you try drilling from a base-level member bu…Joao Carlos Monteiro 31 views 2 comments 0 points Most recent by Joao Carlos Monteiro Financial Consolidation and Close -
Integration fails with not so common error msgWe have a file based data load to FCC system and it has failed with a very strange Error msg: ERROR [AIF]: The rest service request has failed: 400 - {"status":400,"deta…MKhade 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Filter out amount less than 0.0001 in Data extract in FCCSWe need to filter out records that are between 0.0001 and -0.0001 while extracting data from FCCS application. We explored Skip row , however it is available in Data Int… -
created the schedule but not able to see it under the worklist once I created itSummary: We are testing in a Test POD and a schedule was created but it is not in the Worklist Content (please ensure you mask any confidential information): Version (in… -
When zero is loaded to a Historical Amount Override account, the zero is not recognizedWhen zero amount is loaded to a Historical Amount Override account, the zero is not recognized in FCCS in Parent Currency after consolidation runs. Instead, the Parent C…Jacalyn Munyon 11 views 4 comments 0 points Most recent by Jacalyn Munyon Financial Consolidation and Close -
How to Set Up Integrations from Workday to Oracle EPM CloudSummary: We are trying to figure out how to set up an integration from Workday Financial Management to Oracle EPM Cloud. My only search result is to use Oracle Integrati… -
Availability of Reference Tables in EPM PBCS for Scripting/MappingHello All, In On-Premise Oracle Hyperion Planning, we have / can access the following tables that can be referenced in scripts: Table --> Info HSP_TEXT_CELL_VALUE --> Ce… -
FCCS YTD Data Extract from FCCS to a file using Data Integration produces file with only headersI am trying to pull YTD data from FCCS into a file using Data Integration. I see rows in workbench with correct periodic numbers but the data file that gets generated on…Karthiga Devi Ramanathan 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Are there technical specs available for the file based import method under data integration?Summary: Is there a technical doc that outlines the EPM system controls used in the file-based integration method? Content (please ensure you mask any confidential infor…MarshaH 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Extracting Data from FCCS for YTD without Data ExchangeSummary: Hi, Currently, users use HFM Extract data load option to extract data from HFM. However, they want to have similar option in FCCS but they do not have access to…Sud VJ 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Pipeline feature using EPM commandSummary: Pipeline feature triggering EPM command and EPM automate command triggering pipeline Content (required): Is there any EPM Automate command to trigger pipeline? …Ramsha Ansari 831 views 13 comments 3 points Most recent by DJ Banga Financial Consolidation and Close -
Recommended Approach to Data Pull if Primary Ledgers & Secondary Ledgers are in Different CurrenciesSummary: In our current set-up we are pulling Primary Ledger data in functional currency for all countries using standard PBCS data integration (into No Multi GAAP dimen… -
Task Manager connection to Oracle ERP fusionSummary: Task Manager Integration to Oracle ERP fusion Content (please ensure you mask any confidential information): Hello, I am trying to integrate FCC Task Manager wi…Rashmi Subash 84 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close