Integration
Discussion List
-
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 21 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…
-
lookup dimension in multi dim mappingIn the context of multidimensional mapping, it is feasible to utilize a lookup dimension. Within the specified application (Datasource onPrem File), dimensions are mappe…
-
Data management Source Filter results in empty data set and makes process failSummary: Data is empty in the filter defined in Source Filter during the start of the closing week, but works OK later when data is posted to the filter intersection. Co…
-
Budgetary Control Drill Through (Custom Application)Summary: Can budgetary control drill-through be setup for non-financials module? Content (required): Looking at the documentation for Budgetary Control drill-through, it…
-
EPM Cloud SSO with IDCSSummary How to integrate EPM Cloud with IDCSContent * Oracle Identity Cloud Service (IDCS) * The value of IDCS for EPM Cloud * SSO Flow – 2 Options * IDCS as the Launch …
-
EPBCS needs both GL and AP integration for same account. Do we need some data transformation?Summary: There is a requirement as follows: EPBCS will integrate with GL to take the balances for the Accounts, but 1 custom dimension does not exist as segment in GL. T…
-
Planning to Project Management ConnectionSummary: We have a custom project planning application in EPM that we want to be able to send new project to ERP Project Management. I can only find documentation on the…
-
Choice List for BIP ReportSummary: Use Choice List for the parameters of BIP report Content (please ensure you mask any confidential information): Hi, I asked a question in another post, and it d…
-
how can I use mapping script in the new data exchange in EPM cloudI need to create a multi dim mapping with some lookup dimensions, but I cannot find the pencil to edit the #SQL script. Is this functionality disabled in data exchange?
-
Can not write back budget data to ERP cloudP/s: I also tried to put zero. But acting like #Missing, zero was not pushed into ERP, and 20.000 remains.
-
Is there a way to insert a Delay in PipelineSummary: Ability to have an xx amount seconds delay in between actions in Pipeline Content (please ensure you mask any confidential information): We are wanting to perfo…
-
Access Narrative Reporting folders/artifacts from EPM PlanningI've been exploring the integration of EPM Planning with Narrative Reporting and have come across a couple of options: 1. I've successfully set up connections from EPM P…
-
What's New in 20.08?Summary ... some exciting stuff, as usual!Content Okay, so I'm about a week late with this post this month. I hope you haven't been having withdrawals, pacing your home …
-
Groovy script not performing the bursting definition jobSummary: I need to perform a bursting definition job in NR for which the Groovy script has been developed in the EPM planning. We have established the connection for the…
-
Map multiple members from one cube to another that do not have the same dimensionSummary: Map multiple members from one cube to another that do not have the same dimension. For example, we have two cubes, OEP_FS and Plan. OEP_FS has a standard dimens…
-
EPBCS/FCCS Integration to SAP 4 Hana and SAP ECC using EPM Integration Agent or OICSummary: EPBCS/PBCS Integration to SAP 4 Hana and SAP ECC using EPM Integration Agent or OIC Content (required): I wanted to know what is the best option out of OIC & EP…