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… -
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
-
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…Neha!03 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 31 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 51 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
-
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
-
DataMap error-The max no. of remote cubes in DataMap's has reached.I am trying to create a new DataMap from one instance to another. However, I received the message: "The maximum number of remote cubes in DataMap has been reached." The …
-
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 101 views 10 comments 0 points Most recent by Girish Joshi 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 121 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
add refresh job in pipelineSummary: I want to add refresh database, refresh members and metadata as a job in a pipeline. How can I do that as that option is not available in the drop-down menu. Co…Suravi 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 54 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 81 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 81 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
EPCM - Data Import and Export with a period range using EPM AutomateHi All, In Enterprise Profitability and Cost Management, I can load source balances for a range of periods in one go by specifying a start and end period in the UI using…Anantha Krishnan 31 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
How to remove dataload mapping of deleted lookup dimensionInitially during development , we have created some additional lookup dimensions and created mappings against this DM dimension. Later we deleted those Dimensions but fo…SrikanthReddy-Oracle 11 views 1 comment 0 points Most recent by NarayananS EPM Platform and Freeform
-
Performance issue with Writeback in Snowflake table using EPM Integration AgentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-