EPBCS
Discussion List
-
"Unknown Member used in query" error in Data Load RuleSummary: I am updating the Source Filter in an EPBCS data load rule, changing the spec for Accounts, but even using the member selector to ensure correct spelling, I am … -
Dynamic Custom Business Rule to select the number of months for each scenarioSummary: I need to develop the custom business rule in EPM Planning so that user can set the number of months for Actual,Forecast and Budge Scenario for calculation. The…
-
Connect with Snowflake from PBCS applicationI am trying to connect Oracle EPM agent to Snowflake database to source the data from cloud Snowflake DB and load it in PBCS DB. Has anyone done ir?
-
Retrieve member alias for my DataExport File through DataManagementSummary Retrieve member alias for my DataExport File through DataManagementContent Hey all, I need to export on my data export to file, via Data Management, the member a…
-
Is there any possibility to retain Audit history data for two years in EPBCS?In Current EPBCS Audit, Maximum of 180 days audit data is only present. Can we increase this to One or Two years? Through EPM Automate command we see data can be exporte… -
Writing Back Budget from EPBCS To Fusion Budgetary Control and GLSummary: Content (required): Hi All, We are integrating budget data from EPBCS to Fusion ERP. Also we have a requirement to have the balances in both Budgetary Control a…
-
What Happens if a dimension hierarchy type is not set in an ASO cube?Summary: What happens if a dimension's hierarchy type is not set? Does the hierarchy type just default to "Stored"? Content (required): I recently set up an ASO cube for… -
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
Automate file transfer from SFTP to ePBCS using copyfromsftpI am trying to use copyfromsftp in groovy business rule, rule is working successful but file is not getting copied from sftp to data management inbox. Need help .
-
Passing file name while using rest API to run data load ruleSummary: I am running the data load rule using rest API functionality but while giving the file path it is giving an error mentioning "File or directory does not exist" … -
Using Multiple Monthly calendar in a EPBCS applicationSummary: How to make use of multiple calendar in a EPBCS Application Content (required): Hello All, We would like to know is it possible to make use of multiple calendar…
-
HOW TO ADD PRE-DEFINED Substitution Variables TO ALL CUBEHello, I am currently using EPBCS. When checking the demo server, I noticed that the pre-defined variable (OEP_CurMnth) is registered for all cubes. How can I register i…
-
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any… -
Multi-period multi-column data load using BIPI want to load multi-column multi-period data from the BIP report, in the report, the headers are like BUCKET_AMOUNT7 BUCKET_AMOUNT8 BUCKET_AMOUNT9 BUCKET_AMOUNT10 BUCKE…Rimjhim Gupta-Oracle 62 views 4 comments 0 points Most recent by Rimjhim Gupta-Oracle EPM Platform and Freeform
-
Drill through to source fusion ERPSummary: Facing error "Drill query does not return any data. Data was not loaded to this intersection using Data Integration. For more information view the detail log. D…
-
Can we have a member with Dynamic Calc in one cube and Never share in another cubeSummary: We would like to confirm whether it is feasible to have a member defined as Dynamic Calc in one cube and Never Share in another cube, while using the same hiera…
-
Can not run groovy rule when attach rule to DashboardHello everyone, I have a dashboard. And now i want to attach the business rule (Groovy scrtipt) to this dashboard with the set up below: But the rule is groovy script. S… -
Share access to the Oracle Cloud Earned Value Management demo environmentSummary: Hello, Could someone please share access to the Oracle Cloud Earned Value Management demo environment with me? Thank you! Content (please ensure you mask any co… -
How to split EPM Financial Reporting (Reporting) AliaseName using Delimiter featureSummary: Hi, we have specific requirement where MemberAlias Name to be split based on Delimiter in EPM Financial Reports (Reporting). Ex: PRODUCT Alias Name 1233444 1233…
-
Pipeline setup for Copy to SFTPSummary: Content (please ensure you mask any confidential information): Hi, Can anyone provide some guidance on how to setup the Copy to SFTP with pipeline? While readin…
-
Creating Schedule from Task Manager Template using REST APII am trying to create a schedule from template using REST API. I have enabled "Integration Name" override parameter for "Run Data Integration" task type. Is it possible …
-
Import Security Roles/Groups assignments using EPMAutomateSummary: Hi, I am trying to import both User Roles and User Groups assignments exported using the commands "roleAssignmentReport" and "userGroupReport" but I dont find a…
-
Task Manager: Passing Schedule Period and Year as Task Parameters for custom user taskSummary: We have user tasks pointing to reports which are driven by "Substitution Variables" i.e., &ActMonth=Dec and &ActYr=FY25, Currently Trying to drive these instead…
-
ASO Dynamic Calc Children (Member Formulas) Not Rolling Up to Dynamic Calc ParentSummary: We have an issue where dynamic calc children that have member formulas (red highlighted below) are not rolling up to a dynamic calc parent (yellow highlighted b…
-
EPBCS - Multi dependent smart list selectionsSummary: i have 2 members linked to 2 different smart lists, how to make if i choose certain selection in member 1 then member 2 will show certain selections within smar…
-
Predictive Cash Advanced Predictions Failing Data TransformationSummary: I am using Advance Predictions and getting errors on a simple setup. I am trying to use two banks as our driver and put the prediction into the OEP_Any Bank in …
-
How can I see the attribute dimension in ad hoc ?Hello everyone, I am using SmartView ad hoc to create members. I have 2 attribute dimensions is "Program" and "Programa": However, when using member selection to choose …
-
Restructure cube in pipelineHello experts, I'm configuring a pipeline at the end of diferent stages, I want to setup a Restructure cube task, I tried to create a EPM Platform Job and previously I h… -
Can Groovy script produce Business Rule logs?Summary: When we run a Business Rule in could EPM, the job console does not show the log as it would when run on prem. Is it possible to generate essbase-like calculatio…
-
Is it possible to merge one of the dimensions found in the columns of EPM PBCS forms?Summary: I am trying to create a dashboard where customer need a comparison of different scenarios month-wise. Content (please ensure you mask any confidential informati…