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
-
Member Formula is working, but cannot see data in Ad HocSummary: Content (please ensure you mask any confidential information): I recently updated a member formula to calculate payrate based on number of days worked in a mont… -
Help with SQL statement in Planning IntegrationSummary: I have an SQL statement in a Planning Integration that was written years ago by a consultant that I need to update. In one of the columns of data I am trying to… -
Extract all level data from a BSO Planning ApplicationWe are attempting to extract all‑level data, including dynamic calculation data, from the BSO Planning application. The extraction is currently failing due to the extend…
-
Audit Details Report to Provide Second-Level Granularity 26.04 Oracle EPM UpdateHello, we did an impact analysis for EPBCS and FCCS for the Audit details report and as stated on the document, we should be seeing "seconds" on the report. But we the r…
-
"Display" Access for Data FormsSummary: Content (please ensure you mask any confidential information): Hi, Does anyone know about or have been using the "Display" Access for Data Forms? I remember it …
-
Is it possible to export text, smartlist or date members using Data management rules to a text file?Summary: We have a query to export the data from EPBCS to Flatfile, the data include Text, SmartList, and Date. However, when I tried to export, it exported numeric not …
-
How to remove Unrecognized Smart List Values ?Hello everyone, I have a Smartlist create from members. When I delete some members and check the form it showed the id like this: Do we have any way to delete unrecogniz… -
EPM Pipeline: Running a business rule with runtime prompt type SmartlistSummary: Hi, I'm trying to execute the BR: "OWP_Process Loaded Data" as part of a pipeline. I want to pass the variable "OEP_FcstMnth" as the RTP 'Month'. However, Month…
-
Seeing different results in Groovy 26.04 vs 26.05 in variable settingSummary: Validating business rules between 26.04 and 26.05 and we found syntax that produces different results Content (please ensure you mask any confidential informati… -
Is it possible to limit text cell input to a specific number of characters in EPM Planning?Summary: We are aware that the maximum limit for text data in a cell is 4000 characters. We would like to know if there is a way to restrict or limit the number of chara…
-
Unable to perform bursting because the specified POV members are not found in the bursting query.Summary: We are trying to execute a Bursting Definition but we are getting the error message; Unable to perform bursting because the specified POV members are not found …
-
Member formula for certain Account Members are not calculating properlyHello, we are trying to retrieve an adhoc in Oracle PBCS for this intersection: GAAP OI Actual ex Royalties > Actual Budget Rate > FY25 > Restatement and EBIT Actual > A…
-
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
Pipeline - Integration does not work for files inside inboxSummary: Two issues here. I am just unable to select the file to launch the pipe line from any folder. I have admin rights. When I type the file name in the box , the in…
-
Can you Export Data with many Rows of Data to not be Split into Multiple FilesSummary: We are exporting Data using Overview→Actions→Export Data. The data being exported is becoming too large in which the .zip file generates multiple files. Is ther…
-
Data Management Data Exports errors with 21C (April 26.04 upgrade)We have SR's open already but not yet confirmed issues back from Oracle. Has anyone else run into errors when running file Export Integrations in Data Management / Data …
-
when is the next version of smart view being release , currenlty we are 25.200when is the next version of smart view being release , currently we are on 25.200
-
Suppress #noaccess on EPBCS Data FormsWe currently have multiple data forms that display all departments associated with a Business Unit. When a user with access to only certain departments accesses the form…
-
UnZipping Files using zipOutputStreamJust some sample code to use the new zipOutputStream function String exportJobName='Job_Console_Export_20250925.zip' zipInputStream(exportJobName).withCloseable { ZipInp…
-
YTD (Period) members not retrieving values in Management ReportsSummary: YTD (Period) members not retrieving values in Management Reports Content (please ensure you mask any confidential information): Version (include the version you…
-
Enterprise Performance Management Enterprise Cloud Service patch updatewe are using planning Version26.04.66 of Enterprise Performance Management Enterprise Cloud Service. After the recent patch update users both admin and non admin are una…
-
Application Refresh Taking Over Two HoursSummary: Content (please ensure you mask any confidential information): Our application refresh is taking over two hours to run when we add a new "store" account. This t…
-
Add checkbox in FormsHello, We have a Card where Departments can put their requests in and they get approved or denied and gets moved in different tabs. I want to add checkboxes next to the …
-
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u…
-
Workforce Planning Deprecated Rules in June 2026Summary: The Nov 2025 "Important Actions and Considerations" included that the following workforce rules will be updated and prior rules will be deprecated in the June 2…
-
Run a database refresh embedded in a rule from a PipelineI believe similar questions have come up but haven't seen a straight answer for this use case. I have a groovy business rule that performs this high level sequence: Cond… -
Oracle EPBCS: Unable to execute CopyfromSFTP in pipelineHi all, In our current project, we are trying to bring a txt file from SFTP server to Oracle EPBCS Inbox folder. We have recently encountered a job "CopyfromSFTP" in pip…
-
Source expression is causing issue in epbcs integration after 26.04 upgradeSummary: We had the following source expression in the integration which is causing issue after 26.04 upgrade Content (please ensure you mask any confidential informatio…
-
Multiple Selection on Member VariableHow do I select multiple members below? I want to be able to have an option to select as much members as needed. I don't see select multiple option.
-
EPM Cloud REST API Role for UPload file and delete fileHI This is about security roles for the REST API calls to work. We are interested in two REST APIs i.e. DELETE FILE(v3) AND UPLOAD File (11.1.2.3.600), we want to know w…