On Demand Rules
Discussion List
-
Writing calculation at parent entityHi, We are trying to write a calculation at parent entity, is there any property or attribute we could enable to write the calculation at parent entity? Regards Jyoti Sh…JyotiSharma 11 views 2 comments 0 points Most recent by JyotiSharma Financial Consolidation and Close -
Sum for 12 months in member formulasSummary: Assistance Required: Dynamic 12-Month Summation Across Current and Prior Years in Member Formula Content (please ensure you mask any confidential information): …Anand Thota 23 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
User Selection of Multiple Elements from a Dimension for Data FormsFor the presentation of capital consolidation, we always require the paired display of Investor & Investee. These are reflected in the data model as follows: Investment …Bjoern Schumacher 11 views 1 comment 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
i have written rule as TOPDOWN and CELL mode, due to that i am facing performance issueSummary: i have written rule as TOPDOWN and CELL mode, due to that i am facing performance issue Content (please ensure you mask any confidential information): Version (…Narinder Arora-162322 81 views 9 comments 0 points Most recent by Narinder Arora-162322 Financial Consolidation and Close
-
Reclass rule not working when Source POV have Parent AccountSummary: I have written a rule to pick the source pov value and past it in target pov, it's working fine when i am using child account but not working with parent accoun…Narinder Arora-162322 11 views 4 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Overrides not working in alternate hierarchySummary: When override is entered at base entity using the FCCS_Amount Override consolidation member, where there are alternate entity hierarchies, the shared hierarchy …Larry Amato 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Best process for overrides when there are multiple hierarchies?Summary: We have multiple hierarchies for entity where the parents in the shared hierarchy may have a different currency. Was wondering if there was a solution other tha…Larry Amato 41 views 3 comments 1 point Most recent by Larry Amato Financial Consolidation and Close
-
How to migrate the custom rules in deployed state?Summary: How to migrate the custom rules in deployed state? and if that is not possible, how to select multiple rules and deploy them at once? Content (please ensure you…Harshith J Rao 41 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
We've successfully run a consolidation; however, the data does not roll up and impacted calculation.Summary: Hi All, We've successfully run a consolidation; however, the data does not roll up, and the calculation status is impacted. What am I missing? Thank you. Regard…
-
Tips to improve UI response when executing Business Rules via Data Forms or Rules cards.Summary: This post provides some helpful tips to improve UI responsiveness when executing long running Business Rules via Data Forms or Rules card. Content (please ensur…Ashutosh Bhatikar-Oracle 11 views 1 comment 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…
-
FCCS Copy All Data from One Scenario to Another Scenario including journals dataSummary: We are trying to copy data from one scenario (Actual) to another scenario (Actual CC @LC) including journals data using calc script but this seems not working. …JyotiSharma 61 views 11 comments 0 points Most recent by aarguello Financial Consolidation and Close
-
How to redirect FX Variance for Historical Override Account to Movement member?For a historical rate override account, can the FX Rate variance be redirected to a movement member instead of plugging the variance in CTA account?
-
Shared entity members and rules - rules only runs for primary memberWe have a couple of rules in the main consol rules which should only run for certain entities. To do this we added an if statement for the entities for example, IF (@ISM…EmmaPa 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 121 views 8 comments 2 points Most recent by User_30Z7I Financial Consolidation and Close
-
FCCS Essbase script is not workingHi Team, We have defined below script to aggregate the data appearing at the child member to its respective parent member for Amount override and GBP, but it seems not w…JyotiSharma 91 views 11 comments 0 points Most recent by JyotiSharma Financial Consolidation and Close
-
How frequent the Oracle is doing the Application security and Vulnerability Assessment and remediatiHow frequent the Oracle is doing the Application security and Vulnerability Assessment and remediation standard for development artifacts including, code, scripts, softw…UdayaKumarDuba96 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy script to filter entities by ICP_Entity_YesWe are using a groovy script within a form. We have it currently building the rows with ILvl0Descendants of the entity in the user's POV. This works with no problem. Now…Dale Joosten 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issue with FCCS Create Block for Opening Balance AdjustmentSummary: Hello All - I need to copy the Opening Balance into Opening Balance Adjustment from one entity to the other. I see my script is not creating the block and check…Hari Jetti 41 views 20 comments 0 points Most recent by Pranab Kumar-279997 Financial Consolidation and Close -
JTD Issue in P&L EntriesSummary: The client posted entries last year with the journal type as JTD. These entries were subsequently reversed in the following year at the same intersections. For …
-
Can you source data from FCCS_YTD in on demand rules?Summary: When I try to pull the YTD data from 1 account to the Periodic member of another account, it appears to ignore that I have specified FCCS_YTD in the rule and pu…EmmaPa 101 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to handle parent entity move from a USD parent to an AUD parentSummary: What's the best way to handle the below scenario: Content (please ensure you mask any confidential information): When Entity is disposed from one parent and acq…
-
Delete file from inboxSummary: Hi all, i'm facing the following issue while deleting file from inbox/outbox explorer through using REST api from groovy script. "A method called by the script …SRAD 33 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Rule is not working as expectedSummary: Hi Team, I would like to copy the "FCCS_openingbalance adjustment" values from one account to another and written rules for the same but still it is not working…Jagadiswar Rao Gandham-Oracle 41 views 5 comments 0 points Most recent by Sai Ch-Oracle Financial Consolidation and Close -
Facing issue having error message starting with "You are trying to change the data" after patchSummary: While deploying rules or try opening forms, we are facing below issue in the EPM application after the patch has been updated on Friday. Appreciate your help an…Subramanian Karunamoorthi 81 views 9 comments 0 points Most recent by Russ Financial Consolidation and Close -
Can you allocation balances across entities in FCCSummary: Have a new client that would like to do allocations across entities in FCC (vs in ERP). Content (please ensure you mask any confidential information): Client wo…Nancy Ackerman 21 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
How To:Debug Essbase Solve Order InaccuraciesSummary: Article describes how On Demand Rule can be used to investigate Solve Order Conflicts which lead to incorrect values in Member Formulas. Content (please ensure …Ashutosh Bhatikar-Oracle 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Block creation issue in custom ruleHi, We have one custom rule in FCCS where we are facing Block creation issue. We have to do the calculation at "FCCS_Amount Override" consolidation dimension member and …JyotiSharma 91 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
default movement issue on retained earnings priorSummary: default movement now calculating on no intercompany intersection for retained earnings prior account for FY24 when it has never done this in prior years - anyon…Lynda G 51 views 8 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close