Data Integration
Discussion List
-
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 … -
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 …
-
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…
-
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 40 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Profitability and Cost Management
-
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 44 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 25 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 21 views 3 comments 0 points Most recent by Philip Hulsebosch 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 81 views 4 comments 0 points Most recent by Don Bean-Oracle 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 11 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 36 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…
-
Is direct data transfer from PCM_CLC to PCM_CLC transfer stable?Summary: Content (please ensure you mask any confidential information): Hi Experts, Currently we have a quick mode integration build which pulls data from PCM_CLC (sourc…Ashish Antony 11 views 1 comment 1 point Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
Smit Shah 31 views 4 comments 0 points Most recent by Stu G-Oracle Profitability and Cost Management
-
Export and Import to a file Rules, Rule Set and Model's in EPCMSummary: The objective is to automate the creation, alteration and deletion of Models, Rule Set's, and Rules (usual artifact to configure and allocation rule and grup of…Michel_MB_PwC_ADV 82 views 2 comments 1 point Most recent by Michel_MB_PwC_ADV Profitability and Cost Management -
Custom Date column addition in EPCM to GL write back interfaceIs it possible to add a custom date column which represents last date of accounting period in the JDBI extracted .csv file? Another requirement is to get the new date co…Aashish Kumar-248418 41 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Profitability and Cost Management
-
How to can Reset Weight and Cube on a Shipment to the latest values in Oracle Fusion?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to use Substitution Variables in Data Management-EPCMCSSummary: Hi All, Is this possible to use Substitution Variables in data load mapping?. Let say we already run 12 month data for working version and now we want to copy t…
-
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 233 views 9 comments 1 point Most recent by Katie Seavy Walker Profitability and Cost Management
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…Avtar 22 views 1 comment 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
EPMAUTOMATE command doesn't exist to launch pipelineSummary: EPMAUTOMATE commands are not available to launch Pipeline. Content (please ensure you mask any confidential information): Unable to launch pipeline job. Version…Sreenivas Rayala-Oracle 31 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management -
Error in loading PCMCS data to EPBCS financialsSummary: Trying to push data from pcmcs to epbcs but facing a issuse in transform step. Content (required): We tried mapping the target application values(EPBCS Financia…
-
Unable to refresh members from source (EPBCS) application in an EPBCS to EPCM integration.Summary: In Data Management I am unable to refresh members from the source application (EPBCS Reporting cube) after registering the EPBCS application. In error log it's …Sanchari Chakraborty-Oracle 31 views 4 comments 0 points Most recent by Sanchari Chakraborty-Oracle Profitability and Cost Management
-
EPCM - YTD from PTD source data for every periodSummary: In EPCM, all of my current month calculations require previous month YTD data for calculation. we have not created any additional period type dimension and its …Anantha Krishnan 162 views 9 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Unable to use Rule dimension in EPCM to populate Journal Line Description in Integration with ERPSummary: We are sending data from EPCM to ERP as a single journal using Data Integration. The requirement is for the user to be able to see in ERP which allocation rule …