On Demand Rules
Discussion List
-
25.11/Essbase 21c - (Unexpected) reduction in consolidation time.Summary: At one of our customers we are testing the 25.11 upgrade to see if we have any of the issues mentioned, related to Essbase 21c. We encountered a significant red…Tjeerd Huisman 18 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How To: Invoke EPM Cloud FCCS Ownership Management REST API Using GroovySummary: Article provides a video to demonstrate how FCCS REST API can be invoked using Groovy business rule and then used in Data Integration Pipeline. Content (please …Ashutosh Bhatikar-Oracle 9 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Oracle Essbase 21c Guidance for EPM Cloud FCCS RulesSummary: Observations and best practices for Essbase 21c Hybrid BSO Calculation Scripts. Content (please ensure you mask any confidential information): This article shar…Ashutosh Bhatikar-Oracle 20 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Syntax to pick up all periods after a sub varSummary: Do anyone have suggestions on how to pick up all periods after a particular period? I.e. if an application has a December Year end and June is the current month…EmmaPa 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
I am trying to write a rule in Calculation manger to loop through all base member accountsSummary: I am trying to write a rule in Calculation manger to loop through all base member accounts under FCCS_Total Balance Sheet under entity CO1147 and assign it to a…SeanY 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we export exchange rates using with Groovy script (writing in Console Cube)Summary: Can we export exchange rates using with Groovy script (writing in Console Cube) Content (please ensure you mask any confidential information): Version (include …Srinath.M 34 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Inquiry Regarding Restriction Conditions for the FCCS_TranslatedCurrency_Input MemberHi, Based on the client’s requirement to adjust some data directly in the parent currency, we enabled the FCCS_TranslatedCurrency_Input member. Several journals have bee…PAMUDI 34 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 37 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 32 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 47 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 103 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 25 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 19 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 391 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 316 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 17 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 69 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 18 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 30 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,…Ashif 29 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 47 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 24 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 39 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 37 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 27 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(…