Category 101
Discussion List
-
Prior balance (Spanning in years and months)Summary: Content (required): Hi I need to do the following scenario, where i need to get the prior month balance + current month balance. but when it spans over the next… -
Simplified editor: adding shared member special character & is failingSummary: Simplified editor: adding shared member special character & is failing. The error is 'base member specified for shared member could not be located' You can add …
-
Does Critical Patch Update also applicable to Oracle Planning?Summary: Oracle Critical Patch Update is released for Oct 2023 and it includes security patch for Essbase. Is the security patch also applicable to Oracle SAAS products …
-
EPM Automate SkipupdateHi. Question on the skipupdate. Our test was migrated to OCI on the first Friday in October. We are looking to postpone PROD from migrating to OCI on the third Friday in…
-
Auto update of members across ERP and EPBCSSummary: Content (required): Hi Experts, We have defined data integrations to transfer budget data from EPBCS to ERP and actual data from ERP to EPBCS. In ERP COA natura…
-
Import security failed in epbcsSummary: I am able to export security to inbox/outbox folder. But cannot import the same file from inbox/outbox folder Content (required): app_security.csv = exported ap…Naveen_Bonakurthi-Oracle 31 views 6 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning -
Additional fields in data extract from EPMI am trying to export data from EPBCS application using DLR. Would like to know how can I add additional columns in my export file which is not available as a Dimension/…
-
User point of view when transitioning between different cubesHi all, we have two cubes in our Planning application. One cube holds data at the weekly level in the period dimension and the other holds data monthly level(there are n… -
Is there a way to see the last time a report was ran?Summary: I have a large amount of report, and some are no longer being used. I would like to delete the old reports that are no longer being used. Before I can do this, …
-
Prefix data in Data IntegrationKindly advice on how below can be achieved using Data Integration Source is sending us "GL Department" as "4200620". We would like to load this as "_4200620".
-
how to enable SSO in EPMSummary: how to enable SSO in EPM - PBCS Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support…
-
in data exchange how to import mapping accounts that contain a commaI've tried using Excel and text files to import Data Exchange mapping for accounts that contain a comma. Will not import mapping for accounts with a comma, no error mess…
-
clear region in data management issueSummary: Content (required): Hi we defined the clear region in options and tried to export using export mode "REPLACE" method. Clear rule did not execute, i checked the …
-
How to delete only descendant members of a parent in EPBCS using groovy scriptWe have a requirement to delete Purchase requisitions every time we load the transactional data. To achieve this we want to use a groovy Business rule to delete the desc… -
If condition for variables.Summary: Content (required): Hi i have an account with date format where we enter the loan start date. for ex : 1st may 2020. Then i pass the loan fixed rate which user …Lakshani Hettiarachchi 32 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
EPM automate Login Command using OAuth 2.0 refresh tokenSummary: I am trying to login into the planning application using Login command with OAuth 2.0 refreshable token option by running the batch script. Content (required): …
-
Copying data for period rangeSummary: Content (required): Hi I need to copy data for a period range as below. Ex: i have a loan start date : 01-may-2020. and loan end date as 31-apr-2026 (72 no of p…
-
date in calc managerSummary: Content (required): Hi I want to copy a certain to a specific month and year, based on the date entered by user in "loan start date" (MM/DD/YYYY Format) For ex:…
-
What is the best option to force users to enter supporting details for specific accounts?Summary: What is the best option to force/remind users to enter supporting details for specific accounts on a form? Content (required): We have an expense form, we have …
-
How to use RTP in MR ?Summary: Hello , Recently we have a requirement to build a MR keeping the Year Dimension as RTP . However we want use same RTP (Enter Year) for both Current Year : Singl…
-
HSP_NOLINK - Checking if the Dynamic XREF has been sucesfully removed or notSummary: By adding HSP_NOLINK UDA, we delink the automatic Dynamic XREF from source to target cube. In EPM application, can we see somewhere like Smartview or extract if…
-
Create & Import a Snapshot via Groovy Rule (Valid Intersection Automation)I have been trying to find a way to do this as a way to try and automate the creation of valid intersections at a client. Ideally, I am trying to complete the following …
-
Data Management Member Mapping - One Source value to Multiple targets within same dimensionSummary: Content (required): Hi Experts, We have a business process to transfer budget amounts from EPBCS to ERP Fusion. There is a requirement to transfer the same budg…
-
Error with a Groovy codeHello, I am trying to validate the data on Form load event. But getting an error which is not very clear. PLease advice! Error: A method called by the script failed on l…
-
getting multiple emails about account getting locked and unlockedSummary: I am continuously getting emails that as below on my Oracle PBCS user account as locked and unlocked alternatively as below Is this a security hacking email whi…
-
Financial Reporting Web Studio replaced?Summary: Hi all, I recall that I read somewhere that in the future "Financial Reporting Web Studio" will be fully replaced by "Reports". However, currently I'm not able …
-
Groovy - Using getEvaluatedMembers with Shared MembersSummary: I am attempting to generate a custom metadata export file using Groovy to feed into some reporting solutions. We want to be able to generate a clean csv that ha… -
How to disable Launch button when the Template is launched for executionSummary: How to disable Launch button when the Template is launched for execution Content (required): Hi, I have created a template in ASO cube with 2 steps. When I laun…