To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Planning
Discussion List
-
custom business rule not yielding expected resultsSummary: I am trying to write a simple business rule to take many discontinued entity balances and add them up and store them in a single new entity. The rule I wrote is… -
integrating HCM cloud with EPM cloudHi All We are trying to integrate HCM cloud with EPM cloud. For doing that, we need to import EPM extracts / formats/metadata into HCM cloud as HCM extracts. As per belo… -
DELETEDThis thread is deleted -
EPM Login issue: There is a problem with your account. Please contact SupportSummary: Did anyone had this issue before? What did you do to resolve it? We have few users who are having issue in logging in to our EPM Cloud Planning. We are using SS…
-
Writing Back Budget from EPBCS To Fusion Budgetary Control and GLSummary: Content (required): Hi All, We are integrating budget data from EPBCS to Fusion ERP. Also we have a requirement to have the balances in both Budgetary Control a…
-
What Happens if a dimension hierarchy type is not set in an ASO cube?Summary: What happens if a dimension's hierarchy type is not set? Does the hierarchy type just default to "Stored"? Content (required): I recently set up an ASO cube for… -
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
Oracle OOTB Finance Driver based PlanningSummary: Hi Experts, I have a scenario where my customer wants to understand if there could be any performance issues when using Oracle’s out‑of‑the‑box Finance and Plan…
-
Automate file transfer from SFTP to ePBCS using copyfromsftpI am trying to use copyfromsftp in groovy business rule, rule is working successful but file is not getting copied from sftp to data management inbox. Need help .
-
Passing file name while using rest API to run data load ruleSummary: I am running the data load rule using rest API functionality but while giving the file path it is giving an error mentioning "File or directory does not exist" … -
How to bold “Total” row and sort in descending order in Table chart (Planning Dashboard)?Hi Experts, I am working on a Planning application (Oracle Cloud EPM) and building dashboards using the Table chart component. I have the following requirements: Bold th… -
Groovy to identify deltas in edited cells in a formSummary: I'm new to Groovy and in one implementation of Planning I need to create a rule that can identify not only which cells were modified, but what was the "delta" o… -
Configure Source Connection Error: TEST ok. PROD errorSummary: HI, I am trying to configure a connection with oracle erp cloud. When I configure using test erp. I am able to make connection. When I configure using prod erp.… -
Download file from Inbox/Outbox explorer via Rest APISummary: Download file from Inbox/Outbox explorer via Rest API Content (please ensure you mask any confidential information): Hi, I am trying to download a file from Inb…
-
multiple monthly calendarhow to handle multiple calendars for different products in one PLANNNIG Application? some users want to use JAn-Dec, few want to use OCt- Sep. is it possible to use? IF …
-
Using Multiple Monthly calendar in a EPBCS applicationSummary: How to make use of multiple calendar in a EPBCS Application Content (required): Hello All, We would like to know is it possible to make use of multiple calendar…
-
Can we capture warning status in EPM Automate as response while executing runDataRule command.Summary: Hi All, Can we capture warning status in EPM Automate as response while executing runDataRule command or is there any way to capture the warning status in integ…
-
Excel Groovy ParserSummary: This code is to read an excel file in EPM Groovy. The LXP (Lite eXcel Parser) is designed to parse .xlsx files natively. It functions by unzipping the Excel fil…
-
Mass Delegation in Workflow in Planning EPBCSSummary: There are over 450 workflow delegations that need to be performed. At present, delegations must be completed individually, which is extremely time-consuming and…
-
HOW TO ADD PRE-DEFINED Substitution Variables TO ALL CUBEHello, I am currently using EPBCS. When checking the demo server, I noticed that the pre-defined variable (OEP_CurMnth) is registered for all cubes. How can I register i…
-
Download File to a directory from Planning via API / EPMAutomate / GroovySummary: I need to download a file from Inbox/outbox Explorer to the address I want. Content (required): Hello All, Today we can download a file from Planning via EPMAut… -
Oracle EPM to ERP Integration - getting 401 errorSummary: I am configuring Oracle EPM to ERP integration and setting up source connection. When I test the connection, i receive "Unable to connect to source system Oracl…
-
REST API for Direct Data Read/Write in EPMDear All, We would appreciate your guidance on whether EPM provides a supported REST API to Read and Write data directly , without relying on Data Management or file imp…
-
Book Prompt Member AliasSummary: Hello, I created a Book within Planning that is the combination of two reports in Planning. Both reports have a Prompt for a specific Dimension and both are cur…
-
How to load multiple periods into beg balance in EPCMSummary: In order to have a calculated driver work in EPCM I need to add my Prior Years Year Total with the BegBalance from the prior year. We had initially loaded the d…
-
Groovy String Issue In Calc Script IFSummary: Running into an issue where we are trying to @SHIFT values based on an average receipt date. In the Working image below the @SHIFT is working and moving the val…
-
Oracle EPM Data exchange, Ignoring all the data in mappings but the job failsSummary: Hello, In EPM data exchange, I see that the job fails if all the data are ignored as per the mappings, Is there a way it could give a warning or make it sucessf…
-
Attribute dimension update using groovySummary: I am looking for a solution to update non-HR positions added by a Planner during the budget process. Currently the user has service admin roles and is able to d…
-
Financial Reporting - Showing children from selected Entity in POVDear Community, our client needs a financial report where he selects an Entity in the POV of the report and then sees the number for all respective children of the selec…
-
[sharing info] Interesting find using debug mode and edit mode with different resultsSummary: I was working on a calculation to add the ARR of a contract to a vintage month (If the contract starts in Jan 24, I want the ARR to be placed in Month 1 and the…