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
-
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 …
-
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… -
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 …
-
Smarview Private connection URLs to be clearedSummary: In the process of testing different applications and enviornment, a number of URLs have been added to the smartview prviate connection. Now, I have a problem in…
-
EPM Automate - EPMAT-7 Unable to connect - Unsupported protocol: httpsSummary Error thrown when running EPM Automate login commandContent I have previously connected, but now when I try to run to log into the PBCS server through EPM automa…
-
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 …
-
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…
-
Smart View Submitting Zero Instead of Missing into ASOSummary: Need to clear an ASO cell (submit missing) via smart view ad hoc - presently is submitting zero Content (required): With a smart view ad hoc, we are submitting … -
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…
-
Unable to create table of content in planning reportsSummary: In EPBCS planning reports are available, unable to create Table or Content that we can easily be able to create in previous version. Content (required): Version…
-
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 …
-
Period starting from Jul through Jun spanning over two yearsWe are implementing an environment that has a fiscal year that starts in Jul and ends in Jun. Is the implementation done correctly for this situation in this system? Our…