Oracle FCC Certification Prep – Financial Consolidation and Close |
Academic Year 2025-2026 – Study Guide and Practice Material
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 - ANS✔✔ 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 - ANS✔✔ 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 - ANS✔✔
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 - ANS✔✔ 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. - ANS✔✔ 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 - ANS✔✔ 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 - ANS✔✔ 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.
Academic Year 2025-2026 – Study Guide and Practice Material
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 - ANS✔✔ 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 - ANS✔✔ 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 - ANS✔✔
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 - ANS✔✔ 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. - ANS✔✔ 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 - ANS✔✔ 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 - ANS✔✔ 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.
