Data Integration
Discussion List
-
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 175 views 17 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can we establish a direct connection in EPM Data Exchange to an OACS databaseSummary: Can we establish a direct connection in EPM Data Exchange to an OACS database (Oracle Autonomous Database) without using an EPM Agent? Content (please ensure yo…HariKetha 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Issue with multidimensional mappingSummary: When I added the entity CORIX in Multi-Dimension mapping, Data Management interpreted the substring "OR" in the word CORIX as a logical operator. As a result, t…Supriya_EPM 21 views 2 comments 0 points Most recent by Harikiran_EPM-Oracle Profitability and Cost Management
-
Oracle's position on concurrent integrations?Does anyone know what Oracle's position is on running multiple loads at once? Can you pull from different cubes within the same EPBCS Applications at the same time with …Peter Joelson 31 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data integration (refreshing from source issue)Hi everyone, I have an ERP → EPM integration issue where a segment value with special characters was fixed in ERP, but EPM is still receiving the old value. Even after s…Ouma_123 51 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Exporting Supporting Details to CSVSummary: Hi all, I am wondering is there is a way to export supporting details in CSV or text format? Via the Migration tool it is possible to export this Relational Dat…
-
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 82 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to remove last 4 characters from source file in data exchange (EPBCS)Summary: I am executing an incremental file adapter-based integration wherein a particular column has data which looks for example like "XYZBand13EP7.75". To meet a part…
-
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…
-
set up the ERP Cloud GL Balance (FRCOA) connection in Data ExchangeSummary: Hi everyone, I’m trying to set up the ERP Cloud GL Balance (FRCOA) connection in Data Exchange, but the connection does not appear in the list of available sour…Ouma_123 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data exchange connection to databricksSummary: Trying to connect to databricks through data exchange Content (please ensure you mask any confidential information): I am trying to create a connection to datab…
-
How to lock/unlock periods in Data ExchangeSummary: Looking for the functionality in Data Exchange that exists in Data Management to Lock/Unlock locations by Period. Content (please ensure you mask any confidenti…Stephanie Philopoulos 384 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 11 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…
-
Unable to Map Source Periods (FSC1, FSC2…) to Global Periods During Data Exchange ExportSummary: I have Global Period mappings defined in Data Exchange in the format Jan-24, Feb-24, Mar-24, etc. However, my source system uses a different period format such …
-
New Cube Fields in Edit Integration Throwing Error When Trying to SaveSummary: We discovered that the 25.11 patch introduced new cube fields to the edit integration screen when viewing integration details. For some of our integrations, the…
-
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 21 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 31 views 2 comments 1 point Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
DLR needed to use Qualified Member Name for one EPBCS cube but not another?Hey all, We hit the following error when we ran a direct data integration from EPBCS to EPCM (running the integration from the EPCM environment): "Cannot perform cube vi…Peter Joelson 11 views 2 comments 0 points Most recent by Peter Joelson Profitability and Cost Management
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, … -
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 71 views 13 comments 0 points Most recent by Nicolas Cantarini Financial Consolidation and Close
-
ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGESummary: ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGE Content (please ensure you mask any confidential information): Hi Team, We are trying to load data…
-
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 21 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close