On Demand Rules
Discussion List
-
10K Disclosure Tables in FCCSSummary: For an insurance company, preparing the 10K requires numerous disclosures, including, but not limited to, annuities, amortizations, and retirement plans. To fac…Saraiya Daisy Dhanesh 15 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Can configurable consolidation rules be used to copy opening balanceSummary: We have introduced a new parent in between to our existing structure. On consolidating at new parent only movements are rolling over to new parent from old pare…KamalRawat9918 25 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Use User Variables as Parameters in an ODR RuleSummary: Hi, is it possible to pass User Variables like entity to a ODR ? In my Data form, I have Source Entity and Target Entity, I'd like to pass only the Target Entit…Guixdx 43 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 92 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 19 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 373 views 8 comments 3 points Most recent by NK2025 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 313 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 11 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 64 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 14 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…
-
EPM FCCS calculation: Rule fails with the error message: Cannot use restricted dimensions: "ENTITY"Requirement: 1. Data available in Entity ABC with ICP_XYZ. 2. We want to copy the same account data to the entity XYZ and ICP_ABC. The rule fails with the error message:…Saran Kandasamy - EPM Cloud 25 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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,…
-
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 88 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 37 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 33 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…NK2025 72 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 38 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 360 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…