Data Integration
Discussion List
-
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 10 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…
-
Need report from Data exchange for Process detailsSummary: Need report from Data exchange for Process details showing how many times TB uploaded for particular location for specified period Content (please ensure you ma…
-
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 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Power Users to access Process Details and Lock LocationsSummary: We have provisioned Power users with the Data Integration - Create role and enabled Location Security in our environment. As part of the location security setup…Saraiya Daisy Dhanesh 33 views 9 comments 0 points Most recent by ApOK Financial Consolidation and Close
-
Email Notifications via Pipeline to Multiple UsersSummary: What is the best approach in the Oracle FCCS pipeline for sending email notifications to multiple users when a distribution group email address is not available…Saraiya Daisy Dhanesh 55 views 7 comments 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 6 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 811 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 1 view 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… -
secondary audience for the EPM Cloud ServiceSummary: Getting 401 Unauthorized error when starting the Integration Agent after updating to 26.07 Content (please ensure you mask any confidential information): I foll…
-
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…
-
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 23 views 2 comments 0 points Most recent by Peter Doyle - Equator EPM EPM Platform and Freeform
-
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 … -
Not able to download "Artifact Snapshot" in parallel for multiple EPM Pods after EPMAutomate UpgradeSummary: After updating EPM Automate to version 26.06.49 where Oracle has changed behaviour for "downloadFile" command. Since the files are written to single folder, we …Prateek Mohan 25 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform