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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Profitability and Cost Management
Discussion List
-
Recommended way of loading Metadata to PCMCS from EDMHi All, I need to load Metadata to PCMCS from EDM. I am aware of running Extract to get Metadata file and then upload and load file to PCMCS using EPM Automate. What are… -
How to move data from PCM_CLC to PCM_REP cubeSummary: Content (required): Hi all As per documentation, we have just migrated from Standard PCM to EPCM and we wanted to take advantage of the REP cube. However, I can… -
Standard Target Version Use CaseSummary: I notice that the Version dimension allows for set up of a Target version. What is the use case for this in EPCM given all the cubes are ASO? I presumed you cou… -
Please suggest SmartView link that can be used to connect/test to PCMCS OCI temporary URLs.Summary: SmartView link that can be used to connect/test to PCMCS OCI temporary URLs provided by Oracle to validate the env before migration. Content (required): PCMCS U…
-
Time Series Analysis using a View dimensionContent Over the past few months several posters have asked about calculating and reporting on time series values such as YTD, QTD, Trailing 12 months. The EPM Planning … -
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…
-
Export Data With Attribute EPCMCSSummary: Hi All, Can we export data form data management with attribute value?? Let Say I have 10 Dimension out of that I tag Attribute Dimension with segment dimension(…
-
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)…
-
Are Smart View Admin Extensions available for PCMCS?Summary Are Smart View Admin Extensions available for PCMCS?Content Are Smart View Admin Extensions available for PCMCS? I am able to use it when connected to a Planning…
-
Can allocations be triggered using Data pipeline in EPCM?Summary: Is there a way to trigger the allocations within EPCM using Data Pipeline? If yes, could you please help with steps? Content (required): Version (include the ve…
-
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…
-
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…
-
How to set data precision when exporting data from ASO through Data ManagementSummary: We are trying to export data from PCM to a flat file using Data Management. Is it possible to restrict the data precision to 2 as the source is an ASO cube Cont…
-
What are the options for data exchange between EPM planning and EPCM moduleSummary: Data exchange between EPM planning and EPCM module Content (required): Currently using EPM Planning and EPCM module for systemization of transfer pricing system…
-
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… -
Killing Calculation Rules in EPCMSummary: Need to kill the calculations Rules in EPCM Content (required): In EPCM I am trying to kill the running of Rule(s) with the 'Cancel' button. Nothing happens wit…
-
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…
-
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)…
-
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…
-
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… -
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…
-
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…
-
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…
-
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…
-
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…
-
Moved: EPCMCS Dashboard_Link_ReportThis discussion has been moved.
-
EPCM Custom Calculation Rule - Mark up for multiple entities in a single ruleSummary: Can we create single custom calculation rule for marking up cost by x% for multiple entities? Content (required): I have 50+ entities and cost of each entity ne…
-
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…
-
Moved: Pipeline LimitationThis discussion has been moved.