Integration
Discussion List
-
View data in EUR format in workbench and drill regionSummary: Hi, in a project I need to import data from the source ERP system in EURO currency. For this reason, an import format has been set up in Data Management that al… -
Clear Region option in Data Integration can not work when integrating from EPBCS to ERPSummary: Hello everyone, I have trouble with Clear Region in Data integration. I tried to push budget control data from EPBCS to ERP by using data integration. When I se… -
How can we map two source dimension period and year into a single dimension in data managementWe are creating a integration to send the budget back to people soft in file format, what client requires to send the budget file where period and year will concatenated… -
EPM Data Exchange interface to Oracle Autonomous Database bad performanceSummary: We tried to extract EPBCS data (5000 records) to OAW and it takes 15 mins to completed. We found the IMPORT and VALIDATE are pretty quick but stuck in EXPORT. A… -
Groovy script to pass subvariable in DLRSummary: Hi Experts, Im trying to pass subvariable for start period and end period on the Json payload , it shows the method is invalid, it might be an easy one for you …
-
Data Integration: changing the source type changes it for all the rules under the same locationSummary: Content (please ensure you mask any confidential information): Hi all We are seeing a change in behaviour in Data Integration when trying to change the source t…
-
EPM Data Exchange interface data to Oracle Autonomous DatabaseSummary: In EPM Data Exchange, we can create Application Type = [Data Export to Oracle Autonomous Database]. With such feature, can we interface EPBCS data to OAW in Dat…Joseph Ip - Oracle-Oracle 1 view 2 comments 0 points Most recent by Joseph Ip - Oracle-Oracle Planning
-
Import Project Budgets integration run failedHello , We ran the integration called "Import Project Budgets" but it failed. When we checked in the Project Details, we found that: After running the Import Project Bud…
-
Drill through from planning to ERP cloud GL balances failingSummary: When trying to drill through to source, either from a data form, workbench or smart view, I'm only getting a blank browser page. Content (please ensure you mask… -
Data Management with blank amount rowsHi All, We tried to set up File as source and target as EPBCS. We have loaded a file data and checked it from Data Workbench of Data Management, but the blank amount row…
-
Syncing Users between HCM and EPM Access ControlSummary: Is it possible to integrate/sync User Security between HCM and EPM? If it's possible, how to achieve it? -
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
redwood p2T refreshSummary: Hi Team, we have recently refreshed test site from production, after the refresh redwood pages not working properly, am able to navigate to the redwood pages bu… -
How to delete a file which is loaded into the EPM agent inbox folderSummary: Content (please ensure you mask any confidential information): Hi there Can someone let me know if there is a way to delete automatically a loaded file via EPM …
-
[Integration] Error in the Pipeline and unable to edit/save the pipeline changesSummary: I am currently encountering 2 issues in Pipeline Pipeline Substitution variable is not working Pipeline settings is not editable Content (please ensure you mask…
-
Drill Through skipping one dimension when DrillingSummary: Hello, I created a drill through in both the development and production environments. The drill through works well in the dev environment, and the sum of the da…
-
Schedule Job - Refresh Database - Job Name No data to display.I am trying to schedule a job (Refresh Database) in our environment after updating projects values. In the job details, no job or data was displayed for us to successful…
-
Cannot calculate. Essbase Error(1042017): Network error: Timed out before receiving all dataSummary: Data Exchange Job. It FAILED at the last step of exporting data to planning application. 2024-03-18 18:44:09,361 INFO [AIF]: EssbaseRuleFile.getReplaceDataScrip…
-
Multi Column Load with Period as DriverWe have a multi column load with period as the driver. However, the load will always start with the first data column (column K). Even if selecting a different period (F… -
How to Push Initial Budget and revised Budget from EPBCS into Fusion ERP?Summary: Customer wants to push both the initial budget and revised budget into fusion ERP. How to differentiate the initial budget and revised budget? Any mapping optio…Subramanian Karunamoorthi 14 views 3 comments 0 points Most recent by Subramanian Karunamoorthi Planning -
Can the Output file in Data Management show more than 1000 lines?Summary: Can the Output file in Data Management show more than 1000 lines? Content (please ensure you mask any confidential information): Version (include the version yo…
-
No periods were identified for loading data into table 'TDATASEG' when running integrationSummary: Hello everyone, I need to get budget data from ERP to EPBCS. But unfortunately, the integration run failed in Dec-2024 with the log: "RuntimeError: No periods w…
-
Is "Position Tree Code" mandatorily to be defined in HCM so as to import the Position into EPBCS?Summary: We are integrating the HCM Position with the Job dimension in EPBCS Workforce cube. All our HCM to EPBCS integration works except for Position. There is no Posi…
-
adding filters / parameter for BI publisher's Data model to planning integrationSummary: adding filters / parameter for BI publisher's Data model to planning integration Content (please ensure you mask any confidential information): hi all, we have …
-
Is there functionality in EPM to create a relative timespan?Summary: Looking for a way to have reports, automations and various other processes run based on a relative timespan. The goal of this would be to not require updating s… -
Drill-through set up to other cubes and/or applications?Summary: Is it possible to set up drill-through definitions to drill-through to other cubes and/or applications? Content (please ensure you mask any confidential informa…
-
Hierarchy-driven Smart Lis t- Display Member Name or Alias (instead of Description)Summary Hierarchy-driven Smart Lis t- Display Member Name or Alias (instead of Description)Content Hello, Does anyone know if there is way to display a member name/alias…
-
ISSUE - Integration of Oracle SQL Table with EPBCS using EPM Integration AgentHi all, I am trying to integrate Oracle SQL table to EPBCS application using EPM Agent and Data Integration. Below is Oracle SQL table ("EPM_AGENT" is table name) For no…
-
Store daily level data in one cube and post monthly aggregated data to anotherSummary:Looking for a solution to store daily level data into one planning cube and post monthly aggregated data to another cube Content (please ensure you mask any conf…
-
How to create a dynamic parameter for monthly data load in task manager?This oracle training video describes how to load data between applications using task manager within a monthly process by entering a fixed period. https://www.youtube.co…