Data Integration
Discussion List
-
Consolidation works for January, but gets false data for FebruaryHi there, I have a strange problem when consolidating our initial Closing Balance. Perhaps somebody can help me? Here's the situation: We are loading the initial closing…JSchil 7 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Turn Off Suppress Missing in DLRI am trying to run a DLR and get results as though suppress missing is turned off. If there is a row which should have #Missing, that row would appear in the output with…annaschmult 14 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Option to configure dont map to a particular target account code.In Data Management or Data Exchange is it possible to define negative mapping "Not to map to a particular target coa code" For eg For Target Custom 1 mapping I DONOT wan…Amara Sai Sandeep 12 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
FCCS: Handling Opening Balance Adjustments with YTD Loads and Data ExchangeSummary: We want to make some adjustments to the opening balances. However, when we post a journal as an opening adjustment, it gets aggregated with the loaded YTD balan…AishShirke 15 views 2 comments 1 point Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
DataCopy with FCCS on-demand rulesSummary Is it possible to use DATACOPY in FCCS on-demand rulesContent Hi all, just have a question regarding the usage of Essbase DATACOPY from within FCCS on-demand rul…User_2025-02-03-23-55-06-250 137 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Anyone using importOwnershipData EPM Automate command?Summary: I am looking to manage FCCS ownership outside of FCCS and load via the importOwnershipData EPM Automate command. Content (please ensure you mask any confidentia…Stuart.Porad 37 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
not able to load data for unlocked entitySummary: we are trying to load data from a Oracle EBS source sytem the file has multiple enities some of them and locked in FCC and some are not. I am not able to load a…Ashish Mishra-169689 63 views 13 comments 0 points Most recent by Nicolas Cantarini Financial Consolidation and Close
-
Pushing data from FCCS to EPBCS with different parent member.Summary: Each month, we are pushing data from FCCS to EPBCS. We used to have the same hierarchy in both applications. FCCS: Legal Hierarchy (Primary) Management Hierarch…Pieter-Jan Vandendriessche 17 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Any Template including parent code, all base code under it & all GLs mapped to those base codes?Auditors usually ask for this kind of data wherein the excel financials show the BS or PL any parent code and they require as to how the data is rolling up to these code…Neha!03 17 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Invalid Intersection in DM - Output FileSummary: Hi, When data is loaded on an invalid intersection in DM, it marks the process as failed on Export step and creates an output file of the invalid rows. In this …Alyssa Longo 46 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Downloading Validation errors report and restricting loading invalid intersections dataAt present in workbench there is no option to download Validation errors data. So is there any workaround to download this data? At present data in invalid intersections…Amara Sai Sandeep 76 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Where is Account Type stored for DM?Summary: We had an issue (still open SR under investigation) with a journal load from DM. When the journal rule was run, the end result was an OOB journal in FCCS. An As…Alyssa Longo 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Loading of entire Trail Balance to Closing Balance InputSummary: Hi All, Customer does not want to load zeros, in case no data is present for Balance Sheet specifically for January to have the reversed Movement as its increas…Mary John-Oracle 86 views 10 comments 0 points Most recent by TechM-GJ Financial Consolidation and Close
-
How to copy rate using pipeline?Summary: Error while executing pipeline to copy rates from P12 to P13 Following steps were followed to copy the rate from P12 to P13 using Pipeline: Create a copy rate p…SAJ 116 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC: Restrict Security for Users in Data IntegrationSecurity Setup to restrict users in Data Integration is msissing. Our business case foresees users who need to trigger a data integration and access the Data Load Workbe…Andreas Otto 47 views 4 comments 0 points Most recent by Trey Daniel Financial Consolidation and Close -
Can Process Details from Data Exchange be Exported to excel?I’m trying to extract data to identify when the first trial balance for each location was loaded. The information is available in Process Details, but I’m unable to expo…Rekha S 61 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS (EPM) Backup & AutomationSummary: We would like to find out if any of you all have been successful in automating FCCS daily backup Content (required): We have a requirement to hold up to 60 days…Rihan Jameel 82 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
Derive Pipeline ParametersHi Community, We use Pipelines to optimize our processes. To make the process more secure, I am looking for a way to derive certain Pipeline variables from others during…Andreas Otto 29 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close
-
Source Period Not Available in FDMEE - Custom ApplicationSummary: Hi All, I created a custom application (Load_to_Oracle) in order to produce a txt file to load in a specific target system. In the custom Application I added th…Antonio Barbaro 12 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Input Currency Journal Adjustment Load Via Data ManagementSummary: Can Input Currency Journal Adjustment be loaded in FCC Via Data Management/FDMEE Content (please ensure you mask any confidential information) Can Input Currenc…
-
FileName Variable in Run Time PromptsI have an integration rule in the data exchange for importing a data file, and associated with it, I have a business rule (Groovy) set to run on the "Before Import" even…Timestamp EPM Team 1 view 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Import Format "Factor" expression working twice for Admin Users for FCCS.Hi All, We have an import format , where the source amount is getting divided by 1000 (Factor = 0.001) and then getting loaded into FCCS. Ex. Source amount =12345678 , T…Twink-Oracle 2 views 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCCS data export issue on mappingSummary: Export to essbase contains the source member however mapping and workbench contains target member which causing the issue on member not found and failing the DL…
-
Simple Tutorial: Import Text based Consolidation Journals via Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based Consolidation Journals using Data Integration and Data Management. Tutorial is used to …Ashutosh Bhatikar-Oracle 34 views 3 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS ConnectorsHi Team, We are in a journey of integrating Oracle FCCS to Workiva, We have some Oracle seeded connector in Workiva which can pull Data,Metadata,Mapping & Snapshot. Woul…Ramya Kalaparthi 91 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Moving from HFM to FCCS CloudWe have 5 yrs of Historical Data in HFM that we want to Archive. What are my options? Reason for not moving these in FCCS as I am told that the recociliation becomes a c…
-
INFO [AIF]: EPMFDM-140274:Message - Import Mappings: Current DimensionsHi Experts - We are getting this DM error when we try to import mappings from OIC→EDM→FCCS. We have not changed any file format till now but still getting this error. Ca…
-
Rounding FDMEE - Issue decimal FormatSummary: Rounding FDMEE - Issue decimal Format Content (please ensure you mask any confidential information): Hi All, in my FCCS application I noticed an issue in export…Antonio Barbaro 22 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Create Drill regionClient is trying to drill back to workbench via SmartView. We have enabled Create Drill Region in our integration options and loaded the data. I am able to drill back to…
-
Guidance Required for Setting Up OAuth2.0 Connection Between FCC and OIC with Different IDCS DomainsHello Oracle Community, As part of our current project, we are working on establishing an OAuth 2.0 connection between Oracle Integration Cloud (OIC) and Oracle Financia…