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 …
-
FCCS Movements_Disposals with Eliminations are created after entity is set to No consolidationTeam, We have a strange issue. In March enterprise journals were enabled in FCCS and the EJ’s were being submitted from FCCS to Oracle fusion and again being loaded to F…
-
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…
-
FCCS shared entity data roll-up prospective basisSummary: Hi, In FCCS entity Hierarchy, we have an requirement where in balances for a shared base node(E1) should rollup data only to Parent1 but not Parent2 on prospect…
-
Options for Discontinuing an Entity in FCCS Without Ownership ManagementHi All, I'd like to understand the available options for discontinuing an Entity in FCCS when Ownership Management is not enabled. Specifically, is there a way to tag an…
-
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.
-
Changes to consolidation methods for EOBPHello experts, We do not have "Inactive" entities in our setup as of now and we use "Not Consolidated" methods for active entities which should not be consolidated to th…
-
Is there any EPMautomate command to update period mappings in FCCS?Summary: Clients wants to update the period key under period mapping for one of the target application on everyday basis. They also want it to be automate. How can we do…
-
Best Practice for removing data (prior years) in FCC Cloud; changing the initial "seeded" yearSummary: Our FCC application was initially created using September 2018 as the "seeded" year for the purposes of RE. We need to change that to September 2022; thereby cl…
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…
-
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!
-
Groovy Helper Rules to Execute Data Integration and PipelineSummary: Attached helper Groovy business rules to help execute a Data Integration and a Data Integration Pipeline. Please feel free to customize as required. Content (pl… -
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…