Data Integration
Discussion List
-
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 81 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 386 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 22 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 38 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
-
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 72 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 22 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Pipeline Stage Failed If File Is MissingHi Team, We have a pipeline within the FCCS instance that consists of two stages. The first stage loads data into FCCS, and the second stage loads data into PBCS through…Jacob Gomes 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…Nehal Masrani 21 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Data integration to load data from ERP connection fails at extract stage.Summary: We are trying to execute an integration in data exchange to load actuals data from ERP data source connection, but the integration gets stuck at the extract sta…
-
Using Task manager we want to manage system automated activitiesSummary: Using Task manager we want to manage system automated activities from ERP like running a process or job in subledger (like Run Depreciation in FA module, or Cre…Dilip Kumar Ranga 32 views 6 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
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 52 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w… -
How to use the pipeline for data load in oracle account reconciliation?Summary: We would like to use pipeline for some sequence tasks including the data loads Content (please ensure you mask any confidential information): We would like to u…Omar Muhammed - PWC 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 81 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close