PBCS
Discussion List
-
what is the difference between stop and start database?Hello everyone, I have one question about the stop/start database. I have read the Oracle document about stopping and starting the database: However, I really don't unde… -
PBCS jobs getting stuck at drill through step in DMSummary: PBCS jobs is getting stuck at drill through(Create drill region HPL_DRILL_REGIONS) step in DM and kept on running until we cancelled the job and changed the dri… -
XREF and mdshiftSummary: Hi I have a BSO and ASO architecture in the application, where BSO is used for data consolidation from different applications and ASO is used for aggrgation/rep…
-
Setting up SAML SSO with Azure AD and Oracle EPBCS/PBCSSummary How to guide on setting up Single Sign On with Azure AD for Planning CloudContent Azure Active Directory (AD) is Microsoft’s directory and Identity and Access Ma… -
@XRANGE not work properlyHello everyone, I am using XRANGE function in my rule to calculate the average amount. Under my Period dimension, I have YearTotal hierarchy and YearTotal_Input alternat…
-
Sharing Info: String Compare in Planning - @CalcMgrCompare functionSummary Execute a set of statements based on the Variable/Prompt Value (String Compare)Content Hi All I found something interesting and want to share with all of you. We… -
Mapping attributes in DataManagement using PBCSSummary: Hello experts, I have a doubt with an special mapping that I have to do in PBCS and DM. I have two different PBCS applications: Application1 (Source) has a dime… -
Operational data to EPM PlanningSummary: If we have to source Operational data and forecast demands specific grants, is it possible in EPM? Content (please ensure you mask any confidential information)…
-
Sorting the member Alias names with Alphabetical order in SWP formsSummary: Is there an option to sort members alphabetically based on their alias names when a user opens a form in SWP application? Current Scenario: We have approximatel…
-
How to stop aggregate to the parent for Period dimensionHello everyone, My Period dimension has an alternate hierarchy called "YearTotal_Input", which I shared the members from Jan to Dec under it: However, when I input the d…
-
How to kill every session in PBCSHello everyone, I am facing problem that I cannot refresh the database, and it shows the error: Cube refresh failed with Essbase Cube: CDGInput, Error code: 1013132, Mes…
-
Loading Date via Data Management in PBC ASO cube is not working!Summary Did load the Date to a Account member to a ASO Cube via Data Management, but its not displaying the loaded date even the load is success.Content Did tried to loa… -
Drill through via forms not working - "Drill down query did not return any result"Summary: Drill through via forms is not working - throws error: Drill down query did not return any result. Content (please ensure you mask any confidential information)…
-
What's the layout for DataMap fetching source dataSummary: Content (please ensure you mask any confidential information): Hi, We recently got an issue when executing datamap via smartpush from rules, which errored out d…
-
Setting UDAs in Main Hierarchy, but Filtering on Shared HierarchySummary: Data form contains a POV drop-down which references a section of our Shared alternate hierarchy filtering on a UDA. However, UDA filtering does not work. Conten…
-
PBCS - Migrated Financial Reports to Reports, but no artifacts are displayed in the target folderTested the migration of an existing Financial Report to Reports by using the Migrate Report icon (for a single report). I selected a target folder that was created in th…
-
Trying to list Base members using WITHATTR functionSummary: I am trying to allocate the expense for 2 different projects based on a input project entered by user. Here is my logic. Logic validates fine and it runs withou…
-
Export TDATASEG in cloudSummary: We are performing multiple data loads and earlier in the Datamanagement on primise we can take TDATAGEG table from SQL in case if we want to trace back any issu…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified…
-
The following value is not valid for the runtime promptHello everyone, I am facing with stupid error. I have a ruleset and attached it to the form for running after save. However, when I clicked on the Save button, the runti…
-
CICD process in Oracle EPMHello Community, Our team is looking to implement a CI/CD process for our Oracle EPM Planning Cloud application. Our goal is to automate the deployment of rules, metadat…
-
Data Copy Calc ScriptTrying to run a simple data copy from one account to the other and can't figure out why it's not working the member I am copying from (Monthy Net Charge Offs) is a dynam…
-
EPM PBCS Integration with SnowflakeSummary: Hi Team, We are working on to export EPM PBCS Data to Snowflake System. Is there any direct integration where we can integrate with Snowflake? We have tried wit…
-
I've cloned a EPM Cloud Planning env from Test to Prod. Data Exchange Application artifactsI've cloned a EPM Cloud Planning env from Test to Prod. On EPM Cloud Planning Prod, I'm connecting to a NetSuite ERP Production instance with new Consumer/Token keys and…
-
Load Supporting DetailSummary Load Supporting Detail through text fileContent Hi Everyone, the customer wants to load massivly supporting detail to their budget, so they do not have to do it …
-
Adding a custom dimension to Planning does not show in the Planning Admin extensionSummary: When I add a custom dimension, either through DM or manually, the added dimension does not show in the Planning Admin Extension in Smartview under dimensions. I…
-
Trouble when using Calculate Currency in PBCSHello everyone, I am trying to convert the local currency to the reporting currency in PBCS by using "Calculate Currencies" . Step 1: I input the exchange rate in the sy…
-
How to replace #Missing value in Export Data to blankHello everyone, I am trying to export data from PBCS by using Overview»Actions»Export Data. However, i could not replace #Missing data (default value) to blank for Missi…
-
Newly added Dimension not displaying in the smartview dimension (editor) Planning extensionSummary New Dimension not displaying in smartview to be able to add new members.Content Using a Standard EPM license. Created a Planning application. After application w…
-
Drill-Through From Excel SmartView to Data Management File SetupSummary: Drill-Through From Excel SmartView to Data Management File Setup Content (required): I have a custom ASO cube for vendor expenses (lots of vendors). The source …