Oracle FCC Certification Prep

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

FCCS_Rate Override

FCCS_Elimination

Which four sample ratios can be created during the application creation process? (Choose four)

A. Inventory Ratios

B. Contribution Margin

C. Debt Ratio

D. Earnings per Share

E. Days Sales in Receivables

F. Gross Margin

Inventory Ratios

Debt Ratio

Days Sales in Receivables

Gross Margin

When can the Intercompany Dimension be enabled and n=made visible within your application?

A. during application creation and selection Muti-source Data Input of Other Data

B. after application creation by selecting any Entity as IC_Entity_Yes for the Intercompany Entity attribute

C. After application creation by selecting any Account as IC_Acc_Yes for the Intercompany Account attribute

D. During application creation and selecting the Intercompany Data feature option

During application creation and selecting the Intercompany Data feature option

Which three tasks can users perform on FCC data with Smart View in Excel? (Choose three)

A. Submit Data

B. Adjust data with journals

C. Retrieve data

D. Run a rule such as Consolidate or Translate

Submit data

Retrieve Data

Run a rule such as Consolidate or Translate

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.

The Intercompany Alias is automatically changed to the new Entity Alias

Which three fields must be defined when registering a file-based source system in Data Management? (Choose three)

A. Source Type

B. Drill Type

C. Cloud Type

D. Description

E. Name

Source Type

Description

Name

Which is NOT a member of the Data Source Dimension created by FCCS?

A. FCCS_No Data Source

B. FCCS_Data Input

C. FCCS_SystemTypes

D. FCCS_Proportion

FCCS_Proportion

How is drill-back enabled to Supplemental Data Manager (SDM) from the Supplemental Data

member within the Multi-source dimension?

A. Drill-back to SDM is not an available feature.

B. 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.

Drill-back is available from any Multi-source dimension member by default, know the source of the origination data load

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.

January and February should be consolidated.

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

Period, Scenario, Base Entity and Parent Entity

Three child entities - P, Q, and R - of a mid-level parent entity - AceCo - have account 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?

A. 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.

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.

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 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

The current period consolidation status is Impacted and the remaining periods are OK

When setting an account property to a data storage type of "Dynamic Calc" which two are allowed?

A. Member formulas cannot be created

B. load data to this account and make member formulas

C. load data to this account

D. create Member formulas

Load data to the account and make members formulas, create member formulas

When creating an application in Financial Consolidation and Close, 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

12-month and 13-month

Which three scenarios result in foreign currency translation during the default consolidation

process? (Choose three.)

A. A base entity currency has a parent entity with a matching default currency.

B. A base entity currency has a parent entity with a different default currency.

C. A parent entity has the same default currency as its parent.

D. A parent entity has a different currency from its parent.

E. A shared entity has a parent with a different currency.

A base entity currency has a parent entity with a different default currency.

A parent entity has a different currency from its parent.

A shared entity has a parent with a different currency.

Which financial close related component is NOT a part of the Financial Consolidation and Close Cloud integrated product suite?

A. Process Management

B. Account Reconciliation Management

C. Data Management

D. Supplemental Data Management

E. Financial Close Management

Account Reconciliation Management

A client company has expanded quickly in the past year and has recognized the need to move their financial team off spreadsheets and to a more verifiable and automated solution.

Which two requirements from this team would Oracle's Financial Consolidation and Close Cloud Service satisfy? (Choose two)

A. robust consolidation engine that provides automated aggregations, intercompany eliminations and translations without requiring a strong IT footprint

B. Dashboard reporting with daily revenue comparisons and KPI's that measure cost controls

C. leverage compliance efforts to fix process issues across all businesses and provide oversight for risk awareness

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

E. provide the ability to collaborate during close and analyse transaction

dashboard reporting with daily revenue comparisons and KPI's that measure cost controls

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 dimension includes the FCCS_Global Assumption member that is used to store currency information?

A. Account

B. From Currency

C. Entity

D. Currency

From Currency

By default, security access is set to "None" for which three dimensions? (Choose three.)

A. Movement

B. Data Source

C. Account

D. Entity

E. Year

Data Source

Account

Entity

What is the primary function of enabling the Track Intercompany Elimination option during the application creation?

A. enables the Elimination member in the Consolidation dimension

B. process will separate total elimination values by Data source

C. Enables the application to include Intercompany data

D. Enables the application to perform Intercompany eliminations

Process will separate total elimination values by data source

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

Currency, Account, Movement

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.

C. Close out of Excel, and relog in to Smart View.

D. Change one of the Row or Column dimension members and click Refresh.

Change one of the Row or Column dimension members and click refresh

A company would like capture Fixed Asset additions and disposals within Movement dimension.

Which three tasks are necessary to achieve this goal?

A. Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals

B. Add custom members for Additions 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

Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals

Add custom members for Additions as dependents of FCCS_Mvmts_CapitalExpenditures

Load detailed Fixed Asset data to Movement members

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_1

C. Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_1

D. Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1

Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_1

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

IS Plug Account

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

Reporting Currencies

Which is true behavior of default FCCS_members within an application?

A. You can change the default FCCS_member prefix at application creation

B. You can change the Alias of these default FCCS_members at any time

C. You can change the Name of these default FCCS_members at any time

D. You cannot change the Alias of these default FCCS_members

You can change the Name of these default FCCS_members at any time

Which explains why the Currency dimension does NOT display in your application?

A. Security access to the Multi-GAAP dimension in required

B. Multi-Currency option was not selected at application creation

C. Entity-specific security rights were not properly granted

D. Security has not been granted

Multi-Currency option was not selected at application creation

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

the Point of View

What is the Data Storage value for an account that must remain at a historical exchange rate and not retranslate with current rates?

A. Store

B. Never Share

C. No Rate

D. Dynamic Calc and Store

E. Dynamic

Store

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

The ability to calculate foreign exchange rates

Which statement is true regarding Data Management categories?

A. Categories are defined on the Global Mapping tab and then the frequency is specified on the Application Mapping tab

B. Categories must begin with FCCS_ to match their Financial Consolidation and Close counterparts

C. Application mapping is not required if the global mapping target category is exactly correct

D. The category's time frequency allows data to be loaded to daily, weekly, and monthly scenarios

Categories must begin with FCCS_ to match their Financial Consolidation and Close counterparts

You are required to create a form to allow users to input data. Which three actions or form components selected should accomplish this?

A. Set the currency on the form to the reporting currency member USD_Reporting

B. Level 0 dimension members on POV, rows and columns

C. Give data input users WRITE access to form dimension members

D. Set access rights for data input users to the form

Level 0 dimension members on POV, rows and columns

Give data input users WRITE access to form dimension members

Set access rights for data input users to the form

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

The ICP dimension will be omitted

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.

Ensure security of sensitive data.

Integrate with source systems.

Provide a strong compliance framework that includes auditing and segregation of duties.

If the Intercompany Property for an Entity is changed from marked to unmarked, which result occurs?

A. The alias of the associated Intercompany member is automatically updated.

B. The associated Intercompany member must be manually removed.

C. The associated Intercompany member is automatically removed.

D. The alias of the associated Intercompany member must be manually changed.

The alias of the associated Intercompany member is automatically updated.

What will Financial Consolidation and Close (FCCS) do when adding a new member that is an expense type account under a parent that is set as an income type account?

A. this setting will not affect additions or subtractions to the next parent

B. subtract amounts consolidated to the parent

C. add amounts consolidated to the parent

D. you can't load data to this account

subtract amounts consolidated to the parent

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 divest itself of a division

Intercompany eliminations are generally required to remove the effect of transactions within the company

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

FCCS_Contribution

When creating a Financial Consolidation and Close (FCCS) application, which initial Multi-source data options can be selected? (Choose two)

A. ERP Cloud

B. Supplemental Data

C. Data Management

D. ERP r12

Supplemental Data

Data Management

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?

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

FCCS_CashFlow_Accounts Payable account member

FCCS_Total Balance Sheet - Cash and NonCash account member

For which three levels can Profiles be set in Data Management?

A. Category

B. Source System

C. System

D. User

E. Application

System

User

Application

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

3-3-3-4

Which statement is FALSE when enabling a Multi-GAAP application?

A. Two custom dimensions are available after enabling Multi-GAAP

B. The Multi-GAAP dimension is optional

C. The system automatically creates an FCCS_IFRS member

Additional GAAP adjustment can be created

Two custom dimensions are available after enabling Multi-GAAP

Which selection enables data to be imported directly into any Financial Consolidation and Close (FCCS) application?

A. Select Application, then Overview, then Data, and then Export

B. Select Application, then Overview, the Actions, and then Import Data

C. Select Dimensions, then Actions, and then Import Data

D. Select Import, then Actions, and then Data

Select Application, then Overview, the Actions, and then Import Data

PQR Company has the ownership structure shown above. 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?

A. First common parent

B. Generation 0

C. First order relation

D. Lowest common denominator

First common parent

When designing a report in Financial Reporting Studio, which condition should NOT be considered for a Financial Consolidation and Close (FCCS) report?

A. Designing dynamic reports

B. Expanded vs. single data segments

C. Report performance

D. Suppress missing blocks

Suppress missing blocks

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

during application creation and selecting the Intercompany Data feature option

Which statement accurately describes alternate hierarchies?

A. Single entities having multiple parents

B. Parent members having the same currency

C. Contribution to parent members are similar

D. Data must be entered multiple times for shared members

Single entities having multiple parents

Which two data extract export file types are available within Financial Consolidation Close (FCCS)? (Choose two).

A. DAT file type

B. Excel XLS file type

C. Comma delimited

D. Tab delimited

Comma delimited

Tab delimited

In which two instances will the FCCS_Mvmts_FX_to_CTA movement member populate in a

translated currency?

A. Movement of FX impact for historical rate accounts to the FCCS_CTA account

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

The current FCCS_CTA account balance does not change from the prior period

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.)

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 journal entry to reverse the adjusted Common Stock balance with the Data Source member FCCS_Journal Input.

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

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

the first and third Friday of each month; first Friday for TEST and third Friday for PROD

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 by Average Rate

FCCS_OpeningBalance multiplied by Ending Rate minus FCCS_OpeningBalance carry forward

FCCS_Mvmts_Subtotal multiplied by ending Rate minus FCCS_Mvmts_Subtotal multiplied by Average Rate

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

The dimension allows users to see input versus journal adjustment data

When enabling Multi-GAAP during application creation, which additional option is available?

A. Automatically calculate adjustment

B. Allow adjustments for IFRS

C. Track Multi-Source Data Input

D. Include Supplemental Data

Automatically calculate adjustment

For data load rules in Data Management, which two statements are FALSE?

A. If specified, the import format will be used; if not, then the location's format will be used

B. A job must first run to import the data file before the user can run the data load rule

C. End users can upload a file when running a data load rule

D. Data load rules cannot be shared across locations

E. Valid load types are Merge and Replace

A job must first run to import the data file before the user can run the data load rule

Valid load types are Merge and Replace

Which four statements are true about the members in the FCCS_Cash Flow hierarchy in the Movement dimension? (Choose four)

A. The Cash Change hierarchy cannot be modified

B. All primary Movement members under the FCCS_Mvmts_Subtotal member must be included in the FCCS_CashFlow hierarchy

C. The seeded member FCCS_Mvmts_AccountsPayable found within the FCCS_CashFlow hierarchy has a Subtraction operator

D. Input level members under the FCCS_Mvmts_Subtotal are Shared members in the FCCS_CashFlow hierarchy

E. Standard cash accounts are members of the FCCS_CashFlow_Operating hierarchy

F. Siblings can be added to the FCCS_CashFlow_Investing member

The seeded member FCCS_Mvmts_AccountsPayable found within the FCCS_CashFlow hierarchy has a Subtraction operator

Input level members under the FCCS_Mvmts_Subtotal are Shared members in the FCCS_CashFlow hierarchy

Standard cash accounts are members of the FCCS_CashFlow_Operating hierarchy

Siblings can be added to the FCCS_CashFlow_Investing member

Which explains why the Currency dimension does NOT display in your application?

A. Security access to the Multi-GAAP dimension is required

B. Multi-Currency option was not selected at application creation

C. Entity-specific security rights were not properly granted

D. Security has not been granted

Multi-Currency option was not selected at application creation

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

FCCS_Proportion

What will Financial Consolidation and Close (FCCS) do when adding a new member that is an expense type account under a parent that is set as an income type account?

A. this setting will not affect additions or subtractions to the next parent

B. subtract amounts consolidated to the parent

C. add amounts consolidated to the parent

D. you can't load data to this account

subtract amounts consolidated to the parent

Which of the following is allowed for accounts with the data storage type of "Dynamic Calc"?

A. Load data to this account

B. Create member formulas

C. Load data to this account and create member formulas

D. Enter data through a data form

Load data to this account and create member formulas

You need a report that displays all adjustments to account balances of child entities for a parent, including journal adjustments, intercompany eliminations, and adjustment from consolidation rules.

Which type of report can you run to accomplish this?

A. Consolidation Report

B. Journal Report

C. Intercompany Report

D. Financial Report

Consolidation Report

Which two statements are true about Cash Flow in the Movement dimension?

A. When you add a level 0 member to FCCS_Mvmts_Subtotal, it is automatically added as a shared member to the FCCS_CashFlow hierarchy

B. The seeded level 0 members under FCCS_Mvmts_Subtotal are shared members in the FCCS_CashFlow hierarchy

C. You can add shared members to the FCCS_CashChange hierarchy

D. The FCCS_Mvmts_AccountsPayable member is under FCCS_CashFlow_NetAssets in the FCCS_CashFlow hierarchy

When you add a level 0 member to FCCS_Mvmts_Subtotal, it is automatically added as a shared member to the FCCS_CashFlow hierarchy

The seeded level 0 members under FCCS_Mvmts_Subtotal are shared members in the FCCS_CashFlow hierarchy

Once metadata is updated and the Refresh Database have completed successfully, how will the status via the default Data Status grid for all entities be listed via the default Data Status grid?

A. Impacted

B. Need Translate

C. OK

D. System Changed (SC)

System Changed (SC)

Which three combinations of dimensions could be valid for a Financial Consolidation and Close (FCCS) application?

A. Period, Year, Entity

B. From Currency, Movement, Scenario

C. Multi-GAAP, Data Type, Intra-company

D. Value, Entity, Account

E. Data source, Consolidation, View

Period, Year, Entity

You have created a navigation flow named Analysts that should be the default navigation for users in the Analysts user group.

How can the Analysts navigation flow be made the default for the Analysts user group?

A. In the Analysts navigation flow, select the Analysts user group in the Assign To Field

B. In Application Settings, assign Analysts to the Analysts user group in the System Settings section

C. In their User Preferences settings, members of the Analysts user group should select Analysts in the Navigation Flow list

D. Because the navigation flow was given exactly the same name as the user group, it is assigned automatically to the group

In the Analysts navigation flow, select the Analysts user group in the Assign To Field

You need to define a form that requires users to select the entity for which to view data from a list that includes USA, Canada, and South America, but no other entities.

Where on the form do you place the Entity dimension?

A. the Point of View

B. rows

C. columns

D. the Page Axis

the Point of View

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 Source

FCCS_Journal Input

FCCS_Intercompany Eliminations

Which statement explains why, in the Consolidation dimension, the data for an entity in the FCCS_Entity Input member might be different than the data in the FCCS_Proportion member?

A. A rate was entered into the FCCS_Rate Override account

B. An ownership percentage for the entity other than 100 was entered

C. An intercompany elimination was performed

D. The parent entity has a different currency than the child

An intercompany elimination was performed

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

Enable a dimension for Currency after application creation via a Metadata load

Which statement about the Equity Pickup feature is FALSE?

A. Seeded rule-sets are provided for Equity Pickup

B. Equity Pickup rules run as part of the consolidation process

C. Equity Pickup requires that the Ownership Management with Equity Pickup feature is enabled

D. Equity Pickup rules are on-demand from the Rules card by users with launch permissions

Equity Pickup rules run as part of the consolidation process

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

The script will work if the script is referenced in the In mapping type with #SQL as the target

What information is included in the data extract export file delimited format?

A. the ID of the user performing the extract

B. the domain and application name

C. the data load cube name

D. the application name

the ID of the user performing the extract

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

Batches can execute data loads for multiple locations

What file type / file extension format extracts data exports from Financial Consolidation and Close (FCCS)?

A. The data export format / file extension is always extracted in a XLS file format

B. The data export format / file extension is always extracted in a ZIP file format

C. The data export format / file extension is always extracted in a DAT file format

D. The data export format / file extension is always extracted in a CSV file format

The data export format / file extension is always extracted in a CSV file format

Which two statements are correct with regard to Data Management locations?

A. 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

Locations can share dimension member mappings by specifying a location as a parent location of others

Locations must specify an import format, which may be used by other locations

Company 123 is a public company that reports in US Dollars. Company 123 owns Company XYZ, a European company that consolidates in Euro. One of the Company XYZ's subsidiaries is Company IOU, headquartered in Switzerland with a functional currency of the Swiss Franc.

Which process produces USD balances for Company IOU?

A. A translation to the USD_Reporting currency member for Company IOU

B. A translation of Company IOU

C. A consolidation of Company 123

D. A consolidation of Company XYZ

E. A translation of Company XYZ to Parent Currency

A translation of Company XYZ to Parent Currency

Which statement is FALSE when Intercompany Data is enabled?

A. The Intercompany Entity attribute for an Entity must be set to Yes to store intercompany data

B. Tracking intercompany eliminations is optional

C. In order for intercompany data to be eliminated, intercompany entities must be children of the same parent

D. Intercompany accounts are assigned plug accounts

In order for intercompany data to be eliminated, intercompany entities must be children of the same parent

Which two statements are true of the roll forward calculation in the Movement dimension?

A. Values for base-level Movement members are calculated as the difference between Closing Balance and Opening balance

B. Translated values for Closing Balance are adjusted to the ending rate for the period

C. Values for opening Balance are retrieved from the prior period Closing balance

D. Data for opening balances must be loaded to the Opening Balance member prior to consolidation

Translated values for Closing Balance are adjusted to the ending rate for the period

Values for opening Balance are retrieved from the prior period Closing balance

Which components are pre-built into Financial Consolidation and Close Cloud Service to provide a configurable and scalable consolidation solution?

A. pre-built integrations 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 detailed data source tracking and an automated cash flow

D. calculations, dashboards and reports built on planning frameworks to provide cash flow planning

calculations, dashboards, and reports as well as detailed data source tracking and an automated cash flow

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

If a base member is included in a valid intersection rule, then any shared member is not included in the rule

Shared members are not supported in valid intersection rules

Which three scenarios result in foreign currency translation during the default consolidation process?

A. A parent entity has a different default currency than its parent

B. A parent entity has the same default currency as its parent

C. A base entity has a different default currency than its parent

D. A base entity has the same default currency as its parent

E. A shared entity has a different default currency than its parent

A parent entity has a different default currency than its parent

A base entity has a different default currency than its parent

A shared entity has a different default currency than its parent

What will Financial Consolidation and Close do when aggregating data for a member that is set as an expense type account to a parent that is set as an income type account?

A. This setting does not affect aggregation to the parent

B. You cannot load data to this account

C. Add amounts aggregated to the parent

D. Subtract amounts aggregated to the parent

Add amounts aggregated to the parent

A company is based in the United Kingdom and has an application currency set to GBP. The company collects data from a United States based subsidiary. The subsidiary's functional currency is USD.

Which two items facilitate the reporting of the subsidiary's Common Stock balance at an historical rate in the GBP reporting currency? (Choose two)

A. Common stock must have an Exchange Rate Type set to Historical Rate Override

B. The subsidiary must have a balance not equal to zero in Common Stock

C. Common Stock must have a Data Storage property set to Never Share

D. USD must be created as a reporting currency

E. The subsidiary must have a parent entity with a GBP currency

The subsidiary must have a balance not equal to zero in Common Stock

The subsidiary must have a parent entity with a GBP currency

For which three dimensions is security enabled by default?

A. Data Source

B. Entity

C. Consolidation

D. Scenario

E. Account

Entity

Scenario

Account

When designing a report in Financial Reporting Studio, which item is NOT an insert-able report object?

A. Chart

B. Grid

C. Image

D. Header

Chart

Grid

Which four sample ratios can be selected during business process creation?

A. Inventory ratios

B. Gross Margin

C. Contribution Margin

D. Earnings per Share

E. Debt Ratio

F. Days sales in Receivables

Gross Margin

Contribution Margin

Earnings per Share

Days sales in Receivables

For which scenario would an On-Demand rule be an appropriate solution?

A. to perform a custom currency translation for a subset of accounts

B. to add a column with a calculation to a report

C. to copy data from one scenario to a different scenario

D. to allocate data to base entities prior to consolidation

to copy data from one scenario to a different scenario

Which three can be manually edited on the Manage Ownership page in a Financial Consolidation and Close business process with Ownership Management enabled?

A. Ownership Percentage

B. Control

C. Consolidation Method

D. Consolidation Percentage

E. Minority Interest Percentage

Control

Consolidation Method

Consolidation Percentage

The close cycle covers seven days and consists of three days of pre-close preparation tasks, one dat to close the books, and then three days of reviewing, analyzing, and reporting.

To define a Close Manager task template to monitor all seven days, which day range should you define?

A. Day -3 to Day 4

B. Day -3 to Day 3

C. Day 1 to Day 7

D. Day -2 to Day 4

Day 1 to Day 7

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?

A. The new task will run outside of the schedule end date

B. An error, you can't add a new task past the due date

C. The schedule end date changes to match the end date of the task

D. The task will not run

The schedule end date changes to match the end date of the task

A company would like to capture Fixed Asset additions and disposals within the Movement dimension.

Which three tasks are necessary to achieve this goal?

A. Add custom member for Additions and Disposals as children of FCCS_Mvmts_CapitalExpenditures

B. Build a custom Movement member for Fixed Assets with child members for Additions and Disposals

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

Load detailed Fixed Asset data to Movement members

Add custom Movement members to the FCCS_CashFlow hierarchy

Create a Roll Forward in the account dimension

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

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

What are two important first steps in initially setting up Task Manager?

A. Set up Users

B. Define system settings such as Organization units, Holiday rules and Task attachment size

C. Assign tasks to users

D. Create a schedule and set it to Open status

Set up Users

Define system settings such as Organization units, Holiday rules and Task attachment size

To have access to Dimension Management from directly within Financial Consolidation and Close (FCCS) which security rights are required?

A. Metadata Administrator

B. Metadata Supervisor

C. System Administrator

D. Power User

Metadata Administrator

In the Movement dimension, for which two can you modify the default translation calculation?

A. Base-level members under FCCS_Mvmts Subtotal

B. Opening Balance

C. Closing Balance

D. Opening Balance Input

Base-level members under FCCS_Mvmts Subtotal

Opening Balance

Which statement is true of the default FCCS_ members within an application?

A. You can change the default FCCS_ member prefix at application creation

B. You can change the Alias

C. You can change the Data Storage property

D. You can change the Name

You can change the Alias

Which statement is FALSE when setting up Shared Entities?

A. The calculation status will not change in all instances when data is changed in one instance

B. The Data Storage Member Property must set to "Dynamic Calc"

C. You build an alternate hierarchy by using partial share Entity members

D. When data is posted to one shared entity, the data is posted to all instances

The calculation status will not change in all instances when data is changed in one instance

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

D. Entity Currency

Entity Currency