Rules
Discussion List
-
Map members into other dimensions based on data set in Account dimension using a RuleSummary: Hello, I have a request to populate the data residing in the account dimension into 2 other dimensions, such that the intersection below copies data 25 and 35 f… -
calculate children members sum on parent member level for sparse Dimension on EPM Essbase RuleHi, I will try to describe the issue in the below lines I have three sparse dimensions "Employee", "Job", "Position" Let's say the three dimension have three parent memb…
-
YTD calculation issue in ASO CubeHi All, I have a query on YTD calculation in ASO Cube. We copied 4 months of actuals in forecast and remaining 8 months forecast is present in forecast data type(which u…
-
Oracle EPM Platform: Looking for exact Release Date of new groovy engineWith the August Release of Oracle EPM (Planning Cloud) the update of the groovy Engine was announced for the 2nd half of Year 2025 (pop-up window on start screen and rel…R Abel 83 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
OAuth2 Refresh Token Request not working from EPM Groovy ScriptSummary: We are facing issue while calling Rest API to generate an OAuth2 token using EPM Groovy script. I am trying to run the following code, but if I try same step in…Gajendrababu Srinivasan 103 views 10 comments 1 point Most recent by NarayananS EPM Platform and Freeform
-
How to check last execution time for business ruleSummary: Hi, Is there a way to check when was the last time a business rule was executed? I understand there is a way we can export the job console logs but that would g…Neha_R 11 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Unable to display Groovy Script error since Forms 2.0 implementation - Now Rule(s) execution failedSummary: We are unable to display a custom Groovy Script error message that pops up when saving in Forms 2.0 since implementation. Content (please ensure you mask any co…
-
Format Validation Rule in Forms 2.0 retaining red format in edited cellsSummary: Edited cells are retaining the red format based on the format/validation rules since the implementation of Forms 2.0. Content (please ensure you mask any confid…
-
EPM planning business rules runs multiple times even after triggering only onceEPM planning business rules runs multiple times even after triggering only once. Has anyone faced this?
-
Workforce Utilization and Split Funded FTESummary: Hello Oracle, Can you please enlighten us on the process of integrating project data to workforce, utilization calculation as well as the split funded fte? Inte…
-
Error while converting RTP To Smartlist ValueSummary: We have a requirement where we're updating smartlist values based on form POV through RTP using function : "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@AL…
-
In Oracle PCM, Can we retain the data in the application after creating new dimensionSummary: In Oracle PCM, We already have a application with existing data. Due to a new requirement, we need new dimension. Can we retain the data in the application afte…Subhojyoti Chakraborty 21 views 3 comments 0 points Most recent by Raama Rao-Oracle EPM Platform and Freeform
-
calculating YTD from MTD dataHi, As the data is loaded in MTD values I want to calculate the YTD value for the Balance Sheet accounts in EPM Planning. The dynamic time series only considers the curr…
-
Create Dynamic Child with sequential codeHi, Can we create sequential project codes in EPM metadata? We know we can use the Create Dynamic Child option to create metadata members through RTP. In this option, we… -
When lauching a rule via Rules I get an errorSummary: Hi everyone, When launching a rule from Rules I get following error: the dimension Year is invalid. However it is successful when launching it via calculation m…
-
Allocation precision in EPCM for SAD and custom calculation rulesHow do other customers handle allocation precision in EPCM for SAD and custom calculation rules? -
Unable to launch business rule from RulesSummary: Hi all, I created a rule to copy data from one year to another year, the rule is successfully validated, saved and deployed. I can also launch it from the Calcu…
-
Issue with smart list RTP rule not running from form action menuSummary: Issue with smart list RTP rule not running from form action menu, but runs fine from Rules Content (please ensure you mask any confidential information): We hav… -
Dataexport not exporting #missing dataHi, I am trying to export members in a certain area regardless of whether there was data or not. My understanding is that DataExportNonExistingBlocks ON, was to export a…
-
How could reversal in proportion change for YTD view correctly?Summary: In a hierarchy some entities are changing from 90% Subsidiaries to Not Consolidated method and 0% Ownership, the same entities are consolidating in a 100% in ot…AA_AlfonsoGonzalez 53 views 5 comments 0 points Most recent by Hussein M Ali Financial Consolidation and Close -
GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMESSummary: GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMES Content (required): Hi I am taking note of the new features of May 2023 for EPM Cloud. And in particular I am int…Alain Mathon 608 views 6 comments 0 points Most recent by Jonathan A Cohen EPM Platform and Freeform -
Business Rule Use Members on the FormSummary: Business Rule Use Members on the Form. We have a form with POV for Entity and Department. It has a rule attached that is calculating percentages for all departm…Ija Vidaurri 31 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Issue with Scheduled jobService: Enterprise Performance Management Enterprise Cloud Business Process: Planning Version: 24.09.73 We have multiple scheduled jobs that run nightly, we are noticin…mshahid1016 21 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Data Export with Pivot DimensionSummary: Hello Wizards, I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot). Expected Output (StartDate and … -
In EPBCS, Unable to copy data from Working Version to Final Version within ASO cubeSummary: I've used MDX to copy the data from 'Working' version to 'Final' version within the ASO cube but I'm unable to do that. The Rule got successful in the validatio…
-
New Asset creation in EPBCS Capital Planning moduleSummary: I have created a new asset in EPBCS capital module. I have done the calculate asset portion, the next step is to roll up the asset. However, upon executing this…
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Has anyone used server side epmautomate with a loopback (127.0.0.1) or "localhost" server name?Summary: I'm using a groovy script that uses server side epmautomate. In place of the the server name in the URL, I would like to use a loopback address like "localhost"…
-
Data push from PCM_CLC to PCM_REP using Groovy in EPCMSummary: Hi Team, I am curious to know if we can push data from Calculation cube(PCM_CLC) to Reporting cube(PCM_REP) using Groovy Script in EPCM. If anyone has tried ple… -
Send Email REST - Allowed email attachment size is 10MB. Will this be increased?Summary: We have a requirement to attach more than 10MB files to Business Users. Content (please ensure you mask any confidential information): We have a requirement to …NarayananS 52 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform