Category 101
Discussion List
-
Free Virtual Workshop: Introducing Environmental, Social and Governance (ESG) Reporting (3.5 Hr)We are pleased to announce Free Live Virtual Workshops on Cloud EPM for Environmental, Social and Governance (ESG) that include earning CPE Credits facilitated by our va…Al Marciante-Oracle 313 views 1 comment 5 points Most recent by Harish Kumar C Enterprise Performance Management Resource Center -
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… -
groovy rule to track changed data to get entities loaded via data management in FCCSSummary: Requirement: We are currently looking to optimize our data load process and are looking for a way to track which entities have actually loaded to the applicatio…Amarnath_Kothapalli 21 views 3 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
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…
-
Get form Ids of a Eloqua formSummary: We are integrating Adobe Experience Cloud(AEM) with Eloqua. This integration requires form Id and form field Ids for form created in Eloqua to map them in AEM. …
-
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 …
-
Approval Unit Hierarchy overrides Data form level securitySummary: Approval Unit Hierarchy overrides Data form level Read access security Content (please ensure you mask any confidential information): Hi Team, We are facing one…DISHIL SHAH 31 views 6 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
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…
-
Looking for a way to use Azure service principal for connecting to EPMSummary: Hi, Looking for a way to use the Oracle EPM API through azure service principal instead of service account for authentication purpose? Found the below blog but …Tushant Pandey 1 view 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform
-
How to update Contact data with CDO data in EloquaHi all, I have a scenario where data is being imported from SFDC into a Custom Data Object (CDO) in Eloqua. My goal is to push this CDO data into a form submission. Sinc…
-
Text data on a formula row in Data FormsSummary: There is a Text appearing in a cell on a Formula Row in a Data Form, that I don't know where it is coming from. Content (please ensure you mask any confidential…Ilse De Vries 172 views 41 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 …
-
calculating YTD from MTD dataHi, As the data is loaded in MTD values I want to calculate the YTD value for the Balance Sheet accounts in EPM Planning. The dynamic time series only considers the curr…
-
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 : https://docs.oracle.com/en/c…
-
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…
-
Sales Revenue Workflow:Unable to Restrict Email Alerts by Opportunity Business UnitSummary: We are configuring an email notification workflow in Application Composer under the Opportunity Revenue object. The goal is to send email alerts only when Reven…
-
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 …
-
Being logged out of EPM when using Nav flows with ReportsWithin the context of EPM Planning Navigation Flows, if we navigate away from a tab with a Report in it, we are being logged out of EPM. I have tested this in the test e…
-
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…