Integration
Discussion List
-
EPM Drill Through Resulting in SmartView "Cannot Connect to Provider" ErrorSummary: Drill through to the data stage (i.e. new sheet or web browser) has been working without a hitch, However now receiving the SmartView "Cannot Connect to Provide… -
Can *End Users* import data into PBCS using Data Exchange?Admins can run Data Management processes in PBCS, no problem (via both the Data Exchange GUI, or Data Management). I am trying to allow regular users (or power users) to…
-
Is there a way to delete existing members in Planning using a DM integrationSummary: Is there a way to delete existing members in Planning using a DM integration. In Data Management, when we build a Metadata Integration is there a way to delete …
-
Error while loading special character member data in Data ManagementSummary: Content (required): Hi All, Here we are trying to load data for the members containing special characters like -,(,),", in the EPBCS application using Data Mana…
-
For WF to FS: Can you recreate the functionality as an XWRITE code or map to an additional dimensionIn our app we have two dimensions: Cost Center (CC) and Department (DP). Workforce has Cost Center, and Financials has both Cost Center and Department. The DP and CC hie…
-
How to map FCCS P13 into Planning Dec (P12) ?Summary: How to map FCCS P13 into Planning Dec (P12) Content (required): I've created an extra global period mapping Adj-21 mapped to a target Dec FY21. This led to doub…
-
Capex : BIP Report Data Integration does not workSummary: Content (required): Hi All, Here we are trying to integrate data from FA module - Capex Module with the BIP report using Data Management - Multi Column All Data…
-
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…