To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Profitability and Cost Management
Discussion List
-
MDX Formula with Avg function is not working in Groovy Business Rule in PCMCS ASO cubeHi, I am creating Groovy Business Rule to calculate Average of an Account from Jan to Current Month and assign this value to other account. ([ACCT_AVG]) := (Avg(({[Perio… -
Does EPCM Custom Calculation supports String Operations on left side (Target) of the script?Summary: Targeting the results to certain ICP Dimension members ICP_**** from an alternate hierachy of Product Dimension whose parent will be CP_****. Content (required)…
-
quick mode EXPORT from EPCMhi All from our EPCM application, we want to extract the data set and send to target systems for reporting. We have extremely huge volumes of data (approx 1 million of r…
-
Change functionality so that the TO Return only have cost when the Organization confirms the ReceiptSummary: In Oracle Cloud we realized that there is a case where Transfer Order Return transactions establish a cost even when the Destination Organization does not confi…
-
Member formula or custom calc?Summary: Need to calculate average FTEs in most efficient manner Content (required): I have a requirement to calculate average FTEs for a whole list of departments. Curr…
-
Clarification on Simple Reclassification (SR) rulesSummary: What is a simplified calculation process for reclassification rules? Content (required): In the What's New of September 2023 is a note on simplified calculation… -
Announcing a new "How Do I... " Help Center tab to answer your most common questions quickly !Summary: The new "How Do I... " Help Center tab lists easy, common, and necessary tasks for setting up your EPM Cloud environment and Enterprise Profitability and Cost C… -
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)…
-
NEW Reports module open on a different Smartview workbook instead of under a new Excel TabSummary: Content (required): Hi All It seems that the new REPORTS module opens reports on a separate WorkSheet every time we open new Fully formatted reports. We want th… -
EPCM - Setting current month number in a account dimension memberSummary: Hi All, I have a scenario where I need current month and previous month in number for some mathematical expression. My plan is to set the number in account dime…
-
What is the rule dimension member [PCM_ Rule]？Summary: Why should calculation always include the rule dimension member [PCM_ Rule]? An error occurs if [PCM_Rule] is not included in the calculation. What role does [P…
-
Moved: EPCMCS Dashboard_Link_ReportThis discussion has been moved. -
Use multiple cubes for cost allocation in EPCMSummary: Hi, I am exploring an option to use multiple ASO cubes in EPCM for separate types of allocation. If anyone tried, can you please share potential risks or downsi…
-
Adding unique Sequence number and system date in EPCM ReportsSummary: We are building a journal entry (WebADI) report for one of the transfer pricing flows using EPCM. Report contains two columns with GL/posting date and transacti…
-
Moved: Pipeline LimitationThis discussion has been moved.
-
Is there a limit on the number of members that can be added to a dimension?Summary: We are in the process of migrating our Gen1 EPM environments over to the new Gen2 architecture, and as part of that effort, I copied over our existing PCM envir…
-
PCMCS Custom Calculation error: Unable to allocate resources for cube PCM_CLC for 10800 secondsSummary: Using dynamic calc member in the custom calculation to calculate stored member Content (required): Hi, we have a requirement to calculate YTD value and use that…
-
Calculation Manager enabled in ePCMCSSince last (08.23) patch calculation manager is available in EPCM test applications version 23.08.60. Is this expected? Is this specific to MDX scripts, or are groovy sc…
-
Historical data change in PCMSummary: Our historical "Input" and "Allocated" data in PCM Prod got changed, could I get some suggestions on it's cause and how to fix it? Content (required): Our histo…
-
System adds numbers at the 13th decimal place - entering data errorSummary: Good morning, in EPCM I encountered an error when entering percentages. Example: After entering 1% in a form, the system displayed 1,000000000009%. At that mome…
-
End-to-End Trace Allocation for Multi-stage allocation in EPCMSummary: We have a requirement to do multi-stage cost allocation and end-to-end trace allocation. I.e., If we do 4 stages of allocation, after the 4th stage of allocatio…
-
Clone / migration failing to IDCShi team we are migrating our PCMCS applicaiton from Classic instance to IDCS. and getting below errors (be it CLONE or using ePM automate to migrate the snapshot and imp…
-
PCMCS Export data using query not showing AliasesSummary: PCMCS Export data using query not showing Aliases Content (required): Hi, I am trying to export data using query from PCMCS. Even though I select Use Aliases, t… -
PCMCS Query - Exporting data using epmautomate with "," as delimiterSummary: Exporting Data from PCMCS using epmautomate exportQueryResults Content (required): Hi, I am trying to export data from PCMCS using a query using epmautomate exp…
-
Menu Parameters for BIP Report IntegrationSummary: We are attempting to integrate with ERP using the BIP Report option in our Target Application in Data Management. The BIP Report we are utilizing uses a shared …
-
PCMCS - Data Management replaced by Data IntegrationSummary: Content (required): Hi, Since DM will be replaced by the new Data Integration by September, do you know where I can find it on PCM? I know that e.g FCCS has a m…
-
Pervious POV rule balancing report changes when Dimension data in loadedSummary: We recently implemented PCM module and are in Parallel run mode. However whenever we move from one month to another, there are changes to dimension data. As we …
-
Transfer Pricing EPCM vs FreeformSummary: We are contemplating between EPCM vs Freeform for our Intercompany extension (transfer pricing) needs. Content (required): We need to fetch data from ERP fusion… -
Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ','Summary: Essbase Error(1260052): while running Calculation Content (required): I have been running validation of custom calculations rule and got the following error. Ca…
-
How to copy multiple periods from one version into another?Summary: A poweruser want to copy multiple periods from multiple years from one version into another. How to do this in the UI in a simple way? Content (required): In th…