Data Integration
Discussion List
-
Data Management - Error: 3335Summary: Content (required): Hi, When running the a rule in Data Management to import data, I get the error: | Error: 3335 | 69080101 | "69080101","9999","xxxx","069","0…Timestamp EPM Team 203 views 3 comments 1 point Most recent by User_BZTEB Profitability and Cost Management -
Unable to exclude members based on conditional search from a source filter in EPCM Data ManagementWe are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as …
-
Shared Entity shows the different value then the value shown in Primary EntityWe are loading YTD data in FCCS DSO Application in Replace mode. There are some Variance accounts created outside of FCCS_Balance sheet which uses the primary accounts u…ShubhamVj 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
OWP_Incremental Process Data with Synchronize Definition rule gets executed twiceSummary: I am trying to execute an incremental file adapter–based integration where I have attached the rule “OWP_Incremental Process Data with Synchronize Definition” a…Suravi 12 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Does Audit logs record data changes from Data managementSummary: Does Audit logs record data changes from Data Management? Content (please ensure you mask any confidential information): Hi team, We have exported Audit logs an…DISHIL SHAH 71 views 17 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
AFCS integration with EPM Cloud FCCSDear All, We have a requirement to load data from AFCS to FCCS for Notes To Accounts. Requesting support to understand best approaches to integrate AFCS (Accounting Foun…Kunal Baikar 11 views 3 comments 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Combining Debit and Credit columns into Amount - Data ExchangeSummary: Hi All - I am integrating with the Account Analysis report from ERP and need to take Debit - Credit in data exchange since they are in separate columns in the r…Megan Morgan 11 views 4 comments 0 points Most recent by Megan Morgan Profitability and Cost Management
-
HCM 'effective date' and EPM Planning IntegrationSummary: HCM 'effective date' and EPM Planning Integration Content (please ensure you mask any confidential information): I would like to better understand the role of t… -
In PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up windowIn PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up window select Point of View and then must setup Period Key in (N) Data Exchange > A…sarahayuputri 61 views 15 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Integration between FCCS and Microsoft Business Central (Cloud based)Is there a way to integrate FCCS with Microsoft Business Central (Cloud based) to retrieve the trial balances without using Oracle Integration Cloud? Can we use Oracle I…
-
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 …
-
3rd party cloud load data into Oracle FCCSSummary: Need to obtain a third-party data file or access an API to load data into Oracle FCCS from a cloud location. Please confirm whether it is possible to retrieve d…
-
Clearing Table in Data push to oracle DBSummary: currently we are pushing data to the oracle db using data integration with help of the data load rule. before loading the data to the table we need to clear the…
-
Switching FCCS Data load approach from periodic to YTDHi Team, We got request from client to change the data load approach from periodic to YTD, What are the key consideration or points that we should keep in mind while doi…JyotiSharma 27 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data integration: Export double data if there is a break in yearsHi, we have a DSO FCCS-System. In order to export data we needed to change the 'Data Extract Option' to 'All Data'. With this option the system is using a MDX-Statement …Fabian Bistram 21 views 3 comments 0 points Most recent by Fabian Bistram Financial Consolidation and Close
-
Is there REST API or another non-interactive way to change connection details under Data ExchangeSummary: Is there REST API or another non-interactive way to change connection details under Data Exchange in EPM? After each clone from Prod to non-Prod and after nativ…Thoraclus 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Email Data Integration Output File as AttachmentSummary: Email Data Integration Output File as Attachment Content (please ensure you mask any confidential information): We have data export file from Data Integration a… -
EPM Agent Automatic Vs Manual - Neither works when run as ServiceSummary: EPM Agent automatic does not work for scheduled jobs but whereas when set as Manual it works. Is there any issue with Agent running as a service when set to Aut…
-
FCCS Data Exchange – How to clear an Attribute value once it has been loaded?Hello everyone, I’m working with Oracle FCCS – Data Exchange mappings and I need clarification on how attribute values can be cleared or removed. Scenario: I am mapping …Alberto Parisella 21 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Custom MDX Query in a data integration giving errorHello, I am trying to add a custom MDX query to my data integration. I am following the document at https://docs.oracle.com/en/cloud/saas/enterprise-performance-manageme…
-
Slow execution of DELETE FROM TDATASEG_THello, We are experiencing a performance issue in our FCCS environment (Data Integration). The execution of the following query in the backend is taking an unusually lon…MKhade 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error loading Exchange Rates to FCCS Rates Cube via AutomationHello All, I have an Integration defined to load Exchange Rates to the Rates Cube in FCCS from an On-premise Database using EPM Agent, but the rates are failing to expor…Simon Eng 43 views 15 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Simple Tutorial: Import System Exchange Rates from a File Using Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based exchange rates to FCCS Rates cube using Data Integration. Tutorial demonstrates how to …Ashutosh Bhatikar-Oracle 14 views 1 comment 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Load at Parent EntitySummary: There is a requirement to enter data at the parent-level entity. The parent entity is associated with only one shared member. We introduced the shared member be…Yashaswini 32 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close