On Demand Rules
Discussion List
-
Rest API for restart service is not workingSummary: Below groovy rule is running fine, but the services are not getting restarted, i have tried with both v1 & v2 versions but rule ran fine but services didnt rest… -
FCCS On-Demand Rule Calculated Data Gets Cleared During ConsolidationSummary: I have created an On-Demand Business Rule in FCCS that calculates and populates data for a specific set of entities. The rule executes successfully, and I can s…VijayNadesan 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we get Journals Period Status (Open/Close) using Rest API/Groovy in FCCSSummary: We have a requirement where users should not enter data in forms for closed periods. If it is possible to retrieve the Journal Period status (Open/Close) in FCC…Srinath.M 19 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What is the best recommended way to extract SHARED data from FCCS?Summary: What is the best recommended way to extract SHARED data from FCCS? is it Data Exchange? Code Snippet (add any code snippets that support your topic, if applicab…NarayananS 19 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy Email Triggers - Stops after 37 emailsSummary: We have a groovy rule to trigger emails based on certain conditions but after sending 37 emails per rule/day this stops and does not send emails. We checked the…
-
ODR Validation rule is not workingI have one rule which is working with 26.07.68 but give the wrong result with 26.07.95, i am getting the extra value in target side which is reversal of last quarter num…Narinder Arora-162322 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Oracle Essbase 21c Guidance for EPM Cloud FCCS RulesSummary: Observations and best practices for Essbase 21c Hybrid BSO Calculation Scripts. Content (please ensure you mask any confidential information): This article shar…Ashutosh Bhatikar-Oracle 133 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
New Recording Available - Best Practices and Tips PresentationsWe have recently added new best practice content focused on typical issues we have seen in customer applications and implementations in the events area (you can always s…Rich Wilkie-Oracle 3.3K views 17 comments 15 points Most recent by Chandramouli B-Oracle Enterprise Performance Management Resource Center
-
How To: Consolidate Entity on Data Form POVSummary: This article stems from this Customer Connect Thread Option to have select POV from data forms — Cloud Customer Connect. It uses a Groovy rule to execute Consol…Ashutosh Bhatikar-Oracle 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Offset EPA at Entity Currency coming from CTASummary: Due to extensive Organizational ReOrganization of entities with multiple ownership changes, we have ended up with OOB (Out of balance) at parent levels coming f…SunilKumar-Oracle 21 views 5 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
On demand FCCS rule clearing only single periodWe have a clear data script which is getting triggered through a DLR loading budget data for multi period. However ,the on demand BR is accepting only single value for P…PrinceKumar 21 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Trying to clear zeroes but ODR does not workSummary: As there are a lot of stray zeroes in our environment (manually loaded by users), we want to delete them to improve performance. We tried it using two Essbase m…Tjeerd Huisman 54 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
In FCCS, Highlight the data form cell if any data was input in previous periodLike in HFM, there is a functionality in Data form, where if for any cell if there is any data input in previous period/quarter, then it is highlighted which allows user… -
Business Rule to reclass PnL accounts to its MovementsSummary: I am trying to do a reclass using PnL accounts to its respective Cash Flow movements. I have built alternate hierarchy for accounts to combine set of accounts a…Kenneth John Asper-Oracle 51 views 8 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
Offset opening balance at parent currency using opening balance adjustmentSummary: I am trying to nullify opening balance data at parent currency for an entity using opening balance adjustment by submitting negative of OB at OBA using Rule-40.…SunilKumar-Oracle 33 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to use the conditions BEFORE and AFTER in Configurable Consolidation rule setSummary: Content (please ensure you mask any confidential information): Hi all Could someone please give me and example on how I can use correctly the Before and "After"… -
Member selection is restricted in RPTWhile executing a rule in RTP, the member selection is restricted — we do not see any drop-down options. This functionality was working as expected earlier, but now the …Tejaswini Kulkarni 12 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy Helper Functions to Execute an EPM Cloud Job and Poll For its StatusSummary: This discussion provides a couple of Groovy based helper methods that could be added to a Groovy based business rule to execute an EPM Cloud job. Content (requi…Ashutosh Bhatikar-Oracle 312 views 4 comments 2 points Most recent by Vishal Vora Financial Consolidation and Close
-
FCCS Consolidation Rule Clearing Data Calculated by On‑Demand RuleSummary: We have created on-demand business rule that calculates data and writes it to accounts. The on-demand rule runs successfully, and the calculated data is visible…VijayNadesan 29 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy script not calculating Minority Interest Income accurately for 2026 periods in 25.10Summary: Groovy script not calculating Minority Interest Income accurately for 2026 periods. Its working fine for prior years. We have been running Groovy script validat…Deepshikha 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
CustomSummary: Intercompany eliminations across different LOBs retain source LOB instead of defaulting to “No LOB" Content: The customer is facing an issue in FCCS related to …
-
Can we load delta data from Cloud GL ERP to FCCS using OOB integration and groovy scriptingCan the incremental data from ERP be extracted and loaded to FCCS using out of the box integration and groovy scripting. Could you please share any link or steps detaili…Batul Rangwala 12 views 3 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Cost Center dimension custom allocationSummary: We have implemented an alternate cost center allocation process in our application. In this setup, data is allocated from a source cost center to multiple targe…Krithika Krishan - PwC 21 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Note: Essbase 21c and @QUERYBOTTOMUPSummary: Article describes FCCS calculation script and member formula guidance related to usage of new @QUERYBOTTOMUP Essbase 21c function. Content (please ensure you ma…Ashutosh Bhatikar-Oracle 61 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
variance in leaf level dynamic calc member formula data between non-DSO and DSO applicationSummary: We have a leaf level account member with member formula in a Non-DSO application. The source accounts used in Member formula has data, but the dynamic calc memb…VSKrishnan 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Bulk Force Close automated tasks in FCCS Task ManagerSummary: FCCS doesn't give an option to bulk force close automated tasks in FCCS Task Manager. Is there a way to create a rule which can be used to trigger the force clo…Tomy Stephen_1 71 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Allocation for Multiple entities without HardcodeSummary: Hi All, I am trying to write an FCCS calculation script to perform an allocation for a specific set of entities without hardcoding entity names. Requirement: Fo…Aditya Sahoo 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close