Category 143
Discussion List
-
Smart View Adhoc Refresh - Alternate & Default Alias Table Behavior differencesHow can we make an alternate alias table the default in Smart View? Currently, when an ad hoc grid is saved with an alternate alias table, it does not refresh with the s… -
Can we update alias on the new alias table for an entity Dimension?I believe it should be possible to update alias on a new alias table, but when I tried, I received an error saying that journals are posted on this entity.B.Bhandari 72 views 15 comments 0 points Most recent by B.Bhandari Financial Consolidation and Close -
FCCS Job Deletion Log / ReportHello, In FCCS, there was a job that is no longer present. Is there any option to see when it was deleted and by whom from the Job Console? We reviewed the Audit and Act…Alexander Ulanovski 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS_Mvmts_NetIncome not calculatedSummary: FCCS_Mvmts_NetIncome not calculated for P&L accounts for new entities that started receiving data recently. Data from ERP is loaded at "FCCS_ClosingBalance_Inpu…Rahul Sharma-226069 60 views 10 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close -
How can we reverse the data of FCCS_Entity Proportion Adj+parent entity?Summary: How can we reverse the data of FCCS_Entity Proportion Adj+parent entity? We need to correct the data of FCCS_Entity Total+Entity Currency+Parent entity. Writing…Nan Wang-Oracle 40 views 5 comments 0 points Most recent by YogeshKJain Financial Consolidation and Close -
FCCS_Entity Proportion Adj Result is Out of BalanceSummary: Hi, Anybody know how is FCCS calculate data for FCCS_Entity Proportion Adj and FCCS_Entity Elimination Adj? What is the formula? We have restructuring cases and…J Mahero L 279 views 14 comments 0 points Most recent by YogeshKJain Financial Consolidation and Close -
Why is our Balance Sheet out of balance after enabling org by period?Summary: We have recently enabled the enhanced organisation by period option in FCC in order to manage some upcoming changes to our entity hierarchy but despite much tri…Mel Bowers 78 views 9 comments 0 points Most recent by YogeshKJain 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… -
having this error during cloning FCCS prod to testSummary:Clone Status Details Importing Snapshot Artifact Snapshot: Failed Summary: The command failed during the import process due to missing users in the target enviro…User_9I3H4 15 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Calculation script failed to retrieve opening balance of parent accountSummary: Hi All, I am using FCCS 25.09.77. We are using a store account as a validation account where it would retrieve the closing balance from a parent account. We fou…Tam Kam Yuen 61 views 11 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 26 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Migrating Financial Management metadata and artifacts to FCCS - missing Doc 2420798.1We are migrating from on‑prem HFM to Oracle FCCS. The EPM migration page references MOS Doc 2420798.1, but I cannot find it on My Oracle Support. Links I referred - Migr…Sridhar Huchegowda 77 views 11 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 58 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Need Option to Capture Separate Override Amounts at Subconsolidation Level in FCCSCurrently, Oracle FCCS provides only one placeholder to capture override data at the subconsolidation level. With the system’s default translation logic, this override i…adityasingh 33 views 3 comments 0 points Most recent by Deepesh Bohra-Oracle Financial Consolidation and Close -
Entity with less than 50% ownership but overall control not consolidating/eliminating as expectedSummary: We have a subsidiary that we want to fully consolidate and have a non controlling interest of > 50% but we're seeing issues with intercompany eliminations Conte…Jeremy Stubbs 40 views 8 comments 0 points Most recent by TechM-GJ 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 41 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Data Discovery does not provide calculation trace if a member has a shared instanceHi, Our team is trying to do FCCS Data discovery against a certain combination of data and we noticed that if one of the members has a shared instance, data discovery do…Avi12589 41 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can a power user promote a parent level in approvals without the base level entities being promotedSummary: We have the need for power users to have the ability to promote an Entity Parent even though all the base entities are not promoted. Ideally the base level enti…LSN_CE 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Loading by FDMEE - Replace vs MergeSummary: Loading by FDMEE - Replace vs Merge Content (please ensure you mask any confidential information): Hi All, I noticed an issue during Loading Phase by FDMEE. In …Antonio Barbaro 69 views 14 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Lock/Unlock entities in different phasesSummary: Actually our requirement is to lock/unlock entities in two phases for example client wants to lock TB data first and data forms after few days Content (please e… -
Dynamic Reserve locations to dynamic reserve locations replenishment in WMS logfireSummary: When we implemented replenishment in WMS logfire it works only if item assignment type is permanent and not dynamic but for us all are reserve locations and ite…Akshita Manne 10 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC Budget OOB Intercompany Reports More than One PeriodSummary: If FCC is used to Consolidate Budget data this means processing at least 12 separate periods at the same time. If the Elimination functionality is used you'd wa…Steve Hitchman 44 views 9 comments 0 points Most recent by TechM-GJ Financial Consolidation and Close -
How to use Clear Shared Members dimension import option when importing from EDM?Summary: The Clear Shared Members option shows an error in FCC when importing dimension metadata from Enterprise Data Management (EDM) because we cannot perform any acti… -
How to run custom reports in FCCS using rest APIWe have custom reports build under Dashboards Reports section. We want to execute them via rest API. I have tried the rest API provided under https://docs.oracle.com/en/…KamalRawat9918 48 views 10 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 24 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Consolidate or Translate FirstSummary: Content (please ensure you mask any confidential information): We're getting conflicting information on which rule to run first. Which is the correct order of r…Rory Mullin 35 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
25.11 Patch Note OAuth 2.0Summary: Hi, we saw the note in 25.11 Patch Note for OAuth 2.0 Recommendation. We have some clarifying/follow up questions. Content (please ensure you mask any confident…Alyssa Longo 35 views 3 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 18 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Oracle EPM Data Integration REST API- Retrieve Job Status using Job NameSummary: Is it possible to query EPM Data integration jobs through REST API using Job Name or Status instead of job ID? The Document below only talks about using Job Id …SoumyadipBasak251 45 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM Data Integration FailureI inquire if the integration between ERP and EPM fails, if it's possible to send back the log file to the ERP directly from EPM, or to the user performing the integratio…Mohamed_Shehata 27 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close