Calculation
Discussion List
-
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…
-
Creating expressions to filter the source combinations in PCM designerHello Experts, We have a requirement where the client wants the project-level allocations (currently performed in PPM) to be migrated to PCM. However, the list of projec…Himani Jena 33 views 3 comments 0 points Most recent by GhanshamDass Profitability and Cost Management
-
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 11 views 0 comments 0 points Started 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 11 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 32 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 24 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 21 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 32 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 52 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 31 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 32 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