Download FCCS Practice Exam Questions and Answers: A Comprehensive Guide for 2024 and more Exams Biology in PDF only on Docsity!
FCCS Practice Exam Q/A | 100% Correct
Answers | Verified | Latest 2024 Version
- In Financial Close Manager, when would you choose to define tasks in a Template rather than create a new Schedule each month? A. when the tasks are repeatable over multiple close cycles B. when the tasks require consistent definition across close schedules C. when the tasks are often late in completion and they need to be monitored more closely D. when the tasks require multiple levels of approvers - ✔✔A. when the tasks are repeatable over multiple close cycles
- Which two data extract export file types are available within Financial Consolidation and Close (FCCS)? (Choose two.) A. DAT file type B. Excel XLS file type C. Comma delimited D. Tab delimited - ✔✔C. Comma delimited D. 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?
A. 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. - ✔✔A. The script can be eliminated by using a multi-dim map on the Product dimension that also looks for the account Sales.
- 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? A. There is no way to do a prior period entry like this. B. January and February should be consolidated. C. February should be consolidated, after which the cash at AceCo is now 65. D. January should be consolidated for the change and nothing needs to happen for February. - ✔✔B. January and February should be consolidated.
- Which statement correctly describes the Consolidation dimension? A. The dimension contains members to store non-controlling interest and joint venture data. B. The dimension uses a separate member to store data from an entity's descendants. C. The dimension allows users to see input versus journal adjustment data. D. The dimension aggregates input, consolidated, and elimination data together. - ✔✔D. The dimension aggregates input, consolidated, and elimination data together.
- Which statement is true regarding Data Management categories?
D. By selecting Track Multi-source Data Input option for Other Data during the application creation process. - ✔✔B. Drill-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? A. Plug Account B. Intercompany Account C. Is Plug Account D. Intercompany Entity - ✔✔A. Plug Account
- 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.) A. FCCS_Elimination B. FCCS_Proportion C. FCCS_Entity Input D. FCCS_Entity Consolidation E. FCCS_Entity Total F. FCCS_Contribution - ✔✔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? A. The FCCS_No Intercompany member of the ICP dimension will be used for all data. B. Data can be stored by intercompany partner but no eliminations will occur.
C. An extra custom dimension will be available. D. The ICP dimension will be omitted. - ✔✔D. The ICP dimension will be omitted.
- Changes in the balance of Accounts Payable are captured on a company's Cash Flow Report. Which two dimension members must be built into the row of the company's Cash Flow to report the impact of Accounts Payable? (Choose two.) A. FCCS_Accounts Payable account member B. FCCS_CashFlow_Operating movement member C. FCCS_CashFlow_Accounts Payable account member D. FCCS_Total Balance Sheet - Cash and NonCash account member E. FCCS_CashChange movement member - ✔✔C. FCCS_CashFlow_Accounts Payable account member D. FCCS_Total Balance Sheet - Cash and NonCash account member
- When defining a batch in Data Management, which statement is True? A. Each data load rule must specify the period or the batch will default to the POV period. B. Batches can import from source or export to target, but not both. C. Batches can execute data loads for multiple locations. D. A batch replaces the need for data load rules. E. A batch can load to multiple plan types. - ✔✔E. A batch can load to multiple plan types.
- Which is NOT a member of the Data Source Dimension created by Financial Consolidation and Close (FCCS)? A. FCCS_No Data Source B. FCCS_Data Input C. FCCS_SystemTypes D. FCCS_Proportion - ✔✔D. FCCS_Proportion
B. A variance in the Average rate and the Ending rate C. The current FCCS_CTA account balance does not change from the prior period D. The account is FCCS_Net Income - ✔✔A. Movement of FX impact for historical rate D. The account is FCCS_Net Income
- Which components are pre-built into Financial Consolidation and Close Cloud Service to provide a configurable and scalable consolidation solution? A. 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 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 - ✔✔A. pre-built integration to combine narrative and data to produce both internal and external reporting packages OR 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? A. The ability to force translations B. The ability to report in multiple currencies C. The ability to calculate foreign exchange rates D. The ability to calculate CTA (Cumulative Translation Adjustment) E. The ability to input foreign exchange rates - ✔✔C. The ability to calculate foreign exchange rates
- Financial Consolidation and Close Cloud Service (FCCS) provides a consolidation path through which dimension combination? A. Consolidation, Currency, Account B. Currency, Account, Movement C. Entity, Consolidation, Currency D. Entity, Currency, Account - ✔✔C. Entity, Consolidation, Currency
- Which statement is false regarding establishing security for Financial Consolidation and Close (FCCS)? A. All members are accessible for dimensions with no security applied. B. The Identity Domain Administrator inherits full access privileges. C. Security is mandatory for one dimension. D. Security can be assigned at a parent level. E. Security can be disabled for any dimension. - ✔✔B. The Identity Domain Administrator inherits full access privileges.
- Which statement is correct regarding intercompany eliminations? A. Intercompany eliminations are generally required to remove the effect of transactions within the company. B. Intercompany eliminations are required for sustainability reporting to show the company's waste output. C. Intercompany eliminations are optional in FCCS and use one of the custom dimensions when enabled. D. Intercompany eliminations are needed when a company divests itself of a division. - ✔✔A. Intercompany eliminations are generally required to remove the effect of transactions within the company.
- What is the Data Storage value for an account that must remain at a historical exchange rate and not retranslate with current rates?
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. 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. - ✔✔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.
- Which two members of the Consolidation dimension cause the standard foreign currency translation rules to be ignored? (Choose two.) A. FCCS_Amount_Override B. FCCS_Rate Override C. FCCS_Contribution D. FCCS_Proportion E. FCCS_Elimination F. FCCS_Translation - ✔✔A. FCCS_Amount_Override B. FCCS_Rate Override
- Which statement is true regarding shared members and valid intersection rules? A. Shared members are supported in valid intersection rules B. If a shared member is selected for a valid intersection rule, then the base member is not included 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 - ✔✔A. Shared members are supported in valid intersection rules
- Which statement correctly describes what happens to parent entities during consolidation? 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. 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. - ✔✔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? A. Any number of months can be selected B. 12-month only C. 12-month and 13-month D. 12-month, 13-month and a 14-month - ✔✔C. 12-month and 13-month
- How can Metadata be imported into any Financial Consolidation and Close (FCCS) application? A. by selecting Application, then Overview, then Dimensions, and then Export B. by selecting Dimension, then Import, and then Metadata C. by selecting Application, then Overview, then Dimensions, and then Import D. by selecting Tasks, then Metadata, and then Import - ✔✔C. by selecting Application, then Overview, then Dimensions, and then Import
C. Day 1 to Day 7 D. Day - 2 to Day 4 - ✔✔B. Day - 3 to Day 3
- Which dimension includes the FCCS_Global Assumption member that is used to store currency information? A. Account B. From Currency C. Entity D. Currency - ✔✔C. Entity
- Which statement correctly describes when a consolidation can occur within a given year/scenario? A. 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. - ✔✔B. The current period consolidation status is Impacted and the remaining periods are OK.
- What is the correct Currency dimension member to select when running an Intercompany Matching Report? A. Input Currency B. Reporting Currency C. Entity Currency D. Parent Currency - ✔✔D. Parent Currency
- Financial Consolidation Close Cloud maintains the status calculation for which combination of dimensions? A. Scenario, Account, Base Entity and Parent Entity B. Year, Scenario, Base Entity and Account C. Scenario, View, Parent Entity and Account D. Period, Scenario, Base Entity and Parent Entity - ✔✔D. Period, Scenario, Base Entity and Parent Entity
- On what days during the month does Oracle apply patch updates to fix bugs, apply code optimizations, and add new features? A. the third Friday of each month to apply to both TEST and PROD simultaneously B. the first and third Monday of each month; first Monday for TEST and third Monday for PROD C. the second and fourth Friday of each month; second Friday for Test and fourth Friday for PROD D. the first and third Friday of each month; first Friday for TEST and third Friday for PROD - ✔✔B. the first and third Monday of each month; first Monday for TEST and third Monday for PROD
- To show the Intercompany account and matching account balances on the Intercompany Matching Report, you make which selection? A. Intercompany Accounts B. Intercompany Partners C. Intercompany Plug Accounts D. Elimination Consolidation Dimension member - ✔✔D. Elimination Consolidation Dimension member
- What member of the Currency dimension is associated with the Entity Input member of the Consolidation dimension? A. Base Currency B. Parent Currency C. Local Currency
- Which option can be used for quarter distributions on a 13-month time period calendar when creating a Financial Consolidation and Close Cloud (FCCS) application? A. 3- 3 - 3 - 3 B. 3- 3 - 3 - 4 C. 4- 4 - 4 - 4 D. 4- 4 - 4 - 5 - ✔✔B. 3- 3 - 3 - 4
- What member of the Currency dimension should be used during data entry for historical override amounts? A. Parent Currency B. Input Currencies C. Reporting Currencies D. Entity Currency - ✔✔B. Input Currencies
- You are required to define a form that displays all form data for only specific View dimension member and not allow users to change this. Where on the form do you define the View dimension and select the correct member? A. a column B. Other Options section C. the Page Axis D. the Point of View - ✔✔D. the Point of View
- PQR Company has the ownership structure shown above. If P_2 lends money to H_1, which point of view would the credit balance that offsets P_2's debit balance? A. Entity PQR, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany
B. Entity Paducah, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany. Entity P_2, Consolidation FCCS_Contribution, Intercompany ICP_H_ C. Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_ D. Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1 - ✔✔C. Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_
- Which three key requirements does the Financial Consolidation and Close Cloud Service (FCCS) deliver to ensure a modern consolidation and close solution? (Choose three.) A. Ensure security of sensitive data. B. Integrate with source systems. C. Provide predictive analysis and modeling. D. Provide a strong compliance framework that includes auditing and segregation of duties. - ✔✔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? A. 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 D. during application creation and selecting the Multi-source Data Input of Other Data - ✔✔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.) A. Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals
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 - ✔✔C. Locations can share dimension member mappings by specifying a location as a parent location of others. E. Locations must specify an import format, which may be used by other locations.
- What are two important first steps in initially setting up Close Manager? (Choose two.) A. Create a schedule and set it to Open status. B. Set up Users. C. Assign tasks to users. D. Define system settings such as Organization units, Holiday rules and Task attachment size. - ✔✔B. Set up Users. D. Define system settings such as Organization units, Holiday rules and Task attachment size.
- How do you enable multiple currencies within a Financial Consolidation and Close (FCCS) application? A. Enable a dimension for Currency after application creation via a Metadata load. B. During application creation, select the Multicurrency option of "No" and insert additional currencies within the Currency dimension. C. During application creation, select the Multicurrency option of "Yes". D. Add a new label for a currency when creating a new Entity member in the Reporting Currency attribute field. - ✔✔C. During application creation, select the Multicurrency option of "Yes".
- What member of the Consolidation dimension aggregates the Proportion member and the Elimination members?
A. FCCS_Entity Total B. FCCS_Parent Currency C. FCCS_Contribution D. FCCS_Entity Consolidation - ✔✔C. FCCS_Contribution
- Which two members of the Data Source dimension are optional when you create a Financial Consolidation and Close (FCCS) application? (Choose two.) A. FCCS_Journal Input B. FCCS_PCON C. FCCS_Intercompany Eliminations D. FCCS_No Data Sourc - ✔✔A. FCCS_Journal Input 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? A. The Intercompany Alias is set to the Entity Name. B. The Intercompany Alias is automatically changed to the new Entity Alias. C. The Intercompany Alias is not automatically changed to the new Entity Alias. D. The Intercompany Alias is automatically set to the Intercompany Name. - ✔✔C. The Intercompany Alias is not automatically changed to the new Entity Alias.
- 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? A. Disconnect from the Smart View connection, and relog in. B. Activate the Connection.
