PBCS
Discussion List
-
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…
-
Account in @REMOVE is being ClearedSummary: Content (please ensure you mask any confidential information): I use the below business rule to clear expense accounts before loading a new employee roster and …
-
Shared Account Dimensional Member 445 Properties IssueProblem with setting an account flag to '445' for distributing the entered value. In the system there is a 'never shared' type account which does not have the flag set t…
-
SmartView Grid not Displaying Data when Copying a Sheet or POV to new tabHello Everyone - I am noticing an issue with SmartView when copying an ad-hoc query or POV to a new excel tab. It appears I can connect to the DB, but no data is returne…
-
[OCI]I want to know how to grant role privileges in bulk.Summary: I want to know how to grant role privileges in bulk. Content (please ensure you mask any confidential information): I understand how to grant role privileges to…
-
User Preferences retrieval using Rest API (uservariablevalues)Summary: I am using the following REST Resource to retrieve user variable values set for all users and all user variables: GET /HyperionPlanning/rest/{api_version}/appli…