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
-
Can the Netsuite connector be configured bidirectionally with Planning?Summary: Content (please ensure you mask any confidential information): Hi all We have the intention to use the Netsuite Connector with Planning, but we are wondering if… -
Do we have any option to clear data from an on-prem database table before it imports from EPBCS?Hi, I am trying to create an integration for data export from EPM application to an On-premise database table using EPM Integration Agent. Integration runs fine and expo… -
We have some doubts related to Oracle Classic and Oracle Redwood Supply Planning Page.Summary: What are pages and page groups in classic, which is there now in Redwood. It was stated by Redwood all data from classic to Redwood would come through but we do…
-
We have some doubts related to Oracle Classic and Oracle Redwood Supply Planning Page.What are pages and page groups in classic, which is there now in Redwood. It was stated by Redwood all data from classic to Redwood would come through but we do not see …
-
Clone environment - excluding transactional dataSummary: Hi All, I'm trying to achieve a snapshot copy, excluding the transactional data, of an application towards a target environment in order to retain the data of t…
-
@IRR and @CalcMgrExcelIRR does not return a value equalent to the Excel IRR calculationSummary: We are using @IRR inbuilt oracle function in our Calculation rules to arrive at the IRR value , IRR(AC.PBC.6013)= IRR( Cumulative(Free Cash Flow (FCF)(AC.PBC.50…
-
Drill Through issueSummary: Content (please ensure you mask any confidential information): Hi, We are facing an weird issue with the Drill Through. So, we have made all the configurations …
-
Reports - How to export multiple grids in a single excel worksheet?Summary: is it possible to export multiple grids in a single excel worksheet with the new Reports tool? Content (please ensure you mask any confidential information): Wi…
-
Getting error Cannot find matching method java.util.Date#format(java.lang.String, java.util.TimeZoneSummary: Getting below error for one of the Groovy scripts in Groovy Script Validator. But we can validate and run the rule without issues Cannot find matching method ja…
-
Has the logic behind dimensional security on shared members changed?Summary: Security logic that we have always used in the past successfully doesn't work any longer Content (please ensure you mask any confidential information): In our o… -
Predictive Cash Forecasting - Forecast Range SetupSummary: We have requirements for 13 week and 18 month forecast ranges for predictive cash forecasting, but it looks like the configuration settings only go up to 45 day…
-
Select Account from Target Dimension in Data MappingSummary: We have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwis…
-
Select Account from Target Dimension in Data MappingSummary: We have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwis…
-
Issue with Thousand Separator in Multi-Column All Data Type Rule in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all, I’m working with Oracle EPBCS Data Management and running into an issue with thousand sep…
-
Advance Predictions is applicable for which all EPM licensing part numbers?Summary: Advance Predictions is applicable for which all EPM licensing part numbers?
-
Can Oracle Rest APIs be used to export/import data and metadata (dimensions)?Summary: Can Oracle Rest APIs be used to export/import data and metadata (dimensions) to/from Planning and other database types (i.e PowerBI as an example)? I have revie… -
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
How to use @SHIFT(@CurrMBR in a crossdimI am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF sta…
-
How to hide #noaccess and display data for users in EPBCS formsSummary: In EPBCS we are using Cell level security to restrict access for certain intersections based on security groups. However, we noticed a strange behavior: When us…
-
Restrict Users to run specific DLRsSummary: Is there any way to restrict users to run specific DLR in EPM FCCS. For example, only User under Group A should be able to execute the DLR_A . Content (please e…
-
Automation Mechanism for Approval Status SynchronizationHi Gurus, I am seeking an automation mechanism that will allow the approval status of an entity in PBCS to change based on the approval status of the same entity in FCCS…
-
Transfer file from a unix server to EPM cloud aplllication using copyfromSFTPSummary: There is a requirement to pull files from Unix server to EPM cloud application. Is it possible to meet the requirement using EPMAUTOMATE copyfromSFTP command. I…
-
Why is the waterfall chart in Oracle EPM not showing the desired data points?When building a report in oracle EPM. We are experiencing issues developing a waterfall chart not showing the desired data points, however the data points are can be dis…
-
Adavanced prediction Dynamic calc membersHi, Is it possible to predict dynamic calculation members in Advanced Prediction? I’m currently providing a dynamic (parent) member in the Historical Data tab and Future…
-
Missing LinkForm and Explainability function when opening forms via Task ManagerSummary: When I open a form from Task Manager, the LinkForm and Explainability options are missing from the options list. Opening the same form from the Data section sho…
-
Change in FIX AND behavior with 25.08In my business rules, I often use SET EMPTYMEMBERSETS ON; along with FIX statements to handle different branches of logic that need to occur for different years or scena… -
Why doesn't leaf level data in financial forms, roll up to top level dimensions?Summary: We have data uploaded for plan and actuals in financials at leaf level. When we select the specific POV we can see the data uploaded, but when we filter for top… -
Best case and Worst Case scenarios are not calculating for advanced PredictionHi , I have defined Wostcase and BestCase Scenario in advanced prediction but still its not calculating and Fitted Value also its calculating when i am selecting algorit…
-
"Unknown Member used in query" error in Data Load RuleSummary: I am updating the Source Filter in an EPBCS data load rule, changing the spec for Accounts, but even using the member selector to ensure correct spelling, I am …
-
can we run merge data slice while data maps and other smartpushes are in progressSummary: can we run merge data slice while data maps and other smartpushes are in progress Content (please ensure you mask any confidential information): We have Scenari…