Allocations
Discussion List
-
Scratch cellsHi I want to know about scratch cells role and what are the use cases for it also, what is the value for substitution variable. thanksSucharitnarang 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
PCM to EPCM migration Data POV issueSummary: While performing, PCM to EPCM migration, the status shows in progress for a long time and doesn't proceed forward when we included Data POVs, but the report is …Vikasitha 31 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle 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
-
Filters are not working on Rules for Attributes and UDASummary Filters are not working on Rules for Attributes and UDAContent Hi, It appears that when we use filters in Rules for Attributes and UDA the rule fails during run.…Parmit Choudhury-Deloitte 76 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management
-
Alternate Offset LocationContent Hi, What is the relevance of using Alternate Offset Location in Rules. It is clear that when we use this option, data from Offset Location member combination ref…Mohit Pahuja 68 views 5 comments 1 point Most recent by Harish Kumar C Profitability and Cost Management
-
Allocation Rule fails because Essbase Error(1013295): Server Request Fails with error code [1200601]Summary: Dear experts, I created a normal Allocation Rule in EPCM and it works usually. Today, it always runs on an error ErrorAllocation Rule 'ALLOCATIONRULENAME' faile…
-
Allocation In is calculated but corresponding Allocation Out is not getting calculatedSummary: In a model for a few Rules, Allocation In is calculated but for the same Rules corresponding Allocation Out is not calculated where the 'Offset' is at the Sourc…Rajen Patil 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM Precision issue while allocating dataSummary: While allocating data, the Allocation In and Out values are not matching and giving out minor difference (upto 0.20) which is summing up to give out a huge diff…Vikasitha 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
I have traceability requirement in EPCM. Any design suggestion or recommendation to achieve this.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…Nilotpal Bhaskar 31 views 2 comments 0 points Most recent by Nilotpal Bhaskar Profitability and Cost Management
-
Groovy Script to start an Allocation RuleContent (please ensure you mask any confidential information): Dear Experts, I try to create a groovy script to start an allocation rule from Planning but always receive…Mueller 121 views 12 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
PCMCS bug when we change Period = YearTotal in rule / to Period = Jan in global contextSummary: In PCMCS, we use a model with the YearTotal period defined in each rule for our Budget, because YearTotal is not accepted in the Global Context. When the Budget…Frank_Fec 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Mass Edit "Replace member" feature in EPCM is not workingSummary: Mass Edit "Replace member" feature in EPCM is not working to remove a member. Previously to remove a member from Source/Driver, we used "Replace member" feature…Vikasitha 41 views 2 comments 0 points Most recent by Crystal Eide Profitability and Cost Management
-
Is it possible to assign security to a specific EPCM Model?Summary: The client requirement is that one user should only be able to edit, view, and execute Model 1 and User 2 should only be able to do those activities for Model 2…Hema R 21 views 1 comment 0 points Most recent by Old_School_DCom-Oracle Profitability and Cost Management
-
Merge Incremental Cells and Compact CubeSummary: We are using Merge incremental slices (merge all into main slice) and there is improvement when using this, the cost of querying inc data also reduced from 0.9 …
-
Is it possible to reference PCM_Rule as a source dimension in an allocation rule?Summary: Content (required): Hi. I have a custom calc rule that moves dollars from multiple markets to a single market prior to allocating the dollars. I would like to u…SAW23321 81 views 7 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Allocation Amount (Operating Expenses - Revenue) in PCMCS AllocationsSummary: Content (required): Hi All, We have a need to reference the account (Which should be the result of Expenses – Revenue instead of Net Operating Income (Revenue -…Ashok Kumar Raya 81 views 12 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM - Divide by proper and improper zeroSummary: While performing an allocation if denominator encounters a proper zero and an improper zero how does the calc be treated/performed? Content (please ensure you m…
-
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 71 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 82 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 224 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 72 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 …