Data Integration
Discussion List
-
Invalid Intersection in DM - Output FileSummary: Hi, When data is loaded on an invalid intersection in DM, it marks the process as failed on Export step and creates an output file of the invalid rows. In this …Alyssa Longo 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w… -
How to use the pipeline for data load in oracle account reconciliation?Summary: We would like to use pipeline for some sequence tasks including the data loads Content (please ensure you mask any confidential information): We would like to u…Omar Muhammed - PWC 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Downloading Validation errors report and restricting loading invalid intersections dataAt present in workbench there is no option to download Validation errors data. So is there any workaround to download this data? At present data in invalid intersections…Amara Sai Sandeep 81 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Where is Account Type stored for DM?Summary: We had an issue (still open SR under investigation) with a journal load from DM. When the journal rule was run, the end result was an OOB journal in FCCS. An As…Alyssa Longo 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Loading of entire Trail Balance to Closing Balance InputSummary: Hi All, Customer does not want to load zeros, in case no data is present for Balance Sheet specifically for January to have the reversed Movement as its increas…Mary John-Oracle 101 views 10 comments 0 points Most recent by Girish Joshi 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 121 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
add refresh job in pipelineSummary: I want to add refresh database, refresh members and metadata as a job in a pipeline. How can I do that as that option is not available in the drop-down menu. Co…Suravi 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 71 views 4 comments 0 points Most recent by Trey Daniel Financial Consolidation and Close -
Can Process Details from Data Exchange be Exported to excel?I’m trying to extract data to identify when the first trial balance for each location was loaded. The information is available in Process Details, but I’m unable to expo…Rekha S 81 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS (EPM) Backup & AutomationSummary: We would like to find out if any of you all have been successful in automating FCCS daily backup Content (required): We have a requirement to hold up to 60 days…Rihan Jameel 91 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
EPCM - Data Import and Export with a period range using EPM AutomateHi All, In Enterprise Profitability and Cost Management, I can load source balances for a range of periods in one go by specifying a start and end period in the UI using…Anantha Krishnan 31 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
How to remove dataload mapping of deleted lookup dimensionInitially during development , we have created some additional lookup dimensions and created mappings against this DM dimension. Later we deleted those Dimensions but fo…SrikanthReddy-Oracle 11 views 1 comment 0 points Most recent by NarayananS EPM Platform and Freeform
-
Performance issue with Writeback in Snowflake table using EPM Integration AgentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
-
How to pass POV as parameters in URL from EPM as drill through to FDISummary: Hi, We want to drill through to FDI using direct drill option from EPBCS and pass the FORM POV selection as parameters in the URL used in direct Drill. Users re…
-
FCCS Data Exchange - RATES Integration Issue - DATAVIEWSummary: We have configured a RATES cube integration, which is supposed to import FX rates from a CSV file into the FCCS RATES cube. We are unable to correctly map the V…Andreas Otto 41 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Derive Pipeline ParametersHi Community, We use Pipelines to optimize our processes. To make the process more secure, I am looking for a way to derive certain Pipeline variables from others during…Andreas Otto 31 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close
-
Batch to be replaced with Pipeline but how about Open Batch?Summary: "Pipeline is a replacement for the batch functionality in Data Management and can be migrated automatically to the Pipeline feature in Data Integration" as per …NarayananS 41 views 3 comments 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Set up integration with Fusion GL with custom cube in EPCMSummary: We are trying to fetch data from Oracle Fusion GL and want to set up integration with Oracle Enterprise Profitability & Cost Management. Can we have this inform…NikhilDeshpande 21 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management -
Source Period Not Available in FDMEE - Custom ApplicationSummary: Hi All, I created a custom application (Load_to_Oracle) in order to produce a txt file to load in a specific target system. In the custom Application I added th…Antonio Barbaro 11 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
EPM integration agent multi period import from on-premise file to data exchangeHi All, I am trying to do multi-period load using On-Premise File Data Source Application, but getting below error when it is trying to import dat file. Application Sub …Prem Siva Kumar Reddy Rami Reddy 21 views 4 comments 0 points Most recent by NarayananS EPM Platform and Freeform
-
Input Currency Journal Adjustment Load Via Data ManagementSummary: Can Input Currency Journal Adjustment be loaded in FCC Via Data Management/FDMEE Content (please ensure you mask any confidential information) Can Input Currenc…
-
FileName Variable in Run Time PromptsI have an integration rule in the data exchange for importing a data file, and associated with it, I have a business rule (Groovy) set to run on the "Before Import" even…Timestamp EPM Team 1 view 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Import Format "Factor" expression working twice for Admin Users for FCCS.Hi All, We have an import format , where the source amount is getting divided by 1000 (Factor = 0.001) and then getting loaded into FCCS. Ex. Source amount =12345678 , T…Twink-Oracle 1 view 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCCS data export issue on mappingSummary: Export to essbase contains the source member however mapping and workbench contains target member which causing the issue on member not found and failing the DL…
-
Request for Suggestions to Optimize Data Integration Run TimeHello Everyone, We have a data integration process that takes approximately 15 minutes to complete. This integration loads data into FCC, with NetSuite as the source sys…Srinivas Challa17 21 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Simple Tutorial: Import Text based Consolidation Journals via Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based Consolidation Journals using Data Integration and Data Management. Tutorial is used to …Ashutosh Bhatikar-Oracle 61 views 3 comments 3 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close