Integration
Discussion List
-
The member does not exist for the specified cube or you do not have access to itSummary: We created a new child under a shared parent hierarchy in EDM. When we run our integration to load metadata into PBC we are receiving an error that says the new… -
Unable to push data from WF to Fin Cube using OOB Data Maps for Non Comp AccountsSummary: Unable to push data from WF to Fin Cube using OOB Data Maps for Non Comp Accounts. The data maps is only letting us push the Data to a single Account in Fin Cub…
-
Netsuite to PBCS interface custom transaction typeSummary: Custom transaction type records are not included in saved search import in DM Content (required): We are trying to import data from a saved search from Netsuit …
-
[Data Integration] Explicit Period Mappings for file imports broken?Hi everyone - I am experiencing an extremely concerning issue (submitting a severity 1 SR shortly as well), where our Data Integrations that use explicit Period mappings… -
[Data Integration] How can I generate and include a timestamp on a Data Export to File extract?I am looking to add a timestamp on a data extract via the Data Export to File target application type. From what I can tell, this is not a straightforward task, but I co…
-
How to ignore the negative amounts in the outbound data management Interface?Summary: We are extracting a data from EPBCS cube to a flat file. But, it contains the negative amounts in it. Is there any way to ignore these neagtive amounts? Content…
-
[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