Category 146
Discussion List
-
MDX Formula with Avg function is not working in Groovy Business Rule in PCMCS ASO cubeHi, I am creating Groovy Business Rule to calculate Average of an Account from Jan to Current Month and assign this value to other account. ([ACCT_AVG]) := (Avg(({[Perio…RakeshRanjan 27 views 9 comments 0 points Most recent by RakeshRanjan Profitability and Cost Management
-
Change functionality so that the TO Return only have cost when the Organization confirms the ReceiptSummary: In Oracle Cloud we realized that there is a case where Transfer Order Return transactions establish a cost even when the Destination Organization does not confi…José Rojas Hernandez 21 views 7 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
quick mode EXPORT from EPCMhi All from our EPCM application, we want to extract the data set and send to target systems for reporting. We have extremely huge volumes of data (approx 1 million of r…Sucharitnarang 41 views 2 comments 0 points Most recent by AndrewLaferla 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 91 views 8 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
How to set data precision when exporting data from ASO through Data ManagementSummary: We are trying to export data from PCM to a flat file using Data Management. Is it possible to restrict the data precision to 2 as the source is an ASO cube Cont…Vikasitha 51 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
What are the options for data exchange between EPM planning and EPCM moduleSummary: Data exchange between EPM planning and EPCM module Content (required): Currently using EPM Planning and EPCM module for systemization of transfer pricing system…Sucheta Srini 31 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
Is there a limitation on the file size or number of records while exporting via QUICK MODE?While using DATA EXCHANGE - QUICK MODE integration-> to export data to a FILE, (from EPCMS - ASO cube) to flat file, Is there a limitation on the file size or number of …Sucharitnarang 1 view 0 comments 0 points Started by Sucharitnarang Profitability and Cost Management
-
Does EPCM Custom Calculation supports String Operations on left side (Target) of the script?Summary: Targeting the results to certain ICP Dimension members ICP_**** from an alternate hierachy of Product Dimension whose parent will be CP_****. Content (required)…Sivavignesh V 11 views 0 comments 0 points Started by Sivavignesh V Profitability and Cost Management
-
Member formula or custom calc?Summary: Need to calculate average FTEs in most efficient manner Content (required): I have a requirement to calculate average FTEs for a whole list of departments. Curr…SAW23321 21 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Clarification on Simple Reclassification (SR) rulesSummary: What is a simplified calculation process for reclassification rules? Content (required): In the What's New of September 2023 is a note on simplified calculation…Philip Hulsebosch 11 views 2 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Killing Calculation Rules in EPCMSummary: Need to kill the calculations Rules in EPCM Content (required): In EPCM I am trying to kill the running of Rule(s) with the 'Cancel' button. Nothing happens wit…Rajen Patil 143 views 13 comments 0 points Most recent by Dinesh Chand Profitability and Cost Management
-
Calculation Manager enabled in ePCMCSSince last (08.23) patch calculation manager is available in EPCM test applications version 23.08.60. Is this expected? Is this specific to MDX scripts, or are groovy sc…EPM2000886 91 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
MDX format for power(raise to) in custom calculationSummary: Hi All, I want to build below formula, [Adjustment]:=([input][account])*(1+([input][mark up]))^3 What is the format for MDX format for power function (raise to)…Anantha Krishnan 31 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
EPCM - Setting current month number in a account dimension memberSummary: Hi All, I have a scenario where I need current month and previous month in number for some mathematical expression. My plan is to set the number in account dime…Anantha Krishnan 51 views 7 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Announcing a new "How Do I... " Help Center tab to answer your most common questions quickly !Summary: The new "How Do I... " Help Center tab lists easy, common, and necessary tasks for setting up your EPM Cloud environment and Enterprise Profitability and Cost C…Kathleen Day-Oracle 11 views 0 comments 0 points Started by Kathleen Day-Oracle Profitability and Cost Management
-
NEW Reports module open on a different Smartview workbook instead of under a new Excel TabSummary: Content (required): Hi All It seems that the new REPORTS module opens reports on a separate WorkSheet every time we open new Fully formatted reports. We want th…
-
Adding unique Sequence number and system date in EPCM ReportsSummary: We are building a journal entry (WebADI) report for one of the transfer pricing flows using EPCM. Report contains two columns with GL/posting date and transacti…Anantha Krishnan 31 views 1 comment 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
PCMCS Custom Calculation error: Unable to allocate resources for cube PCM_CLC for 10800 secondsSummary: Using dynamic calc member in the custom calculation to calculate stored member Content (required): Hi, we have a requirement to calculate YTD value and use that…User_S3H04 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
What is the rule dimension member [PCM_ Rule]?Summary: Why should calculation always include the rule dimension member [PCM_ Rule]? An error occurs if [PCM_Rule] is not included in the calculation. What role does [P…User_IPP4R 11 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Use multiple cubes for cost allocation in EPCMSummary: Hi, I am exploring an option to use multiple ASO cubes in EPCM for separate types of allocation. If anyone tried, can you please share potential risks or downsi…Smit Shah 51 views 8 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
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 111 views 6 comments 1 point Most recent by NarayananS Profitability and Cost Management
-
EPCMCS Dashboard_Link_ReportHi All, Is there is any option available in Dashboard to link the report???? For example when user open a dashboard and within same page there is option available to att…
-
EPCM Custom Calculation Rule - Mark up for multiple entities in a single ruleSummary: Can we create single custom calculation rule for marking up cost by x% for multiple entities? Content (required): I have 50+ entities and cost of each entity ne…Anantha Krishnan 91 views 6 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
How can the member count limits be increased?Summary: My potential client has roughly 880K product level 0 members. They have roughly 50-100 ancestors. They were curious if EPCM could handle that amount of members …
-
Is there a limit on the number of members that can be added to a dimension?Summary: We are in the process of migrating our Gen1 EPM environments over to the new Gen2 architecture, and as part of that effort, I copied over our existing PCM envir…Braxton Sowell 11 views 3 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
Pipeline LimitationSummary: Hi All, Is there is any limitation of job under one stage. Let say in one stage how many job admin can added?? And in one pipeline process how many stage admin …
-
System adds numbers at the 13th decimal place - entering data errorSummary: Good morning, in EPCM I encountered an error when entering percentages. Example: After entering 1% in a form, the system displayed 1,000000000009%. At that mome…Mueller 11 views 1 comment 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
PCMCS Export data using query not showing AliasesSummary: PCMCS Export data using query not showing Aliases Content (required): Hi, I am trying to export data using query from PCMCS. Even though I select Use Aliases, t…Amit Agarwal-158816 21 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Historical data change in PCMSummary: Our historical "Input" and "Allocated" data in PCM Prod got changed, could I get some suggestions on it's cause and how to fix it? Content (required): Our histo…Parul Pardhi-282807 31 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Menu Parameters for BIP Report IntegrationSummary: We are attempting to integrate with ERP using the BIP Report option in our Target Application in Data Management. The BIP Report we are utilizing uses a shared …Sawyer Teague 21 views 1 comment 1 point Most recent by Sawyer Teague Profitability and Cost Management