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
-
How to get member aliases from row dimension set as "Children of" in ReportsSummary: Planning - Reports Content (required): Hi, I have a report with 2 row dimensions. The first row dimension is set as "Children of [Total Expenses]", the second o… -
HsGetValue function not refreshingSummary: Workbook with HsGetValue functions not refreshing for a single user Content (required): Workbook with multiple HsGetValue formulas on it. Works fine for multipl… -
Restructure Errors - asking to clear ASO Cube --Why only just one of our ASO Cubes?We got errors restructuring our database, saying that data must first be cleared in one of our ASO Cubes. "In order to restructure database [CUBE NAME] all data must fir… -
Member formula still calculating when when "IF" is falseSummary: Content (required): We have a formula that is supposed to check the employee status, and if active, calculate the 401. However, we have noticed that that it con… -
IfThen formula function Management reportSummary: Hi All, For a specific report I have been using the formula function "IfThen", but I am struggling to have the falseparameter defined properly. The goal is to g…
-
Enabling Batch/Shell Scripts execution from Business Rules (Like OnPrem CDF Functionality)Summary: We would like to implement a functionality where Business Rules having ability to call Shell/Batch Scripts. The same feature available in OnPrem (CDF Functional…
-
Opening data form in SmartView is the same as opening in PBCS UI?Summary: Opening data form in SmartView is the same as opening in PBCS UI? Content (required): In PBCS, when I open a data form in SmartView, is the request sent to the …
-
Validation fails even if I have mappingI'm trying to load data from a file to Oracle planning cloud using On-premise FDMEE. I have all the required mapping but still the Data load rule fails at validate step.…User_2025-03-10-22-57-31-218 44 views 3 comments 0 points Most recent by User_2025-03-10-22-57-31-218
-
Set default for Smartlist selectionSummary: Is it possible to have a default set for a smartlist? Content (required): In PBCS workforce, I have a saved assumption account that uses a smartlist for medical…
-
Dimension Top-Level SecuritySummary: Can you apply security to the top-level member of a dimension? Content (required): If we have enabled security on a dimension, is there any way to give a user a…
-
On-premise FDMEE to Oracle Planning cloud integration - failing at import stepHello Everyone, I'm trying to integration On-premise FDMEE with Oracle Planning cloud and I have the setup, scripts and mapping in place, when I ran the DLR (Data load r…
-
In EPM PBCS, is it true that you cannot lock down actuals for a closed period ?Summary: Technically a business rule can change any data for any month. This is a huge risk. Content (required): PBCS Version (include the version you are using, if appl…
-
Cross-Pod mapping with SmartlistSummary: I'm trying to do a cross-pod map from a Planning application to a FreeForm application. Several dimensions are using smartlist to dimension mapping. I've cleare…
-
Announcement: Financial Reporting change in behavior for valid intersections in 23.05UPDATE: This will no longer be an issue in 23.05, a bug related to this has been addressed. In the 23.05 release, Financial Reporting (FR) will now filter and restrict d… -
If @PREVSIBLING returns null, have it return the member being evaluated instead. Is this possible?Summary: Is it possible to return the current member being evaluated in @PREVSIBLING if the formula evaluates to null (the member being evaluated does not have a previou… -
How does HypGetParent work?Summary: Error 57704 using VBA HypGetParent, et al Content (required): I'm in EPM cloud planning and Budgeting. Get error code 57704 and vtParent is Empty after running.…
-
Approval Hierarchy - Reviewers couldnt make amendementsSummary: Content (required): Hi All, We have created an approval hierarchy where 'User A' is assigned as Owner and 'Users B' & 'User C' are assigned as reviewers in an a…
-
Auto Release Planning orders based on CatalogSummary: We have a set of items we want planning orders to release automatically. We defined a catalog for such items and add the items categories to that catalog We add… -
How to refresh a form using a groovy rule?Summary: How to refresh a form using a groovy rule? Content (required): Dear all, I've written a Groovy rule to add some complex control before saving data. This rule is… -
Issue in Smart View LoginSummary: Hello, when i try to login yo Smart View, login pop-up seems to be blocked and there is no chance to enter username and password. Previously, it worked correctl…
-
Importing Text through data management (Non Numeric)Summary: Importing Text through data management (Non Numeric) Content (required): Hi I have setup data management import format "Delimited All Data Type". And Load metho…
-
Hide a cube using Security in Cloud Planning AppSummary: Cloud app has 5 cubes and security is provided to users for only two cubes. IS there a way to hide the cubes which users doesnt have access to Content (required… -
Future of Data maps in PBCSHi, In the Oracle march monthly update there is a notice concerning Data maps: "Data Maps with Mapping or Cross Applications Data Maps with mapping or cross applications…
-
Oracle Reports Output to ExcelSummary: Working in Oracle EPM Cloud (Planning) and have reports the users want defined in Excel but, it limits to 100 worksheets when we need a 110 worksheets to genera… -
Google cloud ( Big query/ Star bust) to EPBCS integrationSummary: Google cloud ( Big query/ Star bust) to EPBCS integration Content (required): We have a requirement to integrate data from Google cloud(Big query/ star bust) to… -
Groovy error "A method called by the script failed on line..."Summary: I am trying to update the substitution variable using a groovy script from the Business rule, which is returning an error. Content (required): I have a groovy s…
-
Updating substitution variables via REST API broke with 23.03 updateSummary: In performing regression testing, I am having trouble using the REST API to update substitution variables. The rule results in a null pointer exception. Content…
-
Driver Based BudgetingSummary: We are looking to move to driver based budgets and would like some examples of "drivers" used. Content (required): Examples of the drivers used to improve busin…
-
Need to Improve Aggregation Run TimeSummary: Want to decrease time it takes to run an agg. Content (required): Currently takes about 40 minutes to agg one period, one scenario, income statement only. Would…
-
How to select ILvl0Descendants when exporting via calculation manager?Summary: How to select ILvl0Descendants when exporting via calc manager? Content (required): When exporting data via a job, you can specify members sets using the "ILvl0…