Data Integration
Discussion List
-
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 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 96 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 15 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…
-
Create Drill regionClient is trying to drill back to workbench via SmartView. We have enabled Create Drill Region in our integration options and loaded the data. I am able to drill back to…
-
Account Lock Issue Despite Successful Login in EPM AutomateSummary: Account Lock Issue Despite Successful Login in EPM Automate Content (please ensure you mask any confidential information): Hi All, I scheduled the IF account to… -
Guidance Required for Setting Up OAuth2.0 Connection Between FCC and OIC with Different IDCS DomainsHello Oracle Community, As part of our current project, we are working on establishing an OAuth 2.0 connection between Oracle Integration Cloud (OIC) and Oracle Financia…Vijay_Babu 41 views 2 comments 0 points Most recent by Akshay Dharne Financial Consolidation and Close
-
Sending data from EPCM to FAHHi everyone! We have a requirement that we need to send the allocated data from EPCM to Oracle FAH. Does Data Exchange/Data Integration have the option to connect to FAH…GaryYip-Asc 41 views 5 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
For filebased data load is happening in FCCS Data load rule, will only rejected records be skipped?Summary: When running a data load rule to load records in FCCS from file, there are records rejected due to invalid intersections, will none of the records be loaded or …Arvind Moorthy-250185 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to load FCCS YTD actual load to EPBCSSummary: We are trying to pull the YTD value for FCCS_Minority Interest to push to EPBCS, however, per checking it is still pulling the Periodic value. Does anyone encou…User_ZCB13 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
pipeline, variables and a "prompt" to choose a versionSummary: Allow administrators, when running a pipeline, to specify which data "version" is contained in a load file—without requiring this information to be embedded wit… -
data exchange Import issue Applying Amount MappingSummary: I am facing issue during Import step of Data Exchange. Below error: It is allocation data writeback from EPCM to ERP. Integration is able to extract data out of…Ravinder Singh-63390 31 views 11 comments 0 points Most recent by Ckopparam EPM Platform and Freeform
-
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…PrinceKumar 21 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Multiple Adjustment Periods in Data Management for ARCS Data LoadSummary: Hello Everyone, I am working on ARCS Data Loads using Data Management and would like to check if anyone has experience with configuring multiple adjustment peri…DarshanJ 1 view 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Issues Importing Maps in Data Exchange/Management with Comma in Source ValueSummary: We have a number of maps that utilize commas within their Source Value definition. This has never presented as a problem, as wrapping them in double-quotes duri… -
SmartView give errors: Drill through not being availableSummary: The issue appears to be mostly around parent accounts, but I have seen child accounts get the same error as well. when i am trying to do the drill through form …User_8OIEK 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close