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.
Planning
Discussion List
-
EPM Financial Reports to Reports Migration IssuesWe are migrating 'Financial Reports' to 'Reports' in TEST environment. There are few features that do not work as expected. 1. 'Report' header Text Function does not acc… -
on exporting to excel fields with zero's in do not export as a zero they show as "-" or "."Summary: On the new reports (FR) when we export to excel we lose the formatting of fields with Zero. They appear as as "-" or "." Version (include the version you are us…
-
How to use dynamic member for ASO member formulaDear every expert, I have a member under the dimension "Plan Element" which has the member formula on the ASO cube: NONEMPTYTUPLE([M_NET_SALES]) ([Account].CurrentMember… -
Form Validation rules on Smart List LabelsI'd like to create a data validation rule to apply formatting if a column value contains a text string (target column is a Smart List). The docs don't say it's impossibl… -
Unable to perform bursting because the specified POV members are not found in the bursting query.Summary: We are trying to execute a Bursting Definition but we are getting the error message; Unable to perform bursting because the specified POV members are not found …
-
Using the new Reports, can you reference the members in another data row?Summary: Using the new reports, can you reference the level 0 members of another row where the data has been suppressed at a parent level, returning only the data wanted… -
Question on Mapping Based on Multiple Source Dimensions (ERP to EPM Planning)Dear Oracle Product Team, We are currently configuring data mapping settings for integration from Oracle ERP Cloud GL to Oracle EPM Cloud Planning. Below is the dimensio…
-
How to set substitution variables using Task ManagerI want run pipeline through Task Manager. for that instead of period I want use substitution Variable.
-
Assigning Permission to the FormHi All, I have a quick question regarding form permission assignment in EPBCS. There is a form in Planning where one of the groups has write access to all dimensions use…
-
Is there a way to audit the data that is uploaded through a data load rule or Data integrationHi, in reviewing the audit logs, we found that there is no logging of the data that is loaded through a data load rule or data integration, nor does the jobs show up in …
-
Cannot see folders in the file browser in data exchange but visible in DM? Here is a solution!!!Summary: Issue: Non Admin users cannot see the folders in the file browser, in data exchange, while they can see all the folders in the Data Management, this occurs afte… -
BIP Report Integration with EPM having no parametersSummary: Hi guys, I am trying to do an integration of BIP Report with EPBCS application. Following the process, I have configured the target application as below. Since,…
-
How can I refresh EPM environment from Production to Test?Summary: I need to refresh the EPM TEST environment from Production. Content (please ensure you mask any confidential information): Version (include the version you are …
-
Groovy to read a text fileUsing REST API I've managed to trigger my integration and get the job id, status and log file. I would like to read this log file in Groovy. I only see reader functions …
-
Assign security for each task in a task listSummary: Is it possible to assign security for each task in a task list? Content (please ensure you mask any confidential information): Hi Experts, we have a task list a…
-
Valid intersections do not work in EPM Reports?Summary: Valid intersections do not work in EPM Reports. Is this expected behavior? Content (please ensure you mask any confidential information): Valid intersections ar…
-
Spreading doesn't work in SmartViewHello All, I'm trying to input data in the form on SmartView (and click on Submit) and it doesn't for (however on Web it works well) : It works only if click on Adjust >… -
Replace specific data without changing clear region in Data integartion.Summary: Our requirement is we are giving user to load adjustment data to specific combination by file. And we are expecting Replace option should work for only the user…
-
Unable to load Date, Data Type account through datagrid in groovy scriptSummary: Originally loaded to the same account as a Text data type with no issues. changed to Date and now not working. Hoping it's an application setting i'm missing? C…
-
Dynamic user variable doesn't consistently show full hierachy of a dimensionSummary: In a Planning webform, I have set a dense dimension (Account) as a dynamic user variable with member selection set to IDescendants(SomeParent). However, the mem… -
Best practices method to reduce fragmentation & increase block densitySummary Best practices method to reduce fragmentation & increase block densityContent Here in my application i tried few things to reduce fragmentation & increase block … -
Can this be optimized further?Summary: Hey All, just wondering if this can still be optimized without changing some of the parents to Dynamic Calc?. My Aggregation rule for actual data is taking appr…
-
DTS for account member with member formula doesn’t calc the expected YTD amountSummary: We have a base dynamic calc account member with member formula that has slightly different calculation with period dimension at different level – periodic, quar…
-
Tips for bunch change member namesSummary: Content (please ensure you mask any confidential information): Hi, Want to see if anyone has better idea or tips for bunch changing member names. For example, i…
-
Email notifications turned off in IDCS for all the categories, not able to receive password recoveryEmail notifications turned off in IDCS for all the categories, not able to receive password recovery email. we have only 2 active users in IDCS and both accounts passwor…
-
@allocate is not parsing a value in basisMr parameterHi , I am trying to run an allocation to emulate a copy for performance issues. This is the command: "OEP_Plan"= @ALLOCATE("No Consolidado","2.2.1. PROFESOR HORA",1,,mul…
-
Smartview Report HsgetValue to retain data when it is openedSummary: Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection Content (please ensure you mask any confidential in…
-
Change in Behavior for Duplicate Members Being Returned While Using MDXCan someone further explain the upcoming consideration item for 25.08? what is an "MDX Flow" versus a "non-MDX flow"? Looking to understand use cases where this is going…
-
Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dyn parentSummary: Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dynamic parent Content (required): we are trying to make the code dynami…
-
Reports: How to share a prompt?Hi, With Reports in PBCS, if I have two grids, how do I share a prompt, so that the user selects a member and it applies to both grids? The member is on the grid. Grid 1…