Category 143
Discussion List
-
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 17 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 27 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 27 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 17 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 25 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…Aditya Mehta 206 views 13 comments 0 points Most recent by Eddie F Financial Consolidation and Close -
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 16 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 26 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 37 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 66 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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 15 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 25 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 47 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 57 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 96 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…MKhade 14 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-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 55 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 14 views 2 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 18 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 77 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…NKW 97 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 40 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can FCCS perform consolidations with 2 segmentsSummary: Can FCCS perform consolidations with 2 segments (primary and secondary balancing segment from Fusion cloud ERP) Content (please ensure you mask any confidential…Garry_Lee 30 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close -
Integration execution failed, Outline load finished with errors.Hi, I am trying to import data using data integration. Once I have run the integration. I am getting this error in log "Outline load finished with errors" Here is the lo…Noah01010101 181 views 10 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
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…Sirisha_Snap 33 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
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…SenthilSSN 27 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
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…Anand Rasa 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close