EPBCS
Discussion List
-
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…
-
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/…
-
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".
-
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
-
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 43 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 12 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…