test Flashcards
You need to set up a calendar for fiscal year Apr-XX to March-YY where YY is the following year, and
you would like the periods to be named according to the year they fall in.
What Calendar format should you choose?
A. Period
B. Calendar
C. Year
D. Fiscal
Answer : D
Your company has a legal entity in the UK, US, and Canad A.
They can all share the same chart of accounts but are required to transact and report in their local
currency.
What is the minimum number of ledgers you need and why?
A. One, because they can all share the same chart of accounts
B. Three, because each requires a different currency
C. Two, because the US and Canada can share the same ledger because they are in North
America
D. Four, because the UK has statutory requirements and you will need a separate ledger for
statutory reporting
B
All of your subsidiaries reside on the same application instance, but some of them require a different
chart of accounts and/or accounting calendar and currency. There is no minority interest or partial
ownerships. What is Oracle's recommended approach to performing consolidations?
A. Translate balances to the corporate currency, create a chart of accounts mapping to the
corporate chart of accounts, then transfer balances to the corporate consolidation ledger
using the balance transfer program
B. Use Oracle Hyperion Financial Management for this type of complex consolidation.
C. Translate balances to the corporate currency for ledgers not in the corporate currency, use
General Ledger's Financial Reporting functionality to produce consolidated reports by
balancing segment where each report represents a different subsidiary.
D. Create separate ledgers for each subsidiary that shares the same chart of accounts, calendar,
currency, and accounting method. Create a separate elimination ledger to enter intercompany
eliminations. Then creates a ledger set across all ledgers and report on the ledger set.
D
The Accounting Manager requests that a schedule be created to automatically post journals from
subledgers at different times. Which journal attribute should you use to set the automatic posting
criteria?
A. Journal Category
B. Journal Description
C. Journal Batch
D. Journal Source
D
You can run predefined reports to reconcile subledger application balances to General Ledger
balances.
Which attribute needs to be set up on the Manage Values page for chart of accounts segment values
so that you can run the Payables to General Ledger Reconciliation Report or Receivables to General
Ledger Reconciliation Report?
A. End Date
B. Reconcile
C. Financial Category
D. Third Party Control Account
E. Start Date
C
Your company has a legal entity in the UK, US, and Canada.
They can all share the same chart of accounts but are required to transact and report in their local
currency.
What is the minimum number of ledgers you need and why?
A. One, because they can all share the same chart of accounts
B. Three, because each requires a different currency
C. Two, because the US and Canada can share the same ledger because they are in North
America
D. Four, because the UK has statutory requirements and you will need a separate ledger for
statutory reporting
B
Management wants to use the budget transfer function available on the Review Budgetary Control
Balances page. Which privilege is required to perform the budget transfer?
A. Import Budget Amounts from Spreadsheet
(XCC_IMPORT_BUDGET_FROM_SPREADSHEETS_PRIV)
B. Import Budget Amounts (XCC_IMPORT_BUDGET_PRIV)
C. Manage Control Budgets (XCC_MANAGE_CONTROL_BUDGETS_PRIV)
D. Budget Loading (XCC_BUDGET_LOADING_DUTY_PRIV)
C
You entered the following information in the Companies and Legal Entities tab of the Rapid
Implementation Spreadsheet:
(check Q8)
Assuming currency is left blank in the Ledger worksheet, how many Ledgers will the process create?
A. 6
B. 4
C. 5
D. 3
B
On which three occasions are Essbase balances updated? (Choose three.)
A. every time the tree version is published
B. every time you run the batch program called “Update Essbase Balances”
C. every time you open a new period
D. every time journals are posted to the general ledger
E. at report run-time
Answer : A, C, D
How do Cross Validation Rules (CVRs) handle existing violations in the Code Combinations
Identification (CCID) table?
A. If CVR determines that an invalid combination exists in the CCID table, it will automatically
disable that account code combination.
B. Nothing has changed. If you have an invalid account combination existing in the table, you
must deactivate it to prevent further usage
C. CVRs only test new account combinations being inserted into the table. They ignore any
invalid account combinations already existing in the table
D. CVRs are assigned to the end user role; therefore controlling what account code combination
individuals can leverage in the General Ledger and the subledgers
C
What is the most efficient way to add a new year to the accounting calendar?
A. Import the periods from a spreadsheet
B. The application automatically populates the next year when you open the first period of a new
fiscal year
C. Use the Add Year button
D. Add the periods manually
C
Your customer wants to create fully balanced balance sheets for the Company, Line of Business, and
Product segments for both financial and management reporting.
What is Oracle's recommended method for doing this?
A. Use account hierarchies to create different hierarchies for different purposes and use those
hierarchies for reporting
B. Create three segments for the Company, Line of Business, and Product segments and qualify
them as primary balancing segment, second, and third balancing segments, respectively
C. Create a segment that acts as the primary balancing segment and create values that
represent a concatenation of all three business dimensions
D. Create two segments where the first segment represents the concatenation of Company and
Line of Business, and then enable secondary tracking for the Product segment
B
After loading your budget data into General Ledger Cloud, you can view budget balances using these
features. Which feature does not belong on the list?
A. Application Development Framework Desktop Integration Budget Balance Report
B. Account Inspector
C. Account Monitor
D. SmartView
A
Before implementing Financials Cloud, your customer used to manually reconcile their intercompany
payables and receivables accounts. What is a more automated approach to do this?
A. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account
balances
B. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables
and payables accounts that are out of balance
C. Run the BI Publisher reports called Intercompany Transaction Summary and Account Details
to automatically reconcile intercompany balances
D. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match the
intercompany payables and receivables balances
E. In Financials Cloud, you must manually reconcile your intercompany account balances
B
You just submitted the Accounting Configuration. What two things must happen before you can enter
journals? (Choose two.)
A. You must define a Data Access Set to obtain full read/write access to ledgers in the
Accounting Configuration
B. A Data Access Set with full read/write access to the ledger is automatically created
C. You must assign the job role and data security context to each user
D. You must re-deploy the chart of accounts
Answer : B, C
The current implementation project covers Financials (with Fixed Assets and Expenses) with
operations planned in three countries (USA, Italy, and India).
Which three labels are required when designing the chart of account structure for this project?
(Choose three.)
A. Cost center
B. Primary Balancing
C. Natural Account
D. Secondary Balancing
E. Intercompany Segment
Answer : A, B, C
You have a requirement to have invoices generated for certain Intercompany transactions.
Where do you enable invoicing?
A. the transaction source
B. the transaction type
C. the transaction category
D. the transaction batch
B
The expense account of airfare was erroneously assigned to the account type "Liability". Which
method should you choose to fix the problem?
A. Run the "Correct Misclassified Account" program
B. Deactivate the value
C. Run the "Update Balance Cube Chart of the Accounting Dimension" program
D. Run the "Segment Value Inheritance" program
A
A subsidiary company, in a highly regulated country, where there is a legal requirement to produce
fiscal reports under local GAAP, is about to configure their General Ledger.
Given the following:
Subledgers transferring to general ledger must use the local currency.
There is a requirement to report to the parent company (not local currency) using International
Financial Reporting Standards (IFRS).
Which two ledger types should be configured to address this reporting requirement? (Choose two.)
A. a secondary ledger with the IFRS accounting convention
B. a primary ledger with the IFRS accounting convention
C. a primary ledger with the local accounting convention
D. a reporting currency with the local accounting convention
E. a reporting currency with the IFRS accounting convention
A, C
You entered a journal and the client is asking for the following information: The current account
balance
What the future account balance will be if the journal is approved and posted How will you get this
information?
A. Use Oracle Transactional Business Intelligence (OTBI) to query General Ledger balances
B. View the Projected Balances region in the Create Journals page
C. Run a Trial Balance before and after posting
D. Query the account balance online
B
You want to monitor the close process of all your financial subledgers and ledgers. How can you
quickly obtain this information?
A. Use the Manage Accounting Periods page to view the status of all subledgers and ledgers
B. Run Closing Status reports
C. Access each subledgers' calendar and General Ledger's Manage Accounting Periods page to
view the status of each period
D. Use Close Monitor in General Accounting Dashboard
D
When will Intercompany processing balance a journal using the accounts identified here for the UK
Ledger?
Check image Q22
a. when the journal is balanced by second balancing segment value
b. when the journal is balanced by the primary BSV but not by second or third BSV
c. when the journal is not balanced by the primary balancing segment value (BSV)
d. when there is a many-to-many journal and you want to use a clearing company
B
During implementation, a consultant accidentally designated the cost center segment as the natural
account. Values have already been assigned and journals have been posted.
Select the process that allows you to change the qualifier back to cost center qualifier.
A. Change and save the segment qualifier.
B. Delete the segment and create a new segment with the correct qualifier.
C. Create a new chart of accounts.
D. Delete the chart of accounts and create a new one.
C
Which feature outside of reporting and analysis leverages the Essbase cube?
A. calculation manager to perform allocations based on multidimensional balances and budgets
B. period closing and opening of ledgers to keep General Ledger Cloud and the Essbase cubes
in sync
C. journal entries and journal approval to create journals that update balances to the cube
directly
D. revaluations and translation to revalue and translate currencies stored in the Essbase cube
A
You are creating financial statements and want to have charts, such as a bar graph, automatically
inserted to improve the understanding financial results. How would you achieve this?
A. When designing your financial statement using Financial Report (FR), embed a chart into
your report
B. Use Account Inspector that automatically creates graphs on financial balances
C. When viewing the report, download to Excel and use Excel's Charting features to create your
bar graph
D. Use Smart View, which is an Excel Add-on
A
You want to process multiple allocations at the same time. What feature do you use?
A. Point of View (POV)
B. General Ledger journal entries
C. RuleSets
D. Formulas
C
Which two are valid Data Access Set types? (Choose two.)
A. Read and Write access
B. Read Only access
C. Primary Balancing Segment Value
D. Full access
E. Full Ledger
C,E
Which tool can you use to create a Financial Income Statement?
A. Rapid Implementation Enterprise Structures setup
B. One View Reporting
C. Account Inspector
D. PS/nVision
C
In which two ways can your users personalize the Springboards and Work Areas to suit their
individual working styles? (Choose two.)
A. They can use "+" under the Apps section of the News Feed homepage
B. They can have the System Administrator configuring pages for them using Page Composer
C. They can format certain tables by hiding and showing columns, moving columns, and resizing
columns
D. Users have very little control configuring their Springboards and Work Areas; they can only
resize columns
A, C
Which three objectives must be considered when designing the chart of accounts? (Choose three.)
A. Limit the number of segments to those you need today to reduce data entry
B. Effectively manage an organization's financial business
C. Anticipate growth and maintenance needs as organizational changes occur
D. Try to use all 30 segments and 25 characters per segment because you cannot change it
later
E. Consider implementing a single, global chart of accounts
B, C, E
Journal Description Rules are assigned to Subledger Journal Entry Rule Sets.
What are the other three subcomponents of a Subledger Journal Entry Rule Set? (Choose three.)
A. Chart of Accounts
B. Account Rules
C. Supporting Reference
D. Accounting Date
E. Journal Line Rules
B, C, E
On a primary ledger in the system options close section, the following field has been selected ‘Prevent General Ledger Period Closure When Open Subledger Periods Exist’.
For which three subledgers can you opt out of the period close checking feature by using the lookup ORA_GL_INCLD_STRICT_PRD_CLOSE? (Choose three.)
A. Receivables
B. Assets
C. Receipt accounting
D. Order Management
E. Revenue Management
A, B, E
You want to automatically post journal batches imported from subledger source to prevent accidental edits or deletions of the subledger sources journals, which could cause an out-of-balance situation between your sub ledgers and general ledger. Which two aspects would you consider when defining your AutoPost Criteria?
A. Use the all option for category and accounting period to reduce maintenance and ensure that all imported journals are included in the posting process.
B. Include all of your sub ledger sources in the AutoPost criteria. Divide up criteria sets by subledger source only if you need to schedule different posting times.
C. Create your AutoPost criteria using minimal source and categories..
D. Schedule your AutoPost criteria set to run during off-peak hours only.
A, B
How can your Accounting Manager expedite journal processing during the time-critical month-end close?
A. by creating an ad hoc query on journals using Oracle Transactional Business Intelligence (OTBI)
B. by using the Journals region to view journals Requiring Attention, Requiring Approval, and Pending Approval from Other
C. by using the Close Status monitor to drill down on the close status across ledgers
D. by running the Journals report using Business Intelligence Publisher
B
Your customer has a number of Chart of Account Mapping Rules for their Primary and Secondary ledgers. You decide to use the FBDI template to load the rules.
Which two statements are true when using this method of entry? (Choose two.)
A. It supports external integration using REST services.
B. You can create, update, and delete segment rules for a chart of accounts mapping.
C. You can create, update, and delete account rules for a chart of accounts mapping.
D. You can download the template only from the Manage Chart of Accounts Mappings page.
B, C
Which two allow access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis? (Choose two.)
A. Reports and Analytics
B. Scheduled Processes
C. Business Process Management Workspace
D. Universal Content Management Workspace
E. Enterprise Performance Management Workspace
A, E
What are the two purposes of a secondary ledger? (Choose two.)
A. It should only be used to main balances for processing performance
B. It can differ from its primary ledger by the accounting method, chart of accounts, accounting calendar, currency, and/or journal processing options
C. It should not be used when trying to meet local accounting requirements
D. It is used to main balances in a different currency only
E. It is an optional ledger that is linked to a primary ledger for the purpose of tracking alternative accounting
B, E,
You are using account hierarchies for reporting and allocations.
Which two statements are true about these types of hierarchies? (Choose two.)
A. Hierarchies for reporting and allocations have to be published to Essbase cubes.
B. You can have only one version of a hierarchy published to the Essbase cube at any time.
C. Hierarchies for reporting and allocations do not have to be published to Essbase cubes.
D. Child values in these hierarchies can belong to only one parent.
A, D
Most of the accounting entries for transactions form your source system use TRANSACTION_AMOUNT as a source of the entered amount accounting attribute. For some events, you need to use TAX_AMOUNT as the source.
At what level can you override the default accounting attribute assignment?
A. Journal Line Rule
B. Journal Entry
C. Event Type
D. Journal Entry Rule Set
E. Event Class
A
You need to create a month-end reporting package for an upcoming Audit Committee meeting, you have 10 financial reports that you want to share with executives and auditors that are nicely formatted.
Identify the two Oracle recommended ways to accomplish this. (Choose two.)
A. Using Workspace, assemble multiple reports into a book that can be printed and viewed individually as an entire book
B. Use OTBI to create multiple reports that you save to a folder that only the users can access
C. Create a Smartview report, where the various sheets represent the different Financial Statements and send them the spreadsheet
D. Use BI Publisher to configure the reports and then use bursting to email the reports to the executives and Audit Committee
E. Use a report batch to run reports at a specific time to create a set of snapshot reports
A, E
Your Financial Analyst needs to interactively analyze General Ledger balances with the ability to drill down to originating transactions. Which three features facilitate this? (Choose three.)
A. Sunburst reports
B. Online Transactional Business Intelligence
C. Account Monitor
D. Account Inspector
E. Smart View
C, D, E
Your company has two legal entities in the US (Balancing Segment Values [BSV] 101 and 102), one legal entity in France (BSV 401), and one legal entity in the UK (BSV 402).
Both US legal entities share the same ledger, whereas the UK and France have their own ledgers.
Assuming intercompany transactions are not being entered, what is the minimal action you can take and still configure the ledgers correctly?
A. You should assign a balancing segment value to identify each legal entity in the US Ledger and assign the balancing segment values to the ledger in the UK and France.
B. You should assign a balancing segment value to identify each legal entity in each ledger.
C. You should assign the balancing segment value to the ledger in the US and assign a balancing segment value to identify each legal entity in the UK and France ledgers.
D. You should assign a balancing segment value to identify each legal entity in the US ledger.
A
Your company has complex consolidation requirements with multiple general ledger instances. You are using Oracle Hyperion Financial Management to consolidate the disparate General Ledgers. You can typically map segments between your general ledger segment to a Hyperion Financial Management segment, such as Company to Entity, Department to Department, and Account to Account. What happens to segments in your source general ledger, such as Program, that cannot be mapped to Hyperion Financial Management?
A. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management
B. The unmapped segments default to future use segments in Hyperion Financial Management
C. No data is transferred
D. Data is summarized across segments that are not mapped to Hyperion Financial Management
D
Which feature outside of reporting and analysis leverages the Essbase cube?
A. revaluations and translation to revalue and translate currencies stored in the Essbase cube
B. journal entries and journal approval to create journals that update balances to the cube directly
C. Calculation manager to perform allocations based on multidimensional balances and budgets
D. period closing and opening of ledgers to keep General Ledger Cloud and the Essbase cubes in sync
C
You want to define an allocation rule where segment values are constants for rules and formulas. What should you do?
A. Only specify segment values in formulas
B. Specify Run Time Prompts (RTP)
C. Always use the Outer Point of View (POV)
D. Never use the Outer Point of View (POV)
C
You want to enter budget data in General Ledger Cloud. Which method is not supported?
A. Entering budget journals
B. File-based Data Import
C. Direct budget balance updates from a Financial Statement in Smart View
D. Application Development Framework Desktop Integration (ADFdi)
A
You have a requirement for the Intercompany Provider and Receiver distribution accounts to be created automatically for all intercompany transactions.
What should you configure?
A. a Provider and Receiver distribution set
B. the Transaction Account Definition
C. the AutoAccounting Definition
D. Intercompany transaction type default accounts
A
You need to define a chart of accounts that includes an intercompany segment. Your customer plans to use segment value security rules for the Company segment.
What is Oracle’s recommended method to define this chart of accounts?
A. Define the company segment and assign both the primary balancing segment and intercompany segment labels.
B. Share the same value set for the company and intercompany segments.
C. Create two different value sets for the company and intercompany segments.
D. Define the intercompany segment with a default value.
C