Data Integration
Discussion List
-
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 13 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 …
-
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 14 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…
-
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 26 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…
-
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 17 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
-
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 41 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 33 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Input at Parent EntitySummary There is requirement where we have to enter data at parent level Entity.Content Hello All, There is requirement in FCC where we have to enter data through custom…Tushant Pandey-151106 537 views 13 comments 0 points Most recent by Yashaswini Financial Consolidation and Close -
How can we remove shared entities from a Data Management extract?Summary: We need to generate a SOX control from Data Management. Content (required): The shared entities are duplicating the results. We have tried using mapping to filt…Michelle Wagner 121 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPBCS to EPBCS IntegrationSummary: I have to create two EPBCS applications for budgeting and then consolidate the budget in one application. The application will have same number of cubes but the…
-
Numeric Data load Vs All Data Type with Security thereby Amount Vs Data in DM/DESummary: Numeric Data load Vs All Data Type with Security thereby Amount Vs Data in DM/DE Content (please ensure you mask any confidential information): When the integra…
-
Data Exchange using ESS Job errorSummary: ERP Fusion connection using ESS Job gives an error stating "Job could not be triggered with given parameters.Request ID returned is -1" Content (please ensure y…