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
-
Saving inputs in form on dashboard doesn't trigger the on-save rules?Summary: I am starting to look into utilizing dashboards to have an input form and then a reporting "form" in one page for our users. The input form has an on-save rule … -
Read Datamap log fileHello everyone, I want to ask how I can read the log and the script file after running a Data Map rule. When I go to the job and check, it only shows the steps; I can no… -
Cell text limitation in PBCS cloudSummary PBCS cell text and cell comments character limitation after migration to PBCSContent Hello, We have migrated on-prem to PBCS and found upto 2000 characters are s… -
What does Planning Dimension Audit Report Modify action by User SYSTEM mean?Summary: In our Audit Report from Planning, we see Entity Dimension Modify actions performed by the User "SYSTEM". The modification date coincides with the monthly patch… -
I have changed a salary grade in the assumption tab and they did not update in the mass update formSummary: Hi Team. I have run all rules for the existing employees. But the rate for that salary grades was not updated. Content (please ensure you mask any confidential …
-
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg…
-
Can not attach business rule in Data IntegrationSummary: Can not attach business rule in Data Integration Content (please ensure you mask any confidential information): Hello all, We tried to attach a rule in Data Int…
-
Disable Oracle EPM Cell attachment featureHi All, About the Smart View Attachments feature, we can Right-click on a cell in an ad hoc sheet and click Smart View >> Cell Attachment to attach a file. Can I disable… -
Planning report from 2 sourcesSummary: Is it possible to create a report or form that pulls from 2 different cube sources? Content (please ensure you mask any confidential information): Trying to cre…
-
oracle epm narrative reporting, can I choose a specific day for running reports. e.g 31/12/2022Summary: My client wants the ability to run a report, and the two grids on the report show for example, 31st June 2023, and the second grid to show 31st Dec 2022. Is thi…
-
What are the ways of exporting Dashboards 2.0Summary: Hello , What are the ways of exporting Dashboards 2.0 ? Can someone please assist . Content (please ensure you mask any confidential information): Version (incl…
-
Pipeline GET Call errorSummary: Pipeline POST is successful but trying to get the status of pipeline jobs and says error occurred while processing this page. The error appears same for any 'it…
-
Read csv file using groovy scriptSummary: Hello all Below is the requirement I'm trying I have a csv file in inbox/outbox explorer which has data in a particular combination. Example : A1 jan 2024 = 100…
-
Is there a governor on EPM Cloud Rest API calls?Summary: I'm exporting several data slices from a Planning cube in rapid succession using the Rest API. Usually the data is returned in about 500ms but, seemingly random… -
Forms 2.0 - Add Project - Adding extra day on Start and End DateHi, Does anyone experience an issue where you enter a Project Start Date and Project End during project creation and created project has extra day added on those dates? …
-
Return a stored smartlist value as string?Is there a non-groovy way to return a stored smartlist value as string? For example, let's say I have stored smartlist value: CarMake→Begbalance = "Ford" I'm trying to r… -
Exisitng vs create a new control budget to support EPM to ERP budgetary Control integrationSummary: Content (please ensure you mask any confidential information): Hi All, We are integrating budget data from EPBCS (Module based) to Fusion ERP. Our client is cur…
-
Json ArrayI have requirement of writing JsonArray data which is pulled from a wen API to a csv file Rest API url : Json array : [ { "id": 1, "name": "Leanne Graham", "username": "…
-
Cross Pod Data Map - Dynamic Wildcard Mapping from Source to Target in Groovy/Smart PushSummary: We have a need for a cross-pod Smart Push to push data from a cube in one Planning environment to a cube in a another, separate Planning environment. I am loopi… -
Fastest way to export large filtered ASO data setWhat is the current consensus for the fastest method of exporting ASO plan type data? Assuming it could be a large data set with dynamic members and would need to be fil…
-
Webform 2.0 - Period dimension in the rows expands on POV changeSummary: I have idescendants(YearTotal) in the row of a form with "Start Expanded" unchecked. The webform open with YearTotal collapsed but when I change the POV the for…
-
EPMAutomate disconnects after 10 minutesSummary: Content (please ensure you mask any confidential information): Hi all Our client using EPMAutomate, have noticed that they get disconnected after 10 minutes eve… -
Are there new changes for creating blocks in business rules?Hello, we noticed that some of our calculation logics do not work anymore as expected and are wondering whether some updates from Oracle to the database could be the rea…
-
What is the "Set Current Period and Year" Options?Summary: What is the "Set Current Period and Year" option in the Period dimension of the Classic Dimension Editor? Content (please ensure you mask any confidential infor… -
Listing of all possible upload locations and their uses for EPBCSSummary: I'm looking for a listing of all possible upload/download locations and their uses for EPBCS. For example, locations such as inbox/outbox etc for use with EPMAu…
-
Smart View on premise text member causes error when converting to cloudSummary: We have a client migrating from on-premise to cloud EPBCS. Many of their smart view files have text members imbedded in the grids that match member names in the…
-
How to perform Data Integration without using Period Mappings?Summary: If the linked data contains Year and Period information (columns), we would like to perform Data Integration using the data in these columns without using Perio…
-
Excel array formulas and Adhoc Smartviews?Hi, Do excel array formulas work with adhoc Smartview? We are using Office 365. When we refresh an adhoc smartview (23.1) with an array formula it changes the array form…
-
Difference between Revenue/opex/capex working version and OEP_Working version?Hello everyone, When I enabled modules in Planning, it generated many related versions: But what's different purpose of these versions? Hope there are some documents abo…
-
How to get dimension security groups working in the new reports module?Summary: The new reports module seems to not enforce dimension security and our users are able to see entities outside of their security group that's assigned in the dim…