On Demand Rules
Discussion List
-
FCCS_10 script to write data at parent entity journal inputHi, I am trying to write a FCCS_10 Insertion rule, where I want to allocate 0 as data point where the existing value is "#Missing". This script is running only at FCCS_J…Harshita K 59 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Groovy Helper Rules to Execute Data Integration and PipelineSummary: Attached helper Groovy business rules to help execute a Data Integration and a Data Integration Pipeline. Please feel free to customize as required. Content (pl…Ashutosh Bhatikar-Oracle 35 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS_10_After Opening Balance Carry Forward_LocalCurrencySummary: I am trying to create the following script within the rule FCCS_10_After Opening Balance Carry Forward_LocalCurrency and it gives me an error Content (please en…Leobardo Montufar 22 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How can I leverage groovy to execute the Data Integration in FCCSSummary: I am trying to use groovy to run an integration using groovy in FCCS. I was able to do the same easily in EPBCS. Same is not working in FCCS. Appreciate thought…Srinivas Bobbala 34 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Block Creation issue with Rule10 in Bottom-up ApproachSummary: I’m facing a block creation issue in Rule_10. The rule works fine when a block exists at the target intersection. However, when the block doesn’t exist, I attem…Anand Thota 29 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Rule to eliminate P&L account contribution for deactivated entities in FCCSHi All, We have moved base level entity from one parent to another, however we still see deactivated entity's P&L account contributing to its parent. Wanted to check if …Ashok_Yadav 24 views 2 comments 0 points Most recent by Ashok_Yadav Financial Consolidation and Close
-
ImpactStatus script not workingSummary: Content (please ensure you mask any confidential information): Hi all Someone could let me know what is wrong with this script: FIX ("FCCS_No Intercompany", "No…NK2025 75 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
function @MEMBER(@PREVSIBLING(@CURRMBR("Years")) goes into a loopSummary: Content (please ensure you mask any confidential information): Hi all While using this function: @MEMBER(@PREVSIBLING(@CURRMBR("Years")) EXAMPLE FIX (@RELATIVE(…
-
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…
-
Why FCCS is not able to calculate the minority interest in chain holding ownership structure?Below is my ownership structure - A holds 90% of B and B holds 80% of C. Here, the effective own % of A against C is - 80*90% = 72% MI% of A against C = 28% But in FCCS,…
-
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 32 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 22 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 313 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 32 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 659 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…NK2025 38 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 11 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 66 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 13 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 54 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 91 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 33 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