Rules
Discussion List
-
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 23 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 51 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 554 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 53 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Business Rule behavior in PipelineSummary: Business Rule behavior in Pipeline Content (please ensure you mask any confidential information): Data Exchange Quick Mode Rule (EPM Automate Server-Side script…
-
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 83 views 8 comments 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Export specific dimensions from ASO cube to BSO cube using Groovy ScriptSummary: I've a script in groovy, basic script, it works but i need to remove a dimension that's in the row; Script: Cube cube = operation.application.getCube("CAPEX") c…
-
Alternative approach to calculate employee expenses in Project planning module.The Calculate expense rule in Project planning is throwing the below Error message: Script failed on line: 86, with error: An error occurred while processing this page.
-
Can Power Users/ Users add projects in the Projects Planning module in Oracle EPM cloud?Summary: We are using the "Add Project" functionality in the Project Planning module. This option is available only for "Admin" users and that makes sense as the project…
-
Oracle saleshello Dears I'm experiencing an issue in Oracle Sales Planning with the "Process Actual" rule. The problem occurs in the process of transferring data from the "Actual" s… -
How to retrieve ESS job report from UCM for the jobs trigger by ARCS?Summary: Within our ARCS application, we have multiple direct integrations created to trigger the Oracle Enterprise Scheduler (ESS) Jobs in ERP Fusion and load the data …
-
In OWP_Change Existing Details_T , can we restrict year according to the Scenario?Summary: In OWP_Change Existing Details_T , we need to restrict year according to the Scenario. Like :- If Forecast year is set FY24 then in rule on FY24 is selectable. …