Calculation
Discussion List
-
EPCMCS COPY POV FUNCTIONSummary: EPCMCS COPY POV FUNCTION Hi All, I am try to copy POV form:- "FY24,JAN,Actual,Working" to "FY24,Dec,Actual,Working". I am getting issue there i.e. In this POV "… -
Issue running calculation after metadata update and database deployment.I have been running into issues running calculations in PCMCS after December 2024 update. We usually update our customer and account metadata periodically for allocation…Naplez 161 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Any performance tuning service provided by Oracle Support?My client possesses a vast amount of retail data combined with a highly complex data model, resulting in numerous intricate data intersections. The whole process of load…Supanut Sinphatsirikul 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Issue with User Defined Query to find commission value from previous earnings transactionsSummary: I am trying to find the COMMISSION_VALUE from previous earnings table if there's a match on a transaction id. But for some reason it always retrun Calculation E…Shirley.Q.Motiv 61 views 4 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
Can we load to PCM_CalculatedDriverValue?Summary: Is it possible to load driver data to PCM_CalculatedDriverValue? Content (please ensure you mask any confidential information): We would like to clear almost al…SAW23321 31 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
No Columns available in CN_TP_EARNINGS to enable for CalcluationSummary: Trying to enable the SOURCE_TRX_NUMBER for calculation in the CN_TP_EARNINGS table through the Configure Tables and Columns Task in Setup and Maintenance. The u… -
Why is the "Rate Table" tab on Calculation Details blank.The rate inputs tab is blank after the calculationSangeethats 51 views 9 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
is transaction split works in incentive compensation rate ?There is a business requirement, we created a rate table based on that and providing the rate table below From To Rate (%) 0 10000 2 10000 15000 3 15000 99999 4 Now, the… -
Can you prevent users from selecting "All Rules" in Calculation Processing RangeSummary: We have a few GL Allocations where specific Rule Sets must be run one at a time. Is there a way to prevent the users from selecting "All Rules" from the Manage … -
Getting "Unexpected error in business logic" when trying to run a ledger calculationSummary: Hi Team, I am trying to run a ledger calc for a POV, but I am getting below error. "Unexpected error in business logic" I tried clearing entire cube and deployi…Harish Kumar C 31 views 5 comments 1 point Most recent by Harish Kumar C 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 -
How to add field to expression groupingSummary: We recently created a Attribute_Number type DFF field and want to bring that for use into the expressions. We have added it via the "Configure Tables and Column…NicolaosDerr 22 views 4 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
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… -
Cannot Clear Partial Data. Essbase Error(1200503): Duplicate dimensions in a tuple in function [TUPLHello everyone, I tried to run Calculation for July but it showed the error : when I tried to run calculation for June, it ran successfully. How to fix this issue? Thank… -
Duplicate dimensions in a tuple in function [TUPLE CONSTRUCTOR] on line [2]Hello everyone, When i ran the model calculation, it showed the error: "Unexpected error from essbase or insufficient data privileges. Cannot Clear Partial Data. Essbase… -
Calculate Incentive Earnings for All Participants within BUSummary: Need step id and job name for Calculate Incentive Earnings for All Participants within BU Content (please ensure you mask any confidential information): Hi All,…Pankaj Balkothe 11 views 3 comments 0 points Most recent by Niladri Roy Chowdhury-Support-Oracle Incentive Compensation -
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 -
Divide paysheet by transaction informationHello, We have a requirement here to divide the paysheet according to a specific information of transaction, that should be ATTRIBUTE45. I didn't find any documentation …Fernando S Caneiro 21 views 4 comments 0 points Most recent by Fernando S Caneiro Incentive Compensation
-
Is there a way to create Counterparty transactions in EPCM?Summay: For EPCM Transfer Pricing based Application, we want to create counterparty entries of Transfer Pricing Results. Content (required): If Transfer Pricing Results …Sivavignesh V 81 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management -
how query transaction using RESTSummary: For REST API call: GET, the URI is fscmRestApi/resources/11.13.18.05/incentiveCompensationTransactions//child/Credits In the document, it says we need to provid…SuriNatarajan 11 views 4 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
Cube not deployed warning while running the calculations- possible reasonsSummary: What are the different reasons/scenarios for getting the warning 'Cube is not deployed'? Content (please ensure you mask any confidential information): I unders…Rajen Patil 21 views 2 comments 0 points Most recent by Rajen Patil Profitability and Cost Management -
Purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCMSummary: Hi, Request anyone to let me know the purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCM. It would be helpful if any resource link is shared for the …Harish Kumar C 21 views 3 comments 2 points Most recent by Harish Kumar C Profitability and Cost Management -
EPCM Ruleset Sequence ExecutionHow does EPCM execute the rulesets, if there are 5 rulsesets and are all sequenced as "1"? I wanted to understand if the system exectues the rulesets serially or in para…