Category 101
Discussion List
-
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… -
Cannot export YTD Period's data when using data exportHello everyone, I am using PBCS (which does not support Groovy). When we tried to export data from Navigator » Overview » Actions » Export Data to export YTD data: It sh…
-
Plan Type Map in pipelineHello everyone, I am creating pipeline for integration. When I chose EPM Platform job and chose "Plan Type Map" based on Oracle's guidance : My pipeline did not show the…
-
Advise on Member formula for Average of an accountSummary: Hi Team, We have Account 1 = "Number of people" Account 2 = Average of Account 1 We have set Account 1, time balance property = "Balance" Account 2, time balanc…
-
Form 2.0 won't display data in Dashboard 2.0 until you use Scroll Bar?Summary: Form 2.0 behavior in Dashboard 2.0 displays blank when the dashboard is opened. Data does not appear until the scroll bar is moved. This applies to both the vis… -
Form 2.0 "operation is not permitted when navigate without refreshing data is Yes"Summary: Error received when navigating to or clicking on data entry cells in the 2.0 Form version only. This is not an issue in the same 1.0 version of the form. Where …
-
Power user is not able to insert data at Year total in SmartviewSummary: Power User is not able to submit data when opening a form in SmartView. The cells are yellow but on submitting the data and running the business rules attached …
-
Data Integration - Column Headers in Loadrule Definition "undefined" - not possible to set valuesSummary: When setting up loadrules (CSV File Import), we had the requirement to Upload in 5 columns Dec-24 ... Dec-28. We figure out, that a multicolumn upload does not …
-
Data Integrations are Missing in Data ExchangeSummary: Following the recent patch update(25.04.65), we are unable to see any of the existing data integrations in Data Exchange. However, these integrations are still …
-
How to use script in the EPM integration agent?Summary: I need to use Groovy script to integration NetSuite with PBCS. How to trigger it in PBCS? Content (please ensure you mask any confidential information): The EPM…
-
Can we copy the file from AWS S3 bucket to EPM application using the PipelineSummary: We are planning to implement the Pipeline in our EPBCS Application, and in one stage we are planning to copy the file from the AWS S3 bucket to the EPM applicat…
-
What is the fastest way to duplicating and replacing POV more than 100 forms at one timeHello everyone, I am using Oracle PBCS (which does not support Groovy). In the past, when I worked with Hyperion HPM, I could download the form folder and open it in Not…
-
Groovy - Setup Scenario PeriodHello, I have my Groovy script for scenario and year changes, similar to the Planning Financial Module. I have a form with the "run before save" function associated with… -
PLAN: Unable to amend TASK Parameter content when referencing a Business RuleSummary: Content (please ensure you mask any confidential information): Hi all We have notified that when we have a TASK referencing a Business Rule with a Prompt, we ar… -
Issue with Forecast Data Integration Between EPM Planning Project and Project Portfolio ManagementSummary: We are implementing an out-of-the-box (OOTB) EPM Planning solution using the EPM Planning Project module, while our client also utilizes the Oracle Project Port…
-
How to show full qualified member name in ad hoc mode or member selection windowHello everyone, I have one question about how to show the full qualified member name in ad hoc mode or the member selection window. I have an alternate hierarchy for the…
-
Data Management and PBCS - New Integrations between ERP Cloud and PlannningSummary: We have requests to develop metadata integrations between Oracle ERP Cloud and PBCS for Standard. I looked for updated documentation for account integration wit…