Calculation
Discussion List
-
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 33 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 21 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…
-
Accrue and Amortize the Sales CommissionsSummary: We have a requirement to Accrue and Amortize the Sales Commissions for Sales Persons. To elaborate, for sale made by a Sales Person on 1 Jan 2023, we would like…Rudraraju Aadikrishnam Raju 21 views 4 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Creating a Plan that Accrues the AmountSummary: Hi, We have a requirement to create a Plan that Accrues the Amount based on Plan Component (Co-op). Need to understand how this can be setup in Incentive Compen…ShishirSopariwala 1 view 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation