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
-
Is there a way in Groovy to throw an error based on certain validations and close the prompt screen?Summary: Hi Experts, Is there a way in Groovy to throw an error based on certain validations and close the prompt screen? In my current application, I am using throwVeto… -
IRR (internal rate of return) and NPV (net present value)Client need to have these features - IRR (internal rate of return) and NPV (net present value) in EPBCS. Are these features available in any of Out of Box modules like S…
-
Shared Member Security inherited even when Shared Members not in CubeSummary: Confirming the expected behavior for Shared member security provisioning in Entity Dimension Content (please ensure you mask any confidential information): Addi…
-
Is there a way to allow member selection in SmartView form?Summary: Is it possible to enable "member selection" in a dimension in the page section of a form in SmartView like it is enabled in the web in the same form? Content (p… -
Using new Reports, how can you create with a prompt and also POV?In the old Financial Reporting, you could create a way to select a member via a Prompt and have it show up in the POV returning the selected dimension member, and then c… -
how to change filter of data load ruleSummary:Is it possible to change the filter members selected into a data load rule (integration), either with a groovy, or a pipeline method, or a rule,…? Right now, we …
-
EPBCS : API call to Run Rule not fetching parametersWe have two Rules. Groovy_Rule1 should run on form save. Should pick Run time prompts and pass it to API call which will call Groovy_Rule2 to run a Data Map. Issue: For …
-
Trouble when using Calculate Currency in PBCSHello 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… -
data integration using xml fileHi Team, I have received a requirement , to build integration with XML, upstream team will place the file in EPBCS DM inbox, i need to build an integration using XML fil…
-
Smartview: drill region is not available, operation is cancelledSummary: I have a power user attempting a drill-through on actuals to which they have access (they can see the value). However, when he tries to drill-through, he gets t…
-
Invalid IntersectionSummary: Content (please ensure you mask any confidential information): Hi I want the Last Column : SAP Master Report —all rows to be valid. These rows could be getting …
-
How to replace #Missing value in Export Data to blankHello everyone, I am trying to export data from PBCS by using Overview»Actions»Export Data. However, i could not replace #Missing data (default value) to blank for Missi…
-
EPBCS to Netsuite integration via NSPB SYNC. How to set a specific period and year as criteria?We are pulling Netsuite actuals into EPBCS using income statement transactions savedsearch and NSPB SYNC. NSPB SYNC set up different criteria options for postingperiod f…
-
Newly added Dimension not displaying in the smartview dimension (editor) Planning extensionSummary New Dimension not displaying in smartview to be able to add new members.Content Using a Standard EPM license. Created a Planning application. After application w…
-
How do you favorite webforms to show on the EPBCS Home Page?We are looking for a way to allow users to favorite webforms in EPBCS so that these forms appear on their home page for quick access. We found that dashboards can be add… -
Auditing of Users Running Financial Reports/Management Reports in Oracle EPM Cloud PlanningOur institution is seeking a way to retrieve how often our users run Financial Reports and/or (Management) Reports and the names. We understand that there is an Activity…
-
Moved: How can i integrate the p_start_date and p_end _date parameters into this query in BI Publis…This discussion has been moved. -
Drill-Through From Excel SmartView to Data Management File SetupSummary: Drill-Through From Excel SmartView to Data Management File Setup Content (required): I have a custom ASO cube for vendor expenses (lots of vendors). The source …
-
Push Sparse Dynamic Calc BSO data to store member in ASOSummary: I have a member formula in Plan Element to calculate for % Sales. This member in Plan Element is a Dynamic Calc. I want to push the data to a store member in AS…
-
Hybrid mode calcs, FRMLBOTTOMUP, and NONEMPTYTUPLEThis isn't really a question, more of a PSA! I found a unique relationship between Hybrid mode in calc scripts, FRMLBOTTOMUP, and NONEMPTYTUPLE when working with complex… -
Cannot export YTD Period's data when using data exportHello everyone, I am using PBCS (which does not support Groovy). When we tried to export data from Navigator » Overview » Actions » Export Data to export YTD data: It sh…
-
Plan Type Map in pipelineHello everyone, I am creating pipeline for integration. When I chose EPM Platform job and chose "Plan Type Map" based on Oracle's guidance : https://docs.oracle.com/en/c…
-
Advise on Member formula for Average of an accountSummary: Hi Team, We have Account 1 = "Number of people" Account 2 = Average of Account 1 We have set Account 1, time balance property = "Balance" Account 2, time balanc…
-
Form 2.0 won't display data in Dashboard 2.0 until you use Scroll Bar?Summary: Form 2.0 behavior in Dashboard 2.0 displays blank when the dashboard is opened. Data does not appear until the scroll bar is moved. This applies to both the vis… -
Form 2.0 "operation is not permitted when navigate without refreshing data is Yes"Summary: Error received when navigating to or clicking on data entry cells in the 2.0 Form version only. This is not an issue in the same 1.0 version of the form. Where …
-
Power user is not able to insert data at Year total in SmartviewSummary: Power User is not able to submit data when opening a form in SmartView. The cells are yellow but on submitting the data and running the business rules attached …
-
How to use script in the EPM integration agent?Summary: I need to use Groovy script to integration NetSuite with PBCS. How to trigger it in PBCS? Content (please ensure you mask any confidential information): The EPM…
-
Can we copy the file from AWS S3 bucket to EPM application using the PipelineSummary: We are planning to implement the Pipeline in our EPBCS Application, and in one stage we are planning to copy the file from the AWS S3 bucket to the EPM applicat…
-
What is the fastest way to duplicating and replacing POV more than 100 forms at one timeHello everyone, I am using Oracle PBCS (which does not support Groovy). In the past, when I worked with Hyperion HPM, I could download the form folder and open it in Not…
-
Groovy - Setup Scenario PeriodHello, I have my Groovy script for scenario and year changes, similar to the Planning Financial Module. I have a form with the "run before save" function associated with…