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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Planning
Discussion List
-
How to extract user report by EPM instance via Console IAM ?Hello All, We need to export the list of all users per instance. Before migration to OCI, we could use the APIs and export the list of users per instance, so we could co… -
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l… -
Run a business rule from a dashboardSummary: I have created a dashboard which includes 4 forms. The forms have business rules attached that run on Save and rule prompts are hidden as they take the current …
-
EPM Cloud Connection requires HTTPSSummary: The December update to EPM Planning now requires that all Connections use HTTPS URLS. This was only announced as a future update for February 2025, but this cha…
-
Numeric prompts default to 0 in form 2.0Summary: Is there a way to prevent numeric prompts from defaulting to 0 in the Form 2.0 version? Content (please ensure you mask any confidential information): Form 2.0 … -
ApprovalHi Oracle community, Is there a way to extract the complete approval history, including the exact time and date when users promoted the approval? Currently, the existing…
-
Groovy - Read Only Using Dimension AttributesSummary: I am trying to find a way to get specific cells read only based on a combination of of an account value and a dimension attribute. It is working for the account…
-
EPM REST API Related QuestionsSummary: Since we don't have access to Application and Essbase logs in EPM cloud and we have to rely on REST API. Could you please provide instructions on (1) How to get…
-
Cannot input yeartotal in adhocHello everyone, I am trying to input the number at YearTotal level in both Form and Ad-hoc mode. But I saw that in the form I can input easily and it will automatically … -
Groovy - Issue calling calc script template inside a groovy scriptSummary: I have a groovy rule that executes a calc that references a Template. I am passing the template name using a variable. I am getting a generic error. If I print …
-
Is there an EPM Automate command to run a pipeline?Summary: I built a pipeline and want to run it from sh scripts. But runIntegration does not work. I went through the EPM Automate help book but I was surprised that I ca…
-
Salary web form calculation issue when changing versionsHi, I have come across an issue with a salary web form. When entering a salary line with a start date and no end date salary is calculated for not just the current finan…
-
Dynamic Calc members are not aggregating when CALC DIM is used onceHi all, We have a sample hierarchy as below. Below are the member properties. Net Sales: Store, Two Pass Calculation - Enabled Gross Profit: Store, Two Pass Calculation …
-
Report Repository DistributionMy company uses the report repository to send out batch reports to individual email addresses. We have a number of distribution lists that we need to manually update. Ha…
-
How to Set Conditional Smartlist Functionality ?Summary: Dear All, I would like to ask if it is possible to use Smartlists with conditional functionality. Here’s an example of what I’m trying to achieve: Column 1: Inc…
-
How to do Multi-Year load with multi-column data using file integration in Data Management?Summary: We are trying to set-up a file-based integration which has Years in column with Amount. So we are facing an error says Unexpected error: . Content (required): S…
-
Level 0 block fluctuationSummary: Level 0 Block will fluctuate up and down after a Cube restructure even when there is no activity in cube. Content (please ensure you mask any confidential infor…
-
Do Demand Plan with standard calendar generate a forecasted shipment quantity that has Fluctuations?In Demand Management module, we are looking for a setting/parameter change to have the sales forecasting with standard calendar work properly. Currently, it is showing o…
-
Member selection restriction in run time promptWe have run time prompts for Scenario, version and Entity for a business rule. When I select the Actual scenario in RTP for scenario, I dont see the alternate hierarchy …
-
Smartview Report HsgetValue to retain data when it is openedSummary: Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection Content (please ensure you mask any confidential in…
-
Need to Burst a Report with Multiple DepartmentsSummary: I need the Sales dept report and the Operations dept report to go to two different groups of emails. Content (please ensure you mask any confidential informatio… -
How to Exclude Shared Members in getEvaluatedMembers?Summary: How to Exclude Shared Members in getEvaluatedMembers When Loading Lvl0 Members of a Hierarchy Content (please ensure you mask any confidential information): I a…
-
Is there any OTB solution for comparing/validating data between different cubes?Summary: Is there any OTB solution for comparing/validating data between different cubes and flag if there is difference between two datasets ? Content (please ensure yo…
-
Groovy Validation based on other columnHi, Please need help with below. I want to make "Departure Date" read-only if "New Pos Status" != 2. The below scripts runs without error but doesn't perform the expecte… -
Data Map doesn't support sub var value as a member listSummary: Content (please ensure you mask any confidential information): Hi, For specific design purpose, we have a sub var with the value as a list of members, eg. CC1,C…
-
REST API - GENERATE_ROLE_ASSIGNMENT_REPORTHi Team we are using this report from IDCS , but post Dec24, this will be deprecated, rather we have to use API. I searched it for documentation, could not find any. Do …
-
Scheduled Jobs running for more than 2 daysSummary: Hi , In Explore Repository → Batch Schedular , One of the job that is scheduled for daily is still in running status since past few days . Even today the job is…
-
Unable to fetch asset details using Rest APISummary: I'm trying fetch details using Rest API (crmRestApi/resources/11.13.18.05/assets). Even though I have roles to view Fixed assets from application still count of…
-
Data load mapping using SQL ReplaceHello experts, I have a doubt doing a specific Mapping in DM I have in my source this kind of accounts (Source-Account column): I need to create a mapping that FIRST und… -
Im using oracle epbcs, is it possible to export data management > process details using EPMAutomate?Im using oracle epbcs, is it possible to export data management > process details using EPMAutomate? (Im referring to the table) My goal is to check the data load rule i…