Data Integration
Discussion List
-
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 315 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 48 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 34 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 83 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 31 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 102 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 51 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 81 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 21 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 121 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 77 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 78 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 31 views 2 comments 0 points Most recent by Carolina Silva Financial Consolidation and Close
-
Data Management and zero loadingSummary: I thought that when loading data via data management the defualt behavior was that zero balance lines were NOT loaded to FCC Content (required): I am reviewing …Nancy Ackerman 747 views 10 comments 0 points Most recent by JimmyMcFly Financial Consolidation and Close
-
Calendar Change to Fiscal Year - Impact on data management YTD loads?Hi all, We received a request to change the Fiscal Year from November start to January, as we load data "YTD_Input" via data management to "FCCS Closing Balance Input", …yanni vossos 46 views 1 comment 0 points Most recent by Vani-Oracle Financial Consolidation and Close -
No Input rule/optionSummary: client is moving from HFM to FCC and currently "locks" data by adding the completed year to a No Input rule - is this available in FCC? Content (required): Is t…Nancy Ackerman 132 views 10 comments 0 points Most recent by David Corredera at DTT Financial Consolidation and Close
-
Journal Load button of Data Management in Data ExchangeSummary: Journal upload from Data Exchange Content (required): Is there an equivalent of Journal Load button of Data Management available in Data Exchange interface? I t…Raj N 41 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
Mapping for account based on amount Greater/Less than zero in data load mapping using #SQLSummary Trying to write a SQL script in Data load mapping for defining target account and amount based on the value of source-amount Content (required): In FCCS, I have …Apoorv Jain-234550 81 views 4 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
Setting Replace Mode by Default in Data ManagementSummary: Setting Replace Mody By Default in Data Management Content (required): Hi All, is it possible to setting (in Data Management) the "Replace Mode" by Default ? In…Antonio Barbaro 41 views 1 comment 1 point Most recent by Randa-Support-Oracle Financial Consolidation and Close -
Can the integration agent pull FX rates from Oracle Cloud FusionSummary: Client is asking if data management can pull the FX rates from Oracle Cloud Fusion (which they are implementing at this time along with FCC) Content (required):…Nancy Ackerman 41 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Dry Run option - Data ManagementSummary: Dry Run option - Data Management Content (required): Hi All, I see the "Dry Run" Option in Data Management. Do you know what's it? Version (include the version …Antonio Barbaro 261 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close
-
How to load Budget amount @Specific Currency from Planning to FCCS?Summary: We want to load Budget info for 1 specific currency across different Entities to FCCS. But in FCCS this is not in correspondence with the 'entity currency'. Not…Ilse De Vries_43167 32 views 1 comment 0 points Most recent by CAPawan Kumar Financial Consolidation and Close