Data Integration
Discussion List
-
Resubmission of TB after loading STAT accountsContent Hi Team, We are following below data loading process as a standard load, However there can be a need of resubmission of Trial balance for some entities (In Repla…Kotak Pramit 21 views 2 comments 0 points Most recent by Kotak Pramit Financial Consolidation and Close -
Cutting of leading characters in Data Management (before Mapping)Summary A source system extract will change and we will need to cut of the leading 4 characters (or change all mappings)Content Hi everyone, an extract from a source sys… -
Data Integration - connection cloud to cloudContent Hi all Does Oracle support / facilitate Data Integration from Cloud to Cloud? I see that it is designed to pull data from on-premise to Cloud, but not Cloud to c… -
Using Substitution Variables in Data Exchange FilesSummary Using Substitution Variables in Data Exchange FilesContent Hi- Is there a possibility to use substitution variable as a suffix in Data Exchange output files? We …Amit Agarwal-158816 46 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Deleting data in Data ManagementSummary Data was loaded in Data Management by mistake. We want to delete it before Exporting to FCCSVersion 21.06Roshni Mohan 36 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data management security - FCCSContent Hi Experts, Can we restrict users from upload of flat file in data management folder? Basically users should be able to load data from those file which are alrea…
-
Direct-connect or Integration between two domains for data/ metadata sharingSummary We have FCC in US2 and Planning in US6, is there a way we can establish connection between two.Content We have FCC in US2 and Planning in US6, is there a way we …YogeshKJain 10 views 2 comments 0 points Most recent by YogeshKJain Financial Consolidation and Close -
How to reload data that has been exported in Data ManagementContent Basically, I need to change the sign of data on some accounts that need to be changed from Expense to Revenue. I have exported the relevant data from FCCS to a f…Klaus Andersen 21 views 1 comment 0 points Most recent by Harshith Rao Financial Consolidation and Close -
FCCS: Data Management: is it possible to do multiple Period Mapping at once?Content Hi All I see that at the moment it is only possible to create Period mapping one row at the time. Is it possible to create several period mappings at once? I cou…
-
FCCS YTD Input - Not Calculating PeriodicContent Hi All, I am loading Year to Date amounts for a client using the YTD Input functionality to calculate the periodic balances. The calculation doesn't seem to be t…Preston Oakes 77 views 3 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Scripting options in cloud Data ManagementContent Hi Experts, We are migrating HFM to FCCS. Client has FDMEE for integration in the on premise world with tons of customizations using custom and event scripts. Wh…Payal Kapoor-72335 40 views 5 comments 0 points Most recent by Payal Kapoor-72335 Financial Consolidation and Close -
How to configure data manager file base load to periodicContent I cannot find where in the data management setup you can set the view mode to periodic for a file based import so that it is treated as periodic in FCCS. FCCS au…User_2025-02-05-23-45-21-053 49 views 2 comments 0 points Most recent by User_2025-02-05-23-45-21-053 Financial Consolidation and Close -
FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL ChSummary FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL Changed)Content Hi Experts, It has been observed early this wee…
-
Drill through from FCCS to Oracle Fusion GL not workingContent We opened SR SR 3-25410502941 21 days ago with errors using the drill through from FCCS to Oracle Fusion GL. After loading the GL data into FCCS via DM, I click …scgonz 23 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
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 65 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 56 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 51 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 59 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 91 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 34 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 44 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