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
-
Plug account calculation despite both booking same valueHi everyone This is wrt Intercompany eliminations. Entity structure is such that consolidated entity is using HKD and its child who are intercompany partners to each oth… -
No translation or incorrect translation in one particular account codeBalance sheet is not tallied in parent currency at entity consolidation and entity total members. We have identified that it is due to translation, system is not transla…
-
The delete operation failed as the member XXXX is referenced in the applicationUnable to delete member stating " The delete operation failed as the member XXXX is referenced in the application", it is not used anywhere in application: Rules, Valid …
-
FCCS intercompany elimination within the same entitySummary: We all know that the intercompany transaction is happening between two different companies to perform the elimination. However, is there a way to do it within t…
-
26.04 Update Feature Audit Changes to Documents and Report ArtifactsSummary: New 26.04 Feature Audit Changes to Documents and Report Artifacts - the audit log does not provide the name of report for which content was modified. Is there s… -
Clarification on “Exported Text Type Cell Data” in Latest Oracle EPM Patch Update for FCCSHello Community, I noticed that the latest Oracle EPM patch for Financial Consolidation and Close Cloud Service (FCCS) includes an enhancement related to “Exported Text …
-
Error message when in journals card: Exception encountered while creating/updating dynamic tabSummary: A user keeps on getting the message "exception encountered while creating/updating dynamic tab" when they are in the FCCS Consolidation Journals card. This mess…
-
Metadata Repair UtilitySummary: Utility to help determine metadata out of sync issues. Content (please ensure you mask any confidential information): Attached video explains Metadata Repair Ut…
-
FCCS custom report to dynamically pull data where an Entity has ICP transactions with itselfIs there a way to create a custom report in FCCS to dynamically pull all such lines where an Entity has ICP transactions with itself ( Intracompany transactions)? We cur…
-
Copy / Recompute Ownership via REST-APISummary Is it possible to do a copy of ownership data and/or a recompute of the ownership data via REST-API?Content Hi all, I'm just trying to automate some things to ge… -
GroovySummary: Hi We have a requirement of reading a control file which will contain No of records Summation of Amount Unique Account count Unique Entity count Is it possible …
-
Substitution Variable in FCCS Forms Showing Alias Instead of Member Name in Smart ViewHello, We are using a substitution variable for the Entity dimension in FCCS forms. In the POV within the application, we can choose the entity from the member name. How…
-
Need Groovy script to execute Validate Metadata, and Recompute Ownership Data in FCCSSummary: Hi I need two separate groovy scripts as follow: Groovy script to execute Validate Metadata (Application→Overview→Action→Validate Metadata→Run). Groovy script t…
-
FCCS cannot consolidate dollar overrides over multiple levelsSummary: We are currently implementing FCCS at a company with 1000+ entities and many levels in the entity hierarchy. Based on other ideas and our vendor feedback there …
-
Creating replica of a cube with same members with unique description and aliases.Summary: There is a client requirement in which as per regulatory existing cube needs to be restructured as new compliance in which the metadata members structure should…
-
Loading the data into FCCS_NoMovementSummary: We are Loading the data in "FCCS_No Movement" which is translation the average rate instead of Ending Rate. those accounts are Balance Sheet accounts. ERP data …
-
FCCS Forms YTD Input Accumulation Issue When Months Entered Out of SequenceIn FCCS, YTD input forms are designed to accumulate values across months. This works correctly when data is entered in chronological order (January → February → March, e…
-
Is there any way to extract the DLR list from FCCS?How can I extract the DLR list / Data Integration Names from FCCS?
-
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…
-
Create a validation in Data ExchangeWe have a requirement to create validations on source files in Data Exchange. FCCS will receive two files in Data Exchange from each country unit (one individual locatio…
-
Viewing Historical Process IDs in Oracle Data ManagementSummary: Hello, We are currently experiencing an issue with one of the Oracle Data Integration process IDs. Example: Process ID 1627 was used during yesterday's integrat…
-
Not able to copy ownership data from FY 26 to FY 27 for forecast scenarioSummary: Not able to copy ownership data from FY 26 to FY 27 for forecast scenario Content (please ensure you mask any confidential information): requirement is to enabl…
-
Use epmautomate to generate user group report?Hello, Is there a way to use epmautomate to download user group report? Or is this only accessible via web UI?
-
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…
-
Dynamic scaling in reportsSummary: We have customers who would like to be able to choose the scaling in reports at runtime (as there are different requirements for different purposes). Fiscally t… -
Enterprise journal Approval WorkflowSummary: We have a detailed Enterprise Journal authorization policy with multiple approval bands (e.g., Band 4, Band 5, Band 6), driven by the following logic: Different…
-
Attribute Member aggregation in YTD viewSummary: Hi all, We're looking to Set up Attribute dimension members in our Account dimension to support reporting on exception / non-exception items. I.e. Create a P&L …
-
How to define consolidation method bands to include control and overlapping ownership %Summary: Is there a way to define the consolidation method bands such that the ownership percentage overlaps but the methods are driven by control? For example we would …
-
Application Role Reports-Manage is only showing Copy URL in Action menuSummary: Power users need the ability to edit reports so were assigned Reports-Manage. According to the Oracle documentation this should give them the ability to Add, ed…
-
SmartView Refreshable Report giving #value and Incorrect free form - column dimension on Row.. errorSummary: We have a SmartView refreshable report, some users are able to refresh the values properly in their system. But few users are not able to refresh the values and…