Data Integration
Discussion List
-
How to clear stored QTD and YTD from normal consolidation processSummary We are leveraging the Consolidate by View to help with performance and DB size and accidently ran the normal consol which stores data at QTD and YTDContent Due t… -
Round ReportSummary Rounding ProcessContent After completing the consolidation process, for reporting purposes, we need to apply a rounding at the account level. Not only applying s…Carolina Rodríguez Fleming 59 views 3 comments 0 points Most recent by Carolina Rodríguez Fleming Financial Consolidation and Close
-
Run an On Demand Business Rule before a data load in Data ManagementContent Hi all, Is there anyway in DM to schedule Run an On Demand Business Rule before a data load in Data Management? Best, yannisyanni vossos 43 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Passing parameters to Oracle Cloud Fusion - BI Publisher from Data MgmtSummary Having issues passing accounting period to Cloud Financials to pull subledger details to help automate Cash Flow in FCCSContent I am connecting to a custom BI Pu…
-
Data Upload ErrorSummary File Import is failing without creating any log file in Data ManagementContent Hi All, We are facing an issue with Test instance where data import in Data manage…Amit Kulkarni 55 views 2 comments 0 points Most recent by Amit Kulkarni Financial Consolidation and Close
-
Excluding one particular Level 0 member from Data Exchange exportSummary Excluding one particular Level 0 member from Data Exchange exportContent Hi - I have been doing one export from FCCS data exchange feature to a file. There is a …Amit Agarwal-158816 47 views 1 comment 1 point Most recent by Matt Maurer Financial Consolidation and Close -
Can we write TB validation rule (to ensure uploaded TB’s total is zero) in Data Management?Summary We are looking for a solution to add validation at Validation stage of TB loading processContent In existing setup system is considering availability of Data Loa…User_2025-02-06-06-07-43-641 46 views 2 comments 0 points Most recent by Kotak Pramit Financial Consolidation and Close -
Help with script in DMSummary Help with script in DMContent Hi All, is it possible to write a script in Data Management related to Location ID or Location Name? I tried to use PARTIONNKEY cod…Antonio Barbaro 58 views 6 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Loading Multi period figuresSummary Loading Multi period figuresContent Hi All, i need to implement an interface by using "Data Management" in FCCS in order to load figures of 12 months for a speci…Antonio Barbaro 26 views 3 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
FCCS - Handling Zero Balances when loading Closing Trial Balance through Data ManagementSummary Handling Zero Balances when loading Closing Trial Balance through Data ManagementContent We are currently loading the closing trial balance to 'Closing balance i…SKM 86 views 7 comments 1 point Most recent by User_2025-02-11-00-54-44-609 Financial Consolidation and Close
-
loading metadata from ERP CloudSummary loading metadata from ERP Cloud to FCCS using Data ManagementContent Hi everyone! hope you all are doing great. I have the following question, is it possible to …User_2025-02-05-00-34-04-259 33 views 2 comments 0 points Most recent by User_2025-02-05-00-34-04-259 Financial Consolidation and Close
-
data load rule executionContent Hello All, I have a possible issue when an User uploads data on Data Management using Data Load Rule execution. I have a data file with this header structure: SC…Gianluca Natili 42 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Data Export using Data Exchange in FCCS as a fileSummary Data Export using Data Exchange in FCCS as a fileContent Hi Friends, I am exporting data from FCCS in a file using Data Exchange Option. The file contains the da…Amit Agarwal-158816 57 views 3 comments 1 point Most recent by Amit Agarwal-158816 Financial Consolidation and Close
-
FCC Data Management Complex Logic AccountContent I am trying to create a logic account in FCC Data Management Complex Logic Account to aggregate a series of accounts I.E. 1001,1002,1003 and if the sum of these … -
Sending zero value to Closing balance input movementContent We noted recently that when zero value is sent to closing balance input movement (YTD_Input view) from Data Management (using 'Replace' when exporting), the syst…
-
Bank Balance Data to be available to a userSummary Bank Balance Data to be available to a userContent Hi Friends, I have a requirement to share Bank Balance data from FCCS to a user who doesn't have access to the…Amit Agarwal-158816 31 views 2 comments 1 point Most recent by Amit Agarwal-158816 Financial Consolidation and Close
-
FCCS Data management Replace mode creates opening balance offsetContent We use data management to load data in FCC. We load Life to date Balances. We use YTD input, Closing Balance input for ( B/S accounts) and Mvmts Net income for P…User_2025-02-11-00-54-44-609 81 views 2 comments 1 point Most recent by User_2025-02-11-00-54-44-609 Financial Consolidation and Close
-
Extracting large amounts of base data from FCCSSummary Requesting best method for extracting large amount of base level data from FCCSContent What is the best method of extracting large amounts of base data from FCCS…MKLC 63 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Loading YTD Revenue/Expense Values to Closing Balance Input MovementSummary Loading YTD Revenue/Expense Values to Closing Balance Input MovementContent When uploading Revenue/Expense Values to FCCS_ClosingBalance_Input Movement through D…
-
Enable Drill Region Gives ErrorSummary Enable Drill Region Gives ErrorContent Hey Everyone, Trying to enable Drill Region for FCCS Application in Data Management. I keep getting error. Has anyone face… -
FCCS - Blocking Data Loading for Future PeriodsSummary FCCS - Blocking Data Loading for Future PeriodsContent We are looking for a way to block trial balance loading through Data Management for future periods. Should…
-
Cannot extract data from Dynamic Calc members?Summary Trying to extract data from Dynamic Calc members but cannotContent Hi, I am trying to extract data for six lines in the Account dimension which are Dynamic Calc.… -
Extract journal data with the identification of the journal label using Data ManagementSummary Extract journal data with the identification of the journal label using Data ManagementContent Hello, Does anyone know if it is possible, with Data Management, e…Carolina Silva 35 views 6 comments 0 points Most recent by Klaus Andersen Financial Consolidation and Close
-
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… -
Reference Attribute values in Mapping ScriptSummary Reference Attribute values in Mapping ScriptContent Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O)…
-
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 25 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 90 views 3 comments 0 points Most recent by Vasantha Kumar Raman Financial Consolidation and Close