Data Integration
Discussion List
-
Authentication error when importing data into Profitability and Cost Management from EPM Planning.Hello!!! I have an integration to import data into a Cost and Profitability environment from an EPM Planning environment. Initially, the integration worked correctly, bu…User_F8Z0S 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Inclusion of rule description in output file generated in case of EPCM to GL direct integrationSummary: How to add journal description in data extract file automatically created in FBDI format in case to EPCM to GL direct integration Content (please ensure you mas…Deeksha Gupta EPM 31 views 4 comments 0 points Most recent by Deeksha Gupta EPM EPM Platform and Freeform -
Is it possible to reference attributes in member mapping?Summary: I would like to reference values in an attribute dimension in a member mapping Content (please ensure you mask any confidential information): In my Product dime… -
Unable to set decimal precision for Data integration and EPCMSSummary: Content (please ensure you mask any confidential information): Hi all When exporting Data using data management with EPCMS I am not able to set the data decimal… -
Data Integration Pipeline - EPM FCCS Job - Clear Data not working for power userSummary: We created a pipeline in FCCS to execute jobs, one of which is the "Clear Data" job. The pipeline must be run by a Power User. When executed with System Adminis…Gayatri Vurukuti 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
MDX Descendants function - Exclude Level 0 baseSummary: How do we design the MDX Descendants function to return parent members only and exclude level 0 base members? Content (please ensure you mask any confidential i…Jacalyn Munyon 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
REST API to execute Multiple POVs does not return all Child jobsSummary: REST API to execute Multiple POVs does not return all Child jobs Content (please ensure you mask any confidential information): When executing calculation for M…NarayananS 121 views 12 comments 0 points Most recent by Ryan Fell Profitability and Cost Management -
Data exchange - pipeline process details display incorrect informationSummary: Content (please ensure you mask any confidential information): Hi all Has anyone seen this behaviour with pipelines process details? They seem to display very r… -
FX RATE load from Oracle EBS GL to FCCSSummary: Raising this question under Financial Consolidation and Close section : We have a requirement to load FX RATES from Oracle EBS GL to FCCS using Data management/… -
Drill through from EPM to Agent to Source (ERP Sub GL)Summary: Data is loaded to EPM from ADW which is in turn sourced from Oracle Sub Ledgers. Is it possible through drill through to this Sub GL directly instead of Agent d… -
How I can send information from EPM Planning to a budgeting module in Oracle ERP CloudHello!! I need to create an integration to send information from EPM Planning to a budgeting module in Oracle ERP Cloud through Data Exchange using native integrations. … -
EPM Integration Agent - "EPM_AGENT_INBOX" Parameter error when starting as a serviceContent Hi -- We just downloaded the latest agent as of 5/27 from Data Exchange. We first tested the agent connectivity using the non-service method and everything worke… -
Exporting EPM Planning Data from EPM Cloud to Azure DatabricksWe are exploring the possibility of exporting planning data from EPM Cloud Planning to Azure Databricks. Is it feasible to establish a direct connection to Azure Databri… -
NewLoadYTDClosingBalanceInput not working as expected.Summary: The documentation says "When this substitution variable is set to True, Financial Consolidation and Close reverses the YTD closing balance from the prior period…Zenithz 283 views 5 comments 1 point Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Loading zero values without NZPSummary: We are loading GL data from Fusion to EPM (ARCS). We did not use NZP on amount in the dimension mapping of the data load rules before. Despite that, zero values…Pieter-Jan Vandendriessche 84 views 7 comments 0 points Most recent by EPMTech_Wub EPM Platform and Freeform -
Fusion GL Integration issue Parameter List - Period KeySummary: We are using the Fusion GL Integration to source Fixed Asset data to FCCS. This integration works fine except for december. There it takes the data from novembe…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform -
Exporting TRCS setup data to create connection to EDMSummary: We have been on TRCS for a few years and we have never had the time to connect EDM's master data to TRCS. I wanted to know if there is a way to export/extract t…Jason Rausch 21 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Tax Reporting (Direct Tax) -
Runtime error FCCS pipeline and EPBCS pipelinesSummary: We are running different integrations using pipeline, and it is failing at export stage for one specific integration. Rest integrations work fine, it is failing…Priyesh P. Rane 196 views 20 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
BS Account at FCCS_ClosingBalance Drill-Through not workingSummary: I am configuring the Drill Through in FCCS and when drilling through a Balance Sheet Account at FCCS_ClosingBalance intersection it is giving a default error th…Kenneth John Asper-Oracle 94 views 14 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
drill through to source from FCCS to Planning is generating an errorSummary: Content (please ensure you mask any confidential information): HI all While trying to drill through from FCCS to Planning we are getting this error: Error: ====… -
Restricting zero Balance records at source while extracting data from ERP to EPMSummary: Hi, While loading data into EPM applications from ERP, is there a way to not extract the records where Period Activity is 0. For the code combination where ther… -
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…ESST 24 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Load failing in EPM Test but loading in EPM ProdSummary: We were able to load the same exact Integration in Prod but it is failing in test. Below is the error log from EPM Test: 2024-08-13 13:37:55,273 INFO [AIF]: FDM… -
Not able to extract unmapped Accounts list of all locations in one-goSummary:In ARCS Data Management, we have multiple locations and we have to extract report of Ignored Data from Data Load Workbench from each and every location which bec…Mohammed Shariff 11 views 2 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform