Data Integration
Discussion List
-
Oracle EPM Data Integration REST API- Retrieve Job Status using Job NameSummary: Is it possible to query EPM Data integration jobs through REST API using Job Name or Status instead of job ID? The Document below only talks about using Job Id …SoumyadipBasak251 25 views 3 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Loading by FDMEE - Replace vs MergeSummary: Loading by FDMEE - Replace vs Merge Content (please ensure you mask any confidential information): Hi All, I noticed an issue during Loading Phase by FDMEE. In …Antonio Barbaro 30 views 7 comments 0 points Most recent by Antonio Barbaro 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 164 views 16 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 59 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS_Mvmts_NetIncome not calculatedSummary: FCCS_Mvmts_NetIncome not calculated for P&L accounts for new entities that started receiving data recently. Data from ERP is loaded at "FCCS_ClosingBalance_Inpu…Rahul Sharma-226069 26 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is it possible to use Members from Dimension (dynamically) on Pipeline Variable?Summary: Hi, is it possible to use members from a dimension in pipeline variables in the same way as it prompts in the rules??, or is it only possible by adding them man…
-
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 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Oracle Capability to Fetch Data from Non-Oracle Applications via API Request:Client has asked whether Oracle can directly fetch data from external (non-Oracle) applications using APIs. We need confirmation on: Whether Oracle allows building a cus…Ashishruke 16 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…
-
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 18 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 25 views 2 comments 1 point Most recent by Lakshmi V-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 69 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 24 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 20 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 48 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 78 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 44 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 93 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 118 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 50 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 66 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 85 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 30 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 16 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 3 views 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 4 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 36 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 94 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close