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
-
CreateBlock not working in FCCSSummary: Content (please ensure you mask any confidential information): Hi all we have an issue where the function @CREATEBLOCK is not working and we are not sure why th… -
Is it possible to use drill through for flat file integration in FCCS?Summary: Hello, We are performing the flat file data loads in FCCS Data Management. I wanted to know if drill through is supported for flat file Dataloads ? How to confi… -
Request for list of ERP service user 'roles / Privileges' for Direct integrations to FCCSSummary: Hi, Can anyone suggest what the Oracle suggested roles to be assign while creating a Service user in ERP, which we use for ERP to FCCS direct integrations. I ca…
-
Data is coming in a multiply by 14 in target accountSummary: I have written a rule as moving a data in target account from source POV but i am getting 14 time data in target account. Content (please ensure you mask any co…
-
Security QuestionThere is a user who is a part of two groups, one group has write access and the other group has read access on entity ABC. In this case Write access supersedes read acce…
-
Get Plug account data between Sub-ParentsSummary: How to get Plug account data between Sub-Parents. we have hierarchy as below, we want to get plug account balances for cross parents elimination. What is inters…
-
FCCS integration with Microsoft dynamicsSummary: Customer is looking for an option to do direct integration with MSD ( Microsoft dynamics ) - can we utilise integration agent? Content (please ensure you mask a…
-
Tips to improve UI response when executing Business Rules via Data Forms or Rules cards.Summary: This post provides some helpful tips to improve UI responsiveness when executing long running Business Rules via Data Forms or Rules card. Content (please ensur… -
Feasibility of Application level role security access via APITo understand if API for application-level security is exposed by Oracle for FCCS. Currently the provisioning process is manual and does not use APIs for the same. Is th…
-
email notification when an attribute is updated in FCC TaskSummary: As and when an attribute is updated, an email need to be sent to assignee/approver or user related to task Content (please ensure you mask any confidential info…
-
We've successfully run a consolidation; however, the data does not roll up and impacted calculation.Summary: Hi All, We've successfully run a consolidation; however, the data does not roll up, and the calculation status is impacted. What am I missing? Thank you. Regard…
-
Issues with Dynamic Calc Member formulaSummary: I have several accounts with member formulas in the statistical hierarchy of the Account dimension. After validating the formulas, everything appears to be corr…
-
FCCS Task Manager - Using Oracle Cloud Object Storage to Store AttachmentsARCS has functionality to use OCI Object Storage to store attachments. Is this functionality also available for FCCS Task Manager? As we continue to load attachments in …
-
How to not see the opening balance in a separate P&L accountSummary: Content (please ensure you mask any confidential information): Hi all We have a query for which we want to understand how FCCS treats P&L accounts which are in …
-
Issue with the Scheduled JobsSummary: We have scheduled couple of pipeline activities in the jobs within the FCCS PROD application instance, and these same jobs are running in the FCCS DR pod. Howev… -
Pre-filter dimensions in supplemental data managerHi all, we created a list for supplemental data manager, which requires end users to select from different dimensions on each row (entry). Currently, we can only select …
-
How to migrate the custom rules in deployed state?Summary: How to migrate the custom rules in deployed state? and if that is not possible, how to select multiple rules and deploy them at once? Content (please ensure you…
-
how to disable users with user role from making changes in ownership data in FCCS?Summary: How to disable users with user role from making changes in ownership data in FCCS? Content (please ensure you mask any confidential information): Client does no…
-
Using the SmartView Toolkit to connect to HFMSummary: Does anybody have an example using the HypConnect API in Excel to connect to an on premise HFM application? Content (please ensure you mask any confidential inf… -
Supplemental Data's script - DATE_DIFF using MONTH type return incorrect resultThe test case is input Dec 31,2022 (Start Date) and Dec 31,2023 (End Date). Using function DATA_DIFF with "MONTHS" type will return 12.329 (DIFF_MONTH). How does this nu…
-
Query about Consolidation Journal ReportsI have two questions related to Consolidation Journal Reoirts 1)Is there a way we can view the last access/last modification timestamp for Consolidation Journal Reports?…
-
Help design an FR report with descendant function and suppressionSummary: Dear Reporting Experts, Need some help designing a report. Following is the custom dimension hierarchy: RPT_Entities RPT_Entity_1 RPT_Entity_2 RPT_Entity_3 RPT_…
-
User not receiving notification for approving journalSummary: We have a user who is assigned a role of journal approver, in the user preferences we have enabled notifications for Task Lists and in the Administrator setting…
-
Solve order for movement dynamic parentSummary: i am in DSO mode and i am getting wrong result for dynamic parent of movement dimension which is created outside the FCCS_ClosingBalance Hierarchy. Can i assign…
-
Removing the Validate button while creating an Enterprise JournalWe have one "Validate" button in the EJM module which is there before submitting a journal. Is there any option to remove the validation button permanently from EJM modu…
-
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…
-
FCCS Performance test timeoutSummary: We are trying to execute performance test with 500 concurrent ids to login FCCS application with 10 seconds lag for each login, however but it gets timed out wh…
-
FX rates pull from ERP to FCCS - Dimensions mapping questionSummary: I have this request from my client to Pull FX rates from ERP to FCCS application. and am following this document: https://docs.oracle.com/en/cloud/saas/enterpri…
-
@ILvl0Descendants() function extracting Dynamic calc memberWe have DLR to extract numbers from FCC. We have defined @ILvl0Descendants("[Custom1].[Total Custom1]") for Custom1 dimension in source filter and expecting level 0 memb…
-
Consolidation journal flow account entered as YTD_Input is carrying forward to next yearSummary: A consolidation journal was posted with YTD_Input and a new data source created under parent total input and adjusted. Accounts are flagged as flow. For the jou…