Category 143
Discussion List
- 
             Inconsistent behavior of data load in FCCHello, We came across strange issue as mentioned below: Using Data Exchange, file based load was done for one of the entity and it is visible in Workbench. But same is n… Inconsistent behavior of data load in FCCHello, We came across strange issue as mentioned below: Using Data Exchange, file based load was done for one of the entity and it is visible in Workbench. But same is n…
- 
             Enterprise Journal setupSummary: We're on the step of creating Target and Journal Templates, how we can handle the attributes? Content (please ensure you mask any confidential information): Ver…User_ZCB13 1 view 2 comments 0 points Most recent by Tim Gaumont-Oracle Financial Consolidation and Close Enterprise Journal setupSummary: We're on the step of creating Target and Journal Templates, how we can handle the attributes? Content (please ensure you mask any confidential information): Ver…User_ZCB13 1 view 2 comments 0 points Most recent by Tim Gaumont-Oracle Financial Consolidation and Close
- 
             Enterprise Journals Webinar, Training & Documentation linksHello everyone, Just wanted to provide a single place for everyone to be able to access all the materials that will help you fully implement and utilize Enterprise Journ…Tim Gaumont-Oracle 105 views 0 comments 1 point Started by Tim Gaumont-Oracle Financial Consolidation and Close Enterprise Journals Webinar, Training & Documentation linksHello everyone, Just wanted to provide a single place for everyone to be able to access all the materials that will help you fully implement and utilize Enterprise Journ…Tim Gaumont-Oracle 105 views 0 comments 1 point Started by Tim Gaumont-Oracle Financial Consolidation and Close
- 
             System ratio calc impact on consolidation timeSummary: On analysing our consol performance we spotted that the system ratio calc appears to have an impact on consol times Content (please ensure you mask any confiden…Jeremy Stubbs 11 views 2 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close System ratio calc impact on consolidation timeSummary: On analysing our consol performance we spotted that the system ratio calc appears to have an impact on consol times Content (please ensure you mask any confiden…Jeremy Stubbs 11 views 2 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close
- 
             Opening Balance not coming for entity member when shared under newly created alternate hierarchyHi, We have shared a child member(W175) in newly created alternate hierarchy(W175 Consol) in Aug-FY24. We can see that the Opening Balance is not getting populated. Scre…T Hussain Kumar 41 views 3 comments 0 points Most recent by T Hussain Kumar Financial Consolidation and Close Opening Balance not coming for entity member when shared under newly created alternate hierarchyHi, We have shared a child member(W175) in newly created alternate hierarchy(W175 Consol) in Aug-FY24. We can see that the Opening Balance is not getting populated. Scre…T Hussain Kumar 41 views 3 comments 0 points Most recent by T Hussain Kumar Financial Consolidation and Close
- 
             Restore Backup without having the LinkOwnershipandDataLocking Substitution variableSummary: We have the Artifact backup when we don't have the LinkOwnershipandDataLocking Substitution variable set as False. When we try to restore that backup, currently…Kirti 11 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close Restore Backup without having the LinkOwnershipandDataLocking Substitution variableSummary: We have the Artifact backup when we don't have the LinkOwnershipandDataLocking Substitution variable set as False. When we try to restore that backup, currently…Kirti 11 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
- 
             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 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 11 views 2 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 11 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 21 views 4 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 21 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 21 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 21 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… 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 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close 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 11 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 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…Aditya Mehta 158 views 13 comments 0 points Most recent by Eddie F 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 158 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 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle 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 11 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… 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 21 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close 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 21 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 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 61 views 11 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 61 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 11 views 2 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 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 23 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 23 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 41 views 3 comments 1 point Most recent by Larry Amato 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 41 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 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… 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 81 views 10 comments 0 points Most recent by Aditya Mehta Financial Consolidation and Close 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 81 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 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle 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 11 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 51 views 9 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 51 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 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
- 
             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 11 views 3 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 11 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 71 views 13 comments 0 points Most recent by NarayananS 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 71 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close