Category 143
Discussion List
-
Automate Manage ApprovalsMy team uses the Manage Approvals process to lock data so that it can not be changed, and we are looking to automate the process. I cannot find any EPM REST APIs or EPM …annaschmult 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Month number from Month Name in FCCI am trying to derive month number from Month name (example, 1 for Jan, 2 for Feb etc.) using below member formula but not able to get the expected results when retried.…
-
Considerations for Posting Journals to a Plug Account in FCCSSummary: Are there any concerns or best practices when posting journals directly to a plug account in Oracle FCCS? Content (please ensure you mask any confidential infor…Bjoern Schumacher 51 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Correct amount is not being retrieved in Data IntegrationHello, In Financial Consolidation and Close, when I ran Data Exchange>Data Integration. The correct amount is not being retrieved. I have attached my mapping and the scr…Noah01010101 71 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error connecting to FCCS from Data Management of on-prem HFMI am getting below error when connecting to our Cloud POD and I am pretty sure, all the details I entered are accurate. Both the source and target are in same domain.SR912 81 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - Organization by PeriodSummary: In FCCS, we use 2 entity hierarchies (in the entity dimension) : 1 legal hierarchy and 1 management hierarchy. The management hierarchy changes every year. We h…Julie Belurier 131 views 7 comments 0 points Most recent by Ritesch Malhoe Financial Consolidation and Close
-
Entity is disposed from one parent and acquired by another parentSummary: What's the best way to handle the below scenario: Entity is disposed from one parent and acquired by another parent. Can we share the entity to the new parent a…SKM 61 views 7 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Chinese numerals in FCCS?Summary: Is it possible to see amount balances in FCCS in Chinese numerals? This would be needed in Web Forms, Adhoc Grids, SmartView, Reports, Journal Reports, ICP Repo…
-
pipeline changesAll: In testing the August patch we have found that there are undocumented changes in the pipeline parameters for existing pipeline jobs. The snip below shows a simple i…
-
How can Data Integration Pipeline or Integration be copied?Hi! I need to copy couple of Data Integration Integrations and Pipelines from Test environment to Production. Is there a way to do that without copying anything else (so…
-
FCCS | Data Exchange - No acess to folders in file browserSummary: When we access Data Exchange > Actions > File Browser, we can´t see any folders, even though they were created. At the same menu but in Data Management, we can …Timestamp EPM Team 21 views 2 comments 0 points Most recent by Angela Lewis Financial Consolidation and Close
-
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
-
Consolidation fails, duplicate member name errorSummary:Building alternate entity hierarchy, no error on metadata check, consolidation fails. Content (required): Version (include the version you are using, if applicab…Scott Rodney 95 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issue: Deleting Shared Entity in Entity DimensionSummary: There is a shared entity under one group in the Entity Dimension that cannot be deleted. When attempting to delete it, an error occurs. We also checked this ent…B.Bhandari 41 views 4 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
the starting month is April-2023 and there are values in the YTD of January-23. Do you know how ISummary: Guys, this company has April as its starting month and I enabled the fccs application with this definition. however, after loading data for the year 2023. it is…Silvia Arraiol 11 views 2 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close
-
Journal Approval RuleSummary: Journal Approval Based on Line Item Threshold Content (please ensure you mask any confidential information): Hi, We are trying to implement a journal approval p… -
FCCS Approvals - Failed: Entity or its descendants not locked for previous periodSummary: Hi All, While trying to lock Jan24 I see this error - Entity or its descendants not locked for previous period. But data till Dec23 is locked for all entities, …Priyanka Bhat 31 views 5 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close
-
Maximum limit of base members can be created under any custom dimension available in FCCS.We would like to understand the maximum limit of base member can be created under any custom dimension available in FCCS.Eshant Gupta 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
eliminationSummary: Alternate hierarchy doesn’t roll up correctly for the Alternate hierarchy parent Entity due to missing elimination. Content (please ensure you mask any confiden…Gayathri C 11 views 1 comment 0 points Most recent by Jack Burton-Support-Oracle Financial Consolidation and Close
-
Snowflake to FCCS integrationIs it possible to integrate data from Snowflake to FCCS? Are there any reference documents/whitepapers around this?SR912 21 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
data not consolidating to parent entityI have a very basic FCCS setup and trying to consolidate the data. I am not able to see anything at parent company. I can see data at Parent Current → Contribution combi…S Kumar-Oracle 41 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
price quantity analysis translation effect breakdown in FCCSummary: I have build a price analysis variance split between two revenue numbers in FCC. We use it in Entity Currency but as a next step we would additionally like to v…Erik De Rouck 11 views 0 comments 0 points Started by Erik De Rouck 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 123 views 8 comments 2 points Most recent by User_30Z7I Financial Consolidation and Close
-
Ability to Export and Import Configurable Consolidation Rulesets and RulesSummary: Content (please ensure you mask any confidential information): General Query about this new functionality: _____________________________________________________…
-
FCCS Entity Hierarchy movement causing Data issueIn the month of May (P5) a Parent entity E_923 was created in FCCS entity hierarchy and an existing level 0 member E252 (which initially was under E_919) was moved to E_…Karthiga Devi Ramanathan 21 views 5 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
How to delete all Journals for a scenario in FCCS?Summary: Every month, my client use the same Scenario member for consolidation. To make sure the Scenario has no data, we try to re-create the Scenario member. However, …Joseph Ip - Oracle-Oracle 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
OpeningBalance Adjustement Movement not rollup to parentSummary: i have written a simple ODR to pick a OpeningBalance movement value and move it in OpeningBalance Adjustement with reversal sign, it's working fine at child ent…Narinder Arora-162322 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Entity Lock statusSummary: Hello Everyone, We have encountered an unusual issue: three entities are displaying a locked status in ownership management, even though they are not actually l…VNK 21 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
DI: Drill Through does not work with FCCSSummary: Content (please ensure you mask any confidential information): Hi all We are trying to rul a Drill through in FCCS via Data exchange but we are getting this err…
-
Out of balance Cash Flow with variance found in FCCS_Mvmts_SubtotalSummary: We are trying to understand why our Cash Flow is out of balance (Total Cash Flow does not equal Cash Change) by movement in FX in isolated instances. Content (r…TAMMY_L 81 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close