Category 146
Discussion List
-
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…Gary Yip - D. 3 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
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…Gary Yip - D. 21 views 2 comments 0 points Most recent by Gary Yip - D. Profitability and Cost Management
-
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…
-
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 …Hans Villanueva Rojas 20 views 5 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
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…Hans Villanueva Rojas 12 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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 …Hans Villanueva Rojas 33 views 2 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
"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…Dpanshu 21 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
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…MTipton 31 views 4 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Member selection does not display members in Integration rule -> Option -> FiltersSummary: Hi everyone, I encounter the following issue regularly in EPCM as well as in Planning. Sometimes the following solves the issue: 1. going to the application doi…Mueller 63 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
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…P Avinash 11 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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…
-
How to show aliases instead of member names in profit curves or trace dashboards in EPCM??Summary: We've built some profit curves and trace reports. Although base data forms show alias members, profit curves and trace only show member name. We don't see any p…ALopezS 43 views 6 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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…
-
Gross Margin Details - Recognized and Unrecognized COGS QuestionIn the CST_GROSS_MARGIN_DETAILS table what would cause the unrecognized COGS amount not to be set to zero while the recognized COGS amount is set correctly. In this scen…
-
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…Peter Joelson 11 views 4 comments 1 point Most recent by Peter Joelson Profitability and Cost Management
-
Formula Column not showing precise calculation on Data FormSummary: Working with data forms, I'm trying to sum up the values from columns into one formula column. Content (please ensure you mask any confidential information): Fo…NikhilDeshpande 31 views 3 comments 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management -
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…
-
Issue with multidimensional mappingSummary: When I added the entity CORIX in Multi-Dimension mapping, Data Management interpreted the substring "OR" in the word CORIX as a logical operator. As a result, t…Supriya_EPM 21 views 2 comments 0 points Most recent by Harikiran_EPM-Oracle Profitability and Cost Management
-
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…
-
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…
-
Data in EPCMCS vs Data in Request for Starter Configuration EPCMCS - Oracle success navigator -Same?Hi All, When we login to the cloud success navigator, we see an option to Deploy a ready to use Fusion Configuration for Hands-on experience of Oracle Fusion Application…ArathiGannavarpu 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Convert member formula to Groovy scriptHi All, I have multiple Dynamic currencies in ASO cube of EPBCS and they have member formulas. I am planning to convert this member formulas to Groovy and store. I am fa…Sukrut 21 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management
-
Row filtering on data form in web application is not available while accessing the same on SmartViewSummary: Trying to access the rows filtering option on data form while accessing it from SmartView Content (please ensure you mask any confidential information): We're a…NikhilDeshpande 21 views 5 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
Dynamic mdx calc of driver not working in allocation rule.Summary: Hello Experts - I have calculated a dynamic driver and the results are correct when compared to manual calc of same. However, when using the driver member in th…
-
DLR needed to use Qualified Member Name for one EPBCS cube but not another?Hey all, We hit the following error when we ran a direct data integration from EPBCS to EPCM (running the integration from the EPCM environment): "Cannot perform cube vi…Peter Joelson 11 views 2 comments 0 points Most recent by Peter Joelson Profitability and Cost Management
-
Creating expressions to filter the source combinations in PCM designerHello Experts, We have a requirement where the client wants the project-level allocations (currently performed in PPM) to be migrated to PCM. However, the list of projec…Himani Jena 31 views 2 comments 0 points Most recent by Himani Jena Profitability and Cost Management
-
configure New PCM Agent (Generative AI)Summary: Hi , Is there any document on How New PCM Agent (Generative AI) work in EPCMCS Content (please ensure you mask any confidential information): Version (include t…DivyaG 101 views 10 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Can we have conditional suppressions on data forms?Summary: Need to have only limited rows to be displayed on a data form based on the formatting on the rows. Content (please ensure you mask any confidential information)…NikhilDeshpande 21 views 3 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
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…Don Bean-Oracle 112 views 6 comments 4 points Most recent by Don Bean-Oracle Profitability and Cost Management