Integration
Discussion List
-
Drill Through multiple layers?Content Our application has all actual data in PPM and is loading to FCCS for consolidations and then will load to EPBCS. From EPBCS can you drill back to the Project in… -
Updates to Fusion ERP Cloud Data Adapter in 21.10Summary: Updates to Fusion ERP Cloud Data Adapter in 21.10 Content (required): Attached file demonstrates how to link a custom ESS Job encapsulating a BIP Report in Fusi… -
Backup Data Management DataSummary Is it possible to backup data management (FDM) data?Content Hello everyone! I would like to know if it is possible to backup the data that is inside the Data Man…
-
[Data Management] Is there a way to dynamically name the export file based on the run year?Summary: Hi everyone, We are extracting data from our Planning application for an external PowerBI dashboard using the "Data Export to File" target application type. Bec… -
Is it possible to concatenate two Source Columns to load into a dimension when the source is ERP-GL?Summary: Content (required): We are using Oracle ERP Financials and have two segments, Program and Activity. In Planning, we are going to combine the two to make up a di… -
Best ways to provide data extracts for external applications/data warehouses/dashboardsHi everyone, We have been receiving more and more requests for data extracts from our Planning application into various data warehouses, dashboards (such as PowerBI), et…
-
What's New in 21.09?Summary: To start with, we have a new user interface for Customer Connect! I've added my What's New in 21.09? as an "Announcement," which is found on the right side of t… -
Dynamic update of Metadata with discarded items from FDMEEContent Hi all! I'm working on PBCS and I'm triyng to understand if it is possible, using groovy, to create some dimensions' members dynamically during and FDMEE data in…
-
How to connect Oracle ADW with JDBC url in data management using EPM Agent?Content Hi Team, We had the data and metadata integration with DBCS (Database cloud services) using EPM Agent. But, now we have opt for Oracle ADW (Oracle Autonomous Dat… -
Problem with Non-English Characters in ERP IntegrationSummary Non-english characters are not displayed correctly in ERP IntegrationContent Hello, everyone. We created an integration in Data Integration to load data from the…
-
Data Management shows data values but exports zeros to PBCSSummary File load reads values into Data Management, displays them as mapped but no data arrives. examining the .dat file produced shows every data point is zero.Content…User_2025-03-07-20-43-29-854 148 views 1 comment 0 points Most recent by User_2025-03-07-20-43-29-854 Planning
-
Issue with data export via Data ManagementContent Hi All, We are trying to export data via data management, we are getting the following error message: 2021-08-23 15:02:49,604 ERROR [AIF]: Cannot calculate. Essb…
-
Write back to multiple target accounts from a single source account.Content Our requirement is to write back data from a single account in source application to multiple accounts in target application. We have mapped once source account …
-
Map FCCS entity currency to input currencyContent We get an error on loading EPBCS from FCCS using data management INFO [AIF]: Load data encountered the following errors: | Error: 3303 | Entity Currency | "A2250…
-
What's New in 19.02?Summary A lot!Content I'm sure you haven't slept well awaiting my "What's New" post, so here it is! ;-) As always, please read the latest What's New document for full de…
-
Combining two segments into one dimension in Data ManagementContent Hi there, I am new to Data Management/Data Exchange and we have a dimension in our planning application where we've taken two segments from ERP and combined them…User_2025-02-11-03-04-07-792 49 views 2 comments 0 points Most recent by User_2025-02-11-03-04-07-792 Planning
-
Number format conversion (".," to ",.") using SQL in Data ManagementSummary Converting amounts in Data Management from EU to US notation via SQL scriptContent Hi everyone! Is there a way to change the number format in a value in Data Man…
-
Source plan type error in FDMEEContent Hello! I created a data load rule in FDMEE, which worked until yesterday. I had to make some changes to the filters, and when trying to save...the option of "Sou…
-
Integrate EPM with TableauSummary Data and metadata integration with TableauContent Hi every one, I was wondering if it is possible to integrate EPM with Tableau, I understand there is not a conn…
-
JSONObject is not a number error - PBCS/NetSuite integration using NSPB SyncSummary When extracting information using the NSPB Sync connector from NetSuite ERP to PBCS, I receive a message error that is preventing me to advance on the integratio… -
Set Aggregation property for metedata load through Data ManagementContent Hi, I'm loading metadata, Entity as in this example, through Data Management. It's a simple flat file and it doesn't have a field for aggregation property. I'd l… -
Data Load Mapping - Multi DimensionContent Hi all, We have a requirement to map the "Company" and "Business Unit" segments of ERP Cloud against the "Entity" dimension in Planning application. We have defi…
-
Integration with SalesforceContent Hi, I ran into to these 2 websites when I was doing some reserach on PBCS intergation with Salesforce. They were posted 2 years ago and I wonder if anyone is awa…
-
/interop/rest/v1/reports returns Error "Resource does not exist : ."Summary reports API returns same error "Resource does not exist : ." for any report selectedContent Hi all, I'm trying to get a report from EPM (like User Audit Report, …
-
Data Integration - conditional script failingContent Hi all using this script in Data Integration is failing: CASE WHEN ACCOUNT =="0" Then "NOMIS" ELSE "MIS" END --------------------------------- Is there a better … -
Data Management - Loading mapping limitationSummary We are trying to load a mapping file (.txt) which contain over 125k lines.Content There is lot of mapping in the file and it is multi dimension mapping. Any sugg…User_2025-02-10-15-23-04-423 31 views 5 comments 0 points Most recent by User_2025-02-05-23-55-14-602 EPM Platform and Freeform
-
Data Management is not clearing data before load into BSO cubeSummary The Clear Region is set-up but data is not clearingContent I have successfully set-up a data management clear region for ASO cubes. The data is cleared and I see… -
Workforce to Financials: How to map salaries to a custom accountSummary Need to change the mapping of salary to a custom accountContent Hi, I want to change the mapping of the basic salary from workforce planning to a different accou…