Data Integration
Discussion List
-
FCCS - Pipeline - Is it possible to use variables in a 'Business Rule' type jobSummary: I'd like to use variables for the parameters of my business rules. Content (required): I created a pipeline containing one job: 'Translate'. This is a 'business…Julie Belurier 141 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Audit Log for Export Method of Data Management/Data IntegrationSummary: Is there any audit log report in Data Management/Data Integration to check export method that is runned by user whether the method is Replace, Merge, etc. Thank…
-
"Data Export to file" option in FCCS is not generating YTD valuesSummary: We have created Target application with application Type of "Data Export to File" in order to extract data from FCCS application and then selected "FCCS_YTD" ag…Harshith J Rao 31 views 1 comment 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
Mapping based on another field target member in Data Management/Data IntegrationSummary: Can we do some mapping based on another field target member in the Data Management/Data Integration. It just like excel we can use another field as source to an…
-
Data Validation Data Management to prevent data export to FCCSSummary: How to make some validation in Data Management to prevent data export to FCCS. Example: Validate amount total account (bs + pl) should be zero Validate amount o…J Mahero L 22 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Reports - Data ExchangeSummary: Where can we find Pre defined set of reports in Data Exchange likewise Data Management? Content (required): Currently within Data Management, there are a series…Arpit Ojha 21 views 3 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
How to extract dynamic calc member data from FCCS application using Data managementSummary: How to extract dynamic calc member data from FCCS application using Data management Content (required): Hi Team, Earlier we used to have one option in Source pa…
-
Data exchange fix maps functionalitySummary: In data exchange when there are validation errors, it directs you to fix the map, when you click on FIX MAP it takes you to the Account dimension. In data manag…
-
Mapping Data Management Based on Target to TargetSummary: Can we mapping target dimension to target dimension in data management. For example: There is 2 dimension such as Intercompany Dimension and Entity Dimension. I…Utari321 51 views 3 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Removal of Support for Custom Application in DMSummary: Removal of Support for Custom Application in DM Content (required): Can you please let us know how to create custom target application in Data Integration? If w…Ramsha Ansari 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
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 32 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 41 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 31 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 43 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 93 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 123 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 121 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 192 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 291 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 62 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 81 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