Data Integration
Discussion List
-
Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet?Summary: Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet? Content (required): Does anyone have a procedure for loading currency rat…Phil Nibert 31 views 1 comment 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close -
Error in loading data from Erp Cloud GL (essbase db) to FCCS.Hi all, Its been a very straightforward scenario, where I need to load Actuals ERP cloud data in to FCCS, please see below all my data / member maps, this i swhat im get…yanni vossos 44 views 3 comments 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close -
Is it possible to move a Data Input form from an application to another?Summary: Content (required): Is it possible to move a Data Input form from an application to another? We need to move a data form from Test to the Live application, is t…FT96 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
can we export data attribute dimension using data managementSummary: can we export data attribute dimension using data management Content (required): can we export data attribute dimension using data management Version (include t…
-
Procedure to end date / deactivate a natural account in FCCSSummary: Procedure to end date / deactivate a natural account in FCCS Content (required): Checking to see if Oracle or anyone has a procedure to end date / deactivate a …Phil Nibert 46 views 4 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
Data Integration - MigrationHi all, I would like to ask you If anyone knows when the first stage of the migration to Data Integration in FCCS and PBCS will take place; In the previous Oracle Cloud …
-
Does valid data still get loaded to FCCS if a data integration rule fails?Summary: We have always understood that if a user ran a data integration and it failed on export to FCCS (maybe because of invalid intersections) the WHOLE load failed. …Erringc 91 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Lock Data Location in Data IntegrationSummary: Currently - I lock each data location in DM at the end of each month. Content (required): Switching to Data Integration - is there somewhere to lock the data lo…Casey Kempel 122 views 8 comments 0 points Most recent by Jose1234 Financial Consolidation and Close
-
Export of data with data management and suppression of zerosIn step 1 - when importing the data from FCC into Data Management, the zeros are suppressed. (by default) In step 2 - if the accumulation of rows in Data Management resu…Bjoern Schumacher 132 views 2 comments 0 points Most recent by User_KKXP6 Financial Consolidation and Close
-
data exchange validation checkerSummary: In Data Management, under the mapping section, there is a VALIDATE button which checks your maps are using a valid target dimension member. Is there currently s…
-
Export mode Replace in Data Management does not zerolize YTD valuesSummary: Export mode Replace in Data Management does not zerolize YTD values when there is no line of data for a given POV Content (required): We noticed that exporting …MCV 195 views 8 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Is it possible to copy one scenario to another, including performing math on source data?Summary: Copying Scenario A to Scenario B, with Scenario B's data being scaled/rounded to thousands. Content (required): I have a DLR to load data to Scenario A. I would…SAW23321 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_110 rule to load 0 in place of #missingSummary: Need to write a config consol rule to replace #missing values with 0 Content (required): DSO application. I'm running into a variant of the issue where an accou…SAW23321 312 views 20 comments 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Default Export Mode in Data IntegrationSummary: In data management -> target application -> application options -> Default Export Mode. We put the value as Replace. Is there a way to do that in data integrati…Casey Kempel 63 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close
-
Size of supporting attachments for JournalsSummary Size of supporting attachments for JournalsContent Hi All, Is there any actual or recommended limit with respect to size of supporting attachments for journals i…User_R8P92 47 views 3 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
EPM Integration Agent - Export to FileSummary: Content (required): We need to create a process to export data from FCCS to a data file, using the EPM Agent. Is it possible? We set up the agent and he pings w…Timestamp EPM Team 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data load from Data management to FCCSSummary: We have loaded data from Data management to FCC, every thing went smooth and exported successfully. but when we check in FCCS there is a discrepancy for what we…Naveen Kumar Vasa 82 views 6 comments 0 points Most recent by Shanthi Subramanian-Oracle Financial Consolidation and Close
-
FCCS with GL Ledger setsSummary: We are planning to use ledger sets in GL. Can FCCS work with GL ledger sets. Content (required): Version (include the version you are using, if applicable): Cod…PrasadCCC 32 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Rejected Rows in Data ManagementSummary: In Data Management, the log file says rows rejected: 1 , but no information captured. [TC] - [Amount=NN] SourceSystem|EntityCode|Account Code|Account Descriptin…Naveen Kumar Vasa 106 views 2 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
EPM Integration Agent initialize ErroeSummary Hi all, i'm trying to initialize EPM agent but i'm getting the below error as the screenshot, please note that i'm already installed JAVA, and set the JAVA home …Hussein Mahmoud 52 views 2 comments 0 points Most recent by Ankur Shrivastava EPM Platform and Freeform -
Loading Consolidation Journals using Data Integration/Data ManagementSummary: We are looking into allowing users to load Consolidation Journals using Data Integration and found a few drawbacks: 1) Users will need to update the journal lab…Matt Maurer 82 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Use Case for the BegBalance member in Data ManagementSummary: When configuring DM, there is a default period mapping that is created called "BegBalance" that references the last period of the prior year of the first year i…Valerie Fisher-279201 62 views 1 comment 0 points Most recent by Patrick Northcraft Financial Consolidation and Close
-
Exchnage Rate Loading ...Summary FCCS Exchnage Rate Loading ... from ERP CloudContent Good People, We are looking to see if FCCS product can pull these rates (Exchange Rates) via the connector f…Soumya Prakash Parhi 87 views 4 comments 0 points Most recent by Soumya Prakash Parhi Financial Consolidation and Close -
Data Management - block data importSummary: Block data import Content (required): When importing data through data load rule, is there any way that Data Management block data import in FCCS because data i…Timestamp EPM Team 22 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management replaced by Data IntegrationSummary: Hi All, This is regarding Oracle's new feature Data Management will be replaced by Data Integration, How many of you think it is valid thing oracle is providing…Ramsha Ansari 122 views 6 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Duplicate Mappings while using Data Management in FCCSSummary Unable to delete/identify duplicate mappingsContent Hi, I am using the same FCCS application as both a source and a target and have set it up in Data Management …User_2025-01-29-22-31-29-149 75 views 3 comments 0 points Most recent by KimK Financial Consolidation and Close -
Sample groovy script to export aggregated FCC dataSummary: Sample groovy script to export aggregated FCC data Content (required): I am trying to write a groovy script to export aggregated data from FCC for an interface …
-
FCCS: DSO with PBCS Data for AccountContent Hi all We have a doubt about data import from Planning to FCCS. What happens when account from Planning is set to Dense and we have a new application FCCS where …NK2025 76 views 24 comments 2 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close -
Calculate entity on the various members of the Consolidation dimensionSummary: Content (required): Hi, In the project where I am currently, in the entity dimension there is the following hierarchy: The requirements are: Ent1, Ent1_Y, Ent2,…Carolina Silva 33 views 2 comments 0 points Most recent by Carolina Silva Financial Consolidation and Close