Integration
Discussion List
-
Standard Mapping Issue Between ERP and EPM – Unable to Update Dimension/Classification Column NamesHello everyone, We are currently implementing an Oracle EPM project, specifically integrating Oracle Cloud ERP with EPM. Using Data Exchange, we set up a data load to br… -
Viewing columns in drill throughSummary Viewing columns in drill throughContent Reaching out to all Data Management experts We have setup file-based integration which brings along additional reference …
-
Performance issue with writeback operations to Snowflake table using EPM Integration agentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
PBCS jobs getting stuck at drill through step in DMSummary: PBCS jobs is getting stuck at drill through(Create drill region HPL_DRILL_REGIONS) step in DM and kept on running until we cancelled the job and changed the dri…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
File Based Integration Explicit Period Mapping Not Allowed?Summary: I am trying to do a multi period data load in Planning that is a file type. I setup a Source Period Map, but don't have the option to setup Explicit mapping, is…
-
Pipeline setup for Copy to SFTPSummary: Content (please ensure you mask any confidential information): Hi, Can anyone provide some guidance on how to setup the Copy to SFTP with pipeline? While readin…
-
EPM to ERP Project management Project ExportSummary: We are trying to Export Approved Projects (Created in EPM) to ERP PROJECT MANAGEMENT through jobs Export projects and Budgets. It is showing Error. Content (ple…
-
Smart Push warning in EPM PlanningSummary: We configured some Datamap in EPM Planning. However, when excecuting smart push, the following warning message was displayed. I have no idea why this message ha…
-
ERP to EPM integration failing with error Connection Project Reporting is not found in applicationCan Someone help me on this issue: I’m facing an issue while exporting projects from EPM Standard Cloud to ERP. I’m unable to create a connection using “Project Reportin…
-
Can we add source data and create new data in data integrations?Summary: I have a data integration created in data exchange to map data from a CSV file to an existing cube. I have a new requirement to add two rows in the source file … -
How to stop completely the data load rule (DLR)Hello; I stopped the DLR by clicking on Reset Status but Transform stage continues to work... Does anyone know how to really stop the DLR ? Would be grateful for your an… -
Cross Pod Pipeline not recognizing connectionWe have a pipeline that goes cross pod (Planning » ARCS). For some reason now when I use the connection I still only get the integrations from the local planning applica… -
Pipeline Job is failing with 'periodName' parameter is blank.Setup a nightly pipeline. This integrates with Oracle ERP and builds all the dimensions + loads actuals. The load of actuals is failing on this particular pipeline with …
-
not able to import custom attributes from HCM extractSummary: We want to import data from the HCM Cloud, but other than the columns present in OOTB extract for "Assignment Data" there are other columns also that are needed… -
Oracle EPBCS: Unable to execute CopyfromSFTP in pipelineHi all, In our current project, we are trying to bring a txt file from SFTP server to Oracle EPBCS Inbox folder. We have recently encountered a job "CopyfromSFTP" in pip…
-
Error-EPM to BIP report integrationSummary: Content (please ensure you mask any confidential information): Hi, We are developing the EPM data management integration to pull ERP COA segments (metadata) to …
-
Exception: java.lang.RuntimeException: The CSV output file was not found on UCMSummary: We are trying to extract and load Procurement data from Fusion to PBCS but are getting the above error. We have followed the set up steps in the documentation a…
-
pipeline file name that changes every monthSummary: my file in SFTP serveur is PBCSFILE_XXXX where XXXX changes every month (202508, 202509) is it possible to make this dynamic ? i tried with substitution variabl…
-
Cannot run pipeline through GroovyHello everyone, I am trying to run the pipeline using Groovy. I could run integration with Groovy, but the pipeline couldn't. It showed the error: The pipeline name is i… -
Data Management Log RetentionSummary: How long are logs available in Data Management? Content (please ensure you mask any confidential information): When I scroll to the bottom of my list, it goes b… -
Migrating integrations from Development to Production in Planning applicationSummary: Hi, Can someone let me know the steps to migrate integrations from Development to Production? I tried moving Pipeline definition, but the integrations did not c…
-
NetSuite Saved Search different from Data Management in PBCSSummary: Content (please ensure you mask any confidential information): We are loading NetSuite data to PBCS in data management using a NetSuite saved search. I'm runnin…
-
Integration isn't loading correctlySummary: I am making an integration pipeline and one of its stages is a Data Load Rule. However, the data integration wouldn't load the correct data load rules for the N…
-
EPM Planning to ERP Financials connection with SSO credentialsSummary: We need to create a connection from EPM Planning to extract actuals from ERP Financials where ERP is only accessible using SSO. Content (please ensure you mask …
-
EPM User group management via integration from source systemWe are planning to maintain our user group within EPM to maintain current status and security in line with our source system through EPM Automate and an internally maint…
-
Dynamic calc from Source EPM App to Stored member in Target EPM AppUsing Data Load Rule (Data Excahnge/Data Integration) I am trying to pull a Dynamic Calc from a Source EPM Planning (ASO) to Stored Member in Target EPM Planning (ASO) T…
-
Which Export Mode to use in Data Exchange Integration to override the data intersection?Summary: We have a data file where there are duplicate intersections. On prem Rule file is set to overwrite, so it loads the last intersection. But on cloud, when we run…
-
Integration Option 1 2 3in Data Management meaning?Hello everyone, I saw in the data integration have "Integration Option 1,2,3,4", but not sure what their purpose is: I tried to find the example and document but did not…
-
EPM to Oracle ERP Cloud Integration - getting a 401 UnauthorizedWe are working to setup to the connection between EPM Data Exchange and Oracle Cloud ERP. When defining the connection in Data Exchange and hitting "Test Connection" we …