Calculation
Discussion List
-
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… -
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 24 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…
-
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 31 views 2 comments 0 points Most recent by Himani Jena Profitability and Cost Management
-
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 23 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 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 31 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 11 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 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
-
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 -
How to configure Time Balance "Balance"/ Last for Balance Sheet/ FTE Accounts in EPCM ASO CubeSummary: We are currently configuring EPCM and had a closer look on the time balance setting/ the aggregation of accounts over the Period Dimension. We intended to use p…
-
Where to get additional help / references for Oracle Fusion Incentive Compensation ?Some useful references : Links to Best Practices, How-to, FAQ, see Doc ID 2688415.1 Incentive Compensation Resource Center Implementation Guide : Implementing Incentive …Kim Vu-Support-Oracle 243 views 12 comments 1 point Most recent by Gireesh Bhat Incentive Compensation -
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
-
Clarification on transaction processSummary: Hello team We need clarification on below points: Content (required): 1. Can we import transaction incrementally on weekly basis? 2. Can we schedule transaction…
-
Issue with Transaction while calculating EarningsSummary: Hello Team, We have created compensation plan with Period Type as Quarter and plan component as Per interval. Created transactions and those tnx's are calculati…
-
Use Partcipant Detail Flexfield Segment to Calculate Earnings Per IntervalFor a customer that I'm working with, nearly all incentives paid to Participants are based on a percentage of their base wages. With that in mind, I created a Segment in… -
Any restriction on number of Data POV's maintained in EPCMSummary: Can we have any number of data povs in EPCM, will it impact on the performance? Content (please ensure you mask any confidential information): Earlier in PCMCS …Harish Kumar C 21 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Does 'Calculate Model' pipeline job create POV if it's not created?Summary: Just wanted to know if I pass new POV (which is not created in the application) will it throw an error or will it create new POV automatically in the applicatio… -
Is there any way to execute Merge Slice job using business rule?Summary: Is there any way to execute merge slice functionality using business rule? I know that we can use RestApi groovy rule to execute the same, however we need to cr…