Category 101
Discussion List
-
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 …
-
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…
-
strategic modelling for hotels/hospitality industrySummary: Content (required): Hi We are doing an implementation for hotels industry and currently implementing financials, capital and workforce. further we are checking …
-
Is it possible to invoke rest from a groovy template?Summary: I have done an api call from a groovy business rule and it works fine. If I use the same code within a template, it gives me 403 forbidden error. Is there a lim…
-
Is there any way to obtain Report usage metrics/statistics?Summary: I am being asked to provide usage metrics/statistics for the reports we have built out in our EPBCS application. Content (required): I am being asked to provide…
-
Can we rename the Application name that is showed in Oracle cloud servcies in OCI gen2Summary: Can we rename the Application name that is showed in Oracle cloud servcies in OCI gen2 Example: from Planning-test to xxxx-test Content (required): Version (inc…
-
Drill through regions stop workingSummary: Drill Through Definitions stop working randomly and need to be "refreshed" and I can't figure out why or how to fix this. Content (required):We have defined Dri…
-
How to setup a data form that shows only a certain SmartList member instead of a full listSummary: How to setup a data form that shows only a certain SmartList member instead of a full list Content (required): For employee type, we are using a SmartList, whic…Naveen_Bonakurthi-Oracle 41 views 3 comments 0 points Most recent by Kyle Goodfriend-Oracle Planning -
amortisation schedule scriptSummary: Content (required): Hi I'm trying to build a loan amortization schedule in OEP_FS, with opening balance, repayments, interest and closing balance. Does anyone h…
-
Details on file extracted by BIP reports in UCM pathSummary: Content (required): We have DM integrations to load data from Oracle Fusion and HCM systems to EPBCS using BIP reports. The output of BIP reports is saved in UC…