Data Integration
Discussion List
-
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 73 views 17 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
DM Mapping For MasterHi Team, We are using Oracle FCCS(Version 25.11.72) Cloud with Data Management for data loads.We maintain mappings across two locations, and the mapping setup includes: …Jacob Gomes 30 views 3 comments 0 points Most recent by NarayananS 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 17 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 14 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 64 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 …
-
passing variable value to pipeline through GroovySummary: Is it possible to pass a variable value to pipeline through Groovy rule? I have created a pipeline to run few business rules and to trigger the business rule, I…Tejesh Mhatre 13 views 1 comment 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
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…
-
Why does the data push rule omit one product even though it's not been excluded in the data map?Summary: In EPBCS, I have a data push rule which pushes data from FINREV cube to FS cube. This rule refers to a data map and it does not exclude any specific product. Ye… -
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 24 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…
-
Netsuite integration to FCCS issues with token expiring after 60 daysSummary: My client has an integration with Netsuite to FCCS which runs fine for about 2 months, then the token appears to be become invalid. Content (please ensure you m…
-
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 …
-
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 22 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
FCCS data storage archieval guidanceHello We are seeking official guidance and best practices for managing historical financial data and metadata within Oracle FCCS, specifically as it relates to archiving…Prashanth0302 14 views 0 comments 1 point Started by Prashanth0302 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