Data Integration
Discussion List
-
How best do I create a Proforma scenario in FCCS?Summary A client wishes to have an "adjusted" Actual scenario that adds historical data from acquisitionsContent Since we would be entering new data into the past, this …JoachimB 39 views 3 comments 0 points Most recent by User_2025-02-05-23-45-21-053 Financial Consolidation and Close -
How to connect to FCCS using REST API ?Summary Requirement is to connect to FCCS data for post elimination with MS P-BIContent Hi There, I have an requirement to connect to the FCCS cubes to pull out financia… -
File based load that works will start failing if database isn't refreshedContent Hi. Wanted to see if something is common behavior or not. Please comment if you're seeing or not seeing this behavior (or you know what's going on). In all cases…ericerikson 28 views 4 comments 0 points Most recent by ericerikson Financial Consolidation and Close -
Data migration from Prod to TestSummary Getting warning message 'Essbase data import is only supported during create application'.Content I am trying to copy data from Production to Test instance by ta…Hari Nagumalli - Oracle EPM-Oracle 100 views 3 comments 0 points Most recent by Vasantha Kumar Raman Financial Consolidation and Close -
Data Management - Download Source FileSummary Data Management - Download Source FileContent Hi All, there is a short problem in "Data Management" section. From Data Management (Workbech section) we are not a…Antonio Barbaro 38 views 3 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
DM with FCCS: Too many objects match the primary key oracle.jbo.keyContent Hi all While trying to create 4 different cloud connections for the same user under Data management for FCCS, we have this error: Too many objects match the prim… -
Data Management Export from FCCS - two columns of amountsSummary Output of values in two columns (Amount, Quantity) - Depending on the accountContent Does anyone have an idea how I can export the amounts to two different colum…Bjoern Schumacher 53 views 5 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close -
Extracting data with Data Management - Two header lines requiredSummary data export file with two headlines requiredContent The system to be supplied with data from FCCS needs two header lines. The first header consists solely of 1;2…Bjoern Schumacher 45 views 2 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Substitution Variables in Data Exchange when Integrating with On-Premise EBS when utilizing EPM InteSummary Can a substitution variable be utilized in a Data Integration->Option->Filters for Ledger Name and Period when utilizing EPM Integration AgentContent We have con…User_2025-01-28-16-03-29-902 121 views 1 comment 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close -
Options for One to Many in FCCSSummary Options to Migrate One to ManyContent Hello all, have a client that performs a one to many allocation of gl balances. However, not sure what option to use. 1) Da…mhylton 28 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
DM - Mapping file is empty for only one dimensionContent Hello, I am using data management to integrate data. Usually I export the mappings to Excel file, setting the mappings and then import the file. However, now whe…Carolina Silva 32 views 1 comment 0 points Most recent by James Liaskos Financial Consolidation and Close
-
DM - Mapping accounts according sum valueContent Hello, Does anyone know if it is possible, in Data Management, mapping members according the sum of the data? I need to create the following mapping: If the sum …Carolina Silva 50 views 7 comments 0 points Most recent by Jeffry Kadarusman Financial Consolidation and Close
-
Mapping members - PerformanceContent Hello, Anyone knows if there are any performance impact on the member mapping (one by one) or through a group of members, mapping to a single member? Eg: - Mappi…Carolina Silva 37 views 3 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
Data Managment (DM)ExtractSummary We need to generate a extract from FCCS using DM and can see for few of dimesnions we are unable to extract Parent MembersContent We are trying to extract the da…user13680091 43 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
How to change default load options in Data Integration screen?Summary When loading data Export mode should be replace instead of No Export; Period Dec-30Content Hi, when we click on Data Exchange, we get the Data Integration screen…Joost Mellegers 38 views 4 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Valid intersection not affect the admins !!Content Hello, I configured a valid intersection rule for ICP transactions that specific account must come with ICP, however when users load the data through data manage…Hussein Mahmoud 52 views 1 comment 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Mapping Export Button DisabledSummary Mapping Export Button DisabledContent I need to export a mapping definition in Data Management, but the Export and Import buttons are disabled. Can anyone help m…Carlos Amaral 42 views 12 comments 0 points Most recent by Carlos Amaral Financial Consolidation and Close
-
Can we change the default value in export mode?Summary We would like to change default value in export mode from merge to replace when user execute data road rule.Content customer have default value - replace on thei…Quincy Chen 27 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Importing MetadataSummary Importing MetadataContent Hello : Maybe this is a very basic question. I have the EBS Chart of Accounts information from EBS that I need to populate into FCC. 1.…Martin Kinovisques-110450 41 views 7 comments 0 points Most recent by DariaM Financial Consolidation and Close
-
Using Integration Agent to load data from Oracle EBS to FCCSSummary Using Integration Agent to load data from Oracle EBS to FCCSContent Hi All, greetings. I was just wondering if any of you have used EPM Integration Agent to load…
-
Data Protection option in Data Management?Summary Is it possible to replace data in one Multi-GAAP member and leave the other Multi-GAAP members?Content Hi, we load with replace csv files to a FCC application to…Joost Mellegers 57 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Rest Service API Timeouts when performance testing future periodsSummary OFC loads fail in DM when performance testing more than 5 months in the futureContent We are performance testing FCCS 4D application and have seen dramatic impro…Brian Robinson 12 views 8 comments 0 points Most recent by Brian Robinson Financial Consolidation and Close
-
Running a Consolidation Rule in automatic after loading data from Data ManagementContent Hello All, I would like to know if it is possible run a consolidation rule in automatic from Data Management. At the moment, Users run manually the Consollidatio…Gianluca Natili 57 views 3 comments 0 points Most recent by Hari Jetti Financial Consolidation and Close -
Valid Intersections on Data ManagementSummary Do Valid Intersections block data entry through Data Management?Content I just want to make sure, if Valid Intersections work also when any user is loading data …User_0EW4B 167 views 5 comments 0 points Most recent by Silvie Mirek Financial Consolidation and Close
-
Unable to connect EPMAgent integration agentSummary Followed steps to connect EPM Agent, but getting an error.Content See image for error. Unable to connect EPM Agent. The following are the steps to connecting. 1.…User_2025-01-28-16-03-29-902 43 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Display Validation Failure MessagesContent Has anyone gotten the Data Management "Display Validation Failure Messages" output that came with the March 2020 update to work? It looks like it's supposed to b…ericerikson 52 views 1 comment 0 points Most recent by James Liaskos Financial Consolidation and Close
-
Data loaded from DM not behaving as expected for YTD and PRDContent Hi all We are loading data from DM in YTD data (FCCS_YTD_Input), then these data is transferred automatically in FCCS_YTD member and the system calculates FCCS_P…