Integration
Discussion List
-
[Data Integration Files] Is there a way to automatically purge the outbox of exported files?We recently have been creating a variety of data exports via Data Integration. Some of the output files are large (upwards of 80mb), and these extracts are running every… -
EPM Integration Agent - stops "completing" the polling calls & how to monitor?My client has two different agents running on the same staging server, one for ARCS and one for Planning. ARCS has been running very smoothly for ~6 months. Planning has… -
Data Export to File Pivot: Columns missing due to no data for the specific memberIn Data Management/Data Integration, I have a data extract process that utilizes the Data Export to File method to pivot Accounts as column headers (5 Accounts in total)…
-
NetSuite Planning & Budget Data Integration helpSummary: NetSuite Planning & Budget (NSPB) uses saved searches to import data and metadata from NetSuite into Planning. Saved Searches are part of a bundle. I have used … -
Failure in updating the URL for source system in target application under the Data Management?Summary: We have migrated the application from PBCS to EPM Cloud. In data management we have updated the URL's for the Target Applications. There are few Target Applicat… -
Load data using data management while entity is under approvalsHello everyone, I am locking entity using approvals or through dimension security, then I cannot submit data using SV, that's ok. Now, I Can load data using data managem…
-
Required roles in ERP to integrate EPBCS to ERP BIP report data load /EssJob executionSummary: We are trying to integrate to pull BIP report data from Cloud ERP to EPBCS using DM custom ERP job and essJob. Content (required): We wanted to know the require…
-
Budget Writeback to ERP from EPM (change sign)Summary: Change sign of revenue while budget writeback Content (required): Hello, When we bring Actual data from ERP we tick the change sign for revenue accounts. At the…
-
Agent Data Integration-How to stop jobs in QueueSummary: We recently started experimenting with data integration using Agent. One of the jobs I submitted with Agent was taking quite a long time so I stopped it. I kick… -
Writeback using Integration Agent with Job/Process IDSummary: We are creating a process to write back into EBS and are using the integration agent as that is the path to bring data in. We were thinking using a custom inser…
-
Data Management Range Mapping to Wildcards, possible?Hi All! Is there any way we can have the mapping below with Sql script? Range from 92??-???? to 933?-???? mapped to 92??_???? to 933?_???? Thank you -
[Data Integration] How to automatically clear combinations across multiple dimensions on import?Hi everyone, We have a process where we import a flat text file extract from an external system into Planning via integration. Upon import, we have a Clear Region define…
-
Add a dummy line in DM export fileSummary: We would like to add a dummy line in a data management export file to keep the structure the same. Content (required): Hi, We have a DM export rule which create…
-
Null values for Alias in Data Integration metadata loadSummary: How to handle null values for Alias in Data Integration Content (required): I am trying to load metadata to EPBCS from an on-prem Teradata warehouse using Data …
-
Help from beginner on Budget Writeback to Fusion GLSummary: Source System Initialize was successful in Data Management but there is no corresponding Target Application being created. Content (required): I'm able to fetch… -
Unable to run Data MapsSummary: We created several data maps that we associated with Models in Strategic Modeling. The Data Maps are meant to move data from the Models to our ASO cube. It seem…
-
Is there a restriction on naming your application "EPBCS"?Summary: Client requests application name mirrors the type of application it is (call EPBCS "EPBCS, "PCMCS","ARCS" etc). Content (required): I wanted to see what the opi…
-
Integration between ERP Fusion Budgetary Control and EPM Planning Financial using Budget RevisionSummary: Integration between ERP Fusion Budgetary Control and EPM Planning Financial using Budget Revision Content (required): Integration between ERP Fusion Budgetary C…
-
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 42 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 M. 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 83 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…