Category 101
Discussion List
-
How to import Average FX rates from Financials to Planning in the new Exchange Rates integration?Summary: We are unable to get Average FX rates in the new Exchange Rates integration, when loading data from Financials to Planning. We are getting Closing FX rates, but… -
Your environments will be upgraded to Essbase version 21.7.xx in 25.11Summary: As Oracle has notified us that our environments will be upgraded to Essbase version 21.7.xx as part of the 25.11 update, we would like to gain a clear understan…
-
How to set up Network PerimeterIt was announced below that the EPM Automate "setIPAllowList" command has been removed and the Oracle Identity Cloud "network perimeter feature" will be used instead. ht…
-
PBCS Concurrency Issue During Data loadWe are loading data from Fusion to PBCS using Data Management, and the process is triggered through a pipeline. In our setup, we have multiple Data Load Rules within the…
-
Cells Action->History not openingSummary: Not able to open the Cells update History in SmartView I am trying to check the cell update history in the SmartView form and the history window does not pop up…
-
Security on Attribute DimensionsSummary: We have a custom dimension where level 0 members are a concatenation of the entity, building and cost center (i.e. 123-1234-1234567). For reporting purposes, th… -
Testing nonemptytuple on Planning Custom Calculation ASO (Groovy)Summary: Now that Essbase 21C is under the hood of Planning, did anyone notice performance gains from adding NonEmptyTuple to Custom Calculations in ASO? I have been adj… -
Possible to have Groovy Popup Warning, NOT Error?Summary: We have groovy rules set for validation that we use throwVetoException to stop processes before they start, but is there a good way using groovy to just throw a…
-
ORA-01427: single-row subquery returns more than one rowhello, Getting this message when tried to load a via data integration from epm to erp. has anyone ever faced this type of error ? -
Control Budgets that share same Budgetary Control Cube in hyperion planning (not financials module)hello I have 2 Control Budgets that share the same Budgetary Control Cube in ERP and I want to do a data integration from hyperion planning cloud (not financials modules…
-
Ability to expand to bottom level descendants in FormsSummary: We are running into a use case where a client would like a form to be at a "Total" parent level and then once expanded to show bottom level members. ILvl0Descen…Samantha Rivera 23 views 4 comments 0 points Most recent by N.S - Navulla Saikrishna-Oracle Planning
-
Maximum Amount of Cubes in EPM Cloud Standard Planning Application?Summary: I am trying to determine how many more cubes I can add to my EPM Cloud Standard Planning Application. I found the Oracle documentation that indicates there is o… -
Access log in real timeHello All, We know that there is an access log generated each day in Overview > Activity Reports in Planning. We need the same access log but generated in real time (and… -
can admins delete attachments from dataforms uploaded by other users.Summary: Client admin wants to delete attachments from dataforms uploaded by other users. For instance, if a user left the organization, the admin wants to remove attach…
-
IDR learnings will migrate production to test automatically?Summary: when the Production to test clone is happened, in this process whether IDR learnings also be transferred or not? Content (please ensure you mask any confidentia…
-
Is there anyway to create alternate hierarchy under Years dimension?Hello everyone, I am trying to find a way to create a share hierarchy under the Years dimension, but it seems impossible. Or what steps did I miss? Thanks in advance! -
This page needs access to Oracle's public CDN static.oracle.com.Hello everyone, I am facing a weird thing. When I tried to access the EPBCS instance through Chrome (in normal mode) and it showed the error like this: I tried to clear …
-
Oracle Patch Update- Skip 26.02 and 26.03 UpdateWe got the email from Oracle Cloud saying that "Oracle has decided to not apply the 25.12 (December 2025) and 26.01 (January 2026) updates as well to all environments (t…
-
How to use EPM pipeline copy to Object Storage and copy from Object Storage job typesSummary: Can not use EPM pipeline both copy to Object Storage and copy from Object Storage job types Does anyone sucessfully use these 2 pipeline job types?? Content (pl… -
EPBCS Smartview issues after WebView2 updateWe've started having connection issues with EPBCS after a recent Microsoft update. Curious if any others are having similar issues. It appears to have started around 10/…
-
Is there a way to skip in calculation managerSummary: Content (please ensure you mask any confidential information): I have a business rule that uses a prompt for entity. In the rule I have one calculation to conve… -
How can we copy cell comments and attachments for a large data set?We are trying to copy comments and attachments from one cube to another, smart push is not applicable in our case. Because we want to push comments and attachments with …
-
How to achieve Flexible Hierarchy Selection in Management ReportingHello Community, We have a requirement related to dynamic hierarchy selection in our account reporting structure. Our account hierarchy is structured as follows: AC1000A…
-
We would like to know the Business rules association in EPBCS applicationSummary: We ran the system reports and found that they only display business rule associations related to forms, menus, and tasks. However, some rule associations outsid…
-
Unable to export data from EPBCS to ERP Budgetary ControlSummary: When we try to export data from EPBCS to ERP Budgetary Control, we get an error : ORA-01427: single-row subquery returns more than one row Content (required): W…
-
Data map is clearing data for different cost center in ASO even when CC is passed as parameterSummary: Hello Geniuses, I am facing an issue while running the datamaps using restapi connection. I am modifying the map definition in the job using rest api for cost c…
-
EPM Automate & Multi-Factor Authentication (MFA)Hi Team, We are currently using a custom journal upload template that loads journal data into FCCS and PBCS applications.simple language, in the backend, this template g…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
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…
-
Error: unable to delete the Job as Explainability is associatedSummary: Unable to delete Advanced Prediction model from IPM-Configure Content (please ensure you mask any confidential information): We have created an advanced predict…