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
-
Maximum number of Oracle Epm groups in EPBCSHello, In our EPBCS application, cost center hierarchy is very big. Client is saying as per their existing Planning budgeting system, they might need user security to be… -
Data Exchange - 2 members accounts with smartlistGood morning everyone, I have a CSV file containing two member accounts with smartlists (Position and Scale). In my Import Format, I have the File Type set to "Multi Col… -
@RELXRANGE not working when argument is @XRANGE with cross-dim membersSummary @RELXRANGE not working when argument is @XRANGE with cross-dim membersContent Hi all, frustrated because @RELXRANGE not working as documented. From @RELXRANGE do… -
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to return text values from a Business Rule (without using Smart Lists)?Hi everyone, I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member. The requirement is to store a text string (… -
PROD scheduling not considering change over rules defined for work definition operationSummary: PROD scheduling not considering change over rules defined for work definition operation Content (please ensure you mask any confidential information): PROD sche…
-
Can an EPBCS application exist without service administrator at any point in time?Summary: Is it possible to have an EPBCS application without any service administrator but all power users at any point in time during the use of the application? Conten…
-
How will changes to the QUERYRESULTLIMIT and QRYGOVEXECTIME affect the system's performance?In our Essbase Cloud-based system, these parameters are currently set to 1 million cells and 30 seconds, respectively. When these limits are insufficient, which happens …
-
Custom Report for DM Tables in EPBCSSummary: Hello, I want to know if i can generate a report using custom query with a join between Datamanagement tables say AIF_BAL_RULE_PARAMS or AIF_BALANCE_RULES in EP…
-
Auto Predict Explain Predictions Not AvailableSummary: Auto Predict Explain Predictions Not Available Content (please ensure you mask any confidential information): Auto Predict Explain Predictions Not Available. Th… -
Still we cannot use Parent Members from ASO as source in Advanced Prediction?Summary: Has anyone been successful using Parent Members from ASO as source in Advance Prediction? Content (please ensure you mask any confidential information): When us…
-
Data load between EPM PBCS and FAWHi Team, need suggestions in data load from FAW into Oracle EPM PBCS - any reference of connections / blogs etc? Inbound integration into Oracle EPM (PBCS - Planning Bud…
-
Calculation Manager Errors and Considerations EnforcementSummary: In the August 2025 Monthly Update e-mail I saw this in Important Actions and Considerations: Calculation Manager Errors and Considerations Enforcement In a futu…
-
"Suppress Missing Blocks" occasionally becomes unchecked after the monthly patchSummary: We're receiving reports that "Suppress Missing Blocks" occasionally becomes unchecked after the monthly patch. I haven't been able to find any common details th…
-
Using Substitution Variables in CalcManagerCan I use substitution variables for variables that can be specified in CalcManager? Can I only use variables created in CalcManager? Can substitute variables be used in…
-
Dimension Hierarchy for Descendants in POVSummary: My question using the example below of Descendants of AllSegments: If we were to not use the Prompt function and instead select Descendants of AllSegements in t…
-
Report grid exportSummary: Need the option to export the Grid from Reports. we have recently migrated our reports from Financial Reporting Studio to PBCS Reports. Since then we are unable… -
Data retrieval time in SmartView for Level 0 member is worse than for its ancestorSummary: Say I have a retail operations database with an Employee Type dimension that has three children: Employee Type Customer-facing employees (CFEs) Back office empl…
-
Groovy - Issue passing variable between templates within the same jobHello I have Issue passing variable between templates within the same job. In GroovyValidationReport I got error: The Groovy script failed to compile with internal error…
-
Using Functions and Substitution Variables in Rules in Calc ManagerWhen I set variables that use functions and substitution variables in Calc Manager, I get the following error: Error:Validation against Planning outline succeeded. Faile…
-
Data Management Distinct Query of Year/Scenario/Version to Determine Data Sets in WorkbenchSummary: Data Management Distinct Query of Year/Scenario/Version to Determine Data Sets in Workbench Content (please ensure you mask any confidential information): Is th…
-
Getting error on flex form Index:3 Size:3Summary: When we try to save data on a flex form from smart view, it throws the below error Content (please ensure you mask any confidential information): There is a gro…
-
Options - supporting details copy to new forecastWanted to understand the various options we have in EPM Cloud to copy SUPPORTING DETAILS / LINE ITEMS across different scenario members Copy Data - (CONS) there is no jo…
-
Need access to Oracle CSI - Dont see option in cloud portalI dont see the option for me to enter Customer CSI on cloud support portal. How n where do I request access to customer CSI? I need to open SR for customer.
-
Data Exchange Oracle Write Back on EPM Agent folders appdata/data staging data not createdSummary: PBCS Oracle Data write back rule does not create the staging file Content (please ensure you mask any confidential information): Data Exchange - DLR Run does no…
-
Performance issue with writeback operations to Snowflake table using EPM Integration agentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
Issue while creating Task to launch "Manual Business Rule Run" through EPM Task ManagerSummary: To manually run any Business Rule through EPM Task Manager, Navigate>Task Manager>Task Type>Create: "Task Type" Template for Business Rule with "Execution Type:…
-
Hybrid Cube conversion: The number of rules added exceeded threshold limit (300 + rules)Summary: Converting existing EPBCS application to Hybrid cube. While conversion, getting below error, how do we fix this? The number of rules added exceeded threshold. E… -
Dashboard 2.0 Not Displaying Full Form Data Like Dashboard 1.0Summary: We’ve noticed a significant usability issue after transitioning to Dashboard 2.0. Users are unable to view the complete data sets for forms positioned in the mi…
-
Does Project Benefits flow to financials in EPMI am trying to pull financial benefits from projects to Financial Planning Module. In the Projects configure page I have a seeded form named Project-Finstmt Mapping. In …