On Demand Rules
Discussion List
-
How to use the conditions BEFORE and AFTER in Configurable Consolidation rule setSummary: Content (please ensure you mask any confidential information): Hi all Could someone please give me and example on how I can use correctly the Before and "After"… -
Member selection is restricted in RPTWhile executing a rule in RTP, the member selection is restricted — we do not see any drop-down options. This functionality was working as expected earlier, but now the …Tejaswini Kulkarni 20 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Groovy Helper Functions to Execute an EPM Cloud Job and Poll For its StatusSummary: This discussion provides a couple of Groovy based helper methods that could be added to a Groovy based business rule to execute an EPM Cloud job. Content (requi…Ashutosh Bhatikar-Oracle 310 views 4 comments 2 points Most recent by Vishal Vora Financial Consolidation and Close -
FCCS Consolidation Rule Clearing Data Calculated by On‑Demand RuleSummary: We have created on-demand business rule that calculates data and writes it to accounts. The on-demand rule runs successfully, and the calculated data is visible…VijayNadesan 22 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy script not calculating Minority Interest Income accurately for 2026 periods in 25.10Summary: Groovy script not calculating Minority Interest Income accurately for 2026 periods. Its working fine for prior years. We have been running Groovy script validat…Deepshikha 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
CustomSummary: Intercompany eliminations across different LOBs retain source LOB instead of defaulting to “No LOB" Content: The customer is facing an issue in FCCS related to …
-
Can we load delta data from Cloud GL ERP to FCCS using OOB integration and groovy scriptingCan the incremental data from ERP be extracted and loaded to FCCS using out of the box integration and groovy scripting. Could you please share any link or steps detaili…Batul Rangwala 11 views 3 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Cost Center dimension custom allocationSummary: We have implemented an alternate cost center allocation process in our application. In this setup, data is allocated from a source cost center to multiple targe…Krithika Krishan - PwC 22 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Note: Essbase 21c and @QUERYBOTTOMUPSummary: Article describes FCCS calculation script and member formula guidance related to usage of new @QUERYBOTTOMUP Essbase 21c function. Content (please ensure you ma…Ashutosh Bhatikar-Oracle 14 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
variance in leaf level dynamic calc member formula data between non-DSO and DSO applicationSummary: We have a leaf level account member with member formula in a Non-DSO application. The source accounts used in Member formula has data, but the dynamic calc memb…VSKrishnan 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-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 71 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Allocation for Multiple entities without HardcodeSummary: Hi All, I am trying to write an FCCS calculation script to perform an allocation for a specific set of entities without hardcoding entity names. Requirement: Fo…Aditya Sahoo 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Need to clear balances for equity accounts at Parent Currency at parent total levelWe have dissolved some entity hence trying to clear out all the balances for equity accounts , we are able to clear out the balances at Local Currency level, but not abl…Himanshu Goenka 51 views 19 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
calc script code doesn't write back data per rule. please helpSummary: The calc script returns no errors but no data is written. Please help! Content (please ensure you mask any confidential information): SET HYBRIDBSOINCALCSCRIPT …SeanY 3 views 3 comments 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 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 65 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issue running ODR for entities with a member functionHi All. I am creating an On Demand Rule in FCCS. When created the ODR rule has created automatically prompts for the members of the Entity Dimension (as well as others).…Brian Somers 162 views 22 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Different result when the same script is run in on-demand rule vs insertion point rule on FCCSThere are some validation rules that we developed, and we noticed that the result is different between on-demand rule and configuration calculation rule. We suspect that…Ethal Chan 32 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 65 views 6 comments 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 100 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 33 views 4 comments 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 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 43 views 1 comment 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 31 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 41 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 31 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 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close