Allocations
Discussion List
-
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 61 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
Can allocations be triggered using Data pipeline in EPCM?Summary: Is there a way to trigger the allocations within EPCM using Data Pipeline? If yes, could you please help with steps? Content (required): Version (include the ve…Himani Jena 51 views 2 comments 0 points Most recent by Mark Zacchilli-Support-Oracle 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 111 views 4 comments 0 points Most recent by Don Bean-Oracle 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 41 views 5 comments 0 points Most recent by Philip Hulsebosch 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 61 views 8 comments 0 points Most recent by Luis Autrique 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 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
Transfer Pricing EPCM vs FreeformSummary: We are contemplating between EPCM vs Freeform for our Intercompany extension (transfer pricing) needs. Content (required): We need to fetch data from ERP fusion…getgaurav 81 views 1 comment 0 points Most recent by Al_DuqueEstrada Profitability and Cost Management -
Custom Allocation with IF condition in PCMCSSummary Syntax for Custom allocation using IF conditionContent Hi Everyone, I have a requirement in PCMCS where custom allocation should happen using if condition. can s…Avinash B-140267 199 views 4 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
EPCM partial allocation based on driver?Summary: Can you allocate part of the cost pool but based it off the specific driver (instead of using the percentage on definition page)? Content (required): For exampl…Steve Gan - HCG 61 views 1 comment 1 point Most recent by Aman Kothari-191377 Profitability and Cost Management -
How to automatically assign the non allocated amounts (PCM)Summary: We have a model that allocates (entity, cost center, accounts) to two other dimensions (Dim 1 and Dim 2). Content (required): We want to automatically put the n…KleePerf 61 views 4 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
How can I verify allocation rule calculation output/see intermediate results/source contribution?Summary: I am looking for a report which displays the calculation path / intermediate results for every output cell of EPCM allocation rules. Basically a deeper look in …
-
EPCM - Automation of Allocation and Custom calculation Rule multiple times with different PoVSummary: I have a scenario where set of data with same attributes but different PoV(actuals of previous month YTD and forecast values of current month PTD) are loaded fo…Anantha Krishnan 52 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
How to use driver data from another period when Period is a PoV dimension? (blocker)Summary: I have a scenario where my driver data for current month cost allocation is revenue amount of previous year YTD trial balance. Since period is a PoV dimension a…Anantha Krishnan 41 views 4 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
How do you create Allocation using Headcount as a Driver using an offset destination for the DeptSummary: Allocation uses department (LOB) to be allocated to other dept (LOBs) by Headcount Content (required): Source = one LOB, Destination = Multiple LOB, offset = di…
-
Rule limit for EPCM PCM_CLC cubeCan there be more than 2000 rules that can be configured within the EPCM application for a single model? Is there any impact to the performance? Content (required): Vers…Himani Jena 154 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Rule Limit in EPCMSummary:We are currently looking to migrate from PCM to EPCM and the number of existing rules is around 4000. Can we have same rule limit in EPCM as well? Content (requi…Vikasitha 101 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Is allocation percentage against each entity stored somewhere in driver based allocation?Summary: In EPCM when driver based allocation is performed, allocation percentages are computed and amounts are allocated in background. Can we pull the allocation perce…Anantha Krishnan 71 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 49 views 10 comments 2 points Most recent by NK2025 Profitability and Cost Management
-
Possibility to load in Reporting Cube in PCMSummary: We use PCM for allocating Cost. From a Reporting perspective, we have few details that are not involved in allocation, its mutually exclusive accounts, which we…Mary John-Oracle 41 views 4 comments 0 points Most recent by Mary John-Oracle Profitability and Cost Management
-
Multiple Periods using EPMAutomateSummary: Is there a way to run multiple periods in PCM using EPMAutomate. Content (required): Is there a way to run multiple periods in PCM using EPMAutomate. I cannot s…MyNameisMyName 61 views 7 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Allocation rules take too much time in EPCM and throw a warning messageSummary: Some Allocation rules take too much time in EPCM and result in an error/warning message Content (required): I have encountered this issue in which allocation ru…Gomaa Abdel Hamid Mansy 162 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Using Filter in Rules increases the time to calculate in EPCMSummary: When we use a filter for one of the dimensions in the Rule, the time to calculate the rule goes into hours. Content (required): We have a model for one of our c…Rajen Patil 51 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Rule Set Execution Time IncreaseSummary Rule sets execution from one month to the next periods doubled in time with the same dataset.Content Recently we have seen that our calculation times are increas…Cloud.EPM.TMH 55 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Change Period/Scenario/Year in PCMCS QuerySummary: Need help on automatically changing the Period/Scenario/Year in PCMCS Query. Content (required): Hi Friends. We have a script to calculate markup which runs a q…Amit Agarwal-158816 41 views 7 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
EPCM 22.08 UpdatesEnterprise PCM is now configured for more than over 50 EPM Cloud Suite customers. Each month we are focusing on fixes and enhancements identified by early users. Last we…Don Bean-Oracle 51 views 0 comments 6 points Started by Don Bean-Oracle Profitability and Cost Management -
Rounding data to zero decimal precision when loading to Cloud ERP GL using Direct integrationSummary PCMCSContent Hi We have a ledger in Cloud ERP that was configured with zero decimal precision for business reasons. We wanted to round the debit and credit amoun…SenthilSSN 128 views 5 comments 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
How do I create a formula (or rule) that save information in another POV?Summary: Our POV has business unit and we 'd like to save the allocation in in another POV. Is it possible? Content (required): Version (include the version you are usin…Ana Teresa Vicentini 31 views 5 comments 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
PCMCS - Custom Calculation Formula Length LimitSummary: Hi, Is there a limit on the size on the formula (Number of Characters) in the Profitability and Cost Management Cloud Services Custom Calculation. We have a cus…Ashok Kumar Raya 23 views 6 comments 0 points Most recent by Timestamp EPM Team Profitability and Cost Management