EPBCS
Discussion List
-
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…
-
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…
-
How to call a cube level Sub variable in a groovy ruleSummary: How to call a cube level Sub variable in a groovy rule Content (required): I am trying to call a substitution variable CurrYear from groovy rule which is define… -
Form display in web vs SmartViewSummary: Form displays differently in Web vs Smartview Client would like to know why there is extra space to the right of the last column on this form in the web. Conten…
-
renaming entity and cost center membersSummary: Content (required): Hi We need to rename entity code and cost center members - first four digits. (Ex: old code is 503010001 and new code is 803010001) We teste…
-
Can we create valid intersections updated based on project start date and end date using GroovySummary: We have projects where businesses will change the start date and end date on form. As a next step, the system should allow users to input only the periods (Jan …
-
How to take snapshot backups for oracle NRCS applicationSummary: How to take snapshot backups for oracle NRCS application Content (required): We have a use case where we want to archive(the entire snapshot) the existing appli…
-
EPM Automate upload file based on partial file nameSummary: Hi All, With a batch script we are transferring a csv file into the inbox of EPBCS, making use of the EPM automate command "uploadFile". We have used this multi…
-
PBCS Account Structure IssueSummary: In PBCS there is an account: OFS_Short Term Borrowing - Calc to Balance. This account includes prior period retained earnings. Why does this account sit outside…
-
invalid intersection report : red highlighted cellsSummary: Content (required): Hi Any idea why invalid intersection report contains some data in red, and some data in grey. What does the color indicate Version (include …Lakshani Hettiarachchi 32 views 3 comments 0 points Most recent by Naveen_Bonakurthi-Oracle Planning
-
Calc Rule Error for @avgmissingHi Receiving the following error when using @avgrange essbase function in my rule. "LKR_Reporting"=@avgrange(skipboth,@Relative("Input Currencies",0)); Error message is:…