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 24 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 43 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 22 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…
-
data load rule with PipelineSummary: file based FCCS data load rule in Pipeline fails saying "Error opening Data file" Content (please ensure you mask any confidential information): File based FCCS…Raj N 17 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 23 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 858 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 23 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…
-
Configure Snowflake connection with EPM Integration AgentI am trying to connect to Snowflake via the EPM integration agent. I have followed the documented steps. I am using a File Credential Store. I am now receiving this erro…
-
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 116 views 12 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close