Category 101
Discussion List
-
how to trigger data management rule in PCMCS using Groovy in PlanningSummary: how to trigger data management rule in PCMCS using Groovy in Planning Content (required): We have 2 instances, EPBCS and PCMCS, we would like to pull data from … -
Can I use a string in comparison statement?Summary:I just tried to compare value initially but it didnt't reflected, If I place #Missing in the code inside if condition the code gets executed, if I place any valu…
-
After dimension dense setting and creation of business rules, planning screen takes too long to openSummary: After adding business rules screen does not open even after waiting 10 minutes Content (required): Below are the recent changes performed in the system 1.Change…
-
Using MemberName() Text function in Reports Grid formulaSummary: Getting below error when using text function in Grid formula. Error : Grid "Grid1" formula cell J,2 has a syntax error at or after "MemberName" at the character…
-
OCI E-mailHello, Whenever we create a new user in the OCI environment, that user receives an email about this creation. Since we've set up SSO, we'd like to opt out of this submis… -
Exclude SmartList Accounts in a FIX statement possible?Summary: I need to remove zeros from a cube. However many SmartLists need zeros, so want to keep those. Content (required): Is there a way to exclude by DATA TYPE proper… -
Is there a report that will provide me all PBCS users that includes creation date of the user?Summary: I need to provide a report that shows all PBCS users, when their account was created and if there were any modifications to their profile (email, role etc). Con…
-
EPM Essbase: Managing Calculation Permissions for Users and GroupsSummary: Content (required): Does anyone know if the following documentation only applies to PAAS clients? We're a SAAS client using the Oracle Fusion Cloud EPM suite. I…
-
Hello All;During my write_back to the fusion ERP Cloud when I checked the process in the process details and it showed the following: So, what that error means?? besides, when I i…
-
How to exclude an alternative hierarchy with shared children in calc script?Summary: We are trying to exclude an alternative hierarchy in our calc script but using @remove we are unable to achieve this and also Exclude will not work as we are do…
-
Copy data from one member to other members of same dimension (fastest way)Hello experts, I have to copy data from one member to anothers of same dimension and I ask you which is the best and fast way to do it. My requeriment is copy data from … -
issue while Adding validation rule for column with % value in a formSummary: Encountering issue while adding validation rule for column with % values Content (required): Here we are trying to add validation rule for a column in a form, i…
-
ASO Copy data issue. Query size limitationSummary:Copy data within the same ASO to ASO cube errors out with query size limit. Content (required):Hello, ASO data copy errors out with the below error: Internal Err…
-
Ways to Validate level zero members of Hierarchy in a IF StatementSummary: Encountering Issue while validating entire hierarchy in IF Statement. Content (required): Hi All, I wanted to check ,level zero members of Salaries Hierarchy ==…
-
Automate Data Copy with commentsSummary: How to automate a datacopy with comments, supporting details and attachments ? Content (required): Hello everyone, My client is currently on Planning On Prem 11… -
Question: In PBCS, What is the limit to the number BSO cubes allowedSummary: In PBCS, What is the limit to the number BSO cubes allowed Content (required): In PBCS, What is the limit to the number BSO cubes allowed Version (include the v…
-
Scheduled job (business rule) shows "Misfired" - what it means and why?Summary: Scheduled job (business rule) shows "Misfired" - what it means and why? Content (required): Hello All, I have a scheduled job (business ruleset) and it has this… -
Is it possible to restrict users access to alias table?Is it possible to restrict users access to alias table?
-
mapping the Planning pods in OCI to environmentsSummary: Since we received the OCI EPBCS environments, we see that in the Identity Management, under the Oracle Cloud Service, the "Planning" pods are mapped to our Clas…
-
Rounding off issue in ASO MDX ScriptingHi all, I am trying to copy data from BegBalance to months (Jan to Dec) in ASO cube using MDX scripting. Below is the code: When I am executing this script, the value is…
-
Removing or changing storage type of Oracle provided members from OEP_FS(EPBCS)Summary: Removing or changing storage type of Oracle provided members from OEP_FS(EPBCS) Content (required): Is it possible to remove or change the storage properties of…
-
How is the CAPEX Module supposed to workSummary: Looking for user and administrative instructions/videos/best practices for how the "out of the box" CAPEX module in PBCS is supposed to work. Content (required)… -
Export to excel - Workbench dataSummary: Hi Team, I am looking for an easy way to download workbench data for all locations in one go. Currently, we need to manually select location and period in workb…
-
Ability to load metadata from HCM through Data Management using OOTB functionality.Summary: We are able to load metadata from ERP GL using OOTB adapters. Checking for possibilities to load metadata from HCM using similar approach to avoid file-based in…
-
Does Oracle have plan to have Smart Forms be supported for Standard-mode?Summary: Currently, the smartview option is set to Standard, so there is no possibility to use Smart Forms, the client doesn't want to change to Native since it is known…
-
Troubleshooting Error 1060053 when performing Refresh DatabaseSummary: Trying to troubleshoot an issue when refreshing database. The issue exists with our ASO cube only. I suspect the issue is to do with some new members which were…
-
Do not getting the IDCS login screen after activate SSO.Summary: After activate a single sign on in PBCS, we are not able to get login screen for local users (non SSO). Content (required):When navigating to PBCS URL we do not…
-
Extract UDA and Attribute from CURRMEMBERHello experts, I have a requeriment to do. I have 3 dimensions for this process: 1- Account : Account1 (UDA: Red) Account2 (UDA: Yellow) Account3 (UDA: Black) 2- Product…
-
Clear drill through definitions for specific scenarioSummary: We are loading data from data management and have enabled the drill through region in that and it got enabled for all the scenarios. But we don't want to enable…
-
Data Validation and Throw Exception using Groovy Grid IteratorSummary: Groovy DataForm data validation - raise exception and highlight cells which are causing this causing. Content (required): I have quite number of columns on the …