Oracle FCCS Certification Questions
24. Which exchange rate is used to translate data for the Opening Balance Adjustment member
for non- historical accounts?
a. current period Average Rate
b. current period Ending Rate
c. current period Opening Rate
d. prior period Ending Rate - ANS-b. current period Ending Rate
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 - ANS-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?
A. FCCS_Entity Consolidation
B. FCCS_Entity Input
C. FCCS_Entity Total
D. FCCS_Proportion
,E. FCCS_Contribution
F. FCCS_Elimination - ANS-A. FCCS_Entity Consolidation
C. FCCS_Entity Total
D. FCCS_Proportion
E. FCCS_Contribution
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 - ANS-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 a historical rate in the GBP reporting currency?
a. Common Stock must have an Exchange Rate Type set to Historical Rate Override.
b. Rate data for common stock must be loaded or entered in the Override Rates form
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. - ANS-a. Common Stock must
have an Exchange Rate Type set to Historical Rate Override.
b. Rate data for common stock must be loaded or entered in the Override Rates form
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. - ANS-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 - ANS-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
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. - ANS-B. Activate
the Connection. (Dan's: D)
A user creates an adhoc Smart View query that is defined to show the Financial Consolidation
and Close Cloud parent Account, FCCS_Cash and Cash Equivalents, and all base account
members below it in the rows of the spreadsheet. If a new base account is added to the
FCCS_Cash and Cash Equivalents parent account, what method can the user select to add the
new account to the rows in the query? - ANS-Zoom out on the FCCS_Cash and Cash
Equivalents parent account, then re-zoom in.
An approval unit has the status Under Review. Which users can modify data for the approval
unit?
a. any user with Write access to the dimension members in the approval unit.
b. current owner or Service Administrator.
c. current owner
d. current owner, Service Administrator, or Power User. - ANS-b. current owner or Service
Administrator.
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 memberFCCS_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. - ANS-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.
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.)
24. Which exchange rate is used to translate data for the Opening Balance Adjustment member
for non- historical accounts?
a. current period Average Rate
b. current period Ending Rate
c. current period Opening Rate
d. prior period Ending Rate - ANS-b. current period Ending Rate
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 - ANS-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?
A. FCCS_Entity Consolidation
B. FCCS_Entity Input
C. FCCS_Entity Total
D. FCCS_Proportion
,E. FCCS_Contribution
F. FCCS_Elimination - ANS-A. FCCS_Entity Consolidation
C. FCCS_Entity Total
D. FCCS_Proportion
E. FCCS_Contribution
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 - ANS-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 a historical rate in the GBP reporting currency?
a. Common Stock must have an Exchange Rate Type set to Historical Rate Override.
b. Rate data for common stock must be loaded or entered in the Override Rates form
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. - ANS-a. Common Stock must
have an Exchange Rate Type set to Historical Rate Override.
b. Rate data for common stock must be loaded or entered in the Override Rates form
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. - ANS-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 - ANS-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
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. - ANS-B. Activate
the Connection. (Dan's: D)
A user creates an adhoc Smart View query that is defined to show the Financial Consolidation
and Close Cloud parent Account, FCCS_Cash and Cash Equivalents, and all base account
members below it in the rows of the spreadsheet. If a new base account is added to the
FCCS_Cash and Cash Equivalents parent account, what method can the user select to add the
new account to the rows in the query? - ANS-Zoom out on the FCCS_Cash and Cash
Equivalents parent account, then re-zoom in.
An approval unit has the status Under Review. Which users can modify data for the approval
unit?
a. any user with Write access to the dimension members in the approval unit.
b. current owner or Service Administrator.
c. current owner
d. current owner, Service Administrator, or Power User. - ANS-b. current owner or Service
Administrator.
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 memberFCCS_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. - ANS-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.
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.)
