Integration
Discussion List
-
Split Concatenation and SQLSummary: Split Concatenation and SQL Content (required): Am processing rows using concatenated values where each segment is separated by an underscore character (_) Ex: …User_2025-02-05-23-55-14-602 21 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Planning -
Invalid IntersectionsSummary: Invalid Intersections works as expected when done through Smart view or Web Form but when it is loaded through DM it does not restrict and allows entry, Is this…User_2025-02-05-23-55-14-602 41 views 10 comments 0 points Most recent by Thejas Shetty-Oracle Planning
-
Direct Data integration new functionality and how it differentiates with Data Management (DM)Content Hi All, I'm curious to know what is direct data integration and how it is being differentiated with data management. From Planning admin guide, I came to know th…User_2025-02-01-07-41-50-723 82 views 5 comments 0 points Most recent by Kyle Goodfriend-Oracle Planning
-
Passing Month varialbe through Data Managment - ErrorSummary: Setup rule "OWP_Process Loaded Data" run after load in Data Management Rule. Set to run After Load with all the prompts set. Calc Mgr Rule RTP "Month" is set to… -
Unable to export data from EPBCS to ERP Budgetary ControlSummary: When we try to export data from EPBCS to ERP Budgetary Control, we get an error : ORA-01427: single-row subquery returns more than one row Content (required): W… -
Will the EPM Projects Module integrate with the EPM Workforce Module if we plan in Workforce by Job?Summary: Will the EPM Projects Module integrate with the EPM Workforce Module if we plan in Workforce by Job only? Content (required): The "Administering Planning Module… -
Drill Through / Drill Back capability on PPM to Projects connection?Content We are looking into doing a direct connection between the ERP Project Management and the Projects cube of EPBCS. Is the drill through and/or drill back features …Peter Joelson 84 views 7 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Planning
-
Can different fields in import format in data integration used for different series of account codesSummary: Can multi column be used to fetch amounts from different columns for a single period? Content (required): We got one requirement from client that all the amount…
-
Set substitution variable in Business Rules Data exchange OptionsSummary: I need to set a substitution variable before loading data, using POV Period and POV Year as a value Content (required): Is it possible to use substitution varia…
-
Use counter in Data Management MappingSummary: We would like to load vacancy data to our BSO cube with data management, in our outline we have the following members (vacancy 1 to 30). With every (monthly) lo…
-
Limits of REST APISummary: What are the limits of REST API? Content (required): Hello everyone. I would like to know what the limits of REST API are. For instance, how many calls I can ma…
-
Error in PBCS Forms - Connection ErrorSummary Error 504 - A connection to the server has failed (Status = 504)Content Hi All, Greetings!! We have recently implemented PBCS and soon to go live. We are getting… -
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…