EPBCS
Discussion List
-
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 20 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…
-
Allow multiple selections to display on form Rows?Hi, we use a User Variable called "ProductSelector" to allow the user to make a selection from high up the hierarchy, and then in the Rows on the from we specify ILvl0De… -
Optimizing Allocate RuleHello experts, I have a doubt with a calc script doing an allocation. Type my code and explain if is possible optimize this code: FIX (&Act_Year,"Actual","EUR",@RELATIVE…
-
Uniform Budget Hospitality industrySummary: Content (please ensure you mask any confidential information): Hi Im having a client who is in hospitality industry. and he would like to know how certain types…
-
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
SmartView formulas cells are blank when i refreshHi Please help to resolve this below issue SmartView formulas cells are blank when i refresh the sheet SmartView formulas cells are blank when i refresh Blank Version Se…
-
How to display top n customers by revenue in data forms in planning cloudSummary: How to display Top n customers in data forms in Planning Cloud by Net Revenue or Gross Revenue. Customer is a dimension. Content (please ensure you mask any con…
-
How to display an arraylist in popup using groovy scriptSummary: Display an array list in popup using groovy script Content (please ensure you mask any confidential information): Hello guys In a data form i'm entering startda…
-
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…
-
Custom ML Models accepted in ESG/EPBCS applicationsDear Experts, I'm trying to create a custom ML model using Python and/or R for a ESG demo application. I have no problem implementing models such as "linear regression",…