PBCS
Discussion List
-
Dimension order best practiceHello everyone, I am trying to optimize the system's performance. Now, my cube has 12 dimensions and dimension order as below: When I refreshed database for my applicati… -
Cell level security did not work properlyHello everyone, I created a cell-level security to prevent service admin & power users and users from inputting for OFS_Calculated. However, when I opened the ad hoc, I …
-
DATACOPY did not work with @MEMBERHello everyone, I am trying to use DATACOPY to copy from the prior year to the current year. DATACOPY "****"->"OEP_Actual"->Final->@MEMBER(@PREVSIBLING(&CurrYr))->"Total…
-
EPM Rulescript - DataCopy FunctionHello, I have a rulescript that copies a version to another version for our Budgeting Process which first sits in "Department Requested" tab and changes the status of th… -
Smart Push limitationDear everyone, I have one question about Smart Push. I am trying to use smart push on form and run it after Save. However, when I checked the jobs, it showed the error: …
-
Account Locked for Editing only in OEP_FSHi we recently added a new account (510725) and it is locked for input in our BSO OEP_FS cube. See the screenshot below, the other accounts are its siblings and we are a…
-
@COUNT WITH SKIPNONE AND @XRANGE unexpected behaviourHello everyone, I am using the @COUNT to calculate the count for the number of months from Jun-FY22 to Sep-F23 : OFS_Calculated= @COUNT(skipnone, @XRANGE( FY22->Jun,FY23…
-
How to do a Top Down Forecast in Bottom Up AppSummary: Content (required): We currently have all our forecasting as bottom up. I was recently asked to do out years at a high level account and entity rollups. What is… -
Zoom In Bottom Level Freezes ExcelSummary: Content (please ensure you mask any confidential information): In our relationship dimension, we have approximately 7518 members. They are currently organized i…
-
Unable to run a ruleset from RulesSummary: Content (please ensure you mask any confidential information): I'm trying to run a ruleset from Rules in the Tools section of Navigator (screenshot 1 below). Ho…
-
Non-Groovy: Transfer of Member into Smart Lists created from MembersHello everyone, I have a smart list called TransactionCompany created by @ILvl0Descendants(TransactionCompany) member. And I have a dimension called "Company". Now, I wa…
-
Notification about "Security Policy for OCI Console"Summary: Content (please ensure you mask any confidential information): Last month, the CFO of my company received an email about "Security Policy for OCI Console". He s…
-
Using PBCS Cloud, how to use the REST API to Get the attachment after executing a jobSummary: Using PBCS Cloud, how to use the REST API to Get the attachment after executing a job from Application > Overview > Export Data. I see the job execution & can m…
-
pipeline from groovySummary: Is there any way to call pipeline from groovy apart from REST API? Content (please ensure you mask any confidential information): Version (include the version y…
-
Is there any way to expand the current limitation in Reports for only sending emails up to 10 MB?Summary: In Reports, when executing a bursting definition there is a size restriction of only 10 MB. Is there any way this can be expanded? Content (please ensure you ma…
-
SET CREATEBLOCKONEQ does not open the blockHello everyone, I wrote a business rule with SET CREATEBLOCKONEQ to open the block. But it showed strange behavior. I fix from FY25 to FY28, BUT it did not open the bloc…
-
ESSG_ERR_Operationfailed error after clicking on save in data formSummary: We are getting the ESSG_ERR_OPERATIONFAILED error after clicking on the save button of the form. There is no information available in error to know what is caus…
-
ASO Clear data at Parent LevelSummary: In BSO we have a rule to clear some Account level 0 members data at Period parent member level [All Yrs], while the Period level 0 members [FY25], [FY26] etc… k…
-
What is "Include BegBal as Time Period" in Scenario dimension properties?Hello everyone, I am using PBCS and have one question about "Include BegBal as Time Period" under Scenario dimension properties: Is there any document to explain this pr…
-
ASO Time Balance aggregation not as expectedSummary: In BSO cube, there is accounts aggregated value based on time balance = First, Skip Value = Missing by having Period dimension member [Jan] rollup to [Q1] and t…
-
Delete members/shared memebers using Operation Field in metadata import fileHi all , We are using PBCS version 25.01.31. We are trying to delete members in the entity dimension through the operation column "Delete Level 0/Delete Descendants" com…
-
Calculation for Employee that Terms Mid-MonthSummary: In our Workforce cube/module, is it possible to calculate partial month data for an employee that terms mid-month Content (please ensure you mask any confidenti…
-
cube refresh in pipelineTrying to create a Cube Refresh job in the Pipeline but facing below error 2024-04-02 11:29:36,906 INFO [AIF]: Process ID : 296 2024-04-02 11:29:36,906 INFO [AIF]: Job N…
-
What is the best practice for removing old employees workforce without losing the data?Summary: Content (please ensure you mask any confidential information): I am looking for a good way to remove old employees from workforce so that we don't keep growing …
-
Epm agent Integration for Oracle JD Edwars and Oracle PBCSSummary: Integration data Content (please ensure you mask any confidential information): I need to integrate pbcs standard release 25.01.31 with jde release 9.2.7.3 and …
-
Dynamic Member formula not working in Hybrid BSOSummary: Dynamic Member formula not working in Hybrid BSO. Content (please ensure you mask any confidential information): Hi, I have added a member formula for a retaine…
-
Smart View for Google SheetsSummary: Content (please ensure you mask any confidential information): Is there any impact to turning on the Smart View for Google Sheets option? How different is it to…
-
info about calculation manger related to latest feb release.with February release the web interface of Oracle will change a lot! in particular Calculation Manager is accessible from “rule” tab. From our knowledge users should not…
-
Update Resource Class Dimension Members Parent via GroovySummary: I am looking into the best way to update Resource Class member's Parent value via a groovy script. The reason would be to move from an ACTIVE parent to an INACT…
-
How to create a group at onceSummary: I want to know how to create a group at once Content (please ensure you mask any confidential information): I have too many groups to create, so I would like to…