Integration
Discussion List
-
Drill Through issueSummary: Content (please ensure you mask any confidential information): Hi, We are facing an weird issue with the Drill Through. So, we have made all the configurations … -
Do we have any option to clear data from an on-prem database table before it imports from EPBCS?Hi, I am trying to create an integration for data export from EPM application to an On-premise database table using EPM Integration Agent. Integration runs fine and expo…
-
Can the Netsuite connector be configured bidirectionally with Planning?Summary: Content (please ensure you mask any confidential information): Hi all We have the intention to use the Netsuite Connector with Planning, but we are wondering if… -
Issue with Thousand Separator in Multi-Column All Data Type Rule in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all, I’m working with Oracle EPBCS Data Management and running into an issue with thousand sep…
-
Can Oracle Rest APIs be used to export/import data and metadata (dimensions)?Summary: Can Oracle Rest APIs be used to export/import data and metadata (dimensions) to/from Planning and other database types (i.e PowerBI as an example)? I have revie… -
Restrict Users to run specific DLRsSummary: Is there any way to restrict users to run specific DLR in EPM FCCS. For example, only User under Group A should be able to execute the DLR_A . Content (please e…
-
Can the EPM Project Export to PPM Be Updated to Send Additional Fields? Can Scripts be Updated?Summary: I'm working on implementing the OOB integration to integrate approved projects between EPM and PPM (Project Management). The integration works. However, I need …
-
EPM Project export to PPM fails on business rules not executing? How do I find which rules are used?Summary: I have created a capital project in EPM Planning Projects. When I run Export Projects in Data Exchange the process ends in error. The logfile mentions one or mo…
-
Multi-Column load is not picking up data for the last few columnsSummary: Content (please ensure you mask any confidential information): Hi, We do a revenue file load using the data integration. The integration is setup as Multi-colum…
-
Clear Budget in budget control cube ERP (XCC_) before loading a new budget dataHello everyone, We are pushing our approved budgets from Planning to Budgetary Control Cube. There are cases where we are supposed to clear Budgetary Control cube data b… -
EPBCS to Fusion GL Direct Integration – Support for OAuth2 Authentication?Currently, the direct integration between EPBCS and Fusion GL relies on Basic Authentication (username/password) for EPBCS to pull data and metadata from Fusion GL. Is s…
-
Integration of EPM Agent with ERP Subledger Using SQL & Loading Fixed Asset Depreciation Data in EPMHello, We are looking to integrate Oracle EPM with our ERP subledger using the EPM Integration Agent. Specifically, we would like to: Use SQL queries to extract data dir…
-
Data push for large volumeContext: We need to push ~12–15 million records from a Source ASO cube to a Target ASO cube within the same application. Standard data push and Groovy-based export/impor…
-
Can Task Manager Trigger Pipelines and Business Rules with Parameters in Oracle EPM Planning?Hello, We are exploring ways to enhance user-driven automation in Oracle EPM Planning. Specifically, we would like to know: Is it possible to configure a Task Manager ta…
-
FusionHcmAdapterFailed Error in HCM Integration within PlanningWe are getting an error when loading data from the HCM Assignment Extract into Planning. In PROD instance the data loads for other months have been successful; however, …
-
Independent BR assigned to Integration - runs also rules that are not assignedSummary: Hi all, I have created an Integration in EPM Planning (runs as expected) with the BR assigned to it. This business rule has been added as an Independent, event-…
-
Clearing Behaviour when Sending Budget Data from EPM Planning to ERPSummary: What is the Clearing Behavior when Sending Budget Data from EPM Planning to ERP General Ledger. (Not Budgetary Control) Content (please ensure you mask any conf…
-
Data Exchange error Log failing on Export: ERROR [AIF]: "null"Summary: I'm trying to integrate FCCS with EPCM, but when I create data load rules in FCCS and run the export, I get an error like this: ERROR [AIF]: null. Is there a so… -
Advanced Predictions failing at stage connecting to OCISummary: We are testing Advanced Predictions and are encountering job failure in the Pipeline connecting to OCI. We don't see any guidance in the documentation related t… -
Merge data slice does not work in pipelineHi everyone, I am creating datapipeline for merging data slice epm platform job. However, it showed the error: My parameter here: What should I do next? Thanks and have …
-
Data in tdataseg gets clearedSummary: Hi , i had a question regarding tdataseg table used in data exchange in Oracle ARCS. Can anyone let me know if this tdataseg table gets cleared on daily basis d…
-
Metadata Integration between EPM Cloud ApplicationsSummary: How to integrate metadata between EPM Cloud Applications? How to transfer metadata files to other EPM applications? Content (required): Hi all, between two EPM …
-
Does CopyfromObjectStorage copy a file directly to a custom data management folderSummary: Content (please ensure you mask any confidential information): It seems currently there is no option in CopyfromObjectStorage epmautomate command to copy a file…
-
Best practice around loading data from HDFS to Oracle EPMHas anyone worked on pulling data from HDFS to Oracle EPM planning? Need to understand what are the best practices to integrate data from Hadoop File System to Planning.…
-
can we load Smartlist data from fusion and not through CSV file?Summary: can we load Smartlist data from fusion and not through CSV file? Content (required): I am trying to load smartlist data from fusion but I cannot see the option …
-
Smart Push & Data Map LimitsI was looking through the documentation and didn't see it explicitly called out anywhere, but I wanted to confirm the limits of pushing data via smart push & data maps: … -
Data Integration with smart split QuerySummary: While checking the below latest release : "A new Smart Split feature is available in Data Integration when importing a large volume of data that exceeds Essbase…
-
How to connect / build reports against data integration schema?Summary: In Data Exchange, after loading we need to get some statistics on numer of records exported, sum/avg of these records, etc. In EPM Integration Agent documentati…
-
@XWRITE Smartlist with dynamic MembersSummary: Hi Y'all, I'm trying to basically recreate the Data Push from CAPEX to FS via Calc Script and now I'm at the stage where I want to transfer the Data stored in t…
-
Data Exchange - Create Application NOT Creating New ApplicationSummary: Not sure what I am supposed to do to create a Cloud ERP application, below is what I am trying for Category, Type, and Connection. Why does it not create a new …