Rules
Discussion List
-
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… -
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 31 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"…
-
Allocation precision in EPCM for SAD and custom calculation rulesHow do other customers handle allocation precision in EPCM for SAD and custom calculation rules? -
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 42 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 52 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. …
-
Formula AssistanceI have a scenario where users budget on a data form to Department and Default_Account and not the 'Natural Account' from the G/L. So, now I learn each Department does ma…Hyperion_Junkie 41 views 14 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
EPM Automate login using Connections in Groovy instead of using epw password fileSummary: Is it possible to use EPM Automate in Groovy BR for login? Am trying using getUserName(), getPassword() instead of using epw password file. Defined the connecti…NarayananS 68 views 7 comments 1 point Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
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 52 views 4 comments 0 points Most recent by AA_AlfonsoGonzalez Financial Consolidation and Close -
MDX Formula for ISMBRSummary: Hello, How can I write in MDX language (for ASO cube) this formula? IF(@ISMBR( @RELATIVE ("Tot_Cost_Center", 0) ) ) "CE-1"; ENDIF; Thanks, Davide Content (pleas…DavidePacilio 173 views 41 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPCM allocation from parent to child, is it possible in only one allocation rule?Summary: Let's say we have a product dimension with 2 levels: brands (parents BRAND 1, BRAND 2, BRAND3...etc) and products (lev 0) We need to allocate some costs we have…ALopezS 54 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Reference for EPCM run calculation groovy script?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…Subhojyoti Chakraborty 11 views 1 comment 0 points Most recent by NarayananS EPM Platform and Freeform
-
EPCM Allocation rule allocates many zero valuesSummary: We need to allocate each business expenses using sales as a driver. We have some new business, with no sales. In those cases, we need to allocate its expenses e…
-
Simple logical calculation of budget transferThe below code is supposed to run in a second or two but it's running for 20-30mins and giving wrong results. It's filling all the cells. I checked and we have 10 dimens…
-
Error while creating New Project in Projects ModuleSummary: Encountering Error while creating New Project in Projects Module Content (required): Hi All, Getting this error while creating New Project with OOTB Add Project…
-
What are the member limits in EPBCS?Summary:What are the member limits in EPBCS? Content (required): Trying to identify The Member Limits in EPBCS Version (include the version you are using, if applicable)…
-
Rule Erroring Out: Problem with @hspnumtostringSummary: Our script begin erroring out all of sudden with the portion represented below. This is a Rule that is calculating expenses for payroll and aggregating it up to…
-
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… -
Script or Template objects in Calc Manager, which one is better and why?Summary: Script or Template objects in Calc Manager, which one is better and why? Content (required): Hi All, I wanted to clarify what the community members think about …Fred_Mamadjanov 91 views 5 comments 0 points Most recent by Fred_Mamadjanov EPM Platform and Freeform