Category 143-2
Discussion List
-
EPM FCCS calculation: Rule fails with the error message: Cannot use restricted dimensions: "ENTITY"Requirement: 1. Data available in Entity ABC with ICP_XYZ. 2. We want to copy the same account data to the entity XYZ and ICP_ABC. The rule fails with the error message:…Saran Kandasamy - EPM Cloud 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
SmartView formula 'HsDescription' is not yielding result on the Fusion GL SideSummary: We are using Build Function > HsDescription to show Natural Account Description. However it is not working for us. Does it work on the Fusion Side. Reference : …Wilson Chelakadan 14 views 0 comments 0 points Started by Wilson Chelakadan Financial Consolidation and Close -
Migration errorsWhen we imported snapshot from FCCS test to production [25.11.72 both test and production] We see following errors in Failure message in Migration status report in Tools…Amara Sai Sandeep 21 views 3 comments 0 points Most recent by TechM-GJ Financial Consolidation and Close
-
Is there REST API or another non-interactive way to change connection details under Data ExchangeSummary: Is there REST API or another non-interactive way to change connection details under Data Exchange in EPM? After each clone from Prod to non-Prod and after nativ… -
HSGetVals/HSSetVals functions exceeded the threshold for a single workbook errorSummary: Receiving HSGetVals/HSSetVals functions exceeded the threshold for a single workbook error when trying to refresh worksheet in FCCS. Is there a workaround other…LSN_CE 21 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Issue running ODR for entities with a member functionHi All. I am creating an On Demand Rule in FCCS. When created the ODR rule has created automatically prompts for the members of the Entity Dimension (as well as others).…Brian Somers 165 views 22 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 37 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Expected behavior of approval workflow ( Pre Holiday question - Urgent ! )Summary: Trying to understand expected behavior of Approval Workflow Content (please ensure you mask any confidential information): Dear Experts, I would appreciate your…TechFalcon 28 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Calculate flux amount for p&l account by entity in fccs reportsSummary: Hi All, We have a requirement to calculate the flux (current year vs prior year) for P&L account. However it is working for BS account but not for P&L. We also …
-
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 95 views 12 comments 0 points Most recent by User_2NNLR Financial Consolidation and Close
-
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…B.Bhandari 20 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Task RulesSummary: We'd like to set up some task rules to facilitate conditional workflow. Example: A task has an Assignee and Approver 1. It also has an attribute we added for am…
-
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…
-
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 64 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 34 views 3 comments 0 points Most recent by Deepesh Bohra-Oracle 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 52 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Blank report + grid error when changing Movement via Grid POVHello, We have a report that contains two grid POVs, where the Movement member can be changed individually for each grid. Some users are experiencing issues when opening…Patrick Pontillas 30 views 3 comments 0 points Most recent by SR912 Financial Consolidation and Close
-
pallet pickSummary: In Our business, for Movements Request of WMS, after wave is run LPNs are allocated and we palletize all the allocated LPNs when it is picked from general use t…Akshita Manne 14 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we export exchange rates using with Groovy script (writing in Console Cube)Summary: Can we export exchange rates using with Groovy script (writing in Console Cube) Content (please ensure you mask any confidential information): Version (include …Srinath.M 39 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 49 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 36 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS MR: Is there a way to disable or lock the Grid POV ellipsis to prevent invalid POV selections?I am working on a Management Report in FCCS that uses a Global POV and two grids, each with its own Grid POV containing specific hardcoded members except the Movement di…Patrick Pontillas 24 views 5 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close
-
FCCS Report Bursting FunctionalityWe have been testing the bursting functionality but are unable to get the report to display the alias automatically when using bursting. Is there a way we can use the "A…MehryaarAnwar 76 views 10 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 19 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
SSO in Smart View not working?I have a user who can log in to the application without issues, but when she tries to access Smart View in Excel, the login prompt appears. After she clicks the SSO butt…Patrick Pontillas 19 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we filter the data in reports based on smart list member?Summary: I am preparing one report where i am using smart list. I have smart list member created like - Bank Overdraft,Term Loan, Lease Liabilities and i am recording va…Chakresh 52 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to upload file in inbox/outbox folder using EPM REST APISummary: I am looking to upload a file in inbox/outbox folder using REST API. The Upload (oracle.com) command doesn't seem to be working for me. Below are the links I tr…Avinash Roy 134 views 6 comments 0 points Most recent by Sucharitnarang Financial Consolidation and Close
-
Datedifference formulae function in FCCS ReportsI want to calculate a days difference between 2 dates in fccs reports by the datedifference function available in FCCS reports, I have already used the multiple combinat…Chakresh 62 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Task Manager - is it possible to customize view when opening task?Summary: User is wondering if it's possible to change the default drawer that is opened when opening a task. Content (please ensure you mask any confidential information…