Question 1:
The General Ledger Implementation team is using the file-based data import
(FBDI) template to load chart of account mappings. While loading data from
the interface, they want to change only the subset of records, because they
have created only a subset of mapping data. Which mode should the team
use while importing chart of accounts mapping rules?
All
Update
Increment
Replace
Question 2:
You redesigned your chart of accounts and need to update your existing
cross-validation rules. There is a requirement for new rules; some need to be
updated and others need to be deleted. What is the most efficient way to
achieve this? What should you do to allow access to the ledger?
By using Cross-Validation Rules Import file-based data import (FBDI)
On the Manage General Ledger Security page
On the Manage Cross-Validation Rules page
By creating a Cross-Validation Rules desktop-integrated spreadsheet
Question 3:
You want your sales representatives to be able to find points of interest, such
as customers, while out on business. What should you enable to achieve
this?
Geocoding
Validation
Address Cleansing
HZ_GEO_IDENTFIER_SUBTYPE lookup
Question 4:
You need to add new transactional attributes to the journal approval
notification in an implementation project. Which two Business Intelligence
catalog objects should you copy (or customize) and edit?
Sub template
Output type
Layout template
Data model
Style template
Question 5:
When will intercompany processing, balance a journal using the accounts
identified here for the UK Ledger?
When the journal is balanced by the second BSV
When the journal is not balanced by the primary balancing segment
value (BSV)
When the journal is balanced by the primary BSV but not by the second or
third BSV
When there is a many-to-many journal and you want to use a clearing
company
Question 6:
You are defining intercompany balancing rules that are applied to a specific
source and category,such as Payables and Invoices, or a specific
intercompany transaction type, such as IntercompanySales. Which two
statements are true?
You must define a chart of accounts rule to ensure that
intercompany balancing will always find a rule to use to generate
balancing accounts.
You must define intercompany balancing rules for all sources, categories,
and transactiontypes.
You can create a rule for all sources and categories by selecting the
source Other and the category Other.
Intercompany balancing evaluates the rules in this order: Ledger, legal
entity, chart of accounts, and primary balancing segment value.
Question 7:
An Oracle Fusion Cloud customer has a complex enterprise structure that
includes multiple legal entities in multiple countries. To match the
intercompany balancing requirements, all four levels of rules have been
defined. In user testing, the business experts are asking which rule will be
considered first when balancing an intercompany journal?
Primary balancing segment rule
Ledger-level rule
Chart of accounts rule
Legal entity–level rule
Question 8:
The intercompany accountants on the cloud project are trying to reconcile
intercompany balances using the latest intercompany reconciliation report.
However, they have some concerns about the information presented in the
report and want you to clarify the content in the standard reconciliation
report. What is included in the intercompany reconciliation report?
It displays all clearing company balances for the period.
It displays ledger balancing lines generated when the primary balancing
segment (BSV) is inbalance but not the second or third BSVs.
It displays the intercompany receivables and intercompany payables
lines generated for the provider and receiver of each intercompany
transaction
Question 9:
You want to run a Financial Reporting Web Studio report from Financial
Reporting Center but it isnot displayed as a choice. Which two actions must
you perform for it to appear?
Save it in the MyFolders directory.
Upload it to Financial Reporting Center.
Download the report to your local drive.
Save it in the Shared Folder/Custom/Financials directory.
Question 10:
Which two allow access to the BI catalog for creating an Oracle Transactional
Business Intelligence analysis?
Reports and Analytics
Scheduled processes
Business Process Management Workspace
Universal Content Management Workspace
Enterprise Performance Management Workspace
Question 11:
You want to create an Ad Hoc Analysis in Smart View. You enter the following
dimensions for the report and click Refresh in the POV.
You get #Missing instead of a balance. What value did you not specify, which
resulted in this?
Product
Intercompany
Cost Center
Particular currency
Question 12:
As part of your cloud migration project, you are using the Create Budgets in
a Spreadsheet option to load your budget balances into the General Ledger
balance cube. Your FYXX Budget is not appearing in the Budget Name list of
values. What are the reasons for this?(Select only 1 answer)
A value for the budget scenario is not created.
The Publish Chart of Accounts dimensions and Hierarchies program to the
balance cubes has not been run.
Budgeting in not enabled in the Ledger options.
Question 13:
You are using the Create Budgets in a Spreadsheet option to load your
budget balances into the General Ledger balances cube. Your FYXX Budget is
not appearing in the Budget Name list of [Link] are two reasons for
this?
Publish Chart of Accounts Dimension Members and Hierarchies to the
Balances Cube has not been run.
Transfer Budget Balances to Budget Cubes has not been run.
The Create Scenario Dimension Members program has not been run.
Budgeting is not enabled in the Ledger options.
A value for the budget scenario is not created.
Question 14:
In a primary ledger, under the System options, in the Close section, the
Prevent General LedgerPeriod Closure When Open Subledger Periods Exist
option has been selected. For which subledger can you opt out of the Period
Close Checking feature by using the ORA_GL_INCLD_STRICT_PRD_CLOSE
lookup?
Order Management
Lease accounting
Accounts Payable
Question 15:
Your ledger currency is USD. At month end, you have a balance on the
Accounts Payable LiabilityAccount of 100,000 Euros, which is equivalent to
136,550 USD. This balance needs to be [Link] month-end exchange
rate for revaluation is 1 Euro = 1.3755 USD. What two statements are true
about the resulting revaluation run?
The original journal entry in Euros is updated.
The original journal entry in Euros remains the same.
You have an unrealized exchange gain recorded.
You have an unrealized exchange loss recorded.
There is no unrealized exchange gain or loss calculated.
Question 16:
For translation purposes, the Financials reporting team has decided to load
the monthly Historical currency rates by using File-Based Data Interface
(FBDI). What happens to the existing historical rate for a specific ledger,
currency, account combination, and accounting period if they use insert in
the spreadsheet?
Historical rates are converted into an average rate (original and new rate).
The existing historical rate is deleted.
Nothing, existing historical rates are not updated.
The historical rate is replaced.
Question 17:
All your subsidiaries can share the same ledger with their parent company
and all reside on the same application instance. They perform intercompany
accounting. What is Oracle's recommended approach for performing
consolidations?
Use General Ledger's Financial Reporting functionality to produce
consolidated reports by balancing segment where each report
represents a different subsidiary. Any eliminating entries can be
entered in yet another separate balancing segment.
Use Oracle Hyperion Financial Management for this type of complex
consolidation. Use General Ledger's Balance Transfer programs to transfer
subsidiary ledger balances to theparent ledger, and then enter eliminating
entries as a separate balancing segment in the parent ledger.
Define multiple ledgers for consolidation and report on the ledger set.
Question 18:
You can run predefined reports to reconcile subledger application balances
to General Ledger balances. Which attribute must you 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?
Financial Category
Reconcile
Start Date
End Date
Third Party Control
Account
Question 19:
You are setting up Close Monitor and want to view high-level profit and loss
results for each [Link] should you associate with the ledger set to
achieve this?
OTBI report
Trial Balance report
Financial Reporting Web Studio report
Account group
Question 20:
Which feature do you use to achieve multi-step cascading
allocations?
Formulas
General Ledger journal entries
Rule sets
Point of View (POV)
Question 21:
You have just been hired to add a new subsidiary to the corporate enterprise
structure in the customer's Oracle Fusion Cloud. The subsidiary will capture
transaction information from subledgers in the local currency and
underInternational Financial Reporting standards (IFRS) and local GAAP for
corporate reporting requirements, which will report via the use of a
secondary ledger. The secondary ledger is used only at period end; there is
no need to have real-time transaction or Journal details. It is noted that most
of the accounting between IFRS and Corporate GAAP is [Link]
conversion level would you recommend to keep a thin secondary ledger?
Adjustment only
Journal ledger
Balance level
Sub-ledger level
Question 22:
The cloud client is about to report on financial balances from the GL Balance
[Link] want to know when the summarized levels of the dimensions are
updated. Which two statements are true about dimension balances in
General Ledger cubes?
They are updated automatically when the general ledger period is
opened.
They are automatically updated when you enter a manual journal.
They are automatically updated when the translation is run
They are automatically updated when you load a spreadsheet journal into
the gl_interfacetable.
Question 23:
You already ran Translation, but a last-minute adjusting journal entry in your
ledger currency was entered and posted after you consolidated your results.
What is Oracle's recommended practice when this occurs?
Enter another adjusting journal entry in the target currency to true up the
balances.
Translate only the adjusting journal entry.
Rerun Revaluation and then rerun Translation.
Rerun Translation and then reconsolidate your results.
Question 24:
A subsidiary company is required to report to the parent company on a
monthly basis. The subsidiary is in another country and there is no
requirement to have daily [Link] objective is to minimize data
stored in the reporting currency.
Journal level
Subledger level
Balances level