Data Integration
Discussion List
-
EPCMCS Pipeline FunctionalitySummary: Pipeline functionality has been released. Can you run PCM Models using this capability? Content (required): In more complex environments with a significant rule…Adam Spiller 254 views 11 comments 1 point Most recent by NarayananS Profitability and Cost Management
-
Rounding Issue in PCMCSWe are facing an issue in rounding decimal places in a file that we are extracting from Data Mangement Interface of PCMCS. In custom calculation rules, the decimal place…Kavita Ganesan 85 views 5 comments 0 points Most recent by Peter Joelson Profitability and Cost Management
-
REST API to execute Multiple POVs does not return all Child jobsSummary: REST API to execute Multiple POVs does not return all Child jobs Content (please ensure you mask any confidential information): When executing calculation for M…
-
multi column-all data type export through Data ExchangeSummary: Hi Experts, We have a requirement to export smartlist and 2 data values of DataSource dimension from ePCM into a file. We chose to use Data Management for this …Sahitya Guruju Veena 13 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
In EPCMCS, data is not getting pushed to REP cube using Data ManagementI'm pushing data from the Oracle Planning Cloud to the EPCMCS Reporting cube using "Data Management", I'm getting the below error, my metadata is Refreshed, and there is…Kumari Soni Umesh 193 views 9 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
PCM Essbase data load on member with Chinese charSummary: Our application has products with chinese characters in the member name (not alias), so when we are trying to load data to the PCM_CLC cube its throwing error s…HarryEPMUser 12 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Loading allocation results to ERP GL CloudSummary: Loading allocation results to ERP GL Cloud Content (please ensure you mask any confidential information) We have a need to load the results of our EPCMCS alloca…SAW23321 28 views 2 comments 0 points Most recent by user736959-Oracle Profitability and Cost Management
-
Unable to set decimal precision for Data integration and EPCMSSummary: Content (please ensure you mask any confidential information): Hi all When exporting Data using data management with EPCMS I am not able to set the data decimal…
-
Does integration between PCM_CLC and PCM_RPT timeout more often because of enormous data size?Could the timeout issue in the integration between PCM_CLC and PCM_RPT be caused by the large dataset stored in PCM_CLC, which is slowing down the query performance? Cur…Supanut Sinphatsirikul 35 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
integration between EPCM and Planning Cloud failing with 401 errorSummary: Content (please ensure you mask any confidential information): Hi all While running and integration between Profitability [source] and Planning [target] cloud a…
-
Any performance tuning service provided by Oracle Support?My client possesses a vast amount of retail data combined with a highly complex data model, resulting in numerous intricate data intersections. The whole process of load…Supanut Sinphatsirikul 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Are there technical specs available for the file based import method under data integration?Summary: Is there a technical doc that outlines the EPM system controls used in the file-based integration method? Content (please ensure you mask any confidential infor…MarshaH 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Drill through to BIP report not working with RUN TIME PROMPTSHi All From EPBCS application, we are trying to drill through to source system i.e. BIP report. The BIP Report has 2 Run time parameters P_YEAR (Values = 2024) P_MONTH (…
-
are special characters in Multi Dimensional Mapping allowed in ePCM?hi, the below 2 articles seem very conflicting. in the first one: "the target values for multi-dimensional mapping must be an explicit member name. Wildcard or special c…StevenRigby 41 views 7 comments 0 points Most recent by Kapil K Nankani-Oracle Profitability and Cost Management
-
EPCM with Approval Flow and Task ManagerSummary: How to set up EPCM with Approval Flow and Task Manager? Content (required): I try to set up an EPCM process with a guided process like in task manager and to sa…Mueller 131 views 4 comments 0 points Most recent by Tom LeFebvre-Oracle Profitability and Cost Management
-
Unable to exclude members based on conditional search from a source filter in EPCM Data ManagementWe are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as …
-
Including alias in data exportSummary: How to get alias into data export Content (please ensure you mask any confidential information): We have a job in Data Exchange that exports our data to a flat …
-
How to ignore shared members data while exporting through Data managementSummary: How to ignore shared members data while exporting through Data management Content (please ensure you mask any confidential information): Version (include the ve…
-
Folder in Inbox are missing after the Legacy to Enterprise App MigrationSummary: On Migrating PCMCS application from Legacy instance to Enterprise instance, I identified that in Data Management no folders under Inbox/Outbox got migrated duri…Chiranjeevi Naragani 48 views 4 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Profitability and Cost Management
-
Export mode for data integration is forced from "Replace" to "Merge"Hello, My team is implementing EPCM for a client, and we have noticed strange behavior when attempting to run a data integration. We are using Data Exchange to import a …Pat_sch-eat 21 views 2 comments 0 points Most recent by Randa-Support-Oracle Profitability and Cost Management
-
How to sign flip when we are extracting data from EPM application through Data Exchange Quick ModeSummary: We are trying to flip data on Expenses when exported from EPM application through Quick mode of Data Exchange, but could not find any option. We found all other…
-
EPCM Outbound Extract CLC or RPT cube??Summary: For outbound integrations should the extract be run from the reporting cube or the calculation cube? Is there a performance benefit to running the outbound inte…Cloud.EPM.TMH 22 views 3 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Data Integration with no corresponding source dimensionI am using data integration to move data from Planning to EPCM, can someone please tell me how to set up mapping to a member of a target dimension when there is no corre…
-
Mapping of Dimension based on different data Intersections directly in EPCM ApplicationSummary: Dear Experts, Our Source data is of "No Entity" and we want to map it to proper Entities based on different dimension member combinations (Account → Revenue/ Ex…Sivavignesh V 12 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Pipeline StartPeriod and EndPeriod VariablesSummary: We would like to use Substitution Variables set at the application level to drive the date values for the StartPeriod & EndPeriod integration from ERP to EPM/PC…
-
Data ExchangeSummary: Hi All, Is there is any webinar or workshop conducted by oracle for Data Exchange topic. Can any one share the Link. Thanks in Advance.Avtar 31 views 3 comments 0 points Most recent by Raavi Divya sri-Oracle Profitability and Cost Management
-
Data Clear POV via PipelineSummary: Hi All, We are using pipeline feature to clear POV. We are getting error while executing the pipeline. I am attaching the configuration below is the parameters …
-
Call Pipeline job via epm automate commandSummary: Hi All, Can we call pipeline job via epm automate command or if it is not possible in the current release then Is there is any way we can schedule pipleline bas…
-
Can pipeline variables be used in job fieldsSummary: I am trying to run the calculate model job in EPCM and have the sourcepov be a pipeline variable that can be put in when the pipeline is run. Is it currently po…
-
Instructions for setting up EPCM with EPBCS DM?Summary: We are working on migrating from PCM to EPCM. I am attempting to set up the DM interfaces between the two and cannot get them set up in EPBCS. I can get them to…