Data Integration
Discussion List
-
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 22 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 22 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 41 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 93 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 11 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…
-
Moving from HFM to FCCS CloudWe have 5 yrs of Historical Data in HFM that we want to Archive. What are my options? Reason for not moving these in FCCS as I am told that the recociliation becomes a c…
-
Data exchange export job is not saving target file to outbox folder if specified with /Summary: Data exchange job that exports data to data target is not saving file to outbox/ folder. It works with backward slash though. It was working fine with outbox/ u…Itali Madhusmita 161 views 19 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Send Allocated Journals from Enterprise Profitability to Financial Accounting HubSummary: Hello Experts, I'm having a need to send the allocated journals from EPCM to FAH. Content (please ensure you mask any confidential information): Hello Experts, …NikhilDeshpande 21 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
Unable to pull all entities with defined UDA property with data managementSummary: I'm trying to extract all entities that have a UDA property of Tier2 using data management rule. Content (please ensure you mask any confidential information): …
-
Schedule Remove Cells with Zero ValueIs there a way to schedule a job to run the database properties function in Calc Manager, "Remove Cells with Zero Value", on a nightly basis for a specific database or a…
-
INFO [AIF]: EPMFDM-140274:Message - Import Mappings: Current DimensionsHi Experts - We are getting this DM error when we try to import mappings from OIC→EDM→FCCS. We have not changed any file format till now but still getting this error. Ca…
-
Rounding FDMEE - Issue decimal FormatSummary: Rounding FDMEE - Issue decimal Format Content (please ensure you mask any confidential information): Hi All, in my FCCS application I noticed an issue in export…Antonio Barbaro 21 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Issue while Importing ERP Cloud data into EPM applicationsSummary: Data is not getting imported into EPM application from Cloud ERP. Error at Import step. The request tries to Import data for 30 mins and eventually errors out C…