Calculation
Discussion List
-
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 -
Can pipeline variables be used in job fieldsSummary: I am trying to run the calculate model job in EPCM and have the sourcepov be a pipeline variable that can be put in when the pipeline is run. Is it currently po… -
PCMCS Out-of-the-Box (OOTB): 4.TraceabilitySummary Traceability and transparency within PCMCS - Out of the box featuresContent Traceability is the buzz word in any regulated industry. Being able to prove the numb…
-
Quota Update on Change of Territory of SalesrepAt time of start of new financial year, Salesrep 'James' is assigned a quota for whole year ( Oct to Sep all 12 months) but suddenly due to business change this salesrep…AMIT KUMAR YADAV 21 views 5 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
Administer salary was already approved by approvers but still the status is pending in transactionAs per screen shot, All approvers are already approved the transaction, but the status still pending, and from the UI it's still not displaying the salary data.Joliver Caangay 22 views 3 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
Job Comments not captured in Calculation Statistics and AnalysisSummary: Job Comments that are provided to model executions are not captured in Calculation Statistics and Analysis. Is this an expected behavior in EPCM? Have seen this… -
Incorporate a performance measure within a user-defined queryI have a custom performance measure created and I would like to compute the average of this measure for a specific group of transactions, probably by using a defined que…Leonardo Chiqueti 21 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
PCM Custom Calculation querySummary: In EPCM; I am trying to create Custom Calculation rule to copy data across different Entity. The difference is in the primary Entity where the data is loaded it…Muruges89 41 views 2 comments 0 points Most recent by Risingstar27 Profitability and Cost Management -
Directory/File '/u02/user_projects/instance0/tmp/scratch' does not ExistSummary: Hello! For a second day I'm getting an error "Directory/File '/u02/user_projects/instance0/tmp/scratch' does not Exist" when trying to rum my allocation model. …Alexey Jodzichski 11 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management -
Substitution variables not captured in Calculation Statistics and AnalysisSummary: EPCM Application/Cube level Substitution variables not captured in Calculation Statistics and Analysis. Is this an expected behaviour in EPCM? This is useful fr…NarayananS 31 views 6 comments 0 points Most recent by Padmaja Srinivasan Profitability and Cost Management -
24A Common Lookup Code Tagged with Country Does Not Show Up in the LOV for Compensation PlansHello everyone, there is a bug raised by Oracle where Common Lookup Code Tagged with Country Does Not Show Up in the List of Values for Compensation Plans. Is this bug o…Maria Cristina L. San Jose 11 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
UDA in EPCM ruleSummary: Can i use UDA in EPCM to filter on the source dimension? I am only getting Attribute option to filter on rules. Content (please ensure you mask any confidential…Nilotpal Bhaskar 41 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Earning ID & Measure Result ID Re-Generation QuerySummary: Let us assume there are 5 components in a plan and under that let’s say for two components If we create a new measure in an existing component and change existi… -
We are getting blank results as output. When we combine two Plan components.Summary: when we execute plans separately output is coming correct When we combine two plans and trying to give the output of plan component1 as input to plan component2… -
multiple rate tables in one planSummary: Can we use the multiple rate tables in one plan? Content (please ensure you mask any confidential information): We are following the below approach Rate table1=… -
Groovy script to run ML calculationSummary: Dear Experts, Im trying to trigger the Run ML in pcmcs Via FCCS ODR Groovy, script validation is fine. "/rest/v1/applications/PCM/povs/2024_At_Feb/jobs/runLedge…Sreekumar Hariharan 141 views 11 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management -
Allocation In is calculated but corresponding Allocation Out is not getting calculatedSummary: In a model for a few Rules, Allocation In is calculated but for the same Rules corresponding Allocation Out is not calculated where the 'Offset' is at the Sourc…Rajen Patil 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Issue with Incentive Formula calculationSummary: We want to calculate the commission per event based by using RTR so we defined the compensation plan and all the steps below is the info Measure formula : Credi… -
MDX Member formula too long but no errorSummary: Hello all, when I enter below's MDX member formula in EPCM ASO Cube, it validates successfully and also the refresh database is successful and works fine. Howev…