EPBCS
Discussion List
-
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 31 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning -
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:…
-
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…
-
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…
-
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 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 M. 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…Lakshani Hettiarachchi 11 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Reduce cube size by creating views within ScenariosSummary: I want to know if a capability exists that would keep cube sizes smaller by reducing redundant data Content (required): My client has many scenarios that are co… -
Extract Users and List of Groups through REST APISummary: Hi All, Hope you are doing well. We have requirement to extract list of Users, Groups using REST API in PBCS application. I am trying multiple options , "User A…
-
Forms Design on how to include a series of Metadata members of CC dimensionSummary: The Cost Center hierarchy has nearly 54k members and to display the centers in the form wherever there's Trial Balance data for expense accounts is not renderin…
-
Data Load Workbench - No Data to displaySummary: I am receiving a "No data to display." message in the Data Load Workbench in Oracle PBCS. I have checked and have admin rights over the site and my POV looks to…
-
Custom Time Balance PropertySummary: Hello Experts, Could you please suggest best way to apply custom Time Balance Property for a member from account dim? This means, account member when retrieved …
-
List of ready formulas for EPBCSSummary: Is there a basic guide on a list of formulas which I need to write in EPBCS (Planning) for the calculation of actuals, budgets and forecasts as well as the aggr… -
Issues with PipelinesSummary: I am experimenting with Pipelines to replace some manual processes around loading employee metadata/data and running into issues with the Pipeline editor. Conte…
-
How to integrate data trial balance fusion to PBCS Form with data exchange?Summary: How to pull data trial balance fusion to PBCS as actual data form? Content (required): Hi, Could you give me reference doc or guidance to pull data trial balanc…
-
Is it possible to filter rows in a form based on smart list data like permanent and contractorsSummary: Is it possible to filter rows based on smart list data like permanents and contractors? Content (required): Needs to show rows where smart list data has contrac… -
Hybrid Cube conversion: The number of rules added exceeded threshold limit (300 + rules)Summary: Converting existing EPBCS application to Hybrid cube. While conversion, getting below error, how do we fix this? The number of rules added exceeded threshold. E…
-
Can you use HypCreateConnectionEx() to see forms in a EPBCS app private connection?Summary: In Smartview 11.1.2.5.900 and Planning 11.1.2.5 we could use the HypCreateConnectionEx() function to create a Planning app private connection. In that Planning …
-
Web Reports or Narrative reportingHello Community - we are currently on PBCS for budgeting and forecasting for P&L. Business are using custom report on excel which uses excel add in and get essbase value…
-
Read EPBCS audit log using Groovy directly.Summary: I have a requirement to get last action of planning unit (approval status) for a specific entity. Is there a way to access the audit log directly using groovy (…
-
EPMFDM-ERROR: Error in parsing JSON PayloadSummary: DATA Integration through RESI API using Groovy script. Content (required): How to pass multiple entities in source Filter Admin guide link https://docs.oracle.c…