Category 143
Discussion List
-
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 70 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 75 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 99 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 259 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 78 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… -
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 51 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 292 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 50 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 16 views 2 comments 0 points Most recent by Sanjana Soni 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 39 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 17 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 40 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 102 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 45 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 18 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 25 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 26 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… -
SingleTime in forms with validation rules does not prevent promotion in approvalsSummary: For forms with validation rules that have Do Not Promote selected but also use SingleTime, the validation rules won't stop the entities from being promoted in A…EmmaPa 27 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Calculation of FX movement and FX OpeningHi All, I've a question about "FX movement" calculation in FCCS. We have PL accounts under standard BS hierarchy, here "FX movement" are not getting calculated (expected…MKhade 59 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
The consolidated entity shows difference in the balancesheet, any ideas?Summary: The consolidated entity shows difference in the balancesheet traditional approach while all the child entities has no difference in balance sheet, any suggestio…Mohamed Awad-278765 116 views 37 comments 0 points Most recent by Mohamed Awad-278765 Financial Consolidation and Close -
"EXTENDMOVEMENTSCOPE" substitution variable is not visible after monthly update 24.06The ExtendMovementScope substitution variable is now enabled by default. This allows you to include Movement dimension members that are created outside of the FCCS_Movem…MKhade 46 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
what am I doing wrong? Custom equity.Hi all, have a straightforward requirement of equity method accounting (equity method of accounting or EMA). A holding entity and a subsidiary with 100% ownership. entry…yanni vossos 16 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Can we setup integration between HFM and FCCS to export the data from HFM to FCCSSummary: We are trying to setup integration between HFM and FCCS to export data to FCCS. Is it possible to do so? Content (please ensure you mask any confidential inform… -
Identify the parameters for the Manage Configuration Rule in order to configure Calc FCCS_20Summary: We need to identify the parameter for the Manage Consolidation Rules with FCCS_20 Calculations_localCurrency final rules. The purpose is to execute 2 consolidat…MiguelRamirezLeos-Oracle 26 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close -
Usage of Drill throughHi There, We have enabled the Drill through option in FCCS and loaded the data through data integration(Current period). We are unable to drill through for the previous …Sashidhar Reddy K 27 views 3 comments 0 points Most recent by Sashidhar Reddy K Financial Consolidation and Close