Data Integration
Discussion List
-
What is the best recommended way to extract SHARED data from FCCS?Summary: What is the best recommended way to extract SHARED data from FCCS? is it Data Exchange? Code Snippet (add any code snippets that support your topic, if applicab…NarayananS 29 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to Configure Integration Agent and Data Exchange to Select Queries at the Integration LevelHi. I have installed and configured the EPM Integration Agent so that it can run a SQL query that has been defined in the application. I now would like to modify the app…Peter Doyle - Equator EPM 44 views 4 comments 0 points Most recent by Peter Doyle - Equator EPM EPM Platform and Freeform -
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …
-
Exporting data such as smart list, date, text using data Data IntegrationSummary: Hello Team, I am trying to export data set with different types such as numeric, smartlist, and date in file using Data Export to File in Data Integration. Howe… -
Data Exchange: Extract Year and Period in single columnSummary: Data Exchange Integration: We are extracting data in a file in data exchange. This file has year and period in 2 different columns as we have 2 dimensions years…
-
document data integrationSummary: Hi, can anyone recommend a tool - assuming there is nothing built in - that will facilitate creating documentation from an export of PCM's Data Integrations. Co…Erisia 31 views 1 comment 0 points Most recent by Mike Casey-Oracle Profitability and Cost Management -
Data load Rule for File Export FailsPrior to the June patch the following parameter worked in the export data load rule: inbox\AMCFCC_EXPORT\AMCFCC_EXPORT_ACTUAL.csv. This placed the file exported in the c…
-
EPM to Oracle cloud writeback for actual dataSummary: Hello, I am trying to load back some adjustment data from Oracle FCCS to Oracle Cloud GL using Data Integration. I am successfully able to send data for a singl…Anindya N-Oracle 24 views 0 comments 0 points Started by Anindya N-Oracle Financial Consolidation and Close
-
DATAEXPORTCOLHEADER Please provide a valid dense dimension name to be used as the column headerFor the Version 26.06.73 (June 2026 EPM Monthly updates)that was released on Friday 06/05 - we are now getting error on FCCS to Planning data integration (integration is…Anne-Marie M 862 views 34 comments 0 points Most recent by Ashley Barrett Financial Consolidation and Close
-
epm data exchange integration, can we fetch start year and end year from fileSummary: In data exchange integration from file to EPBCS, need to fetch year period directly from file irrespective of what we select while running a DLR Say in the file…
-
Opening balances load approachWhat is the best practice approach for loading opening balances to a new FCCS application. I am planning to load local subsidiary currency balances to "Opening Balance A…S Kumar-Oracle 47 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Difference Fusion trial balance and GL BalancesSummary: We're designing an integration between FCC and Fusion. We're able to connect with Fusion following the Oracle EPM Cloud documentation. However, we're now face w…
-
Do EPBCS and FCCS support OAuth2 connections to ERPSummary: OAuth2 connections from Cloud EDM to ERP and now supported. https://docs.oracle.com/en/cloud/saas/enterprise-data-management-cloud/dmcaa/oauth2_authentication.h…
-
In EPBCS Data integration pipeline, unable to copy/move file from Outbox/logs folder to inbox folderSummary: In EPBCS data management pipeline, I am trying to copy/move log file from "outbox/logs/" folder to "inbox" folder. It is throwing an error that file not found. …
-
Usage of AIF_TARGET_APPL_MEMBERS in FCC CloudHello, We have a requirement to get member alias in data exports & currently we have used AIF_TARGET_APPL_MEMBERS to solve this problem in Non-Consolidated report. We ha… -
Drill Through to Oracle ERP Cloud not appearing on the Action MenuSummary: I have recently enabled an actuals integration to create drill regions for data sourced from Oracle ERP Cloud. Based on Oracle documentation, not much has to be…
-
Unable to run integration between TAX - Source with Planning - Target - Period mapping failureSummary: Content (please ensure you mask any confidential information): Hi TAX team We are doing a live integration between 2 EPm cloud TAX as source and Planning cloud … -
SubVar for Data Export IntegrationSummary: SubVar for Data Export Integration to use with SubVars Content (please ensure you mask any confidential information): We have Data Integration Quick Mode to ext… -
Data Exchange Mapping member mappingSummary: EPBCS Data Exchange Mapping, if member present in Employee dimension then it should be mapped to * to * else default member, without explicitly mapping employee…
-
DI - Clear Data Scope for promoted Approval GroupSummary: I am looking for clarification on the scope of data cleared from the FCCS application when running a Data Integration in Export Mode Replace. In particular, I w…Andreas Otto 125 views 12 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
oracle epm pipeline integration with smart split job, is there an option to bypass refresh members?Summary: oracle epm pipeline integration with smart split job, is there an option to bypass refresh members? Content (please ensure you mask any confidential information…
-
Cannot perform cube view operation. Essbase Error(1270001): Memory allocation failedSummary: While executing DLR from PBCS reporting cube to PCm, facing error Error: Cannot perform cube view operation. Essbase Error(1270001): Memory allocation failed Co…
-
Data masking for required data combinationsWe need to have access control on data so that no one should be able to view the data of other users. For e.g. Employee compensation information. Business should have co…
-
FCCS Exchange Rate Load to Rates Cube – Post-Load RulesHello everyone, I have a question regarding the exchange rate integration process in FCCS. We are loading exchange rates into the Rates cube through a data exchange inte…Timestamp EPM Team 65 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close