On Demand Rules
Discussion List
-
Script with Substring failingSummary: Content (please ensure you mask any confidential information): Hi all We have this script with Subscring which is failing: FIX ("Input","FCCS_Periodic", @RELATI… -
Suppressing RTP in Groovy ODRSummary: Suppressing RTP in Groovy ODR Content (required): Hi FCC community I am using ODR with Groovy Script selection to kickoff a Data Pipeline. The RTP is irrelevant…Raj N 43 views 7 comments 0 points Most recent by Srinivas Bobbala Financial Consolidation and Close -
Groovy method- To open an invalid intersection in one form to take input and submit the dataSummary: We have scenario where business needs to input data in one form for an invalid intersection Is there any method available through groovy like we have setforceed…Satish9090 27 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Override value posted at base level entity (Non-U.S.D) does not rollup to Parent entity (Non U.S.D)We are posting Override value at base level entity (Non-U.S. D), the override values are not rolling up to the Non-U.S. D Parent. We need to create an ODR to allow rollu…
-
Historical Amount Override Accounts + Journal USD Type Translating to other Reporting CurrenciesI'm creating this separated tread for a better understand and possibilities, I'd appreciatte your insights and knowledge around how FCC works and if there's something th…
-
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 392 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 46 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 43 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 51 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 712 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 48 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 18 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 73 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 15 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 58 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 64 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 98 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 38 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 47 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 103 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 46 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 25 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 74 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 26 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 48 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 47 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 47 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close