Category 101
Discussion List
-
Unable to delete Redundant Period mappings in Data ExchangeHi Team, We have some redundant period mappings which we create previously but not useful as we changed the period mapping naming convention and have potential once. We … -
Navigation to extract metadata for certain entities for EPM ODAHi, Can anyone help with the navigation to extract metadata for following entities for EPM ODA Configuration? JOB_NAME DIM_MEMBER FCM_REPORT_GROUP_NAMES FCM_REPORT_NAMES…Ankit_Bhadja 23 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform -
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…
-
Upload file from EPBCS inbox to files.com via REST API through groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Panning Application type/subscription typeI need to know the type of my Planning application/subscription, 1) is it legacy or standard or enterprise? 2) what is the difference between legacy and standard and Ent…
-
In Forms 2.0, member formula and a drop down exist on first data row ErrorSummary: I have a form that contains a formula and has drop down capability (Line 1 shown below). The Request Source/Request Cost Center/Request Account - UO and Initiat… -
Form Not Exporting to Excel or SmartviewSummary: Has anyone had where you click "Spreadsheet Export" and a form doesn't export? When I try to "Open In Smartview" I get the below error as well. Our other forms …
-
Cloned member formulas missing quotesSummary: We have cloned an application from Prod to Test (they are both on the same version (25.04.65)). We get an errorsupon refresh (e.g., Error[1370388]: at line 3636…
-
Restructure removing more blocks than expectedSummary: We have a lot of business rules that use data copies or CREATEMISSINGBLK ON in order to ensure that blocks exist where they need to. In these rules, after perfo…Sabrina Greensea-166456 42 views 4 comments 0 points Most recent by Sabrina Greensea-166456 Planning
-
Data Exchange - Extract data from one environment to another environment directlyContent (please ensure you mask any confidential information): Good morning everyone, I created my Data Rule in the Data Integration to extract data from one environment… -
Ruleset and RulesSummary: Content (please ensure you mask any confidential information): Hi Probably a stupid question. When a rule is deployed in multiple rulesets, once I updated the r…
-
traverse period hierarchy in reverseHi Team in EPM CLOUD business rules, How to traverse period dimension in reverse order. i.e. first the rule should run for &curActMth (say APR), then followed by MAR, th…
-
Is there a way in Groovy to throw an error based on certain validations and close the prompt screen?Summary: Hi Experts, Is there a way in Groovy to throw an error based on certain validations and close the prompt screen? In my current application, I am using throwVeto…
-
Use OAUTH for EPM GEN2 Rest APIs in OICSummary: Currently we are in EPM GEN2 and using basic authentication for EPM Rest apis in OIC. Customer wants to use oauth for the rest apis. I went through below docume…
-
Is there a way to allow member selection in SmartView form?Summary: Is it possible to enable "member selection" in a dimension in the page section of a form in SmartView like it is enabled in the web in the same form? Content (p…
-
Random values for Smart List memberSummary: Random Values (looks like garbage values) are gettting displayed in webform for the Smartlist Account Member Content (please ensure you mask any confidential in…
-
Using new Reports, how can you create with a prompt and also POV?In the old Financial Reporting, you could create a way to select a member via a Prompt and have it show up in the POV returning the selected dimension member, and then c… -
how to change filter of data load ruleSummary:Is it possible to change the filter members selected into a data load rule (integration), either with a groovy, or a pipeline method, or a rule,…? Right now, we …
-
EPBCS : API call to Run Rule not fetching parametersWe have two Rules. Groovy_Rule1 should run on form save. Should pick Run time prompts and pass it to API call which will call Groovy_Rule2 to run a Data Map. Issue: For …
-
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… -
data integration using xml fileHi Team, I have received a requirement , to build integration with XML, upstream team will place the file in EPBCS DM inbox, i need to build an integration using XML fil…
-
Using substitution variables in source filters in DLR in data managementSummary: Content (please ensure you mask any confidential information): Hi All, We are extracting forecast data from our planning application on a daily basis and sendin…
-
Invalid IntersectionSummary: Content (please ensure you mask any confidential information): Hi I want the Last Column : SAP Master Report —all rows to be valid. These rows could be getting …
-
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…
-
EPBCS to Netsuite integration via NSPB SYNC. How to set a specific period and year as criteria?We are pulling Netsuite actuals into EPBCS using income statement transactions savedsearch and NSPB SYNC. NSPB SYNC set up different criteria options for postingperiod f…
-
How do you favorite webforms to show on the EPBCS Home Page?We are looking for a way to allow users to favorite webforms in EPBCS so that these forms appear on their home page for quick access. We found that dashboards can be add… -
Auditing of Users Running Financial Reports/Management Reports in Oracle EPM Cloud PlanningOur institution is seeking a way to retrieve how often our users run Financial Reports and/or (Management) Reports and the names. We understand that there is an Activity…
-
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 …
-
Push Sparse Dynamic Calc BSO data to store member in ASOSummary: I have a member formula in Plan Element to calculate for % Sales. This member in Plan Element is a Dynamic Calc. I want to push the data to a store member in AS…
-
Hybrid mode calcs, FRMLBOTTOMUP, and NONEMPTYTUPLEThis isn't really a question, more of a PSA! I found a unique relationship between Hybrid mode in calc scripts, FRMLBOTTOMUP, and NONEMPTYTUPLE when working with complex…