Category 101
Discussion List
-
help with @Sumrange across two dimensionsI have an existing formula that looks like this: Fix(Dim1_member, Dim2_member) AcctX = @PRIOR(AcctX→noDept→TotalDim1→TotalDim2) Endfix What I'd like to do it change the … -
"error encountered while downloading file from remote server" in PBCS Data ManagementSummary: Hi, Just wondering if anyone has encountered the error: error encountered while downloading file from remote server This is when we are trying to refresh member…
-
EPBCS Clear DataSummary: Finish Button in Clear Data Page is Not Clickable When executing Clear Data, after identifying the dimensions in the initial page, the Finish button is inoperab…
-
Predictive Planning - Auto Prediction percentageHello, We have recently started using predictive planning with dynamically calculated members. Our hope was that by picking certain parents and totals we would get meani…
-
Data workbench export to excel optionSummary: I tried to export workbench data to excel Content (please ensure you mask any confidential information): I have received a requirement from a user to export wor… -
When converting a calc script to business rule, are commands can be used to enhance performanceSummary: While converting calc script to business rule in EPM cloud, I found that CACHE HIGH command is not accepted on cloud. Are there other acceptable ways to enhance…
-
EPBCS: get migration status reportHi, We can see migration status report in Tools→Migration→Reports→Migration Status. Can we get this report using any epmautomate command or using an API? Did anyone trie…
-
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 5 comments 0 points Most recent by Sabrina Greensea-166456 Planning
-
Getting List of edited Cells after DM load in PlanningHi - we are loading data from Data management using flat file. There is a Business rule attached to the integration to run after the rule. How can we get the list of edi…
-
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 .
-
Are the WFP OOTB smart lists editable?Summary: Are the WFP OOTB smart lists editable? as we need to add members/entries in salary basis and employee type Content (please ensure you mask any confidential info…
-
EPM instancesHello, In the EPM instance, there are 3 environnements: we use Planning14_epm54 for Production and Planning14_epm54-test for Development. Does anyone know what the first…
-
How to export users for each EPM instanceHello, We have many EPM instances, and we need to export the list of users Per instance. any idea? Best regards, Hind
-
Exporting Supporting Details to CSV via GroovySummary: Hello, I'm looking to see if there is a way to export Supporting Details/Line Item Details from EPBCS via Groovy in a CSV. As of right now we have a process of …
-
Predictive cash forecasting demo application\LCM\Snapshot.We are looking to explore Oracle Predictive Cash Forecasting application type in Cloud EPM,Could someone help if there is any demo snapshot of the application which is a…
-
Data Exchange error Log failing on Export: ERROR [AIF]: Database "null" does not exist.Summary: Trying to Load data from an FCC instance into Planning via Data Exchange. Getting this in the error log, never seen this before: ERROR [AIF]: Database "null" do…
-
Business Rule in Pipeline Executes Only for One Year Instead of All Years in RangeSummary: We configured a Data Integration pipeline to run over multiple years (e.g., FY23 to FY25) with a Business Rule job type that runs a Calculation Manager rule. Ac…
-
ChatGPT API IntegrationSummary: Posting a small groovy snippet to allow chatGPT API integration. This is meant as a bit of fun with no practical applications at the moment. You will need to ge…
-
PBCS: Supporting Details Grid SpreadHey Everyone…. I'm looking at the supporting details functionality, and have a question about Grid Spread. Our form is set up to allow for Grid Spread by entering a Full…
-
Trigger from EPM an ERP process using any API?hi Team Can we trigger from EPM an ERP process using any API? thanks
-
Data Push from CAPEX to FS Cube is not workingSummary: Although I'm doing exactly the steps mentioned in the tutorial (https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/capital-tutorial-integrating-fina…
-
Is there a way in Groovy to throw an error message with line separator in error promptSummary: Content (please ensure you mask any confidential information): Hi Experts, Is there a way to include line separators in error messages when using Groovy? I'm cu…
-
Data Integration Error while extracting Budget control Data the Data from EPM PBCS to Fusion ERPHello Dear N.S-Oracle We are Created another Budget Control Target On the ERP And we found this We are trying to import a target application from Oracle ERP Cloud under … -
Has anyone noticed a change in the decimals when loading data in Smart View and viewing it in the weHas anyone experienced this in Oracle EPM Cloud – Planning? When loading a value through Smart View (for example, 2.87681879460787), it later appears with more decimals … -
Run More Than One Calc Script in Groovy ScriptSummary: I am trying to run multiple pieces of calc script from one groovy script. It is executing the first piece essCalc1 and then the data push that is after essCalc1…
-
Predictive Cash Forecasting Seeded Integrations QuestionSummary: We are just starting to go down the path of setting up Predictive Cash Forecasting, are the seeded integrations in data exchange below only available if ERP is …
-
EPM Pipeline: Running a business rule with runtime prompt type SmartlistSummary: Hi, I'm trying to execute the BR: "OWP_Process Loaded Data" as part of a pipeline. I want to pass the variable "OEP_FcstMnth" as the RTP 'Month'. However, Month…
-
How to rename a column header for a lookup codeSummary: I created two lookup type PLC_CONSUMABLE and PLC_FG under the Manage Common Lookups I want to rename the column header "Lookup Code , "Meaning" to a different n…
-
What is the OOTB rule applicable for balance sheet planning?Summary: I'm developing a B/S planning sheet using OOTB forms in EPBCS. Please let me know which rules need to be run to generate forecasts for B/S. For I/S, I ran the "… -
pipeline fails and failure email but all sub jobs are succesfulHi We are on EPM Cloud Planning and have a pipeline that has 6 sub tasks that are run sequentially. Job 1) EPM BR job 2 till 4) EPM DM DLRs for three months job 5) EPM B…