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 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…
-
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…
-
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…
-
NetSuite PBCS, Form 2.0, no Drill Through?Summary: Content (please ensure you mask any confidential information): Hi, We are working on NetSuite PBCS, with Form 2.0, with the cells which indicates there is a Dri…
-
How to Check if member from Plan1 exist in Plan2?Summary: Problem : Customer is copying data from one plan to another plan in planning application. Now some dimension member do not exist in target plan type. Do we have…
-
EPM to PPM project exportSummary: We are trying to export approved projects (created in EPM) to the PPM. The process is showing success in EPM, but no projects are being created in PPM. Content … -
Can I populate a text member with the current associated dimension members?Summary: When creating a new Asset, I'd like to create an Asset Description member that concatenates the member names from the Asset, Asset Class, Company and CostCenter…
-
Account with two pass and stored formula is not pulling data at the Year Total levelSummary: We have many % accounts that have stored formula with two pass. a. When we pull these accounts vs year total at top level of other stored dimensions, they popul…
-
How to surround double quotes when using data management to export data to file?Hello everyone, I am using data management to export data from the OFS cube to a CSV file. I am setting up my data file's column delimiter is ",". However, when I checke… -
PBCS Data Load via Data Management - Ignore Errors?Hi - loading data via DM into PBCS. It seems that a single error (for example, member does not exist) will cause the whole load to fail, no data loaded. Ideally I would … -
If Condition with a Range or Substitution variable Groovy ScriptSummary: Hi , We have a substitution variable SSClosedWeeks which has a value of OEP_W1:OEP_W39. This variable works perfectly in member formulas. I would like to use th…
-
EPM Workforce - partial payment factor gets overwritten by the monthly HCM loadSummary: Process Loaded data rule copies OWP_Partial Payment Factor from the the loaded period into all future periods, hence overrides EPM Workforce direct data entry. …
-
Do we need a new instance for Predictive Cash Forecasting?Hi, We already have existing EPBCS application enabled with Module Type and as per business need to we are planning to enable Predictive Cash Forecasting in the same ins…
-
Show Alias in Business Rule Prompt?Summary: Hello, is it possible to have the member alias display in Business Rule Prompts instead of the member name? Content (please ensure you mask any confidential inf…
-
How to change thousand separator only to 1 member in Oracle PBCS webformsSummary: I have a non currency member in a column showing 4 digits values. For Example 2024, the issue is the thousand separator is causing the number shows with a coma …
-
Error on "Incremental Process Data with Synchronize Defaults" Rule when Run by UserSummary: I have set up a form to run the "Incremental Process Data with Synchronize Defaults" on save. It works fine when I save the form to run the rule (as the service… -
Can I customize the initial template generated when you click "Ad Hoc Analysis" to start a new grid?Summary: I would like to change the default initial grid generated when a new Ad-Hoc is created. The current setup is sub-optimal for our business. It would be nice to c… -
Smartview taking long time to retreive data from BSO cubeSummary: Smartview taking long time to retreive data from BSO cube. We started facing this issue 3 months ago. Also did below setting change but no help in Formatting: S…
-
Request for Mobile App Support in EPM CloudSummary: The customer wants to view dashboards directly through the Oracle EPM Cloud mobile application. They do not want to access dashboards via a mobile web browser; …
-
Trouble when using Calculate Currency in PBCS 2Hello everyone, I am trying to convert the local currency to the reporting currency in PBCS by using "Calculate Currencies" . Step 1: I input the exchange rate in the sy…
-
How to create USD currency under "Currency" hierarchy?Hello everyone, I am using PBCS, and my application has the base currency "THB". Now, under my "Input Currencies" hierarchy, has only 3 currencies : I tried to create US…
-
Data push for large volumeContext: We need to push ~12–15 million records from a Source ASO cube to a Target ASO cube within the same application. Standard data push and Groovy-based export/impor…