Category 143
Discussion List
-
How does FCCS Balance gets calculated if enabled.We need to understand how does FCCS Balance gets calculated, admin guide shows steps how to disable the calculation through configurable consolidation rules. Is it enabl…SagarR 32 views 4 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Minority interest QuestionSummary: Dear All, We have an entity with 95% consolidation. In FY22, the minority interest was calculated on total equity and posted to its parent. However, in FY23, th…VNK 12 views 2 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
How can we ensure intercompany reports reflect the correct parent entities when Parent changedSummary: Hi All, we have below scenario, for example Entities Alpha and Beta were 100% under Parent_One until June 2024. From July 2024 onwards, they are no longer under…VNK 22 views 4 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
FCCS_CTA account data changed after re-consolidation in the prior periodsSummary: We have restructured the Entity Hierarchy with Sub-Parents and re-consolidated all prior periods data, but the FCCS_CTA account shows some variance between now …SenthilSSN 22 views 4 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Issues in Drill thru in Forex and ERP cloudSummary: I am experiencing problems with drilling through forex data. I am utilizing an ERP adapter to extract forex data from the ERP cloud. We have deployed the BI rep…
-
Account with member formula does not aggregate to Top Custom dimensionSummary: I have a Dynamic Calc member with the following member formula in my DSO application: IF (@ISMBR("FA_Fixed")) "COSTot" = "BurdenSGA" + "RegionAllocDiff" + "ICAl…ApOK 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Enhanced ASO Cube Dimensions Table in Activity ReportAs per September 2024 patch update - Enhanced ASO Cube Dimensions Table in Activity Report update has been featured. We want to know how it affects the application & how…PRASANNJEET DAS 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
All Data Extract from FCCSSummary: We want to extract all the data from FCCS to a csv file and are facing challenges. Content (please ensure you mask any confidential information): Hi Experts, Ou…
-
Issue with data retrievalSummary: I have a statistical hierarchy with the following structure: The member formula for the dynamic calc accounts is composed of members from the Primary Balance Sh…ApOK 13 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Inconsistent result possibly due to solve orderHello, I am trying to populate account "Acc1830" with the values of account "Acc1820" using below member formula written on "Acc1830". "Acc1820"->"CP1"->"AC1"->"Total Cu…
-
Is there any way to get behind the system user "frs_epm_prod" to see the actual userSummary: We use a number of data load rules (DLRs) that combine several steps to make the data load process as easy as possible for the users. When these rules are run w…Erringc 22 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can we keep Goodwill offset as a historical account?Summary: In our use case, the Investment and Equity accounts are historical accounts. The child entities are in GBP and the Parent is also in GBP so goodwill is generate…Pooja Jain 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Different job types in Pipeline - how to set variables?I have created a Pipeline with different job types. I have Integration job types on first stage card and Business Rules on second one. On runtime variable I have start p…soile.alm 63 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…Ashok1234 153 views 15 comments 0 points Most recent by Shawn_Paperwala Financial Consolidation and Close
-
Seeking REST API Endpoint for detailed Failure Information on FCCS Data Load Rule ExecutionSummary: When executing the FCCS Data Load Rule via REST API, we are unable to retrieve the exact failure message from the Error Log file. The response JSON from the DLR…dkr_epm1 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Fusion ConsolidationSummary: Fusion Consolidation Challenges_Experts suggestion needed Content (please ensure you mask any confidential information): Business operates across the world and …Kumar 57 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Best process for overrides when there are multiple hierarchies?Summary: We have multiple hierarchies for entity where the parents in the shared hierarchy may have a different currency. Was wondering if there was a solution other tha…Larry Amato 44 views 3 comments 1 point Most recent by Larry Amato Financial Consolidation and Close
-
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…Narinder Arora-162322 51 views 14 comments 0 points Most recent by Narinder Arora-162322 Financial Consolidation and Close
-
Solve Order for Account MembersSummary: I have a statistical hierarchy with the following structure: The base members are dynamic calc with a solve order higher than 58. The formulas calculate correct…
-
How to do common parent elimination using FCCS 50?Summary: We have a requirement to reclass Investment property to PPE on the Sub Consol level. The same should happen basis the common parent elimination approach. FCCS b…Aditya Mehta 67 views 10 comments 0 points Most recent by Aditya Mehta Financial Consolidation and Close
-
Possibility to exclude PL/BS when we run consolidations for Disclosures?Hello, Is it possible to segregate consolidation for PL,BS accounts/Entities and Disclosures accounts/Entities? Here is a business case for such requirements: We usually…Mangesh K 12 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
FCC - Member Formula results do not aggregate up in two dimensionsSummary: I have written some formulae members that do the work as expected. The strange thing is that results do not aggregate up correctly for Custom 1 (Sparse) and Mov…Erik De Rouck 81 views 20 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Map Member in Data IntegrationI can't access dimension data when map membee in data integration because "Unable To Retrieve Members. Either The Target Is Unreachable Or You Do Not Have Permissions" I…Jessican 81 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS recurring journals not availableWe are trying to create recurring journals but they are not available. We just have Standard and Auto-reversal but not recurringSR912 52 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Why are Liabilities seem to be coming in incorrectly in Cash Flow reporting?Summary: Cash Flow reporting for liabilities is not what I expected when liabilities increase Content (please ensure you mask any confidential information): The default …Edwin Ocasio 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…Nkehli 61 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Calculation Status changes to Impacted also for the entities whose base entities are locked.We are unlocking few entities in previous period (Dec-22). Eg. Unlocking only Entity D whose children are Entity E and F. Then recomputing ownership and copying ownershi…SagarR 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…Dharanidharan M 73 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
DM: Data load is taking over 1h to load data when it used to take 30 secondsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where data load from EPM Data Management is taking over 2 hour to load wh…Nkehli 92 views 32 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Error log Limit 1000 linesSummary: EPM has a limit of error lines for importing data into data management which is 1000 lines. We suggest this limit be parameterizable since in many cases informa…David Mata 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close