Calculation
Discussion List
-
September Interactive Demo Hours: Accelerate Revenue Profitability (Incentive Compensation)Always live, never recorded! It's that time again. Interactive demo hours are scheduled for September. Want to motivate your team to reach sales goals? Learn how to leve…Kayleigh Halko - Oracle-Oracle 60 views 0 comments 0 points Most recent by Kayleigh Halko - Oracle-Oracle Incentive Compensation -
Custom rule taking longer time not completingSummary: The PCM custom rule is not completing. I also tried using NONEMPTYTUPLE I want to apply multiple project % drivers with the PR000000 project value. Any idea hin…
-
Quick Data Copy in Aso by GroovySummary: In PCM, I have 30,000 Src,100 Bu,1000 Client and 5000 Accounts and will be copying data from one grid to another. In Groovy code I am using 3 List to read row(S…
-
what are the MDX functions supported in EPCM and how to use them in custom calcsSummary: Content (please ensure you mask any confidential information): Hi all Can someone please point to the the list MDX functions supported in EPCM latest versions a… -
February Interactive Demo Hours: Incentive CompensationAlways live, never recorded! It's that time again. Starting off the new year strong with newly scheduled interactive demo hours. In this one hour showcase, you’ll get an…Kayleigh Halko - Oracle-Oracle 21 views 0 comments 0 points Most recent by Kayleigh Halko - Oracle-Oracle Incentive Compensation
-
How to publish calculated data from PCM_CLC to PCM_REP for reporting purposes?Hello, We are currently working with Oracle EPM – Profitability and Cost Management and would like to gain a better understanding of how the PCM_REP cube is intended to …Hans Villanueva Rojas 21 views 5 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
Best practice for defining formulas in Profitability (Account members vs pre-calculated KPIs)Hello, In Oracle EPM – Profitability and Cost Management, we currently use formulas defined in the Account dimension, since many of our reports directly consume these me…Hans Villanueva Rojas 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Best practice for using PCM_REP vs PCM_CLC for reportingHello, We are working with Oracle EPM – Profitability and Cost Management and would like to validate the recommended best practices regarding the use of the Calculation …Hans Villanueva Rojas 31 views 2 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
Which database table holds intermediate calculation results when using split option on rate tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Cells updated are negativeSummary: We are observing a stats report post allocation where number of cells updated are negative for many rules. In general, what are the reasons for this. Hi @Don Be… -
Dynamic mdx calc of driver not working in allocation rule.Summary: Hello Experts - I have calculated a dynamic driver and the results are correct when compared to manual calc of same. However, when using the driver member in th…
-
Elapsed Time does not match with the time shown in the Calculation Statistics ReportSummary: Hi everyone, I am new to PCMCS and exploring the functionality in the sample application (BksML50). I was running a simple allocation rule with reference to the…Jacky_Chan_I4MUA 21 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Validate Data Form using GroovySummary: We are capturing a percentage input on a data form in EPCM. Content (please ensure you mask any confidential information): We are capturing a percentage input o…NikhilDeshpande 21 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management -
Use of Substitution variable in Custom Calc in EPCMSummary: Substitution Variables used in Custom Calcs are not working though rule shows as Valid. Content (required): We have a use case where we need to calculate the Cu…Kapil K Nankani-Oracle 201 views 4 comments 1 point Most recent by Surendra Agrawal Profitability and Cost Management -
Incentive Compensation - Determine Deleted Transactions from the log delete_txn_on_collection_errorSummary: From A Run All Transaction Processes Job Set: Collect Transactions = Warning Is there a report or an Oracle Fusion Table (Incentive Compensation Transactions) t…Christian Gerald Patacsil 22 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Rounding handling in EPCMHello everyone! We have a situation that the EPCM calculating the result which is different from the using Excel for allocation. We believe it is because of the EPCM rou…GaryYip-Asc 51 views 3 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Need to run EPCMCS Model for selective Entities via GroovySummary: Hello Experts, I am working in EPCMCS and trying to automate my Model execution for selective Entities (instead of running for all Entities defined in the Rules…
-
How is the CREDIT DATE populated on a transaction record in direct credits tabHi All, I would like to understand how the credit date is populated on a transaction record. What is the impact of credit date on the transaction. Thanks, AbhinavAbhinav Balasaheb 12 views 1 comment 0 points Most recent by Gopikannan Mariappan-Oracle Incentive Compensation
-
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
-
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 51 views 7 comments 0 points Most recent by HarshD Profitability and Cost Management
-
Features and Capabilities in PCMCSSummary: Content (please ensure you mask any confidential information): Hi, We have a client in the banking and finance industry already using the tool primarily for all…Lakshani Hettiarachchi 38 views 1 comment 0 points Most recent by Sajal Gupta1-Oracle Profitability and Cost Management
-
Freeze transaction after generate Earning, create payment batch and payHello, We are looking for a way to freeze the transaction and not recalculate, after the earning generated from this transaction and this earnings get paid in a payment …Fernando S Caneiro 31 views 4 comments 0 points Most recent by Tejaswi Tatavarthi Incentive Compensation -
How can a POV or Period be locked in EPCM to block data update of any kind (Submit Data or DM)Summary: Publishing a POV (from Calcualtion Control) seems to only block any calculations being run, but data upload is still being allowed. We need to lock a POV once i…Itali Madhusmita 11 views 6 comments 0 points Most recent by Itali Madhusmita Profitability and Cost Management