EPBCS
Discussion List
-
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… -
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… -
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…
-
50k to 100k Members required in Task/Phases Dimension in EPBCS Projects ModuleSummary: Need to assess the performance impact on the Projects cube in EPBCS for having 50,000-100,000 members in the Task / Phases dimension. Content (required): The cu…
-
Is there a member cell information equivalent in Smartview VBA for EPBCS Planning connections?We recently implemented EPBCS and for one application we shifted from an ASO Essbase application to an EPBCS Planning ASO Plan Type. In Smartview with Essbase connection…
-
Is there a way to send automated email when the data load rule gets completed?Summary: I want to send an automated email with the process log attached to the users which informs whether the data load rules finished successfully or it failed. Conte… -
User Unable to Update Project ExpenseSummary: Planning>Project>Expense Content (required): How to grant User access to update the Project cost under expense? Version (include the version you are using, if a…
-
How to put a multiline message body in a epmautomate sendmail command?Summary: How to put a multiline message body in a epmautomate sendmail command? Content (required): Version (include the version you are using, if applicable): Code Snip…
-
Does adding cell comments on multiple cells work only on a single column at a time in Smart View?The Smart View feature of adding cell comments on a range of cells works only if the range lies in the same column. Is this an expected behavior. Also, deleting cell com… -
Change alias on the sender email IDContent Currently, when scheduled reports are received, they come from planning-test-[zone name] . Is it possible to change the alias (planning-test-[zone name]) to some…
-
Planning inbox/outbox explorer files in Snapshot?Summary: Planning inbox/outbox explorer files in Snapshot? Content (required): I do not see any files retained in the snapshot that are from the inbox/outbox explorer. A… -
How do I protect excel formulas in smartforms business calculationsSummary: I have smartforms that the department or location manager open to input for their budgets and forecasts. We use business calculations becuase the end users can …
-
Flex form open as a regular form in Smart View giveserror "Planning provider error" after SubmitDataSummary: It started yesterday and the number of users who are seeing the issue is growing and it happens to me too, but not to all users. Steps to reproduce: 1 - Open a … -
NEXTSIBLING in fix using Period dimensionHello experts, I have a question about NEXTSIBLING using in FIX. I would like to see FIX("FY23", @MEMBER(@NEXTSIBLING("ClosedMonth")):"Dec","E01") Mycode... ENDFIX My pe… -
Creating a database connection in Reporting Studio in EPBCSContent Hi, We tried to create a database connection in reporting studio in EPBCS. Navigation = Reporting > Explore Repository > Explore > Tools > Database Connection Ma…
-
Smart View - Submit Zero'sToday we were testing out submitting data in Smart View and even with the "Submit Zero" setting unchecked, 0's were still being submitted to the application. I thought h… -
Incremental data load not able to detect delta if last run is failedI have encountered an problem incremental data load in PBCS. Let's say there is a failure due to some missing mappings during an incremental data load and assume it's pr…
-
Error in parsing JSON Payload - Cannot index into a null array.Summary: An error occurred during the API request: {"links":[],"status":4,"details":"EPMFDM-ERROR: Error in parsing JSON Payload"} Cannot index into a null array. + $uri…
-
Convoluted Access in EPBCS 'User Group' AccessSummary: User's access is convoluted when being added to the 2 groups. Content (required): Hello Oracle, Can you please assist or give any suggestion on how we can resol…