Data Integration
Discussion List
-
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 32 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
-
Exporting data such as smart list, date, text using data Data IntegrationSummary: Hello Team, I am trying to export data set with different types such as numeric, smartlist, and date in file using Data Export to File in Data Integration. Howe…Viral Soni 288 views 15 comments 3 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
ERP to EPM Adjustment period loads fail INFO [AIF]: Current polled request status is: WAITSummary: Hi, I am trying to integrate the Adjustment Period(13th and 14th period ) data from ERP to EPBCS. My DLRs with Adjustment period mapping runs for 30 mins and it…
-
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 43 views 3 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS ConnectorsHi Team, We are in a journey of integrating Oracle FCCS to Workiva, We have some Oracle seeded connector in Workiva which can pull Data,Metadata,Mapping & Snapshot. Woul…Ramya Kalaparthi 92 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Configure Snowflake connection with EPM Integration AgentI am trying to connect to Snowflake via the EPM integration agent. I have followed the documented steps. I am using a File Credential Store. I am now receiving this erro…
-
using substitution variable in source filter of EPM cloud outbound integration not workingSummary: I have an integration. EPCM as source and EPBCS as target and used Current Year substitution variable as a source filter. It is not working as expected. if I pa…Srinivas Bobbala 12 views 1 comment 0 points Most recent by Venu-Oracle Profitability and Cost Management -
Writeback to Oracle DB integration agent does not give error if the SQL insert is incompleteHi, I have a scenario in Oracle ARCS where i am doing writeback to Onpremise Oracle database using SQL in EPM integration agent. I am loading the csv file using insert q…