Data Integration
Discussion List
-
In Data Integration what is the difference between Target Period Year and Target Year?Summary: In Data Management/Data Integration, what is the difference between Target Period Year and Target Year in Period Mappings? Content (please ensure you mask any c… -
Is new incremental file application mandatory if file has new columnsSummary: I have created an executed an incremental file adapatar based integration, now suppose I have new columns added in my file, do I have to create a new incrementa…
-
How to map missing values in integration in EPBCSSummary: I want to execute an integration wherein if the "Union" column is "APS" or "Unaffiliated" for example, then the "Salary Grade" field for it will be blank. I was…Suravi 41 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Issue with Period Mapping in Data Management - Source-Period Column Showing Amount Instead of PeriodHello All, We are integrating data between two PBCS PODs. Our goal is to map data from the Jan-Dec periods to 'No_Month' in the target POD. To accommodate this, we have …
-
Data Load Rule "Date format for date data" ignored for User Preferences date formatSummary: The "Date format for date data" setting in a Data Management integration is being ignored and the user running the integration user preference date setting take…
-
How can I use one integration across more than one scenario?Summary: Suppose I have created one integration for actual category to load data into my reporting cube from financials, but I want the same integration to be used acros…Suravi 51 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…Ashif 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we increase the precision in data management data load file.Summary: We are running to load exchange rates from data management, however we came to a problem where we are trying to load 15 decimal, but it is loading only up to 6 …
-
Executing IPM Insights in EPCM - EPMAutomate/Groovy/RESTSummary: Automation and scheduling IPM Insights in EPCM using either EPM Automate, Groovy or REST API Content (please ensure you mask any confidential information): I am…Andy Das 91 views 7 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management -
IGNORE Mappings in SQLSummary Error exporting to FCCS when mapping to IGNORE utilizing SQL scriptingContent Was hoping someone could help with this. I setup Data Load Mapping using SQL script…user3948450 511 views 6 comments 0 points Most recent by Jennifer Lin Financial Consolidation and Close
-
Data Export to File from EPBCS pulls in Amount for Source Period in Data ExchangeSummary: Hi All, I am trying to do a data export to file from EPBCS in data exchange. I have the export working in FCCS correctly for actual data and need to create the …Karla McMillan IBM 11 views 2 comments 0 points Most recent by Odin Mjølsnes EPM Platform and Freeform
-
Direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS is failingI am trying to create a direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS. Extract and import steps are getting succeeded. Getting warning…
-
Invalid Credentials Error - Data Exchange (non-blocking)Summary: Since last update (25.07) we regurlary get an error in data exchange regarding credentials. Eventhough the error is there, the integrations run perfectly. I was…Pieter-Jan Vandendriessche 11 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Data Exchange how to load one cell to multiple cells in FCC ?Summary: In a data load file I have movements that needs to be loaded to both the FCCS_ClosingBalance_Input member and a specific movement member. How can I load to two … -
DELETE sql statement for on-prem databaseSummary: Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that … -
PTD data from Fusion into PCMCS in YTD by Data ManagementSummary Loading of Periodic data from Fusion into PCMCS in YTD by Data ManagementContent Hi, In order to perform monthly costing cycle, I want to load periodic data from…Khushbu Premlani 44 views 8 comments 0 points Most recent by NarayananS Profitability and Cost Management -
When testing strong ciphers with EPMAgent, 401 Unauthorized receivedSummary: We are in the process of testing our strong cipher set ups per the Oracle documentation here: How to Test with the Latest TLS Ciphers The documentation indicate…
-
Post the allocated result to next period to Oracle GLSummary: Hello everyone! It is about EPCM. But it is mainly about Data Integration/Data Exchange in Oracle EPM application. We have a situation: Data pulled from Oracle …GaryYip-Asc 31 views 4 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
How can a POV or Period be locked in EPCM to block data update of any kind (Submit Data or DM)Summary: Publishing a POV (from Calcualtion Control) seems to only block any calculations being run, but data upload is still being allowed. We need to lock a POV once i…Itali Madhusmita 11 views 6 comments 0 points Most recent by Itali Madhusmita Profitability and Cost Management
-
FCC multi cubeSummary: FCC multi cube was trailed at KScope 24 as 'coming soon' but we can't see it on the road map now - what is the current status? Content (please ensure you mask a…Ben Walwyn 331 views 10 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Print Substitution Variable Value in Pipeline Integration EmailSummary: Hi I am using the substitution variables Consolidation_Period and Consolidation_Year for data loads and its picking the values perfectly, the only issue is that…Shimona Gupta 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
The substitution variable DataLoadConsolMember is not working as expected.We have two DLRs: one for overrides and one for trial balance (TB) load from ERP. First, we load the overrides data, which successfully appears in FCCS. However, when we…Avani Makwana 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FCC Pipeline Job Type Import Mapping – RTP for NAMEHi all, The ability to copy pipelines definitely made our work easier. Over time, however, we realized that configuring a specific setting was quite tedious. We need mul…Andreas Otto 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issue while migrating file based data source application from one environment to another.Summary: Hello, I have registered a file as data source and have created a file based integration to import data into EPM application which is working as expected in the…Neha_R 21 views 5 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Is performance affected by using multidimension mapping for all dimensions in EPM Data Management?Summary: Hello Oracle Experts, We are loading data from a source file with 4 columns (like Account, Entity, Cost Center, Department, Location). In our Data Management se…Vijay_Babu 41 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Oracle FCC Data Management – Invalid Intersection CustomizingHello all, We are looking for a meaningful solution to provide our data integration users with an Intersection Validation Report - comparable to what we had in FDMEE. We…Andreas Otto 41 views 2 comments 3 points Most recent by user11033576 Financial Consolidation and Close