EPBCS
Discussion List
-
Error using startsWith function in IF condition within FIX ENDFIXHello, I'm trying to put an IF condition within FIX ENDFIX in an EPBCS groovy script. Need to execute the set of statements if a Custom dimension member starts with a pa… -
Is there a way to execute a predefined groovy rule on saving an on-the-fly grid ?Summary: Like how we have the option to "Run After Save" in webforms, is there a way in groovy to run predefined rules upon saving a grid? -
AI capabilities integrated into the EPM applicationSummary: whether the EPM solution offers AI-based tools and features. Are there any AI-based tools that helps and improves the business activities of EPM Applications in…
-
Fix inside if conditionSummary: Content (please ensure you mask any confidential information): Hi I have a rule which takes 10 min to run. Current setup : 16 Entities and Each of these entitie…
-
Data export from PBCS using rest apiIs there a way a user can read and get data from PBCS environment using REST Api but without having admin privilege. Or Any api available which can be used to fetch data…
-
First Year Monthly and remaining Yearly, Quarterly or Monthly based on Entity is not workingWe have enabled First Year Monthly and remaining Yearly for Budget Scenario, but we need Quarterly and Monthly for remaining years based on Entity feature is not working.
-
YearTotal and its children can not aggregate in EPBCSHello everyone, I tried to find out why the YeatTotal can not aggregate, although it is set "dynamic calc" in OFS cube: And Time Balance is Flow. I tried to check the ot… -
Block loss after dense restructureSummary: Dense Restructure from adding a Dense account member and refreshing the database resulting in block loss. Content (please ensure you mask any confidential infor…
-
Is there a way to update the password for the source application configured in Data Exchange?Summary: Is there a way to update the password for the source application configured in Data Exchange? Content (please ensure you mask any confidential information): We …
-
EPM Data Exchange interface to Oracle Autonomous Database bad performanceSummary: We tried to extract EPBCS data (5000 records) to OAW and it takes 15 mins to completed. We found the IMPORT and VALIDATE are pretty quick but stuck in EXPORT. A… -
Groovy script to pass subvariable in DLRSummary: Hi Experts, Im trying to pass subvariable for start period and end period on the Json payload , it shows the method is invalid, it might be an easy one for you …
-
Smart View Automatic Log InContent Hi All, Over the last several months, I've run into an issue where any time I open a Smart View workbook or the Smart View panel, Smart View will attempt to auto… -
EPM Data Exchange interface data to Oracle Autonomous DatabaseSummary: In EPM Data Exchange, we can create Application Type = [Data Export to Oracle Autonomous Database]. With such feature, can we interface EPBCS data to OAW in Dat…Joseph Ip - Oracle-Oracle 11 views 2 comments 0 points Most recent by Joseph Ip - Oracle-Oracle Planning
-
Convert value of SmartList to member to use in cross-dimensional (Non-Groovy)Hello experts, I have an account linked to smartlist where I have "account values" to choose in this smartlist, like this: For each entity (on columns) and dimension flo… -
Delete members using Operation Field in metadata import fileSummary: Content (please ensure you mask any confidential information): Hi All, We have a requirement to delete members in the entity dimension through the operation col…
-
Restore from very old snapshot backup.Summary: We have a requirement where we are expected to keep 3 days back up every month for 3 years for compliance reasons. So in three years time we will have 108 backu…
-
EPBCS time balance property not working on dynamic calc parentHi All, I have a balance sheet account(level0 stored) in OOTB financials module with properties = (Account Type: Asset, Time Balance: Balance, Skip: Missing) From Plan E…
-
Invalid Intersections using dimensions that exist in only one cube cause issues in other cubesWe implemented invalid intersections in our custom Projects cube. This says that specific members in Plan Element (the trending members) cannot be used with specific mem…
-
Data Erased by Hierarchy Change?Summary After adding a roll up to existing members all level 0 data for those members was erasedContent We added 3 new roll ups to our existing Finance and Facilities co… -
In Data Management Create Application Not WorkingSummary: In Data Management I am trying to create a new application with the below settings, but for some reason after I save and it says Registered Successfully, but it…
-
How to print or use substitution variables in Groovy for ASO cubeSummary: I had a requirement where I need to extract data from ASO cube montly, I created Sub Var in ASO cube for period and year trying to call those in groovy but scri…
-
4 Custom BSO Cube in EPBCS?Summary We need to use 4 custom BSO cube in one EPBCS instanceContent We have a question about BSO custom cubes in one EPBCS instance. We need 4 BSO custom cubes and we …
-
Ledger Id Missing When Trying to Write Back ActualsSummary: Getting the following error when when trying to write back actuals to ERP, it is happening on the Import Journals job in ERP. "Warning: Ledger Id can not be emp…
-
Any examples of createEpmColumnCsvWriterSummary: Does anyone have an example of Groovy code using createEpmColumnCsvWriter? Content (please ensure you mask any confidential information): I'm trying to create a…
-
Pipeline Proxy userHello, I am trying to use the pipeline proxy user functionality. I have selected Yes for Enable Pipeline Execution for Non-Admin, added proxy user(Service admin) credent…
-
data management sql parse source valueSummary: Data Management SQL Mapping Help Content (please ensure you mask any confidential information): Looking for way to use sql mapping in Data Management to take th…
-
Syncing Users between HCM and EPM Access ControlSummary: Is it possible to integrate/sync User Security between HCM and EPM? If it's possible, how to achieve it?
-
How to wrap text cell content in an EPBCS formSummary: Is it possible to always wrap the text cells content if the user entered multiple lines? Content (required): In a form, we have text cells that can be used to e… -
No option to upload company Logo using Oracle Redwood Theme background in the latest patchSummary: We are unable to upload a company logo in the latest Cloud Patch update (version 24.04.70) for the Oracle Default Redwood Theme (Green). Can Oracle enable the o…
-
Can ASO be used as a source of Historical data for PBCS predictive planning?Summary: Can ASO be used as a source of Historical data for PBCS predictive planning? Content (please ensure you mask any confidential information): We are getting error…