FCCS Exam Questions with Complete Solutions. Latest Update 2024, Exams of Nursing

Download FCCS Exam Questions with Complete Solutions. Latest Update 2024 and more Exams Nursing in PDF only on Docsity! 1 [Date] FCCS Exam Questions with Complete Solutions. Latest Update 2024 . In Financial Close Manager, when would you choose to define tasks in a Template rather than create a new Schedule each month? when the tasks are repeatable over multiple close cycles when the tasks require consistent definition across close schedules when the tasks are often late in completion and they need to be monitored more closely when the tasks require multiple levels of approvers - answers>A. when the tasks are repeatable over multiple close cycles Which role can the "Approvals Supervisor" perform? A)They can start and stop a planning unit B)They can start and stop a planning unit and take any action on a planning unit C)They can start but not stop a planning unit D)They cannot stop or start a planning unit but can only give approval - answers>B) They can start and stop a planning unit and take any action on a planning unit Which two data extract export file types are available within Financial Consolidation and Close (FCCS)? (Choose two.) DAT file type Excel XLS file type 2 [Date] Comma delimited Tab delimited - answers>C. Comma delimited Tab delimited When creating a member mapping for account Sales in Data Management, the following script is entered. UD5 refers to a Product custom dimension: WHEN UD5 LIKE 'CAR_%' THEN 'AUTO_SALES' ELSE 'SALES' Which statement is True? The script can be eliminated by using a multi-dim map on the Product dimension that also looks for the account Sales. B. The script will work if the script is referenced in the In mapping type with #SQL as the target. C. The script will not work since Data Management does not support scripting. D. The script will not work since the UD5 member referenced does not start with FCCS_ E. The script will work if the script is referenced in the Explicit mapping type with #SQL as the target. - answers>B. The script will work if the script is referenced in the In mapping type with #SQL as the target. P, Q, and R are children of a mid-level parent entity, AceCo. In February each entity has cash in the amounts of 10, 20, and 30, respectively, and AceCo has been consolidated and has cash of 60. A prior period adjustment to Q adjusts cash with a debit of 5. Which statement regarding consolidation is correct? 5 [Date] E. provide the ability to collaborate during close and analyse transaction detail in real time - answers>A. robust consolidation engine that provides automated aggregations, intercompany eliminations and translations without requiring a strong IT footprint D. a configurable reporting solution with prebuild dimensions, KPIs, reports along with a process to adjust data, monitor the close status and view data and compliance results in dashboards Which two prebuilt calculations run on the Movement dimension to determine CTA by account? A)Prior Average Rate minus Current Average Rate multiplied by FCCS_Mvmts_Subtotal B)Prior Ending Rate minus Current Ending Rate divided by FCCS_Mvmts_Subtotal C)FCCS_OpeningBalance multiplied by Ending Rate minus FCCS_OpeningBalance carry forward D)FCCS_Mvmts_Subtotal multiplied by Ending Rate minus FCCS_Mvmts_Subtotal multiplied byAverage Rate - answers>C) FCCS_OpeningBalance multiplied by Ending Rate minus FCCS_OpeningBalance carry forward D)FCCS_Mvmts_Subtotal multiplied by Ending Rate minus FCCS_Mvmts_Subtotal multiplied byAverage Rate When creating a Financial Consolidation and Close (FCCS) application, which initial Multi- Source data options can be selected? A)Supplemental Data B)Data Management C)ERP Cloud 6 [Date] D)ERP R12 - answers>A)Supplemental Data B)Data Management How is drill-back enabled to Supplemental Data Manager (SDM) from the Supplemental Data member within the Multi-source dimension? Drill-back to SDM is not an available feature. Droll-back is available from any Multi-source dimension member by default, know the source of the origination data load. C. By selecting Track Multi-source Data Input option for Supplemental Data during the application creation process. D. By selecting Track Multi-source Data Input option for Other Data during the application creation process. - answers>B. Droll-back is available from any Multi-source dimension member by default, know the source of the origination data load. When you set the Intercompany Account Attribute Value to Yes, which additional attribute must also be set? Plug Account Intercompany Account Is Plug Account Intercompany Entity - answers>A. Plug Account 7 [Date] A company has two subsidiaries with 1000 EURO each in the Cash account. Which four Consolidation Members will reflect 2000 EURO at the company's balance? (Choose four.) FCCS_Elimination FCCS_Proportion FCCS_Entity Input FCCS_Entity Consolidation FCCS_Entity Total FCCS_Contribution - answers>B. FCCS_Proportion D. FCCS_Entity Consolidation E. FCCS_Entity Total F. FCCS_Contribution When a Financial Consolidation and Close (FCCS) application was created, no intercompany options were enabled. Which statement is true? The FCCS_No Intercompany member of the ICP dimension will be used for all data. Data can be stored by intercompany partner but no eliminations will occur. An extra custom dimension will be available. The ICP dimension will be omitted. - answers>D. The ICP dimension will be omitted. 10 [Date] C)fUSE Metadata Editor D)SmartView F)Classic metadata editor What is the primary function of enabling the Track Intercompany Elimination option during the application creation? enables the Elimination member in the Consolidation dimension process will separate total elimination values by Data Source. enables the application to include Intercompany data. enables the application to perform Intercompany eliminations - answers>B. process will separate total elimination values by Data Source. By default, security access is set to "None" for which three dimensions? (Choose three.) Movement Data Source Account Entity Year - answers>B. Data Source C. Account D. Entity 11 [Date] In which two instances will the FCCS_Mvmts_FX_to_CTA movement member populate in a translated currency? Movement of FX impact for historical rate accounts to the FCCS_CTA account A variance in the Average rate and the Ending rate The current FCCS_CTA account balance does not change from the prior period The account is FCCS_Net Income - answers>A. Movement of FX impact for historical rate accounts to the FCCS_CTA account The account is FCCS_Net Income What type of attribute would you change to make an account translate at a historical rate? A)Data Type B)Data Storage C)Exchange Rate Type D)Account Type - answers>C) Exchange Rate Type Which components are pre-built into Financial Consolidation and Close Cloud Service to provide a configurable and scalable consolidation solution? pre-built integration to combine narrative and data to produce both internal and external reporting packages B. calculations, dashboards and reports to provide analysis for cash flow modeling 12 [Date] C. calculations, dashboards and reports as well as derailed data source tracking and an automated cash flow D. calculations, dashboards and reports built on planning frameworks to provide cash flow planning - answers>C. calculations, dashboards and reports as well as derailed data source tracking and an automated cash flow Which item describes the use for the Currency dimension property Triangulation Currency? The ability to force translations The ability to report in multiple currencies The ability to calculate foreign exchange rates The ability to calculate CTA (Cumulative Translation Adjustment) The ability to input foreign exchange rates - answers>C. The ability to calculate foreign exchange rates Financial Consolidation and Close Cloud Service (FCCS) provides a consolidation path through which dimension combination? Consolidation, Currency, Account Currency, Account, Movement Entity, Consolidation, Currency Entity, Currency, Account - answers>B.Currency, Account, Movement Which statement is false regarding establishing security for Financial Consolidation and Close (FCCS)? 15 [Date] E. Entity Currency F. Parent Currency An entity's Common Stock balance is made up of data loaded through Data Management and an adjusting journal entry posted in the application. The Common Stock balance must not re- translate each month. What two data entries need to happen to have the Common Stock balance bypass the default translation of equity accounts? (Choose two.) Data entry to the Common Stock account with the FCCS_Amount Override member of the Consolidation dimension and the Data Source member FCCS_Managed Data. B. A journal entry to reverse the adjusted Common Stock balance with the Data Source member FCCS_Journal Input. C. A journal entry to the Common Stock account with the FCCS_Amount Override member of the Consolidation dimension and the Data Source member FCCS_Journal Input. D. Data entry to the Common Stock account with the Multi-GAAP FCCS_Adjustments member and the Data Source member FCCS_Data Input. - answers>A. Data entry to the Common Stock account with the FCCS_Amount Override member of the Consolidation dimension and the Data Source member FCCS_Managed Data. C. A journal entry to the Common Stock account with the FCCS_Amount Override member of the Consolidation dimension and the Data Source member FCCS_Journal Input. If the Common Stock of an entity is translating at an historical rate from prior year, what occurs if there is current period activity and no rate specified for the current activity? 16 [Date] A)The new Common Stock balance will remain at the same translated rate as the prior period B)The Common Stock current activity will translate at the historical rate in place from the prior year C)The Common Stock current activity will translate at the current Ending Rate D)The Common Stock current activity will translate at the current Average Rate - answers>D)The Common Stock current activity will translate at the current Average Rate Which two members of the Consolidation dimension cause the standard foreign currency translation rules to be ignored? (Choose two.) FCCS_Amount_Override FCCS_Rate Override FCCS_Contribution FCCS_Proportion FCCS_Elimination FCCS_Translation - answers>A. FCCS_Amount_Override B. FCCS_Rate Override Which statement is true regarding shared members and valid intersection rules? Shared members are supported in valid intersection rules If a shared member is selected for a valid intersection rule, then the base member is not included 17 [Date] in the rule C. If a base member is included in a valid intersection rule, then any shared member is not included in the rule D. Shared members are not supported in valid intersection rules - answers>A. Shared members are supported in valid intersection rules Which statement correctly describes what happens to parent entities during consolidation? From each child of the entity, data from the FCCS_Contribution Consolidation dimension member is added together and stored in the FCCS_Entity Consolidation member of the entity. B. The changes in the relational database are synced to the underlying Essbase cube. C. Since parent entities are tagged as dynamic calc, the consolidation has no effect on the entity dimension. D. The data in the FCCS_Intercompany Eliminations Data Source dimension member is subtracted from the FCCS_TotalInputAndAdjusted Data Source dimension member for each descendant and then added together. - answers>A. From each child of the entity, data from the FCCS_Contribution Consolidation dimension member is added together and stored in the FCCS_Entity Consolidation member of the entity. When creating an application in Financial Consolidation and Close (FCCS), what Time Periods sections can be made? Any number of months can be selected 20 [Date] Which dimension includes the FCCS_Global Assumption member that is used to store currency information? Account From Currency Entity Currency - answers>C. Entity Which statement correctly describes when a consolidation can occur within a given year/scenario? An administrator runs Force Consolidate to force the consolidation of all entities regardless of status or content. B. The current period consolidation status is Impacted and the remaining periods are OK. C. A user has a power user access but only write access to the entity. D. A user with power user access first locks the entity so that other users cannot consolidate the same entity. E. The user specifies the desired parent entity, Feb as the period, Actual as the scenario, and 2018 as the year. - answers>C. A user has a power user access but only write access to the entity. When is a user most likely to have a need for running a consolidation for the current close period? A)The status of FCCS_Total_Geography is No Data 21 [Date] B)After the financial statements have been approved C)After the period has been closed for posting FCCS journals D)After subledgers have been closed in the ERP and loaded to FCCS - answers>D)After subledgers have been closed in the ERP and loaded to FCCS Which two statements explain why data would not be the same for the Consolidation dimensionmembers FCCS_Entity Input and FCCS_Proportion for an entity? A)A member formula calculated a proportion B)An intercompany elimination was performed C)The level zero descendants of the entity have data D)An ownership percentage other than 100 was entered E)The parent entity has a different currency than the child F)A rate was entered into the FCCS_Rate Override account - answers>C)The level zero descendants of the entity have data D)An ownership percentage other than 100 was entered What is the correct Currency dimension member to select when running an Intercompany Matching Report? Input Currency Reporting Currency Entity Currency 22 [Date] Parent Currency - answers>B. Reporting Currency Which statement is correct regarding maintenance of the intercompany dimension? A)All level zero members of the Entity dimension automatically show on the Intercompany dimension B)Adding a member to the ICP dimension that does not exist as a member in the Entity dimension is not possible C)Deleting a member from the Entity dimension that is tagged as intercompany will leave the member in the ICP dimension. D)Adding a member to the Entity dimension and tagging it with the ICP_Entity_Yes attribute will add the member to the ICP dimension as a child of FCCS_Intercompany Top. - answers>C)Deleting a member from the Entity dimension that is tagged as intercompany will leave the member in the ICP dimension. Which two are components of default currency translation? A)The periodic activity of a revenue account is used to translate the balance at the AverageRate B)The year to date balance of a revenue account is translated at the Average Rate C)CTA (Cumulative Translation Adjustment) is calculated by the movement in the AverageRate D)CTA (Cumulative Translation Adjustment) is calculated by the difference between thecurrent Average Rate and prior month's Average Rate E)The periodic activity for an asset account is translated at the Average Rate - answers>A)The periodic activity of a revenue account is used to translate the balance at the AverageRate E)The periodic activity for an asset account is translated at the Average Rate 25 [Date] A)Entity is always included in a data set B)Entity is an optional inclusion in a data set C)Dimension attributes can be included in a data set D)Only administrators can create and update data sets E)Only administrators or power users can create and update data sets - answers>A)Entity is always included in a data set E)Only administrators or power users can create and update data sets Using which Smart View reporting method can users retrieve data from a Financial Consolidation and Close Cloud application data with formulas such as HsGetValue? A)Function Builder B)Adhoc query C)Smart Forms D)Smart Slices - answers>A)Function Builder Which statement about Financial Close Manager Schedules is False? A)To start all the tasks in a schedule to run you must set the status from Pending to Open B)Once a schedule is Locked, it can't be reopened C)Users can still complete tasks once a schedule has been closed 26 [Date] D)You can still add tasks once a schedule has been closed - answers>D)You can still add tasks once a schedule has been closed When creating a task type, what type of task requires a parameter? A)A basic task with a question and rule B)A Financial Consolidation and Close Cloud integrated task requiring no point of view selection C)A task that integrates with an external application and requires a year and month input D)A parent task that provides a roll-up of base tasks - answers>C)A task that integrates with an external application and requires a year and month input In data sets, why might an attribute NOT be able to be used in a workflow? A)Metadata is not set up correctly B)Key Identifier On is not selected C)You can only assign a workflow if the account is a balance sheet type D)The Entity selection is not in your data set - answers>B)Key Identifier On is not selected What member of the Currency dimension is associated with the Entity Input member of the Consolidation dimension? Base Currency Parent Currency Local Currency Entity Currency - answers>D. Entity Currency 27 [Date] You have added a new task to a close schedule with a task due date past the defined end date of the schedule. What is the result of the change? The new task will run outside of the schedule end date. An error, you can't add a new task past the due date. The schedule end date changes to match the end date of the task. The task will not run. - answers>C. The schedule end date changes to match the end date of the task. Which is true behavior of default FCCS_ members within an application? You can change the default FCCS_ member prefix at application creation. You can change the Alias of these default FCCS_ members at any time. You can change the Name of these default FCCS_ members at any time. You cannot change the Alias of these default FCCS_ members. - answers>B. You can change the Alias of these default FCCS_ members at any time. Which four sample ratios can be created during the application creation process? (Choose four.) Inventory Ratios Contribution Margin Debt Ratio 30 [Date] C. Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_1 D. Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1 - answers>D. Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1 Which three key requirements does the Financial Consolidation and Close Cloud Service (FCCS) deliver to ensure a modern consolidation and close solution? (Choose three.) Ensure security of sensitive data. Integrate with source systems. Provide predictive analysis and modeling. Provide a strong compliance framework that includes auditing and segregation of duties. - answers>A. Ensure security of sensitive data. B. Integrate with source systems. D. Provide a strong compliance framework that includes auditing and segregation of duties. What can the Intercompany Dimension be enabled and made visible within your application? after application creation by selecting any Account as IC_Acc_Yes for the Intercompany Account attribute B. during application creation and selecting the Intercompany Data feature option C. after application creation by selecting any Account as IC_Acc_Yes for the Intercompany Entity attribute 31 [Date] D. during application creation and selecting the Multi-source Data Input of Other Data - answers>B. during application creation and selecting the Intercompany Data feature option A company would like to capture Fixed Asset additions and disposals within the Movement dimension. Which three tasks are necessary to achieve this goal? (Choose three.) Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals B. Add custom members for Additions and Disposals as dependents of FCCS_Mvmts_CapitalExpenditures. C. Load detailed Fixed Asset data to Movement members. D. Add custom Movement members to the FCCS_CashFlow hierarchy. E. Create a Roll Forward in the account dimension. - answers>A. Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals D. Add custom Movement members to the FCCS_CashFlow hierarchy. C. Load detailed Fixed Asset data to Movement members. PQR Hickory H1 H2 Paducah P_1 P_2 PQR Company has the ownership structure shown above. 32 [Date] If H_1 lends money to P_2, the intercompany elimination of H_1's receivable occurs as data from Hickory consolidates into PQR. What is this principle called? First common parent Generation 0 First order relation Lowest common denominator - answers>A. First common parent Which two statements are correct with regard to Data Management locations? (Choose two.) A company with three instances of Oracle EBS R12 should only use one location to maintain proper accounting controls. B. Location security allows users to be provisioned in Shared Services for read or modify access to each location. C. Locations can share dimension member mappings by specifying a location as a parent location of others. D. The logic account group is required in order to effect running of calculations after the data load. E. Locations must specify an import format, which may be used by other locations. F. Data load rules can be shared across locations. - answers>C. Locations can share dimension member mappings by specifying a location as a parent location of others. 35 [Date] C. FCCS_Intercompany Eliminations If the Alias of an Entity that marked as "Is Intercompany" and is later changed, what happens to the corresponding Intercompany member Alias? The Intercompany Alias is set to the Entity Name. The Intercompany Alias is automatically changed to the new Entity Alias. The Intercompany Alias is not automatically changed to the new Entity Alias. The Intercompany Alias is automatically set to the Intercompany Name. - answers>C. The Intercompany Alias is not automatically changed to the new Entity Alias. In which two scenarios will the system copy balances to the Reporting Currency? A)Parent Currency matches Reporting Currency B)Entity Currency matches Parent Currency C)Entity Currency matches Reporting Currency D)The Reporting Currency is the triangulation currency - answers>A)Parent Currency matches Reporting Currency C)Entity Currency matches Reporting Currency A new Sheet tab in Excel is copied from an existing tab that contains a Smart View query, but clicking Refresh does not refresh the data and the Smart View (Point of View) POV bar does not display. Which additional step is required to pull data in the new tab and change the POV? Disconnect from the Smart View connection, and relog in. 36 [Date] Activate the Connection. Close out of Excel, and relog in to Smart View. Change one of the Row or Column dimension members and click Refresh. - answers>B. Activate the Connection. Which explains why the Currency dimension does NOT display in your application? Security access to the Multi-GAAP dimension is required Multi-Currency option was not selected at application creation Entity-specific security rights were not properly granted Security has not been granted - answers>B. Multi-Currency option was not selected at application creation Which three tasks can users perform on Financial Consolidated Close Cloud data with Smart View in Excel? (Choose three.) Submit data Adjust data with Journals Retrieve data Run a rule such as Consolidate or Translate - answers>A. Submit data C. Retrieve data D. Run a rule such as Consolidate or Translate 37 [Date] When designing a report in Financial Reporting Studio, which item is NOT an insert-able report object? Chart Grid Image Header - answers>D. Header Which three fields must be defined when registering a file-based source system in Data Management? (Choose three.) Source Type Drill URL Cloud Type Description Name - answers>B. Drill URL D. Description E. Name Which four statements are true about the members in the FCCS_Cash Flow hierarchy in the Movement dimension? (Choose four.) The Cash Change hierarchy cannot be modified. 40 [Date] You build an alternate hierarchy by using partial share Entity members. When data is posted to one shared entity, the data is posted to all instances. - answers>B. The Data Storage Member Property must set to "Dynamic Calc". For which three tasks can Data Management be used? (Choose three.) loading data that is period-to-date or year-to-date drilling through from a web form or Smart View loading data from a fixed width or delimited text file writing back data to source systems loading a Metadata Import File - answers>A. loading data that is period-to-date or year-to-date B. drilling through from a web form or Smart View C. loading data from a fixed width or delimited text file When setting an account property to a data storage type of "Dynamic Calc" which two are allowed? Member Formulas cannot be created load data to this account and make member formulas load data to this account create Member Formulas - answers>D. create Member Formulas 41 [Date] Which three combinations of dimensions could be valid for a Financial Consolidation and Close (FCCS) application? (Choose three.) Period, Year, Entity From Currency, Movement, Scenario Multi-GAAP, Data Type, Intra-company Value, Entity, Account Data source, Consolidation, View - answers>A. Period, Year, Entity B. From Currency, Movement, Scenario E. Data source, Consolidation, View Three child entities - P, Q, and R - of a mid-level parent entity - AceCo - have acco unt receivables in the amounts of 10, 20, and 30, respectively. Which statement contains conditions for all three entities that would cause the account receivable balance amount at AceCo not to be 60? P has the same currency as AceCo, Q is 100% owned, and R has 10 of the 30 as an intercompany receivable balance with another division that is not a descendant of AceCo. B. P has the same currency as AceCo, Q is 90% owned, and R has 10 of the 30 as an intercompany receivable balance with another division that is not a descendant of AceCo. C. P has a different currency than AceCo, Q is 40% owned, and R has 10 of the 30 as an intercompany receivable balance with Q. 42 [Date] D. P has a different currency than AceCo, Q is 100% owned, and R has 10 of the 30 as an intercompany receivable balance with Q. - answers>B. P has the same currency as AceCo, Q is 90% owned, and R has 10 of the 30 as an intercompany receivable balance with another division that is not a descendant of AceCo. Which three scenarios result in foreign currency translation during the default consolidation process? (Choose three.) A base entity currency has a parent entity with a matching default currency. A base entity currency has a parent entity with a different default currency. A parent entity has the same default currency as its parent. A parent entity has a different currency from its parent. A shared entity has a parent with a different currency. - answers>B. A base entity currency has a parent entity with a different default currency. D. A parent entity has a different currency from its parent. E. A shared entity has a parent with a different currency. Which four types of artifacts are able to have artifact level security set up on them (choose 3) Forms Task lists Journals Reports Smart Lists Member Lists - answers>A. Forms B. Task lists C. Journals D. Reports