FCCS
TESTED QUESTIONS AND COMPLETE SOLUTIONS
Question 1.
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. Add custom members for Additions and Disposals as dependents of
FCCS_Mvmts_CapitalExpenditures.
B. Add custom Movement members to the FCCS_CashFlow hierarchy.
C. Build a custom Movement member for Fixed Assets with dependent custom members for Additions
and Disposals
D. Load detailed Fixed Asset data to Movement members.
E. Create a Roll Forward in the account dimension.
ANSWER
A. Add custom members for Additions and Disposals as dependents of
FCCS_Mvmts_CapitalExpenditures.
C. Build a custom Movement member for Fixed Assets with dependent custom members for
Additions and Disposals
D. Load detailed Fixed Asset data to Movement members.
Question 2.
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. Activate the Connection.
B. Change one of the Row or Column dimension members and click Refresh.
C. Disconnect from the Smart View connection, and relog in.
D. Close out of Excel, and relog in to Smart View.
ANSWER
B. Change one of the Row or Column dimension members and click Refresh.
,Question 3.
Which two statements are correct with regard to Data Management locations? (Choose two.)
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.
ANSWER
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.
Question 4.
What file type / file extension format extract 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 DAT file format.
C. The data export format / file extension is always extracted in a ZIP file format.
D. The data export format / file extension is always extracted in a CSV file format.
ANSWER
D. The data export format / file extension is always extracted in a CSV file format.
Question 5.
When setting an account property to a data storage type of "Dynamic Calc" which two are allowed?
(Select two)
A. load data to this account and make member formulas
B. Member Formulas cannot be created
C. create Member Formulas
D. load data to this account
ANSWER
A. load data to this account and make member formulas
C. create Member Formulas
, Question 6.
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
ANSWER
D. Period, Scenario, Base Entity and Parent Entity
Question 7.
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
ANSWER
B. process will separate total elimination values by Data Source.
Question 8.
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
ANSWER
D. Header
TESTED QUESTIONS AND COMPLETE SOLUTIONS
Question 1.
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. Add custom members for Additions and Disposals as dependents of
FCCS_Mvmts_CapitalExpenditures.
B. Add custom Movement members to the FCCS_CashFlow hierarchy.
C. Build a custom Movement member for Fixed Assets with dependent custom members for Additions
and Disposals
D. Load detailed Fixed Asset data to Movement members.
E. Create a Roll Forward in the account dimension.
ANSWER
A. Add custom members for Additions and Disposals as dependents of
FCCS_Mvmts_CapitalExpenditures.
C. Build a custom Movement member for Fixed Assets with dependent custom members for
Additions and Disposals
D. Load detailed Fixed Asset data to Movement members.
Question 2.
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. Activate the Connection.
B. Change one of the Row or Column dimension members and click Refresh.
C. Disconnect from the Smart View connection, and relog in.
D. Close out of Excel, and relog in to Smart View.
ANSWER
B. Change one of the Row or Column dimension members and click Refresh.
,Question 3.
Which two statements are correct with regard to Data Management locations? (Choose two.)
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.
ANSWER
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.
Question 4.
What file type / file extension format extract 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 DAT file format.
C. The data export format / file extension is always extracted in a ZIP file format.
D. The data export format / file extension is always extracted in a CSV file format.
ANSWER
D. The data export format / file extension is always extracted in a CSV file format.
Question 5.
When setting an account property to a data storage type of "Dynamic Calc" which two are allowed?
(Select two)
A. load data to this account and make member formulas
B. Member Formulas cannot be created
C. create Member Formulas
D. load data to this account
ANSWER
A. load data to this account and make member formulas
C. create Member Formulas
, Question 6.
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
ANSWER
D. Period, Scenario, Base Entity and Parent Entity
Question 7.
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
ANSWER
B. process will separate total elimination values by Data Source.
Question 8.
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
ANSWER
D. Header
