On Demand Rules
Discussion List
-
FCCS ODR calculation is not working after Nov-25 patch (Monthly update)We are having a strange issue in one of the FCCS on demand rules, where after Nov-25 patch update the below code is not working in test instances, however, it is still w…Hem Palariya 101 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Recommendations - Hybrid calculation scripts FCCS_10Summary: Hi, I'd like to confirm if there are planned enhancements (safe harbor) for Oracle on the Recommendations regarding executing Hybrid calculation scripts in FCCS…
-
ODR pass on entity using groovy based on row dataSummary: We want to create an ODR rule in Groovy (to reclass movement data across data sources), which uses the entities in the rows as entity selection. We can get the …Tjeerd Huisman 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Unable to export Job Console output to file through Groovy rule in FCCS as well as PBCSSummary: Hi, I am trying to export the Job Console output to a CSV file however it is not working and also unable to see any output file in the job console as well. I ca…Tejesh Mhatre 11 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How To: Process Entities of a Particular CurrencySummary: This article stems from customer connect question, about how to process entities with a particular base currency property. Content (please ensure you mask any c…Ashutosh Bhatikar-Oracle 405 views 8 comments 3 points Most recent by NKW Financial Consolidation and Close -
"An unknown error occurred when executing the script."Hi All, I'm trying to run an ODR groovy script which creates a calculation script and returns the string to essbase to execute. When we run this it returns the error "An…Brian Somers 317 views 6 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Rounding off adjustment and casting effectWe want to round off the actual loaded numbers to their nearest million in FCCS, has anyone implemented the same? If yes, then how was the casting effect managed? Lookin…Vandita Vyas 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Access Exchange Rates & Cross-Rates from Rates cube for calculations of Transaction EffectsSummary: Goal: Calculate transaction effects while pulling exchange rates & cross-rates - independent of entity/parent currency. Seeking best practice in FCCS for access…Bjoern Schumacher 62 views 11 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
How to calculate in future years&periods using on-demand rulesSummary: Hi, we are trying to calculate depreciation and write it into future periods using on-demand calculation. I understood, that by default, a runtimeprompt for Yea…R Abel 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to delete translated data for discontinued entities?Summary: Is there any possbility to delete translated date for discontinued entities? Challenege: We have to keep base level data which in base currency and post consoli…
-
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,…Ashif 42 views 2 comments 0 points Most recent by Ravi Akula Thimmaiah Financial Consolidation and Close
-
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 92 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 61 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 21 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 31 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 32 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 21 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…NKW 81 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…
-
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 41 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 21 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 403 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