Category 146
Discussion List
-
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…SAW23321 41 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
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…Philip Hulsebosch 21 views 2 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
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…Rajen Patil 236 views 13 comments 0 points Most recent by Dinesh Chand Profitability and Cost Management
-
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…EPM2000886 111 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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)…Anantha Krishnan 31 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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…Anantha Krishnan 51 views 7 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
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…Kathy Day-Oracle 24 views 0 comments 0 points Started by Kathy Day-Oracle Profitability and Cost Management -
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…Anantha Krishnan 41 views 1 comment 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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…User_S3H04 41 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
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…User_IPP4R 12 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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…Smit Shah 61 views 8 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
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…Anantha Krishnan 91 views 6 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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…Braxton Sowell 62 views 3 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
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…Mueller 11 views 1 comment 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
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…Amit Agarwal-158816 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
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 …Sawyer Teague 39 views 1 comment 1 point Most recent by Sawyer Teague Profitability and Cost Management
-
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…Amit Agarwal-158816 62 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
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…Sucharitnarang 31 views 3 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
How Post Allocated Journals can be posted from PCMCS to GLSummary: Post Allocated Data needs to be send from PCMCS to GL. Can it be done using seamless integration ? Will it be loaded as unposted Journals in GL and users needs …Mohit Pahuja 91 views 2 comments 0 points Most recent by Nagarajut80 Profitability and Cost Management
-
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…Timestamp EPM Team 51 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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 …Sachin Dhekane 31 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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…getgaurav 86 views 1 comment 0 points Most recent by Al_DuqueEstrada Profitability and Cost Management -
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…User_IPP4R 275 views 5 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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…Philip Hulsebosch 42 views 6 comments 0 points Most recent by AndrewLaferla Profitability and Cost Management
-
Can we integrate Metadata from EDMCS to EPCMCSSummary: Hello Gurus, Can some one please help in understanding, do we have Adapter's to Integrate Metadata from EDMCS to EPCMCS? If not, can you please let me know the …Venkat Peatla 41 views 3 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Backup import failed due to special characters German Umlaut ä ü öI try to rename an application. My first attempt to create an empty application with the new name and import the backup file failed due to the error message there exists…Mueller 22 views 1 comment 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Calc Manager option Disabled/Missing in EPCMCS applicationSummary: We created a EPCMCS application and couldn't see the "Calc Manager" option under 'Create and Manage'. Content (required): Version (include the version you are u…