FCCS Exam
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 - ANSWER- 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
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 - ANSWER- B. FCCS_Proportion
D. FCCS_Entity Consolidation
E. FCCS_Entity Total
F. FCCS_Contribution
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. - ANSWER- 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.
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. 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. - ANSWER- 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.
, 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. - ANSWER- B. Activate the
Connection.
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.
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 - ANSWER- 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
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 - ANSWER- B. FCCS_Proportion
D. FCCS_Entity Consolidation
E. FCCS_Entity Total
F. FCCS_Contribution
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. - ANSWER- 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.
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. 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. - ANSWER- 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.
, 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. - ANSWER- B. Activate the
Connection.
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.
