On Demand Rules
Discussion List
-
Improve Essbase Hybrid BSO Calculation Script PerformanceSummary: This article provides pointers to improve FCCS insertion points written for Hybrid Essbase. Especially useful for applications using Period and Movement Dense, …Ashutosh Bhatikar-Oracle 369 views 14 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Not able to launch ODR RuleWe created rule in the Test environment post testing, we migrated the rule with respective data form & report in the Prod application, but the ODR_rule did not get migra… -
The instance is not loading when multiple users are performing UAT and is hangingHi, We are experiencing performance issues with a custom business rule during UAT, especially when multiple users are active. The rule appears to become stuck, causing a…JyotiSharma 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Restrict the run of on demand rule on the basis of approval statusSummary: System should allow the local user to run an On Demand Rule when they are the owner in the approval unit, once they promote the entity to group(logically they a…Satish9090 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS calc script Issue - Error executing formula: can not cross members members from same dimensionHi, While writing ODR calc script in FCCS, we are getting below error for 4 Profit centers. We checked that alias for these are unique. Still getting the error. What cou…Vidhi Nenwani 38 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How To:Lock Data Forms during Consolidate and Translate.Summary: This knowledge article stems from this Customer Connect question - User should not input data in data form if consol process is running in FCCS. Content (please…Ashutosh Bhatikar-Oracle 706 views 20 comments 9 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
validation error: Cannot use restricted dimensions: Currency consolidationSummary: Content (please ensure you mask any confidential information): Hi all I have an urgent query. We had a calc script which was working until now, but we are getti…NKW 42 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
ODR/ConfigConsolRule to remove/exclude consolidated data from Group entitySummary: Restrict certain accounts from consolidating to the top Parent entity or clear consolidated data from Group after consolidation run Content (please ensure you m…Mihajlo Belosevic 13 views 1 comment 0 points Most recent by Chansouda-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 65 views 2 comments 0 points Most recent by Pradeep Arjunan-Oracle Financial Consolidation and Close
-
Audit rules - New FCCS rule creation not loggedSummary: I created a new rule in FCCS to clear the trial balance. When i run the audit report for Rules - Add or Rules - Modify, it is not in the log that a new rule was…Jking 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Member formula showing incorrect periodic valueSummary: Current scenario : Following member formula written to achieve business driver calculation. Problem : Result is Showing correct at YTD but incorrect on Periodic…AlokP 52 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Consolidation taking longer time due to script calling in insertion rule FCCS_20Hi All, We are using FCCS DSO application, where business requested to copy data for few accounts from Custom4 top parent member to Custom4 base member. To achieve the b…Sydaiah Mudumala - Invesco 61 views 6 comments 0 points Most recent by Sydaiah Mudumala - Invesco Financial Consolidation and Close
-
Default Movement Member Selection - Cash FlowSummary: Client has a requirement for a systemized cash flow in FCC. They will continue to load ending balances where we load to ClosingBalance_Input and rely on the def…User_2025-02-04-11-19-53-782 94 views 7 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close -
How to get rid of default run-time prompts in FCCS Groovy business rule?Am trying to email the activity report and audit report to users using On-Demand (Groovy) Rule in FCCS. Default run-time prompts (Consolidation, Currency, Entity, Period…
-
How can we reverse the data of FCCS_Entity Proportion Adj+parent entity?Summary: How can we reverse the data of FCCS_Entity Proportion Adj+parent entity? We need to correct the data of FCCS_Entity Total+Entity Currency+Parent entity. Writing…Nan Wang-Oracle 31 views 4 comments 0 points Most recent by Nan Wang-Oracle Financial Consolidation and Close
-
On demand rule does not work for the entity specific calculationSummary: Hi Ashutosh Bhatikar, Our client has an entity-specific calculation that we placed in an on-demand rule. This calculation should also be applied to all shared e…Jane Wang 42 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Calculate Average Exchange rate in FCCSSummary: Is there any way to calculate Average Exchange rate input value through a calculation logic(average of Cumulative Ending Exchange rate) Content (please ensure y…Venkatraj Bhat 92 views 4 comments 0 points Most recent by Harpreet Singh Arora Financial Consolidation and Close
-
On-Demand Rule not workingSummary: Hello, We need an on-demand rule to pull a balance from one intersection and post it to another and I can't get it to work. I am not an expert at rules, so any …K McMillan 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Elimination causing issue in account primary and shared hierarchy comparisonSummary: Hi, We have one primary hierarchy for trade receivable and another statistical hierarchy where we are sharing the primary hierarchy account members We are compa…JyotiSharma 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
MDSHIFT not working in FCCSSummary: Is MDSHIFT supported and has anyone got it working in FCCS? Content (please ensure you mask any confidential information): Is MDSHIFT supported and has anyone g…NarayananS 72 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Block Creation Issue in ODRSummary: When we are trying to copy from consolidated top entity(CONSOL_ENTITY) to one base entity STAT_Total for few Stat account and stat profit centers from source we…Hem Palariya 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Adjustment for unrealized profit or lossSummary: Post of the Investment and result of the holding company Content (please ensure you mask any confidential information): Hello, We are analyzing the adjustment o…CarolinaRodriguez 43 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Set Opening Balance in Scenario Budget to Closing Balance of Actual Scenario in P12Summary: By default, FCCS pulls the Opening Balance from the last period of the previous year (P13). However, I need to set the Closing Balance from P12 of the Actual Sc…Bjoern Schumacher 44 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Use Groovy to run business rule for Consolidation and TranslationContent I'm trying to use groovy to automate the data load and translation process. However, I can't find effective way to run the FCCS Translate business rule. I try to…
-
Prolonged Execution Time of a Ruleummary: Prolonged Execution Time “FccsFormStatusProcessor” Rule Content (please ensure you mask any confidential information): Hello, We have the following concern: When…CarolinaRodriguez 44 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
ODR failed with an errorSummary: Our ODR is failing with an error when run manually. We have been live since two years and we never had this issue. The rule runs fine sometimes and sometimes it…Amarnath_Kothapalli 12 views 2 comments 0 points Most recent by Amarnath_Kothapalli Financial Consolidation and Close
-
Groovy error - Cannot run business rules which contain run-time prompts during form load.Summary: Groovy not working for power user Content (please ensure you mask any confidential information): I have added a simple groovy for "read only" in data form. As a…Jai Prakash 32 views 2 comments 0 points Most recent by Jai Prakash Financial Consolidation and Close -
Sum for 12 months in member formulasSummary: Assistance Required: Dynamic 12-Month Summation Across Current and Prior Years in Member Formula Content (please ensure you mask any confidential information): …Anand Thota 22 views 6 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Journal Action REST API - Error when Journal Label contains spacesSummary: Error performing journal actions via REST API to journals with labels containing spaces Content (please ensure you mask any confidential information): I've crea…Shane Rooney 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Do we have any working example of FCCS CTA/CICTA calculation logic?Summary: Customer is looking for CICTA and FX movement calculation logic. Do we have any OBE (Oracle by example ) which explains system logic. Any links to for all syste…