Data Integration
Discussion List
-
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 3 views 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 23 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
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 113 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 16 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 164 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 25 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 23 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… -
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 43 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 24 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 33 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 32 views 11 comments 0 points Most recent by Ckopparam EPM Platform and Freeform
-
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 3 views 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 44 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF?Summary: Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF, upload was success, no error logs were received, but the records was not showi…Anil Mattapally 26 views 1 comment 0 points Most recent by Lakshmi V-Oracle Payables, Payments & Cash Management
-
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 54 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
oracle account reconciliation : how to delete data by locationSummary: I need to delete data from two location only and not from all the location Content (please ensure you mask any confidential information): Version (include the v…