Rules
Discussion List
-
How to Delete Rules after deployment in EPCMCSWe are working on EPCMCS ASO cube and written rules and deployed. A duplicate rule is getting created when we rename the existing rule and deploy it again. Both the name…P Avinash 3 views 2 comments 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management -
Do we have an option to Export / Import the Allocation / Custom Calculation Rules & Rule Sets?Summary: Do we have an option to Export / Import the Allocation / Custom Calculation Rules & Rule Sets to an Excel or a CSV file? This would be massively beneficial in c…NikhilDeshpande 31 views 5 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management -
what is the governor limit in epcmcs for allocation rulesSummary: Hi All, was trying to run one rule but I am getting the error as below: Warning: Rule cannot be saved because it failed the following validations: Potential Sou…Akansha_Ganeriwal 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Executing IPM Insights in EPCM - EPMAutomate/Groovy/RESTSummary: Automation and scheduling IPM Insights in EPCM using either EPM Automate, Groovy or REST API Content (please ensure you mask any confidential information): I am…Andy Das 83 views 7 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management -
Allocation behavior when using "Allocation Amount Type"Hello everyone! Hope you are doing great! I have a question regarding "Allocation Amount Type" when setting up the allocation rules in EPCM. I have a situation: The Calc…GaryYip-Asc 21 views 6 comments 0 points Most recent by Sajal Gupta1-Oracle Profitability and Cost Management
-
Getting a warning for few of the Rules during calculation RunSummary: Hi, I am getting below mentioned warning for few of the rules when calculation is run, this was working fine previously. Also, the allocated results are looking…Harish Kumar C 51 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
REST API to run Business Rule in PCMCSSummary: Hi, I am not able to find REST API to run Business Rule for PCMCS. Is there any REST API available to run BR in PCMCS application. When I tried REST API for Pla…
-
Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ')'Summary Essbase Error(1260052): while running CalculationContent I have been running calculations on PCM model and got the following error. Cannot Perform Custom Calc. E…Rajen Patil 1K views 8 comments 0 points Most recent by AnupamKumar Profitability and Cost Management
-
Member matching expression limitationSummary: In our EPCM app, it has Entity and ICP dimensions. ICP is actually a mirror of Entity dimension with prefix “ICP_”. Every hierarchies are the same. It has a req…GaryYip-Asc 31 views 5 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
No compression set for pcm cube - How to enable this?Summary: Hi, I'm trying to export data in pcm , but getting an error - no compression is set for column dimension, please refer the screenshot, Can someone advise how to…Bernardsha C 42 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
User Smart lists in EPCM AllocationSummary: Dear Experts, How can we use smart lists in EPCM to select Entities based on Smart list values for allocation rules Content (please ensure you mask any confiden…Parmit Choudhury-Deloitte 31 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
SLA Rule for Cost ManagementHi, I have created an Account Rule in Cost Management with Rule Type as Segment (Cost Centre) and would like Standard Cost Adjustment to derive Cost Centre from the Mapp…
-
Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Summary Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Content Hello experts, I want to build a a DLR in Data management to export data …Parmit Choudhury-Deloitte 215 views 8 comments 0 points Most recent by User_511P1 Profitability and Cost Management
-
PCMCS allocation Rules are taking timePCMCS allocations rule are taking 1 hr , Is there any way to optimise the PCMCS application.
-
Groovy Script for Copy Data in EPCMSummary: Dear Expert, Need your help about groovy script. Right now, we are copying data from 1 intersection to another intersection using DATA COPY Feature in EPCM as b…
-
Source member selection for allocate to parent/sibling destinationSummary: Selecting multiple source members for a destination of "allocate to parent" or "allocation to siblings" Content (please ensure you mask any confidential informa…SAW23321 31 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Allocation Out Not calculating when using Allocation to SiblingsI am using an allocation rule where we have "Allocate to Siblings" for one of the Dimensions, the allocation runs correctly however it is not providing "Allocation Out" …
-
Error in Rule Balancing reportSummary: Rule Balancing report throwing an error Content (please ensure you mask any confidential information): While running the Rule Balancing Report following error i…
-
currency conversion in EPCMSummary: I’m using the following currency conversion rule to calculate data in AUD_Reporting for Input, Allocation In, and Allocation Out data. However, it takes too lon… -
1Adding Member Matching Expressions in bulkhello - we are currently working to migrate from PCM to ePCM. We used the template to bring in all of our ruleset and rule configurations, but we do not see any option i…StevenRigby 31 views 2 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM Substitution Variables for OptimizationSummary: Hi Team, I am just curious to explore various substitution variables available in EPCM for better optimization. Request to share if you have used in any of your…Harish Kumar C 153 views 6 comments 1 point Most recent by BhavaniGajula Profitability and Cost Management
-
Designer funsction: Same as source in targetSummary Can we have selecting Same as source option in Mass Edit?Content Hi All, Do we have a option of selecting same as source in multiple rules in Designer > Mass edi…Khushbu Premlani 41 views 2 comments 0 points Most recent by Alexey Jodzichski Profitability and Cost Management -
Write custom rule with NONEMPTYTUPLEHello everyone, I am trying to write a custom calculation to optimize the performance based on Oracle's guidance. But it seems the Oracle standard guidance is not workin…
-
In EPCM, is it possible to create rules and rule sets from excel / csv template?Summary: I know that we can migrate complete rules and models between instances. But I wonder if there is any tool to upload a new rule from scratch? Or we can only crea…
-
Unable to Execute Business Rule via EPM Automate in EPCMSummary: we are trying to execute a business rule (a custom Groovy Script) in EPCM via epm auomate command as per below doc. But it throws an error saying "Not supported…Harish Kumar C 31 views 4 comments 2 points Most recent by Harish Kumar C Profitability and Cost Management
-
Examples of Custom Calculation Rules scriptsSummary: Content (please ensure you mask any confidential information): Hi all We want to know if we can use ALL the MDX functions for EPCM or if there are ANY limitatio… -
Using Multiple Periods in calculations?We have a requirement to use a basis which is calculated from all open periods of a year (FcstMnth:Dec). Is there a good way to calculate this in EPCM? We need to divide…Peter Joelson 11 views 1 comment 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
How to quickly select all members with assigned attributeSummary: In my Source selection for a rule I want to include only members of my Product dimension that have a certain attribute attached. There are roughly 100 that have…KCJ04102003 31 views 2 comments 0 points Most recent by KCJ04102003 Profitability and Cost Management
-
Mass Edit features not workingSummary: No features on the Mass Edit screen are working. Content (please ensure you mask any confidential information): Has anyone experienced an issue where the Mass E…SAW23321 21 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management