Oracle Financials Exam Prep
Oracle Financials Exam Prep
Oracle
Exam 1z0-960
Oracle Financials Cloud: General Ledger 2017 Implementation
Essentials
Version: 5.0
You want to enter budget data in Fusion General Ledger. Which method is not supported?
A. Smart View
B. Application Development Framework Desktop Integration (ADFdi)
C. File-based Data Import
D. Entering budget Journals
Answer: D
Reference:
http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e20384/glossary.htm
Question No : 2
You want to define an allocation rule where segment values are constants for rules and
formulas. What should you do?
Answer: D
Question No : 3
All of your subsidiaries can share the same ledger with their parent company and all reside
on the same application instance. They do perform intercompany accounting.
What does Oracle consider the best practice approach to performing consolidations?
A. Use Oracle Hyperion Financial Management for this type of complex consolidation.
B. Use General Ledger's Balance Transfer programs to transfer subsidiary ledger balances
2
Oracle 1z0-960 : Practice Test
to theparent ledger, and then enter eliminating entries as a separate balancing segment in
the parent ledger.
C. Use General Ledger’s Financial Reporting functionality to produce consolidated reports
bybalancing segment where each report represents a different subsidiary. Any eliminating
entries can be entered in yet another separate balancing segment.
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 create a ledger set across all ledgers and report on the
ledger set.
Answer: A
Reference:
http://www.oracle.com/us/solutions/business-intelligence/consolidation-solution-
1876985.pdf
Question No : 4
Answer: A,B,D
Question No : 5
You entered a journal and the client is asking for the following information:
3
Oracle 1z0-960 : Practice Test
• What the future account balance will be if the Journal is approved and posted
Answer: C
Question No : 6
You are reconciling your Payables the Receivables balances against the General Ledger.
You are using the Payables to Ledger Reconciliation report. You notice discrepancies
between thebalances in the subledgers, subledger accounting, and general ledger.
A. All sub ledger transactions have been entered but do not have complete accounting.
B. Subledger transactions have been accounted and transferred to General Ledger but
have not been posted.
C. There were manually entered journals against the Payables and Receivables accounts
that were posted in General Ledger.
D. Intercompany transactions have not been fully processed.
E. Period Close processes,such as Revaluation, Translation, and Consolidation have not
beenperformed yet
Answer: B,D,E
Question No : 7
While creating a Journal Entry Rule Set, you are not able to use an Account Rule recently
created.
4
Oracle 1z0-960 : Practice Test
A. The Account Rule is defined with a different chart of accounts from the Journal Entry
Rule Set.
B. The Account Rule's chartof accounts have no account values assigned
C. The Account Rule's conditions are not defined.
D. The Account Rule is using sources assigned to different event classes from that of the
associated Journal Entry Rule Set.
Answer: B,D
Question No : 8
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 Intercompany Sales.
A. You must define rules for every combination of specific categories and sources.
Otherwise, theintercompany balancing will not work.
B. You can create a rule for all sources and categories by selecting the source "Other" and
the category "Other."
C. If you choose to have rules at various levels, then intercompany balancing evaluates the
rules in this order: Ledger, Legal Entity, chart of accounts, and primary balancing segment
value.
D. Set up a chart of accounts rule for every chart of accounts structure you have in order to
ensurethat Intercompany Balancing will always find a rule to use to generate balancing
accounts.
Answer: A,C
Question No : 9
Your customer wants to secure their primary balancing segment values to prevent
employees of one company from entering or viewing data of another company. You only
need this for General Ledger balances and reporting.
A. Data Access Sets using an Access Set Type of Primary Balancing Segment
5
Oracle 1z0-960 : Practice Test
B. Cross-Validation Rules
C. Segment Value Security
D. Balancing Segment Value Assignment to Legal Entities
Answer: A,C
Explanation:
https://docs.oracle.com/cd/E18727_01/doc.121/e13620/T450006T450009.htm
Question No : 10
You want to prevent intercompany transactions from being entered during the last day of
the close.
Answer: B
Question No : 11
You lust submitted the Accounting Configuration. Which two statements are correct?
A. You must define a Data Access Set to obtain full read/write access to the ledgers in the
Accounting Configuration.
B. A Data Access Set with full read/write access to the ledger is automatically created.
C. Open the ledger's period to begin entering transactions.
D. Verify the data roles created and assign them to the General Ledger users.
Answer: C
Question No : 12
6
Oracle 1z0-960 : Practice Test
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 Hyperion Financial Management?
Answer: C
Question No : 13
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 does Oracle consider as best practice to define this chart or accounts?
A. Share the same value set for the company and intercompany segments to reduce chart
of accounts maintenance.
B. Use two different value sets for the company and intercompany segment because
segment value security rules are at the value set level.
C. Define the company segment only and qualify it as both the primary balancing segment
andintercompany segment.
D. Define two different charts of accounts.
Answer: C
Question No : 14
7
Oracle 1z0-960 : Practice Test
journals from subledgers at different times.
Which journal attribute should you use to set the automatic posting criteria?
A. Journal Category
B. Journal Source
C. Journal Batch
D. Journal Description
Answer: C
Question No : 15
When working with Essbase, versions of the tree hierarchy as defined in the Fusion not
available in the Essbase balances cube.
Answer: D
Question No : 16
Answer: B,D,E
8
Oracle 1z0-960 : Practice Test
Question No : 17
Most of the accounting entries for transactions from 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. Event Type
B. Journal Line Rule
C. Event Class
D. Journal Entry Rule Set
E. Journal Entry
Answer: D
Question No : 18
You entered users who are both employees and contingent workers. You want an
automated way to assign, reassign, and remove roles from users. What feature do you
use?
Answer: C
Question No : 19
What type of user must be defined before you can create an Implementation Project?
A. None. The Fusion Applications Superuser, FAADMIN, has full access to create an
Implementation Project.
B. A full-time employee that has the FSM Superuser role assigned
C. None. The OIM system administrator user ID, XELSYSADM, which is assigned by the
person provisioning the system, has full access.
9
Oracle 1z0-960 : Practice Test
D. Implementation Users
E. All roles that will be used throughout the implementation
Answer: E
Question No : 20
You operate in a country whose unstable currency makes it unsuitable for managing your
day-to-day business. As a consequence, you need to manage your business in a more
stable currency while retaining the ability to report in the unstable local currency.
A. Define Balance-Level Reporting Currencies in the more stable currency and run
Translation as often as you need.
B. Use Journal-Level or Subledger-Level Reporting Currencies denominated in the more
stable currency.
C. Run Revaluation as often as you need to the more stable currency and report on the
more stable currency’sbalances.
D. Create a secondary ledger that uses a different chart of accounts that is denominated in
the more stable currency.
Answer: B
Reference:
http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20374/F484499AN16AFA.htm
Question No : 21
How do you hide accounts with no balances showing #Missing in Smart view?
Answer: A
10
Oracle 1z0-960 : Practice Test
Reference:
http://www.miamidade.gov/budget/library/bat/smartview-training-manual.pdf
Question No : 22
What's the difference between subject areas that append the word "Real Time" and those
that do not?
A. There is no difference.
B. The “Real Time” subject areas are based on real-time transactions and all others are
based on Historical data.
C. The “Real Time” subject areas are based on real-time transactions in Fusion
Applications, and all others are based on data stored in the Oracle Business Intelligence
Applications data warehouse.
D. The “Real time” subject areas are based on sub ledger transactions and all others are
based on general ledger balances.
Answer: B
Question No : 23
Your foreign currency transactions need to be revalued every month. For balance sheet
accounts, you reverse the revaluation journals in the next period. You are using the period-
to-date (PTD) method of revaluation tor your income statement accounts.
Answer: B
11
Oracle 1z0-960 : Practice Test
Question No : 24
Alter submitting the journal for approval, you realize that the department value in the journal
incorrect. How do you correct the value?
Answer: B
Question No : 25
What are the tables or views from which the Create Accounting program takes source data
that is used in rules to create journal entries?
A. Transaction Objects
B. Event Entities
C. Mapping Sets
D. Accounting attributes
E. Event Classes
Answer: A
Reference:
https://docs.oracle.com/cd/E18727_01/doc.121/e13420/T193592sdextchap.htm
Question No : 26
You are reconciling your subledger balances and you need a report that includes beginning
and ending account balances and all transactions that constitute the account's activities.
12
Oracle 1z0-960 : Practice Test
B. Account Analysis Reports
C. Journals Reports
D. Aging Reports
Answer: C
Question No : 27
Answer: B,C,D
Question No : 28
You created your first Implementation Project and assigned the Application Implementation
Consultant role to your user. However, you are unable to access Oracle Identity
Management (OIM). This issue was caused because you did not assign the_____.
Answer: A
Question No : 29
Your customer has enabled encumbrance accounting. You have a control budget with the
13
Oracle 1z0-960 : Practice Test
advisory level set at control. For November 2015, your budget for a given combination is
$5,000 USD. You have an approved requisition of $900 USD and you have an approved
purchase order of $2,500 USD. An adjustment encumbrance journal is created in the
General Ledger for the obligation type for $1,600 USD. You then cancelled the approved
PO line of $400 USD. For November 201b, you created a new invoice by matching to the
PO for $2,100 USD.
Answer: C,E
Question No : 30
You create a prepayment for USD l00 and validate it to consume the budget and reduce
available funds under the prepayment account. You then pay the prepayment of USD 100
create an invoice for USD 300, and validate the* invoice to consume the budget and
reduce available funds for the expense-accounts used in the invoice. You then apply the
prepayment fully on to the invoice and revalidate it.
What happens to the available funds when you apply a prepayment that requires budgetary
control?
A. The prepayment application was already released at the time of payment and the
invoice consumes funds of 300 USD.
B. The prepayment application releases funds of 200 USD ^nd the invoice consumes funds
of lOO USD, with a net decrease to available funds of 200 USD.
C. Available funds will not change till invoice is approved.
D. The prepayment application releases funds of lOO USD and the invoice consumes
funds of 300 USD, with a net decrease to available funds of 200 USD.
E. The prepayment application releases funds of 300 USD and the invoice consumes
14
Oracle 1z0-960 : Practice Test
funds of 300 USD, with a net decrease to available funds of 100 USD.
F. The budget will be released only foi the USD 30O invoice amount.
Answer: F
Question No : 31
What is the most efficient way to add a new year to the accounting calendar?
Answer: D
Reference:
https://docs.oracle.com/cd/E13228_01/fscm9pbr0/eng/psbooks/fspf/chapter.htm?File=fspf/
htm/fspf13.htm
Question No : 32
Your customer wants to have balance sheets and income statements for their cost center
and program segments. That is, they want to have three balancing segments.
A. When entering journals manually, the customer will need to make sure that the debits
and credits are equal across all balancing segments because the system will not
automatically balance the journal.
B. Every journal where debits do not equal credits across the three balancing segments will
result in the System generating extra journal lines to balance the entry.
C. Additional intercompany rules will need to be defined for the two additional balancing
segments.
D. Ledger balancing rules will need to be defined to instruct the system on how to generate
balancing entries for the second and third balancing segments.
15
Oracle 1z0-960 : Practice Test
Answer: A,D
Question No : 33
Answer: A,B,C
Question No : 34
Which reporting tool is best suited for submitting high-volume transactional reports, such as
invoice Registers or Trial Balance reports, that can be configured to extract the data in Rich
Text Format or XML?
Answer: B
Question No : 35
After loading your budget data into Fusion General Ledger, you can view budget balances
using these feature.
16
Oracle 1z0-960 : Practice Test
Which feature does not belong on the list?
Answer: B
Question No : 36
Your customer is using budgetary control and encumbrance. You have an open purchase
order for $500 USD, which you decide to match to an invoice for $300 USD.
What will be the fund status of the purchase order and invoice?
A. The purchase order is Partially Liquidated and the invoice is Partially Reserved.
B. The purchase order is Partially Liquidated and the invoice will be reserved.
C. Both are reserved.
D. The purchase order is liquidated and the invoice is Partially Reserved. E. Both are
Partially Reserved.
E. The purchase order is Open and the invoice is validated.
Answer: C
Question No : 37
Your company wants to change the Cumulative Translation Adjustment (CTA) account to
record gains/losses from varying currency rates.
What steps must you perform to achieve this objective without causing data corruption?
A. Purge all translated balances, change the CTA account in the Ledger page, and rerun
Translation for all periods required.
B. Open the Ledgers page and update the CTA account and then rerun Translation for all
periods required. The system will automatically update the translated balances.
C. Query the Translation journals and delete all of them, then change the CTA account in
the Ledger page, and rerun Translation for all periods required.
17
Oracle 1z0-960 : Practice Test
D. Define a new ledger and accounting configuration. The CTA account cannot be updated
after the ledger has been in use.
Answer: B
Reference:
http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20375/F350915AN25358.htm
Question No : 38
Answer: B,E
Question No : 39
Answer: A,B,C
Explanation:
http://docs.oracle.com/cd/E29505_01/fusionapps.1111/e20365/F530303AN100AE.htm
18
Oracle 1z0-960 : Practice Test
Question No : 40
You want to automatically post journal batches imported from subledger source to prevent
accidental edits of deletions of the subledger sources journals, which could cause an out -
of-balance situation between your sub ledgers and general ledger.
Which two aspects should 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
Answer: B
Question No : 41
Which two reports should they use In addition to using the intercompany Reconciliation
report?
Answer: C
Question No : 42
Which statement is true when creating an Implementation Project for Financials Cloud?
19
Oracle 1z0-960 : Practice Test
changes later.
C. You must select the Offering "Financials," and each individual product or option to
perform the setup for each product in Financials Cloud.
D. Selecting the Offering "Financials," automatically allows you to perform the setup for all
Financials Cloud products.
E. You only need to make the project name unique, then you can perform the setup for any
product family, such as Financials, Procurement, Human Capital Management and Supply
Cham Management.
Answer: C
Question No : 43
You are implementing Segment Value Security rules. Which two statements are true?
Answer: A,C
Explanation:
https://docs.oracle.com/cloud/farel8/financialscs_gs/FACSF/F1004387AN145CC.htm
Question No : 44
You've set up the standard accrual with encumbrance accounting for your ledger and you
realized that the encumbrance journals are defaulting with current date as the accounting
date.
20
Oracle 1z0-960 : Practice Test
A. The subledger accounting option Is set to system date.
B. The actual accounting date was set up under the encumbrance accounting Default Date
Rule.
C. The system date was set up under the encumbrance accounting Default Date Rule.
D. The current transaction accounting date was set up under the encumbrance accounting
Default Date Rule.
E. The prior related transaction accounting date was set up under the encumbrance
accounting Default Date Rule.
Answer: D
Question No : 45
Your new accountants have been making mistakes in reconciling accounts assigned to
them. Yourbalances have either spiked or dropped 30-40% every period due to human
error. This causes delays in reconciliation.
What feature can you use to be proactively notified of account anomalies in a more
timelymanner?
A. Smart View
B. Financial Reports with Embedded charts
C. Account Monitor
D. Account Inspector and its charts
Answer: A
Question No : 46
Answer: B
Reference:
21
Oracle 1z0-960 : Practice Test
http://docs.oracle.com/cd/E12825_01/epm.111/esb_dbag/frameset.htm?hybrid.htm
Question No : 47
Fusion Accounting Hub includes Hyperion Data Management. For which two tasks can
Hyperion Data Management be used?
Answer: A,C
Explanation:
http://docs.oracle.com/cd/E25178_01/fusionapps.1111/e20374/F484243AN100CE.htm
Question No : 48
You customer is a financial Institution that needs to maintain overage daily balances (ADB).
Which two statements are true regarding this functionality in Fusion Applications?
A. ADB provides organizations with the ability to track average and end-of-day balances,
reportaverage balance sheets, and create custom reports using both actual and average
balances.
B. Average balances are stored for both subledger balances and general ledger balances.
C. Average balances are stored in the Essbase cube.
D. Average balances are maintained for both actual and budget balances.
E. When using ADB, you must define a daily calendar and assign it to your ADB ledger.
Answer: A,D
22
Oracle 1z0-960 : Practice Test
Question No : 49
You want to process multiple allocations at the same time. What feature do you use?
A. RuleSets
B. Point of View (POV)
C. Formulas
D. General Ledger Journal entries
Answer: C
Question No : 50
While troubleshooting the encumbrance entries created for the requisition for your business
unit, you noticed that only a few events are triggering the encumbrance journals when you
submit he create accounting program.
A. Funds check
B. Requisition approved
C. Requisition rejected by the buyer
D. Submit the requisition for approval
E. Checkout and Save the requisition
F. Create change request on the requisition after submitting requisition for approval
Answer: B,F
Question No : 51
You want to display OTBI reports and graphs in PowerPoint to show general ledger or
subledger data.
A. Download OTBI reports and charts to a spreadsheet and then copy and paste the
spreadsheet to PowerPoint
23
Oracle 1z0-960 : Practice Test
B. Use SmartView to create reports and charts using general ledger and subledger subject
areas embed the charts/reports into PowerPoint
C. Use Smart View and Oracle BI EE View Designer to create reports in PowerPoint, Word,
and Excel.
D. Use Account Inspector and then export to Excel and copy and paste into PowerPoint.
Answer: C
Reference:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/smartview/sm
art_view.htm
Question No : 52
Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They
use intercompany entries.
A. Define three segments for the company, department, and natural account. The qualifiers
shouldbe primary balancing segment, cost center segment, and natural account segment,
respectively
B. Define four segments for the company, department, natur.il account, and intercompany
segment. The qualifiers should be primary balancing segment, cost center segment,
natural account segment, and intercompany segment, respectively.
C. Define five segments for the company, department, natural account, intercompany, and
future use segment. The qualifiers should be primary balancing segment, cost center
segment, natural account segment, intercompany segment, and no qualifier, respectively.
D. Define three segments tor the company, department, and natural account. The qualifiers
for the first segment should be primary balancing segment and intercompany segment,
cost center segment, and natural account segment, respectively.
Answer: C
Question No : 53
24
Oracle 1z0-960 : Practice Test
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.
A. Use Oracle Hyperion Financial Management for this type of complex consolidation.
B. 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.
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 create a ledger set across all ledgers and report on the
ledger set.
Answer: D
Question No : 54
You are creating financial statements and want to have charts, such as a bar graph,
automatically inserted to improve the understanding of the financial results.
A. When viewing the report, download to Excel and use Excel's Charting features to create
your bar graph.
B. When designing your financial statement using Financial Report (FR), embed a chart
into your report
C. Use Account Inspector that automatically creates graphs on financial balances.
D. Use Smart View, which is and Excel Add-on
Answer: C
Reference:
https://docs.oracle.com/cd/E37017_01/doc.1115/e22893/F479559AN10590.htm
25
Oracle 1z0-960 : Practice Test
Question No : 55
A. Provide a central place to access and perform all of the setup steps across Fusion
application product
B. Automatically generate lists of setup tasks in the correct sequence with dependencies
highlighted.
C. Automatically mark the status of tasks as Completed after they have been completed.
D. Assign setup tasks to individuals with due dates where users must manually update their
completion status.
E. Centrally manage the close processes across subledgers and ledgers.
Answer: A,B,E
Question No : 56
You want to monitor the dose process of all your financial subledgers and ledgers.
A. Access each subledgers' calendar and General Ledger's Manage Accounting Periods
page to view the status of each period.
B. Use the Manage Accounting Periods page to view the status of all subledgers and
ledgers.
C. Use Close Monitor in General Accounting Dashboard.
D. Run Closing Status reports.
Answer: D
Question No : 57
Your Financial Analyst needs to interactively analyze General Ledger balances with the
ability down to originating transactions.
26
Oracle 1z0-960 : Practice Test
A. Account Inspector
B. Smart View
C. Account Monitor
D. Online Transactional Business Intelligence
E. Financial Reports published to Excel
Answer: E
Question No : 58
In which two ways can your users customize the Dashboards and Work Areas to suit their
individual working styles?
A. They can format each table by hiding and showing columns, moving columns, and
resizing columns.
B. They can use Personalization to move and remove regions from those pages.
C. Users have very little control customizing their Dashboards and Work Areas; they can
only resize columns.
D. They can have the System Administration customize pages for them using Page
Composer.
Answer: C
Question No : 59
Your customer wants to create fully balanced balance sheets for the Company, Line of
Business, and product segments for both financial and management reporting.
A. Create a segment that acts as the primary balancing segment and create values that
represent a concatenation of all three business dimensions.
B. Use account hierarchies to create different hierarchies for different purposes and use
those hierarchies for reporting.
C. Create three segments and qualify them as the primary balancing segment, second, and
third balancing segments, respectively.
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.
27
Oracle 1z0-960 : Practice Test
Answer: C
Reference:
http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20374/F484498AN122F4.htm
Question No : 60
Which three objectives must be considered when designing the chart of accounts?
Answer: A,B,C
Question No : 61
Before implementing Fusion Financials, your customer used to manually reconcile their
intercompany payables and receivables accounts.
A. Run the BI Publisher reports called Intercompany Transaction Summary and Account
Details to automatically reconcile intercompany balances.
B. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match
the intercompany payables and receivables balances.
C. Run the Intercompany Reconciliation report, which shows pairs of intercompany
receivables and payables accounts that are out of balance.
D. In Fusion Financials, you must manually reconcile your intercompany account balances.
E. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account
balances.
Answer: B
28
Oracle 1z0-960 : Practice Test
Question No : 62
You are required to change today's daily rates for converting GBP to USD. What are three
ways in which you can update existing daily rates?
Answer: B,C,D
Question No : 63
Identify three differences between Oracle Transactional Business Intelligence (OTBI) and
Oracle Business Intelligence Applications (OBIA).
A. OBIA is based on the universal data warehouse design with different prebuilt adapters
that canconnect to various source application
B. Both OBIA and OTBI provide a set of predefined reports and dashboards and a library of
metrics that help to measure business performance
C. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards,
SAP, andFusion Applications.
D. OTBI allows you to create custom reports from real-time transactional data against
thedatabase directly
E. Cloud customers can use both OTBI and OBIA.
Answer: B,C,D
Question No : 64
Which two methods can your General Ledger accountants use to more easily view large
amounts of contained in the tables in their work areas?
29
Oracle 1z0-960 : Practice Test
B. Export the table to Excel.
C. Run a Business Intelligence Publisher report with Excel as the output format.
D. Use the Freeze feature on the tables to scroll through large amounts of data.
Answer: A,B
Question No : 65
You are implementing Financials Cloud and are using spreadsheets to load Legal Entities,
Business Units, and Account Hierarchies.
Which three setup objects can be loaded via a spreadsheet from Functional Setup
Manager?
Answer: B,C,D
Explanation:
https://docs.oracle.com/cloud/latest/financialscs_gs/FACSF/FACSF1004386.htm#FACSF1
236038
Question No : 66
You are implementing Fusion Accounting Hub for your external Accounts Receivables
system. The external system sends invoices billed and cash receipts in a flat file, along with
the customer classification information. You want the accounting amounts to be tracked by
customers too but you do not want to add a Customer segment to your chart of accounts.
A. Use the Open Account Balances Listing report that has balances by customer.
30
Oracle 1z0-960 : Practice Test
B. Use the Third Party Control Account feature.
C. Use Supporting References to capture customer classification information.
D. Capture customer information as the source and develop a custom report using Online
Transactional Business Intelligence (OTBI).
Answer: C
Question No : 67
Answer: A,C,E
Question No : 68
A. Use the Manage Users page to update the user's information and change the password.
B. Use Oracle Identity Management (OIM) to reset the user's password.
C. Log in to the user's machine as an Administrator and change the password from the
login pa
D. Use Access Policy Manager (APM) to reset the user's password.
E. Create a new user ID and password for the user.
Answer: B
Reference:
http://docs.oracle.com/cd/E21764_01/doc.1111/e15477/pwd.htm#IMINT236
31
Oracle 1z0-960 : Practice Test
Question No : 69
You need to create a month-end re-porting package for an upcoming Audit Committee
meeting. You have 10 financial reports that you will need to share with executives and
auditors.
Answer: A,B,D
Question No : 70
You transact in 50 different currencies and you need to define a high volume of revaluation
definitions. Which two methods are Oracle recommended best practices for streamlining
this process?
A. Define separate revaluation definitions for each class of accounts, currency, and
different rate types.
B. Use hierarchies and parent values in your revaluation definition.
C. Share revaluation definitions across ledgers that share the same chart of accounts.
D. Define one revaluation definition for all accounts (assuming all ledgers share the same
chart of accounts) and simply change the parameters at run time.
Answer: B
Question No : 71
32
Oracle 1z0-960 : Practice Test
The budget managers specify the budget accounts they want to monitor and decide on
percentage threshold of funds availability.
Where must you define the details while analyzing budget balances in the Budget Account
Monitor page?
A. Budget Group
B. Application Development framework Desktop Integral ion (ADFdi)
C. Account Group
D. Budget Controller
E. Budget Account Group
Answer: C
Question No : 72
Which two statements are true regarding intercompany accounting tor these products?
A. Each product has its own Intercompany Accounting feature that needs to be set up
separately.
B. Intercompany Balancing Rules are defined centrally and applied across Financials,
Portfolio Project
Management and Supply Chain Management products.
C. Within Financials Cloud, Intercompany Balancing Rules are used to balance both cross-
ledger intercompany transactions and single ledger intercompany journals.
D. They need to license a separate stand-alone Intercompany product that acts as the
Intercompany Accounting Hub.
Answer: A,D
Question No : 73
You defined a tree or hierarchy, but you are unable to set its status to Active.
33
Oracle 1z0-960 : Practice Test
A. Chart of accounts was not deployed.
B. Accounting Configuration was not submitted-
C. An Audit process needs to be successfully performed before a tree version can be set to
Active.
D. Two tree versions were not defined
Answer: D
Question No : 74
Your customer wants to control spending against an annual budget but report balances on
a monthly year-to-date basis. Encumbrance accounting is also in use.
A. Create an annual budget with absolute control and so encumbrance accounting will
work.
B. Create a summary budget annually with advisory control and control budget monthly
with absolute control.
C. Create a Summary budget annually with absolute* control and monthly control budget
with advisory or track control.
D. Create two detail control budgets: annually with absolute control and monthly with
advisory or track control.
E. Create two detail control budgets: annually with advisory/track control and monthly with
absolute control.
Answer: A
Question No : 75
What process must be followed to propagate a chart of accounts hierarchy to the Essbase
cube?
A. Define the hierarchy, then deploy the chart of accounts. The chart of accounts
hierarchies will be generated automatically.
B. Define the hierarchy, make sure the tree version is active, and then run the publish
account Hierarchies program or the Publish Chart of Accounts Dimension Members and
Hierarchies
C. Define the hierarchy and make sure the tree is active. The hierarchy will be system
34
Oracle 1z0-960 : Practice Test
generated for
D. Define the hierarchy, make sure the tree is active, and the Publish check box is selected
for the hierarchy.
Question No : 76
A. A set of reports are provided for both exported and imported setup data to validate the
export/import processes and setup data.
B. Reports on setup data can be used to compare and analyze how the data might have
changed over time.
C. To view errors encountered during the export or import Process, you must use SQL
queries to obtain that data because no reports exist.
D. A set of reports lists user names, suppliers, and customers that have been
exported/imported
E. The export/import reports are available only for Fusion Customer Relationship
Management.
Answer: C,E
Question No : 77
You are defining an income statement report. You want to allow viewers of the report to be
able to drill down from report balances to the underlying transactions. What do you need to
enable?
Answer: D
Question No : 78
What are the two benefits of having the Essbase cube embedded in Fusion General
35
Oracle 1z0-960 : Practice Test
Ledger?
A. General ledger balances are multidimensional, allowing you to perform robust reporting
and analysis.
B. You can access real-time results for reporting and analysis because every time a
transaction is posted in General Ledger, multidimensional balances are also updated
simultaneously.
C. You no longer need to create and maintain hierarchies because the Essbase cubes are
created when you create your chart of accounts.
D. Posting performance is much faster.
E. Integrating with third-party systems is easier because the Essbase cube provides chart
of accounts mapping rules.
Answer: B,D
Question No : 79
Which two statements are true regarding how Intercompany Balancing Rule, are defied?
A. All ledgers engaged in an intercompany transaction must share the same chart: of
accounts in order to define balancing rules
B. You can only define balancing rules for different journals' sources. You cannot define
balancing rules for different journal categories.
C. You can define different balancing rules for different combinations of journal sources,
journal categories, and transaction types
D. You can define different rules for different charts of accounts, ledgers, legal entities, and
primary balancing segment value.
Answer: A,D
Question No : 80
Which AMX builder method is most effective in routing the journals to the Accounting
Manager when the General Ledger Accountant enters the journal?
36
Oracle 1z0-960 : Practice Test
B. Job level
C. Position
D. Approval Group
Answer: D
Question No : 81
Your customer has enabled budgetary and encumbrance controls at the requisition level.
You have a purchase order for $1,000 USD, which is fully reserved and has one invoice for
$600 USD. When the purchase order is matched through the final match process, the
purchase order is closed for further invoicing.
Answer: A
Question No : 82
Which two statements are true regarding the creation of a control budget?
37
Oracle 1z0-960 : Practice Test
Answer: B,E
Question No : 83
You need to integrate Fusion Accounting Hub with external source systems used for Billing.
Identity the step that is not correct when implementing this integration.
Answer: D
Question No : 84
Your customer wants to prevent their department managers from viewing the results of
other departments where they have no management authority.
Answer: C
Question No : 85
Which two General Ledger work would you assign to all your entry-level General Ledger
accountants?
38
Oracle 1z0-960 : Practice Test
B. Period Close Work Area
C. Financial Reporting Center
D. General Accounting Dashboard
Answer: A,D
Question No : 86
Your customer is expanding its operations. You defined a new ledger and several business
units. However, you are unable to assign the newly generated data roles to existing
Accounts Payables and Accounts Receivables users in the shared service center.
A. Open the Oracle Identity Management (OIM) and make sure the data roles were
created.
B. Open the Manage Users page and make sure the employees at
C. Open Access Policy Manager (APM) and assign the roles manually
D. Make sure you run the Retrieve Latest LDAP Changes program to regenerate the data
roles.
Answer: C
Question No : 87
You need to distribute departmental expense reports to l00 department managers in your
organization. The report format is the same, but the department values differ.
A. Set the Department segment as a User Point of View (POV) and submit a report batch
and schedule it: to run for every department. Send the different batch outputs as PDF
attachments via email to different users.
B. Create a single report for all departments. When department managers log in to
Financial Reporting Center, they will only be able to view their department's data based on
Segment Value Security Rules.
C. Set up Bursting Options for your batch to prepare multiple versions of a report from a
single process.
D. When defining the report, make the Department Segment a prompt and when users
39
Oracle 1z0-960 : Practice Test
view the report, they can change the prompt to their department.
Answer: D
Question No : 88
Which two types of journals can be automatically routed through the journal approval
process?
A. Allocation journals
B. Revaluation journals
C. Manual journals
D. Sub ledger journals
E. Journals imported from third-party systems
Answer: C,E
Question No : 89
Your customer has many eliminating entries to eliminate intercompany balances. The
General Ledge does not include a purpose-built Consolidation feature.
How would you automate the process of creating eliminating entries, assuming your
customer is not using Oracle Hyperion Financial Close Management?
A. Use the spreadsheet template that is accessed from the "Create Journal in
Spreadsheet" task and import the spreadsheet with the eliminating entries every period.
B. Use the General Ledger's Calculation Manager to define an allocation definition to
eliminate entries that you can generate every period.
C. There is no way to automate this process if the customer is not using Oracle Hyperion
Financial Close Management.
D. Create a manual journal that includes the eliminating entries, and then create a copy of
the Journal batch every period.
Answer: C
Question No : 90
40
Oracle 1z0-960 : Practice Test
On which three occasions are Essbase balances updated?
Answer: A,B,D
Question No : 91
Your customer has only licensed Fusion Financials and wants to use approval workflows.
Using which page to enter users and assign roles does Oracle consider best practice?
A. Manage Users
B. Hire a New Ernployee
C. Oracle Identity Management (OIM)
D. Policy Manager (APM)
E. Financials not a stand-alone product
Answer: C
Question No : 92
You want to define a tree or hierarchy for use in reports and allocations.
What three aspects should you remember when creating the tree?
A. You need to flatten the rows to be able to use drilldown in Smart View and you must
publishtree to view the hierarchy in Essbase cubes.
B. You must flatten the columns and publish the tree to view the hierarchy in Essbase
cubes.
C. The tree should have at least two tree versions to reduce report and allocation
maintenance.
D. You only need to flatten the columns if you plan to use the hierarchy in Oracle
Transactional Business Intelligence (OTBI).
41
Oracle 1z0-960 : Practice Test
E. It is fine to have the same child value roll up to two or more different parent values.
Answer: B,C,E
Question No : 93
Your enterprise structure has one ledger and two business units. Business unit one wants
to enable budgetary control for Requisitioning only in Procure-to-Pay Business Functions
and business unit two wants to enable budgetary control for Payable Invoicing only in
Procure-to-Pay Business Functions.
A. While defining control for business unit two, enable control at Requisitioning and define
the exceptions to only include invoicing.
B. Define control for business unit two to disable control for Requisitioning, Purchasing,
and Receiving.
C. Define budgetary control at ledger level with Budgetary Control Exceptions for each
business unit.
D. While defining control for business unit one, disable control lor Purchasing, Payable
Invoicing, and
Receiving.
E. While defining control for business unit one, enable control at purchasing and define the
exceptions to only include requisitioning.
F. Define budgetary control at ledger level and only encumbrance controls at the business
units.
Answer: A,F
Question No : 94
You need to build a complex account rule. Which four value types can you use in your
definition?
A. Value Set
B. Constant
C. Existing Account Rule
D. Account Combination
E. Mapping Set
42
Oracle 1z0-960 : Practice Test
F. Source
Answer: A,B,C,F
Question No : 95
You are required to enter a high volume of users into the system. What does Oracle
consider best practice to do this?
A. Use SQL to populate the HR interface tables and load employees in bulk.
B. Use the spreadsheet templates available in Oracle Enterprise Repository (OER) and
then import users into Fusion Applications.
C. Use the "Hire an Employee" user interfaceto inter each user manually.
D. Use the spreadsheet available in Oracle Identity Manager (OIM) to import users.
E. Use the “Enter a Supplier" user interface to enter each user manually.
Answer: D
Question No : 96
Invoices received from a source system need to use a specific account based on 30
different expense types. However, if the invoice is from a specific supplier type, it needs to
go to a default account regardless of the account type.
Answer: C
Question No : 97
43
Oracle 1z0-960 : Practice Test
Your customer is closing their period and they are using Fusion Intercompany to create
physical invoices in Fusion Payables and Receivables.
What is the correct order of steps to close Fusion sub ledgers, Fusion Intercompany, and
Fusion General Ledger?
A. Close Fusion Payables and Receivables periods, close the related intercompany period,
and then close the Fusion General Ledger's period.
B. Close Fusion Payables and Receivables periods, close Fusion General Ledger, and
then close the related intercompany period
C. Close the related intercompany period, close Fusion Payables and Receivables periods,
and then Fusion General Ledger.
D. You only need to close Fusion Payables and Receivables periods followed by the
Fusion GeneralLedger's period.
Answer: C
Reference:
http://www.oracle.com/technetwork/middleware/bi-foundation/fcm-11122-fusion-r6-
integration-1900499.pdf
Question No : 98
You want to be notified of anomalies in certain account balances in real time. What is the
rnost efficient way to do this?
Answer: A
Question No : 99
Your customer operates three shared services that perform accounting functions across 50
countries.
44
Oracle 1z0-960 : Practice Test
What feature allows them to share setup data, such as Payment Terms, across Business
Units?
Answer: B
Question No : 100
You already ran Translation, but a last-minute adjusting journal entry in your ledger
currency was entered after you consolidated your results.
Answer: A
Question No : 101
Which repot show you differences between your subledger balances and General Ledger
balances?
A. Payables Trial Balance, Receivables Trial Balance, and General Ledger Trial Balance
reports
B. Payables and Receivables Aging Reports with the General Ledger Trial Balance report
C. Payables to Ledger Reconciliation Report and the Receivables to Ledger Reconciliation
Report
D. General Ledger Financial Statements and the Accounts Payable and Accounts
Receivables Invoice Registers
Answer: C
45
Oracle 1z0-960 : Practice Test
Question No : 102
Which two delivered roles can access the full functionality of Functional Setup Manager,
Answer: A,C
Question No : 103
Your customer has a large number of legal entities. The legal entity values are defined in
the company segment and the primary balancing segment. They want to easily create
eliminating entries for the intercompany activity.
Answer: B
Question No : 104
46
Oracle 1z0-960 : Practice Test
Your customer requires physical invoices to be generated in Fusion Payables and Fusion
Receivables for the intercompany payables and receivables transactions.
A. You must assign the corresponding Receivables and Payables Business Units.
B. You only need to assign the Legal Entity and Organization Contact.
C. You must perform additional setup steps for Fusion Payables and Fusion Receivables.
D. You can only associate one Intercompany Organization per Legal Entity.
Answer: A
Reference:
http://docs.oracle.com/cd/E27605_01/fscm91pbr2/eng/psbooks/sbil/chapter.htm?File=sbil/h
tm/sbil25.htm
Question No : 105
How can your Accounting Manager expedite Journal processing during the time critical
month end close?
A. by using the Close Status monitor to drill down on the close status across ledgers
B. by using the Journals region to view journals Requiring Attention, Requiring Approval,
and Pending Approval from Others
C. by running the Journals report using Business Intelligence Publisher
D. by creating an ad hoc query on journals using Oracle Transactional Business
Intelligence (OTBI)
Answer: C
47