To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Financial Consolidation and Close
Discussion List
-
Error in AUH after enabling EOBPHello, After enablement of EOBP, one of our AUH is not getting synchronized and it is an error as mentioned below. ORA-12899: value too large for column "EPMEUPRDFRAVM30…
-
How can I override FCCS_Global Assumptions FX rates for a specific Entity (ies)?Summary: How can I load static/different FX Rates to a specific/existing Entity, not FCCS_Global Assumptions, and have them used in the translation calculation? In HFM, …
-
Clone causing removal of users access rightsSummary: Last week we did some changes in a secondary production environment and pushed them back to the original instance. By doing this, we did not check the Security …
-
How can I automate copy data using pipeline feature in FCCS?Summary: Pipeline is not working for copy data in FCCS. I have created copy data profile but not able to configure copy data profile in pipeline. It is throwing an error…
-
FCCS Import Data with member not allowedHi all, i'm trying to copy an application and i need to copy data, so i'm using import functionality. The import job is failing due to not allowed members (all reporting…
-
function @MEMBER(@PREVSIBLING(@CURRMBR("Years")) goes into a loopSummary: Content (please ensure you mask any confidential information): Hi all While using this function: @MEMBER(@PREVSIBLING(@CURRMBR("Years")) EXAMPLE FIX (@RELATIVE(…
-
Integration> Load from FCCS to TAX fail due to COMMA in the Account nameSummary: Content (please ensure you mask any confidential information): Hi all Could someone please let me know how to go about this limitation: In Planning it is possib…
-
How to pull the data of a specific date from Oracle GL Average Daily Balance cube?Summary: Client wants to pull data of a specific date from Oracle GL ADB cube. They do not want to pull the data from last day of the month. For example, Today they want…
-
Pipeline email: is it possible to print the value of the substitution variable?Summary: The March 2025 update added pipeline variable definitions to the email notifications generated from pipelines (see Oracle Fusion Cloud Sales Planning March 2025…
-
How access rates cube data from consol cube in FCCS insertion point ruleHi All, Can anyone guide me on how to access rates cube data from consol cube in FCCS insertion point rule.
-
25.07 updates FCCSAfter 25.07 updates, Recommendation card shows blank page. There are few updates to to this section but it looks like it does not work. thanks in advance!
-
How to Dynamically Pass Multi-Year Range from Pipeline to Business Rule in Oracle EPM?Summary: I am working with a pipeline in Oracle EPM where I have attached a business rule to the pipeline execution. The pipeline itself is configured to run over a spec…
-
Cashflow validates on entity currency but not on parent currencyHi, I have a case where my cashflow hierarchy is validating against the cash change member in my movement dimension, however when I change the currency to "parent curren…
-
SSO automatically chooses login account with Smart ViewSummary: Until today when I clicked on SSO to sign on to Smart View, I was prompted to choose an account, now Smart View automatically chooses my work account which is n…
-
FCCS Email Notification Configuration for Approval and Consolidation Journals by Finance TeamWe are using Oracle FCCS and would like to configure email notifications such that only relevant finance teams receive notifications related to their entities. For examp…
-
Prerequisites for CONFCALC_Enable_Rate_Amount_OverrideSummary: Hi All, We have requirement to write/copy to data to amount override through configurable calculations. In Order to achieve this, we had to create a substitutio…
-
Opening balance carry forward not required for Statistical BS accountsSummary: The business is manually entering the Statistical YTD data using data forms in the statistical accounts (having Accounts type as Asset/ Liability) at a custom c…
-
99% subsidiary and indirect holding of 1%Summary: We have multiple use cases where holding company owns 99% in a subsidiary and the remaining 1% is being owned indirectly through another subsidiary. The consoli…
-
Partner Elimination Data doubled if we consolidate only the impacted data levelSummary: Content (please ensure you mask any confidential information): Hi all We have the following scenario. When we use the partnerElimnation rule - all the other rul…
-
SDM Validation Unable to Retrieve FCCS Account Balance ValuesWe are currently facing an issue where, Supplemental Data Management validation process is unable to fetch account balance values from FCCS. Despite having the necessary…
-
Using Conditional Expressions in FCCS Import Format to Handle Empty ColumnsI need to perform an integration in Oracle FCCS where I have a third-party dimension. The issue is that from the source system (NetSuite), the information for this dimen…
-
Disposed entity having contribution from P&L account and OBFXCTAHi All, We are disposing a base entity and sharing under new parent. However, we still see contribution from the disposed entity for P&L and OBFXCTA account. Any idea wh…
-
Best way to handle journals over the year endHi, We have YTD journals which reverse automatically in the next period. In P13 our final period of the year we split the journal into 2 parts, the P&L entries as YTD wi…
-
FCC Looking for meaningful Approval Unit ConfigurationHello Oracle Community, We are currently working on a meaningful security concept in Oracle FCC that also allows us to configure an approval process, that at the end is …
-
How to prevent transfer from CTA to equity plug with IC elimination in the P&L?Summary: We have added multiple IC accounts in the P&L and BS for amongst others (amortization of) internally generated intangible assets as we have internal transfers o…
-
We want to customize subject line for the job status mailWe have Scheduled Jobs in FCCS and we want to customize subject line for the mail of that job status. How can we achieve that?
-
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…
-
Consolidation Job Analytics (25.07 Update in FCCS)We are reviewing What's New FCCS in Jul 2025 in Test environment and noticed that the Consolidation Job Analytics is not available in the Consolidation Settings. Based o…
-
FCCS Approval Hierarchy Setup for Multi-Level Submission (User > Manager > Senior Manager)Hi Team, We are seeking assistance in configuring a structured 3-level approval workflow in Oracle FCCS, tailored to our entity structure and business process. The goal …
-
FCCS - HFM data backup without migrating to FCCSHi We migrated latest 3 years data from HFM to FCCS. What would be ideal way to store historical data from HFM without loading to FCCS ? What is the recommended approach…