Integration
Discussion List
-
Need to connect an On Prem Source to EPBCS using OICSummary: Need to connect an On Prem Source to EPBCS using OIC. Couldn't find much help online but wanted to understand that since we will be using REST API for the conne… -
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…