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
-
25.11 update will NOT be applied on the production environmentsSummary: In case you missed the announcement in the EPM Platform forum read here: https://community.oracle.com/customerconnect/discussion/925646/25-11-update-will-not-be… -
PCM Video Update August 2025Here is a short video highlighting two significant new innovations inthe PCM Agent that are available in the August 2025 update. https://us.v-cdn.net/6034893/uploads/U5Q…
-
De-Support of Cloud EPM Forms 1.0 and Dashboard 1.0Summary: As announced in the IMPORTANT Actions and Considerations section of the Oracle Fusion Cloud Enterprise Performance Management Feb 2025 What's New, please ensure… -
Hyperion Profitability and Cost Management Statement of Direction for Standard Application typeThis might be a little off topic as this is the forum for EPM Profitability and Cost Management Cloud, but many of the partners that participate in this forum may also h…
-
How to use attribute dimensions in data integrationsSummary: Hi All, My source cube is aso, and I am looking to use attribute dimension to filter on data. I tried adding a new dimension in the application but that dint se…
-
ERP Cloud Configuration → PCM Integration from the PCM EnvironmentHello, I am currently working directly within the Oracle Enterprise Profitability and Cost Management Cloud environment and would like guidance regarding the configurati…
-
Oracle EPCM sustainability for 1.5M Patients Along with 10x Visits per Patients per yearSummary: Oracle EPCM sustainability for 1.5M Patients & Approx 10x Visits per Patients. Can we get the profitability at Patient Encounter level using Oracle EPCM solutio…
-
Cannot Perform Custom Calc. Essbase Error(1042017): Network error:Summary: Hello All, I am getting this error Cannot Perform Custom Calc. Essbase Error(1042017): Network error: Timed out before receiving all data using Custom rule. No …
-
Custom rule taking longer time not completingSummary: The PCM custom rule is not completing. I also tried using NONEMPTYTUPLE I want to apply multiple project % drivers with the PR000000 project value. Any idea hin…
-
Quick Data Copy in Aso by GroovySummary: In PCM, I have 30,000 Src,100 Bu,1000 Client and 5000 Accounts and will be copying data from one grid to another. In Groovy code I am using 3 List to read row(S…
-
EPCM filter to exclude a UDAOur product hierarchy contains UDAs like this: Member Name UDA P0001 25kg P0002 300g P0003 300g P0004 25kg P0005 950g We wish to exclude 25kg members in the target dimen…
-
Artifactsnapshot Size increasedHi All, My artifact snapshot size increased to 500 GB in planning application, is there any action i should be taking
-
Amount allocated in earlier rule getting allocated againSummary: This may seem surprising, but the amount for a source intersection that has been completely allocated out is available. The Offset set is set to 'default.' What…
-
How to add a substitution variable with mass edit to allocation rulesSummary: I use the same allocation rules for actual and planning (2 different models), but planning allocation shall still be based on actuals hence I want to change the…
-
PCM is calculating allocation for two excluded membersSummary: Source filter not excluding all cost centers. Content (please ensure you mask any confidential information): I am using a parent level source and excluding cert…
-
Combining Debit and Credit columns into Amount - Data ExchangeSummary: Hi All - I am integrating with the Account Analysis report from ERP and need to take Debit - Credit in data exchange since they are in separate columns in the r…
-
Is there a way to make a custom cube in EPCM be available for POV actions like copy POVSummary: I have a 3rd custom cube in EPCM besides PCM_REP and PCM_CLC. I was intending to copy data into the custom cube for historical reporting. I understand export/im…
-
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… -
Display alias in traceability reportHi everyone! I setup the data form and display the Alias for the row and Column dimension. But when I use that data form in Traceability report, it shows member name onl…
-
Average cost Calculation via Custom calculationSummary: Hi All, We need to calculate a rolling 6-month average cost per unit based on monthly data. For the current period (June), the calculation should consider Janua…
-
Rule Data Validation report running for all rules at onceHi team! We know it has Rule Data Validation report running for each rule to check the Source and Driver based for individual rule. Can we know if it can run for all rul…
-
Managing Filters for Source DimensionSummary: Is there a way to pick all zero level descendants of parent member I want to exclude from my entity dimension source. So If my top level entity is All Entities …
-
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 …
-
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…
-
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 …
-
EPCM Custom Calc: Conditional Allocation Based on Dimension MemberIn EPCM, is it possible to write a custom allocation calculation where: If the Function dimension member is "99," the rule does: Source * Driver If it’s any other member…
-
Can we send back allocated journals from PCMCS to ERP using enterprise journals?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Workbench Data Retention PolicyWe have a business requirement to retain Workbench data (job history, logs, and related artifacts) in EPCM for a minimum of 12 months. We have found no clear Oracle docu…
-
New PCM settings in Dec-25 updateSummary: In the latest release of EPCM, a bunch of new settings were included, one of which is choice between Designer 1.0 and Designer 2.0 forms. Content (please ensure…
-
Does "unused" metadata have impactful performance implications?We are exploring breaking out our existing application and using multiple pods in our environment to help improve performance and run multiple models at the same time. E…
-
"Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member Entity" in PCMCSI'm getting "Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member Entity" when using the Replace option in PCMCS data integration, even though the entity ex…
-
EPCM Models - Manual execution Vs PipelineSummary: We are using Pipeline for automations inclusive of model calc executions. We have migrated certain rules from TEST to PROD. However, after migration the rules i…
-
Dynamic Numbering in ReportsHi all, I want to build a P&L Report in PCM for which I want to supress rows with missing values or 0 as a value. I also want to adjust the numbering of the rows, so the…
-
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…