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
-
PBCS - Delete yearsHello, Is there any way we can delete year dimension members from PBCS? We have lots of initial years (FY10 - FY18) that we no longer need. Is there a way to do this? -
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… -
OAuth for EPM to ERP ConnectionDear Experts, Can we use OAuth while connecting EPM application to Fusion ERP instead of basic authentication. If yes kindly share steps for same. Best Regards, Pratik Y… -
Advanced Prediction: Algorithm Change (Prophet → SARIMAX) Not Updating ResultsI’m using Advanced Prediction on a Dynamic Calc member in EPM Planning. The job runs successfully and generated the dynamic calc prediction but when I change the algorit…
-
Divide data by 6 while loading file-based integrationSummary: We have a requirement for file data load where we need to load half-yearly data into level 0 periods by dividing the data by 6 on fly. Is it possible to do this…
-
EPM Cloud Planning Data Load errorSummary: Has any seen this error? I have multiple files by year. The export script in essbase is same for all years but only certain years are giving this error. This da…
-
Loading Multiple (daily) Periods at onceSummary: In PCF, we have a source (BIP Report) that has a start date en end date as paramter. Via Data Exchange (EPM) we pass the start and end period to that BIP report…
-
Clone environment does not copying data management folders and filesDear Experts, We are doing clone of ARCS test instance new instance. We have enabled Artifacts snapshot & Stored Files check box, still it is not copying file under data…
-
Override Effective Date everyday with the current date before Data Load Rule runsSummary: EPBCS Data Integration - We have a direct integration setup between source system and EPBCS to pull salary data. This needs to be automated to run everyday to p…
-
Why are some dimension properties not editable?Summary: I want to use OOTB plan element OFS_Load, in a report in FS cube. I want to change this member's property from store to dynamic calc but the field is not editab… -
Customising the Subject and body of the Email notification in the EPBCS Data exchange PipelineSummary: Possibilities to customize the email subject or body in Pipeline notifications. Content (please ensure you mask any confidential information): In EPBCS Data Exc…
-
We want the power users in the system to view the form layout and rules but cannot edit themSummary: We want the power users in the system to view the form layout and rules but cannot edit them. Is there a method of doing it because when we have giving them rea…
-
Can not use the file under inbox for data integration in the pipelineSummary: I am encountering an inconsistency when using files in the inbox folder within a Pipeline. Data Integration: When running a standalone Data Integration using a … -
New member under Exchange rates - Account DimensionSummary: In Account Dimension, Under Exchange Rates, we have FX Rates - Average, FX Rates - Ending. We would like to add a new member FX Rates - Historic which will be Y…
-
Period and Year extracted from Oracle database in columns - not working in FCCS Data ManagementSummary: Period and Year extracted from Oracle database in columns - not working in FCCS Data Management Content (please ensure you mask any confidential information): W… -
Use OAUTH for EPM GEN2 Rest APIs in OICSummary: Currently we are in EPM GEN2 and using basic authentication for EPM Rest apis in OIC. Customer wants to use oauth for the rest apis. I went through below docume…
-
Error while creating multiple alternate hierarchies in ASO CubeSummary: We are getting error "Shared members or their shared ancestors can only appear once in a stored hierarchy. Remove duplication or use multiple hierarchy." while …
-
OEM file format in export fileSummary: Hi, This issue is related to on prem to cloud migration. In current on-prem process, we export data through calc script which gives a .txt file. This file is up…
-
Predictive Cash Forecasting (PCF) - Daily Period Mapping isn't workingSummary: In Predictive Cash Forecasting, we're doing a daily forecast. For that, the date should be mapped to a "Day" period. Content (please ensure you mask any confide…
-
Drill-through works on one branch but not the otherSummary: In our projects dimension, we have 2 branches in the tree for the dimension. Total Projects where we simply list all the project values primarily for external r…
-
Data Value [-713242] Encountered Before All Dimensions Selected, [1] Records CompletedSummary: Unable to load data and getting below error Cannot begin data load. Essbase Error(1003007): Data Value [-713242] Encountered Before All Dimensions Selected, [1]…
-
Reports within Navigation Flows have download disabledI've built a navigation flow that contains a card with vertical tabs. Each tab is a report that was created within EPM. These reports have the options to download as PDF…
-
Does Groovy help retrieve the date of latest input data ?Hello experts, I have one question about Groovy's ability. I noticed that on the form, when you right-click, you can view the change history of the data cell. So my ques… -
As Hoc Refresh Extremely SlowSummary: Content (please ensure you mask any confidential information): We are experiencing issues refreshing our balance sheet Smart View ad hocs. These are currently t… -
Optimize User Variable Member SelectorFor the past few months we have noticed it takes longer to load the Entity User Variable member selector. It's currently taking ~20 seconds to load before you can make y… -
How can I read full log of the jobHello experts, I am using Groovy to print the log for the job I am running. However, when I go to the Job Console to view the log, I find that it is not sufficient, and …
-
Unable to access urls in PBCS dashboardsSummary:A custom developed website is not accessible within Oracle EPBCS Dashboards 2.o Content (please ensure you mask any confidential information): we have created a …
-
Auto Predict Not Accounting for Recurring Missing Months TrendSummary: Auto Predict forecasting negative values for recurring missing months and ignoring missing-month trends or events in historical data Content (please ensure you …
-
RTPs Repeated issueSummary: Content (required): Hi I have two run time prompts for scenario and version for all the rules, and i have attached all the rules to a ruleset. when im about to …
-
Can we filter out data before processing an integration?Summary: We have a file from which 50% of data is ignored by the data integration built in EPBCS. Is there a way to filter out the unnecessary data in EPBCS before it pr…