Data Integration
Discussion List
-
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 11 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 11 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 841 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 11 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… -
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…
-
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 111 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 31 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 61 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
User Settings under Data ExchangeSummary: The Log Level under System Settings is currently set to "3". Now a user, set his Log Level to "5" under User Settings. We did re-run the data load rule to get a…Kenneth John Asper-Oracle 31 views 5 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
SDM Validation Unable to Retrieve FCCS Account Balance ValuesWe are currently facing an issue where, Supplemental Data Management validation process is unable to fetch account balance values from FCCS. Despite having the necessary…
-
Does Data Exchange Pipeline job copyToSFTP support privateKey and passphrase secure parametersWould like to use the Data Exchange Pipeline job copyToSFTP with a privateKey and passphrase. Built the application connection with and without the parameters along with…